Advertisement

Advertisement

Advertisement

MSBI Quizzes & Trivia

Top Trending

A Comprehensive Quiz on SSIS

Questions: 61 | Attempts: 4173 | Last updated: Mar 6, 2016

Sample Question
You are in the process of creating a data flow to load sales data into a fact table. You have configured a full cache mode Lookup Transformation in the data flow to find the product data for sales. Two tables host the lookup source for the product data.You then access the Advance Page of the Lookup Transformation Editor.Which of the following is a reason for doing this?

To configure a suitable connection manager.

To configure partial caching.

To modify the SQL statement for the Lookup transformation.

To specify the join between the source table and the reference table.

Msbi Ssas Exam Quiz: MCQ!

MSBI SSAS Exam Quiz: MCQ!

.

Questions: 165 | Attempts: 1721 | Last updated: Dec 24, 2020

Sample Question
Which operation of OLAP provides alternate presentation of data by rotating it?

Slice

Roll up

Dice

Pivot

MSBI 70-448 Cert dump

Questions: 81 | Attempts: 402 | Last updated: Jun 13, 2017

Msbi 2008 Evaluation Test

MSBI 2008 Evaluation Test

MSBI 2008 Evaluation Test For Cyber Think Consultants

Questions: 40 | Attempts: 994 | Last updated: Jan 22, 2013

Sample Question
1. What is the difference between UNION and UNION ALL?

A. Union selects only unique row (data) from all queries and Union all selects all rows from all queries.

B. Union selects row (data) from all queries and Union all selects all rows from all queries.

C. Union selects only unique row (data) from all queries and Union all selects rows from all queries.

D. Union selects row (data) from all queries and Union all selects rows from all queries.

Advertisement

Advertisement

Related

MCSE MCSE Quizzes

Microsoft office Microsoft Office Quizzes

Microsoft Certification Microsoft Certification Quizzes

Microsoft Certification Exam Microsoft Certification Exam Quizzes