MS SQL Server - 85 - Multidimensional Model MCQ

85 – Multidimensional Model MCQ

1 / 25

1. What is the primary purpose of the Multidimensional Model in SQL Server Analysis Services (SSAS)?

A. Real-time transaction processing

D. Data encryption and security

B. Storing raw operational data

C. Enabling complex data analysis and reporting

2 / 25

2. Which term is commonly used to describe data organized in a cube in the Multidimensional Model?

B. Hierarchies

C. Dimensionality

D. Star schema

A. Factoring

3 / 25

3. What does MDX stand for in the context of the Multidimensional Model?

D. Multidimensional Expressions

C. Multidimensional Data eXtraction

B. Multidimensional Design Expressions

A. Multidimensional Data Extension

4 / 25

4. In the Multidimensional Model, what is the primary purpose of a dimension?

B. Defining relationships between facts

A. Storing calculated values

D. Generating reports

C. Providing context for measures

5 / 25

5. Which component of SQL Server Analysis Services (SSAS) is responsible for storing and aggregating data in the Multidimensional Model?

B. Cube Browser

D. Query Processor

C. OLAP Storage Engine

A. Data Source View

6 / 25

6. What is a measure group in the context of the Multidimensional Model?

B. A collection of calculated measures

C. A grouping of related measures

D. A type of hierarchy

A. A set of related dimensions

7 / 25

7. In the Multidimensional Model, what is the primary role of a fact table?

C. Defining hierarchies

A. Storing dimension attributes

D. Storing transactional data

B. Providing context for measures

8 / 25

8. What is a calculated member in MDX?

C. A custom measure defined using MDX expressions

D. A predefined measure

A. A dimension attribute

B. A member of a hierarchy

9 / 25

9. In the Multidimensional Model, what is the role of a hierarchy?

A. Storing dimension attributes

C. Defining relationships between facts

B. Providing context for measures

D. Organizing dimension attributes into levels

10 / 25

10. Which of the following statements accurately describes the use of surrogate keys in the Multidimensional Model?

B. Surrogate keys are used as natural keys in fact tables.

C. Surrogate keys are used as primary keys in dimension tables.

A. Surrogate keys are used as dimension attributes.

D. Surrogate keys are used to calculate measures.

11 / 25

11. What is the primary purpose of the KeyColumn property in the Multidimensional Model?

A. Storing calculated values

D. Generating reports

B. Defining relationships between dimensions

C. Identifying the key column in a dimension attribute

12 / 25

12. What is a dimension property in the Multidimensional Model?

D. A fact table

B. A type of hierarchy

C. A descriptive attribute of a dimension attribute

A. A calculated member

13 / 25

13. In MDX, what function is commonly used to create calculated members?

C. WITH MEMBER

D. CALCULATE MEMBER

A. CREATE MEMBER

B. ALTER MEMBER

14 / 25

14. Which component of SQL Server Analysis Services (SSAS) is responsible for designing the structure of a cube in the Multidimensional Model?

C. OLAP Storage Engine

A. Cube Designer

D. Query Processor

B. Data Source View

15 / 25

15. In the Multidimensional Model, what is a parent-child hierarchy?

A. A hierarchy with only one level

B. A hierarchy with a fixed number of levels

D. A hierarchy with calculated members

C. A hierarchy that represents a tree-like structure

16 / 25

16. What is the purpose of a named set in MDX?

A. A set of named dimensions

B. A set of calculated measures

C. A set of dimension attributes

D. A set of predefined measures

17 / 25

17. In the Multidimensional Model, what is a data source view (DSV)?

A. A view that summarizes cube data

D. A view that contains calculated measures

C. A view that represents dimension hierarchies

B. A view that connects to external data sources

18 / 25

18. What is the main purpose of the Aggregation Design Wizard in the Multidimensional Model?

D. Defining hierarchies

A. Designing calculated measures

C. Optimizing cube storage and query performance

B. Creating dimension attributes

19 / 25

19. In the Multidimensional Model, what is a KPI (Key Performance Indicator)?

C. A dimension property

B. A calculated member

A. A type of dimension attribute

D. A fact table

20 / 25

20. What is the primary role of the Calculations tab in the Cube Designer of the Multidimensional Model?

D. Organizing hierarchies

B. Creating calculated members and KPIs

C. Designing fact tables

A. Defining dimension attributes

21 / 25

21. In the Multidimensional Model, what is a write-back dimension?

A. A dimension that allows for real-time data updates

C. A dimension attribute

B. A dimension that stores calculated members

D. A named set

22 / 25

22. What is the purpose of the MeasureExpression property in the Multidimensional Model?

A. Defining relationships between measures

C. Storing dimension attributes

B. Calculating measures based on MDX expressions

D. Organizing fact tables

23 / 25

23. In MDX, which function is used to define member properties?

B. CREATE PROPERTY

A. DEFINE PROPERTY

C. MEMBER PROPERTY

D. PROPERTY DEFINE

24 / 25

24. Which type of dimension attribute in the Multidimensional Model is used for organizing other attributes into levels?

B. Parent attribute

A. Key attribute

D. User-defined hierarchy

C. Composite attribute

25 / 25

25. What is a dimension role in the Multidimensional Model?

C. A role that determines security settings for dimensions

B. A role that specifies member properties

D. A role that defines relationships between facts

A. A role that defines calculated measures

Your score is

MS SQL Server – 85 – Multidimensional Model MCQ