gs gs116 Business Intelligence - SQL Server MDX - Quiz No.1
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: _______ lets you manage cube context from within an MDX script.
CALCULATE
CALC
SCOPE CALC
None of the mentioned
Question 2: Point out the correct statement.
Few MDX queries run within a specified cube context
SELECT statement is the most frequently used query in MDX
When formulating a Multidimensional Expressions (MDX) SELECT statement, an application typically examines a cube and divides the set of hierarchies into three subsets
None of the mentioned
Question 3: ________ causes the server to raise an error when Microsoft SQL Server Analysis Services finds any error in the MDX script.
Ignore
IgnoreNone
IgnoreAll
All of the mentioned
Question 5: Point out the wrong statement.
The WHERE clause describes the slicer axis in an MDX query
MDX syntax distinguishes sets by surrounding tuples or members with braces
MDX queries can have three query axes in the SELECT statement
None of the mentioned
Question 6: ___________ creates a calculation that evaluates a Multidimensional Expressions (MDX) expression over a specified set of tuples within a cube.
CREATE CELL CALCULATION
CREATE CELL CALC
CREATE MEMBER CALCULATION
None of the mentioned
Question 8: Which of the following is valid syntax for CREATE GLOBAL CUBE?
CREATE GLOBAL CUBE [LocalReseller] Storage 'C:\LocalAWReseller1.cub' FROM [Adventure Works] ( MEASURE [Adventure Works].[Reseller Sales Amount], DIMENSION [Adventure Works].[Reseller], DIMENSION [Adventure Works].[Date] ) CREATE GLOBAL CUBE [LocalReseller] FROM [Adventure Works] ( MEASURE [Adventure Works].[Reseller Sales Amount], DIMENSION [Adventure Works].[Reseller], DIMENSION [Adventure Works].[Date] ) CREATE GLOBAL CUBE [LocalReseller] Storage 'C:\LocalAWReseller1.cub' ( MEASURE [Adventure Works].[Reseller Sales Amount], DIMENSION [Adventure Works].[Reseller], DIMENSION [Adventure Works].[Date] )
All of the mentioned
Question 9: Which of the following is the MDX Data Definition Statement?
CREATE ACTION
DROP CUBE
CREATE CUBE
None of the mentioned
Question 10: Valid syntax for REFRESH CUBE statement is ____________
REFRESH CUBECube_Name
REFRESH CUBE Cube_Name
REFRESH CUBE “Cube_Name”
REFRESH CUBE \Cube_Name\
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
