Question

Point out the correct statement.

(a) Few MDX queries run within a specified cube context

(b) SELECT statement is the most frequently used query in MDX

(c) When formulating a Multidimensional Expressions (MDX) SELECT statement, an application typically examines a cube and divides the set of hierarchies into three subsets

(d) None of the mentioned

This question was addressed to me in my homework.

Asked question is from MDX in chapter Business Intelligence of SQL Server

Answer 1

The correct choice is (b) SELECT statement is the most frequently used query in MDX

The best explanation: By understanding how an MDX SELECT statement must specify a result set, what the syntax of the SELECT statement is, and how to create a simple query using the SELECT statement, you will have a solid understanding of how to use MDX to query multidimensional data.