Question 31 : __________ is the set of hierarchies from which data is retrieved for a single member.
1. Slicer axis
2. Query axes
3. Dice axis
4. All of the mentioned
View Answer   Discuss with Members

Question 32 : Valid syntax for REFRESH CUBE statement is :
1. REFRESH CUBECube_Name
2. REFRESH CUBE Cube_Name
3. REFRESH CUBE “Cube_Name”
4. REFRESH CUBE \Cube_Name\
View Answer   Discuss with Members

Question 33 : Which of the following is MDX Data Definition Statement ?
1. CREATE ACTION
2. DROP CUBE
3. CREATE CUBE
4. None of the mentioned
View Answer   Discuss with Members

Question 34 : ___________ creates a calculation that evaluates a Multidimensional Expressions (MDX) expression over a specified set of tuples within a cube.
1. CREATE CELL CALCULATION
2. CREATE CELL CALC
3. CREATE MEMBER CALCULATION
4. None of the mentioned
View Answer   Discuss with Members

Question 35 : The Backus-Naur Form (BNF) of {*( | | )} will be parsed as ______ for backwards compatibility.
1. {\}
2. {*}
3. {+}
4. {-}
View Answer   Discuss with Members

Question 36 : ________ causes the server to raise an error when Microsoft SQL Server Analysis Services finds any error in the MDX script.
1. Ignore
2. IgnoreNone
3. IgnoreAll
4. All of the mentioned
View Answer   Discuss with Members

Question 37 : _______ lets you manage cube context from within an MDX script.
1. CALCULATE
2. CALC
3. SCOPE CALC
4. None of the mentioned
View Answer   Discuss with Members

Question 38 : Which of the following property enables Analysis Services to use a faster algorithm for string hashing and comparison ?
1. EnableFast1033Local
2. EnableFast1036Locale
3. EnableFast1033Locale
4. EnableQuick1033Locale
View Answer   Discuss with Members

Question 39 : ____________ distinguishes between a single-byte character and the same character when represented as a double-byte character.
1. Accent-insensitive (_AI)
2. Kana-sensitive (_KS)
3. Accent-sensitive (_AS)
4. Width-sensitive (_WS)
View Answer   Discuss with Members

Question 40 : Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character ?
1. BIN2 (_BIN2)1
2. Binary (_BIN)1
3. Case-sensitive (_CS)
4. Case-insensitive
View Answer   Discuss with Members