Analysis Services interview questions part 2
Analysis Services interview questions part 2
Take as many assements as you can to improve your validate your skill rating
Total Questions: 13
1. Which of the following is not supported by linked dimensions ?
Correct Answer is : writeback
2. 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.
Correct Answer is : KEY
3. Which of the following property is set to zero so that all levels are not created ?
Correct Answer is : IsAggregatable
4. By default, in a ________ schema, all attributes are directly related to the key attributes.
Correct Answer is : Star
5. Parent-child hierarchies are automatically detected by the _________ Wizard.
Correct Answer is : Dimension and Cube
6. _______ is currency used to store transactions on which measures to be converted are based in SSAS.
Correct Answer is : Local currency
7. For _________ currency conversions, the pivot currency and reporting currency are the same.
Correct Answer is : many-to-one
8. You can use the __________ Wizard to specify which measures from the rate measure group are used to convert values.
Correct Answer is : BI
9. Point out the wrong statement :
Correct Answer is : Transactions are stored in the fact table in the pivot currency for one-to-many conversion
10. The Business Intelligence Wizard supports ______ different types of currency conversion.
Correct Answer is : 3
11. Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character ?
Correct Answer is : Binary (_BIN)1
12. ____________ distinguishes between a single-byte character and the same character when represented as a double-byte character.
Correct Answer is : Width-sensitive (_WS)
13. Which of the following property enables Analysis Services to use a faster algorithm for string hashing and comparison ?
Correct Answer is : EnableFast1033Locale
