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