Practice Sqlserver Basic Multiple Choice Questions with Answers Quiz-1

Q.1.

__________ is the set of hierarchies from which data is retrieved for a single member.

Explanation

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

Explanation

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

Explanation

Q.4.

_________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.

Explanation

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

Explanation

Q.6.

Which of the following scenario demonstrates USE_EQUAL_INCREMENT allocation method?

Explanation

Q.7.

If a weight expression is not specified, the UPDATE CUBE statement implicitly uses which of the following expression?

Explanation

Q.8.

When used on a measure that contains integers, the _________ method can return imprecise results caused by incremental rounding changes.

Explanation

Q.9.

Which of the following is valid syntax for DRILLTHROUGH statement?

Explanation

Q.10.

Which of the following keyword forces a specified set to be evaluated within the current context?

Explanation