SQL Server Questions and Answers – Analysis Services – 3

This set of SQL Server Problems 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

Answer: a
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

Answer: a
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

Answer: b
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

Answer: a
Explanation: You choose the exchange rate direction on the Set currency conversion options page of the Business Intelligence Wizard.

advertisement
advertisement

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

Answer: b
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

Answer: a
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

Answer: b
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

Answer: b
Explanation: Binary sort order is case sensitive and accent sensitive. Binary is also the fastest sorting order.

advertisement

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

Answer: d
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

Answer: c
Explanation: For the Analysis Services instance, you can get additional performance benefits by setting the EnableFast1033Locale configuration property to true.

advertisement

Sanfoundry Global Education & Learning Series – SQL Server.

To practice problems on all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.