gs gs116 Business Intelligence - SQL Server MDX - Quiz No.2
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Business Intelligence. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: __________ is the set of hierarchies from which data is retrieved for a single member.
Slicer axis
Query axes
Dice axis
All of the mentioned
Question 2: Point out the correct statement.
Only dropping the default member is supported in MDX Scripting
In the SELECT statement, the FROM clause determines the cube context
Very few cube can control how errors within a Multidimensional Expressions (MDX) script are handled
None of the mentioned
Question 3: When you include a many-to-many dimension, which of the following rules apply?
You must add the intermediary measure group
You must add the entire many-to-many dimension
You must add the entirety of all dimensions common to the two measure groups involved in the many-to-may relationship
All of the mentioned
Question 4: _________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.
UPDATE CUBE
DELETE CUBE
ALTER CUBE
None of the mentioned
Question 5: Point out the wrong statement.
A weight expression should be expressed as a decimal value between zero (0) and 1
Each UPDATE CUBE allocation should be considered to be atomic for transactional purposes
When updated cells overlap, the Update Isolation Level connection string property can be used to enhance performance for UPDATE CUBE
None of the mentioned
Question 6: Which of the following scenario demonstrates USE_EQUAL_INCREMENT allocation method?
<leaf cell value> = <New Value> / Count(leaf cells that are contained in <tuple>) <leaf cell value> = < New Value> * Weight_Expression <leaf cell value> = <leaf cell value> + (<New Value > - <existing value>) / Count(leaf cells contained in <tuple>) <leaf cell value> = <leaf cell value> + (<New Value> - <existing value>) * Weight_Expression
Question 7: If a weight expression is not specified, the UPDATE CUBE statement implicitly uses which of the following expression?
Weight_Expression = <leaf cell value> * <existing value>
Weight_Expression = <leaf cell value> / <existing value>
Weight_Expression = <leaf cell value> – <existing value>
Weight_Expression = <leaf cell value> + <existing value>
Question 8: When used on a measure that contains integers, the _________ method can return imprecise results caused by incremental rounding changes.
USE_EQUAL_ALLOCATION
USE_WEIGHTED_ALLOCATION
USE_WEIGHTED_INCREMENT
All of the mentioned
Question 9: Which of the following is valid syntax for DRILLTHROUGH statement?
DRILLTHROUGH[MAXROWSUnsigned_Integer] <MDX SELECT statement> [RETURNSet_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ] DRILL[MAXROWSUnsigned_Integer] <MDX SELECT statement> [RETURNSet_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ] DRILLTHROUGH[MAXROWSUnsigned_Integer] <MDX SELECT statement>
None of the mentioned
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
