This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Analysis Services – 3”.
1. _______ is currency used to store transactions on which measures to be converted are based in SSAS.
a) Local currency
b) Pivot currency
c) Global currency
d) None of the mentioned
View Answer
Explanation: A Local currency identifier associated with an attribute in a dimension table that is then associated with a transaction in the fact table.
2. Point out the correct statement.
a) The Type property of the dimension is set to Reporting Currency
b) The Type property of one attribute for the dimension is set to CurrencyName in Latin
c) The values of Type attribute must be used in all columns that should contain a currency identifier
d) All of the mentioned
View Answer
Explanation: Currency dimension is a database dimension defined with type property of the dimension set to Currency.
3. For _________ currency conversions, the pivot currency and reporting currency are the same.
a) one-to-one
b) many-to-one
c) many-many
d) all of the mentioned
View Answer
Explanation: Reporting currency is the currency to which transactions are converted from the pivot currency.
4. You can use the __________ Wizard to specify which measures from the rate measure group are used to convert values.
a) BI
b) ETL
c) MIS
d) OBIEE
View Answer
Explanation: You choose the exchange rate direction on the Set currency conversion options page of the Business Intelligence Wizard.
5. Point out the wrong statement.
a) Transactions are stored in the fact table in local currencies for many-to-many conversion
b) Transactions are stored in the fact table in the pivot currency for one-to-many conversion
c) If you choose a many-to-many or one-to-many conversion type for your currency conversion, you need to specify the reporting currencies
d) None of the mentioned
View Answer
Explanation: Transactions are stored in the fact table in the pivot currency, and then converted to one or more other reporting currencies.
6. The Business Intelligence Wizard supports ______ different types of currency conversion.
a) 3
b) 4
c) 5
d) 6
View Answer
Explanation: Specifying the conversion type allows the Business Intelligence Wizard to define the named query and dimension structure of the reporting currency dimension.
7. If you select the __________ conversion type, a reporting currency dimension is also created.
a) one-to-one
b) many-to-one
c) many-many
d) all of the mentioned
View Answer
Explanation: The dimension contains only one member representing the pivot currency because the pivot currency is also used as the reporting currency for one-to-many currency conversion.
8. Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character?
a) BIN2 (_BIN2)1
b) Binary (_BIN)1
c) Case-sensitive (_CS)
d) Case-insensitive
View Answer
Explanation: Binary sort order is case sensitive and accent sensitive. Binary is also the fastest sorting order.
9. ____________ distinguishes between a single-byte character and the same character when represented as a double-byte character.
a) Accent-insensitive (_AI)
b) Kana-sensitive (_KS)
c) Accent-sensitive (_AS)
d) Width-sensitive (_WS)
View Answer
Explanation: There is no sort order suffix for width-insensitive sorting.
10. Which of the following property enables Analysis Services to use a faster algorithm for string hashing and comparison?
a) EnableFast1033Local
b) EnableFast1036Locale
c) EnableFast1033Locale
d) EnableQuick1033Locale
View Answer
Explanation: For the Analysis Services instance, you can get additional performance benefits by setting the EnableFast1033Locale configuration property to true.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
- Check SQL Server Books
- Apply for Programming Internship
- Practice Programming MCQs
- Check Information Technology Books
