Explanation:The dimension contains only one member representing the pivot currency, because the pivot currency is also used as the reporting currency for a 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
Answer:A
Explanation:The dimension contains only one member representing the pivot currency, because the pivot currency is also used as the reporting currency for a 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
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.