Question
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
Posted under Business Intelligence and Reporting Services SQL Server
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Point out the wrong statement.
Similar Questions
Discover Related MCQs
Q. The Business Intelligence Wizard supports ______ different types of currency conversion.
View solution
Q. If you select the __________ conversion type, a reporting currency dimension is also created.
View solution
Q. Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character?
View solution
Q. ____________ distinguishes between a single-byte character and the same character when represented as a double-byte character.
View solution
Q. Which of the following property enables Analysis Services to use a faster algorithm for string hashing and comparison?
View solution
Q. _______ lets you manage cube context from within an MDX script.
View solution
Q. Point out the correct statement.
View solution
Q. ________ causes the server to raise an error when Microsoft SQL Server Analysis Services finds any error in the MDX script.
View solution
Q. The Backus-Naur Form (BNF) of {*(<comment> | <whitespace> | <newline>)} will be parsed as ______ for backwards compatibility.
View solution
Q. Point out the wrong statement.
View solution
Q. ___________ creates a calculation that evaluates a Multidimensional Expressions (MDX) expression over a specified set of tuples within a cube.
View solution
Q. Which of the following is valid syntax for CREATE GLOBAL CUBE?
View solution
Q. Which of the following is the MDX Data Definition Statement?
View solution
Q. Valid syntax for REFRESH CUBE statement is ____________
View solution
Q. __________ is the set of hierarchies from which data is retrieved for a single member.
View solution
Q. Point out the correct statement.
View solution
Q. When you include a many-to-many dimension, which of the following rules apply?
View solution
Q. _________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.
View solution
Q. Point out the wrong statement.
View solution
Q. Which of the following scenario demonstrates USE_EQUAL_INCREMENT allocation method?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
