MDX
View Count: 0
Duration: 96 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 14 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 10
Which of the following is MDX Data Definition Statement? 
Options:
  1. CREATE ACTION
  2. DROP CUBE
  3. CREATE CUBE
  4. None of the mentioned
View Answer/Explanation:
a
Explanation:
An action that can be associated with a cube, dimension, hierarchy, or subordinate object

Question No: 2 of 10
___________ creates a calculation that evaluates a Multidimensional Expressions (MDX) expression over a specified set of tuples within a cube? 
Options:
  1. CREATE CELL CALCULATION
  2. CREATE CELL CALC
  3. CREATE MEMBER CALCULATION
  4. None of the mentioned
View Answer/Explanation:
a
Explanation:
CREATE CELL CALCULATION statement creates a calculated cell formula for a specified set of tuples within a cube.

Question No: 3 of 10
Point out the wrong statement: 
Options:
  1. WHERE clause describes the slicer axis in an MDX query
  2. MDX syntax distinguishes sets by surrounding tuple or members with braces
  3. MDX queries can have three query axes in the SELECT statement
  4. None of the mentioned
View Answer/Explanation:
c
Explanation:

Question No: 4 of 10
_______lets you manage cube context from within an MDX script? 
Options:
  1. CALCULATE
  2. CALC
  3. SCOPE CALC
  4. None of the mentioned
View Answer/Explanation:
a
Explanation:
In Microsoft SQL Server Analysis Services, a Multidimensional Expressions (MDX) script is made up of one or more MDX expressions or statements that populate a cube with calculations

Question No: 5 of 10
Point out the correct statement: 
Options:
  1. Few MDX queries run within a specified cube context
  2. A select statement is a most frequently used query in MDX
  3. When formulating a Multidimensional Expressions (MDX) SELECT statement, an application typically examines a cube and divides the set of hierarchies into three subsets
  4. None of the mentioned
View Answer/Explanation:
b
Explanation:

Question No: 6 of 10
________ causes the server to raise an error when Microsoft SQL Server Analysis Services finds any error in the MDX script? 
Options:
  1. Ignore
  2. IgnoreNone
  3. IgnoreAll
  4. All of the mentioned
View Answer/Explanation:
b
Explanation:
Error handling is done through the ScriptErrorHandlingMode enumerator

Question No: 7 of 10
MDX stands for________? 
Options:
  1. Multidimensional expression
  2. Multi data expression
  3. Multi definition expression
  4. None of these
View Answer/Explanation:
a
Explanation:

Question No: 8 of 10
The number of cells within a cube depends on the___________? 
Options:
  1. Number of hierarchies
  2. Number of cubes
  3. Number of dimensions
  4. None of these
View Answer/Explanation:
a
Explanation:

Question No: 9 of 10
What is Slice? 
Options:
  1. A section of the cube represented by a tuple
  2. Collection of members which uniquely identifies the cell in cube
  3. All the above
  4. None of these
View Answer/Explanation:
a
Explanation:

Question No: 10 of 10
Top Count function sorts a set in which order? 
Options:
  1. Descending order
  2. Ascending order
  3. All the above
  4. None of these
View Answer/Explanation:
a
Explanation:

  1