MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Sql Server
Sqlserver Basic
Quiz 1
1
2
3
4
5
6
7
8
9
10
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
1
2
3
4
5
6
7
8
9
10
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page