Business Intel Quiz 3

Which of the following keywords is used for the slicer clause in MDX?

where

Which of the following command (keyword) is used to define a named set in MDX?

with set ... as

Which of the following symbols are used for a tuple in MDX?

( )

Which command keyword is NOT supported by both SQL and MDX?

AXIS

Which of the following statements is correct about MDX?

An MDX query cannot have a ROWS axis (on rows) without a COLUMNS axis (on columns) in the SELECT clause

How many dimensions can an OLAP cube support?

As many as a system can support

Which function is not usually supported by an OLAP client?

Define slowly changing dimensions

Which clause is used for specifying a cube in MDX?

FROM

Which of the following is NOT an OLAP operation?

Match

MDX is a language for

Querying multidimensional data models

Which of the following application cannot be used as an OLAP client?

SSAS

Which one of the following describes ROLAP?

Store only cube structure in multidimensional databases

The major goal of OLAP is

To optimize multidimensional analysis

The analytical technique that a user navigates among levels of data ranging from the most summarized to the most detailed level is called:

drill down