Q.1
__________ is the set of hierarchies from which data is retrieved for a single member.
  • a) Slicer axis
  • b) Query axes
  • c) Dice axis
  • d) All of the mentioned
Q.2
Point out the correct statement.
  • a) Only dropping the default member is supported in MDX Scripting
  • b) In the SELECT statement, the FROM clause determines the cube context
  • c) Very few cube can control how errors within a Multidimensional Expressions (MDX) script are handled
  • d) None of the mentioned
Q.3
When you include a many-to-many dimension, which of the following rules apply?
  • a) You must add the intermediary measure group
  • b) You must add the entire many-to-many dimension
  • c) You must add the entirety of all dimensions common to the two measure groups involved in the many-to-may relationship
  • d) All of the mentioned
Q.4
_________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.
  • a) UPDATE CUBE
  • b) DELETE CUBE
  • c) ALTER CUBE
  • d) None of the mentioned
Q.5
Point out the wrong statement.
  • a) A weight expression should be expressed as a decimal value between zero (0) and 1
  • b) Each UPDATE CUBE allocation should be considered to be atomic for transactional purposes
  • c) When updated cells overlap, the Update Isolation Level connection string property can be used to enhance performance for UPDATE CUBE
  • d) None of the mentioned
Q.6
Which of the following scenario demonstrates USE_EQUAL_INCREMENT allocation method?
  • a)
  • b)
  • c)
  • d)
Q.7
If a weight expression is not specified, the UPDATE CUBE statement implicitly uses which of the following expression?
  • a) Weight_Expression = <leaf cell value> * <existing value>
  • b) Weight_Expression = <leaf cell value> / <existing value>
  • c) Weight_Expression = <leaf cell value> – <existing value>
  • d) Weight_Expression = <leaf cell value> + <existing value>
Q.8
When used on a measure that contains integers, the _________ method can return imprecise results caused by incremental rounding changes.
  • a) USE_EQUAL_ALLOCATION
  • b) USE_WEIGHTED_ALLOCATION
  • c) USE_WEIGHTED_INCREMENT
  • d) All of the mentioned
Q.9
Which of the following is valid syntax for DRILLTHROUGH statement?
  • a)
  • b)
  • c)
  • d) None of the mentioned
Q.10
Which of the following keyword forces a specified set to be evaluated within the current context?
  • a) SCOPE
  • b) CASE
  • c) EXISTING
  • d) FREEZE
0 h : 0 m : 1 s