Business Intelligence on SQL Server related Questions and Answers - Page 5

Question 41 : If you select the __________ conversion type, a reporting currency dimension is also created.
1. one-to-one
2. many-to-one
3. many-many
4. All of the mentioned
View Answer   Discuss with Members

Question 42 : The Business Intelligence Wizard supports ______ different types of currency conversion.
1. 3
2. 4
3. 5
4. 6
View Answer   Discuss with Members

Question 43 : You can use the __________ Wizard to specify which measures from the rate measure group are used to convert values.
1. BI
2. ETL
3. MIS
4. OBIEE
View Answer   Discuss with Members

Question 44 : For _________ currency conversions, the pivot currency and reporting currency are the same.
1. one-to-one
2. many-to-one
3. many-many
4. All of the mentioned
View Answer   Discuss with Members

Question 45 : _______ is currency used to store transactions on which measures to be converted are based in SSAS.
1. Local currency
2. Pivot currency
3. Global currency
4. None of the mentioned
View Answer   Discuss with Members

Question 46 : Parent-child hierarchies are automatically detected by the _________ Wizard.
1. Dimension
2. Cube
3. Dimension and Cube
4. None of the mentioned
View Answer   Discuss with Members

Question 47 : By default, in a ________ schema, all attributes are directly related to the key attributes.
1. Relational
2. Snowflake
3. Star
4. None of the mentioned
View Answer   Discuss with Members

Question 48 : The _______ attribute is the attribute in a dimension that identifies the columns in the dimension main table that are used in foreign key relationships to the fact table.
1. Dim
2. KEY
3. PK
4. None of the mentioned
View Answer   Discuss with Members

Question 49 : Which of the following is not supported by linked dimensions ?
1. readback
2. writeback
3. readwrite
4. All of the mentioned
View Answer   Discuss with Members

Question 50 : In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension.
1. Translation
2. Dimension translation
3. Dim translation
4. None of the mentioned
View Answer   Discuss with Members


View 41 - 50 of 62 Questions

* Be the First to Post a Comment.

Submit comment :


Captcha Image
Reload

Ask Question

Captcha Image
Reload

Note : Name and Email never shown.





Subscribe


Become a part of EducationForever. Subscribe to our FREE Newsletter