View Count: 0
Duration: 25 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 45 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 8
Valid syntax for REFRESH CUBE statement is : 
Options:
  1. REFRESH CUBECube_Name
  2. REFRESH CUBE ‘Cube_Name’
  3. REFRESH CUBE “Cube_Name”
  4. REFRESH CUBE \Cube_Name\
View Answer/Explanation:
a
Explanation:
REFRESH CUBECube_Name refreshes the client cache for a cube

Question No: 2 of 8
How many types of actions available in the Cube? 
Options:
  1. One
  2. Two
  3. Three
  4. None
View Answer/Explanation:
c
Explanation:

Question No: 3 of 8
What are the options to deploy SSAS cube in production? 
Options:
  1. Using BIDS
  2. Using SSMS
  3. Using XMLA
  4. All the above
View Answer/Explanation:
d
Explanation:

Question No: 4 of 8
_________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation. 
Options:
  1. UPDATE CUBE
  2. DELETE CUBE
  3. ALTER CUBE
  4. None of the mentioned
View Answer/Explanation:
a
Explanation:
You can update the value of a specified leaf or non-leaf cell in a cube, optionally allocate the value for a specified non-leaf cell across dependent leaf cells

Question No: 5 of 8
Point out the wrong statement: 
Options:
  1. A weight expression should be expressed as a decimal value between zero (0) and 1
  2. Each UPDATE CUBE allocation should be considered to be atomic for transactional purposes
  3. When updated cells overlap, the Update Isolation Level connection string property can be used to enhance performance for UPDATE CUBE
  4. None of the mentioned
View Answer/Explanation:
c
Explanation:
When updated cells do not overlap, the Update Isolation Level connection string property can be used to enhance performance for UPDATE CUBE

Question No: 6 of 8
Point out the correct statement: 
Options:
  1. Only dropping the default member is supported in MDX Scripting
  2. In the SELECT statement, the FROM clause determines the cube context
  3. Very few cubes can control how errors within a Multidimensional Expressions (MDX) script are handled
  4. None of the mentioned
View Answer/Explanation:
b
Explanation:
This context can be the whole cube or just a subcube from that cube. Having specified cube context through the FROM clause, you can use additional functions to expand or restrict that context

Question No: 7 of 8
Which type of relationship is used for Dimension is indirectly related to measuring group by one more dimension? 
Options:
  1. Referenced Relationship
  2. Fact Relationship
  3. Regular Relationship
  4. None of these
View Answer/Explanation:
a
Explanation:

Question No: 8 of 8
What are the different types of Aggregate Functions? 
Options:
  1. Additive
  2. Non-additive
  3. Semi-Additive
  4. None of these
View Answer/Explanation:
a b c
Explanation:

  1