MS SQL Server - 86 - Tabular Model MCQ

86 – Tabular Model MCQ

1 / 25

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

B. Storing raw operational data

A. Real-time transaction processing

D. Data encryption and security

C. Enabling efficient data analysis and reporting

2 / 25

2. Which programming language is primarily used for creating calculations and expressions in the Tabular Model?

D. C#

A. SQL

C. DAX (Data Analysis Expressions)

B. MDX (Multidimensional Expressions)

3 / 25

3. In the Tabular Model, what is the primary unit of data storage and analysis?

A. Fact table

C. Data source view

B. Dimension table

D. Data model

4 / 25

4. What does DAX stand for in the context of the Tabular Model?

B. Dimensional Analysis XML

C. Dynamic Access XQuery

D. Database Analysis XForms

A. Data Analysis eXpressions

5 / 25

5. Which component of SQL Server Analysis Services (SSAS) is responsible for processing, aggregating, and storing data in a Tabular Model?

B. Data Source View

A. Tabular Designer

C. Formula Engine

D. Query Processor

6 / 25

6. What is a calculated column in the Tabular Model?

C. A column derived from an existing column using DAX expressions

B. A column generated from an external data source

D. A column used for storing dimension attributes

A. A calculated measure

7 / 25

7. In the Tabular Model, what is the primary purpose of a dimension table?

C. Providing context for measures

B. Defining relationships between facts

D. Generating reports

A. Storing calculated values

8 / 25

8. What is a measure in the context of the Tabular Model?

A. A calculated dimension

B. A numeric value to be analyzed

D. A data source view

C. A type of hierarchy

9 / 25

9. Which language is commonly used to write DAX expressions in the Tabular Model?

B. MDX

C. DAX

D. Python

A. SQL

10 / 25

10. In the Tabular Model, what is the primary role of the Model Designer?

C. Defining relationships between tables and columns

A. Creating calculated measures

D. Browsing and exploring data

B. Designing fact tables

11 / 25

11. What is the purpose of a hierarchy in the Tabular Model?

B. Defining relationships between tables

A. Storing dimension attributes

D. Creating calculated measures

C. Organizing dimension attributes into levels

12 / 25

12. In the Tabular Model, what is a calculated table?

D. A table used for storing dimension attributes

B. A table that stores calculated values

C. A table derived from existing tables using DAX expressions

A. A table generated from an external data source

13 / 25

13. Which function is commonly used to create calculated columns in the Tabular Model using DAX?

B. CALCULATE

A. ADDCOLUMN

D. CREATECOLUMN

C. ADDEXPRESSION

14 / 25

14. What is a parent-child hierarchy in the context of the Tabular Model?

C. A hierarchy that represents a tree-like structure

B. A hierarchy with a fixed number of levels

D. A hierarchy with calculated members

A. A hierarchy with only one level

15 / 25

15. In the Tabular Model, what is a calculated measure?

B. A measure that is automatically calculated by SSAS

A. A calculated dimension

C. A measure that uses a custom DAX expression

D. A measure used for storing dimension attributes

16 / 25

16. What is the primary benefit of using columnar storage in the Tabular Model?

A. Faster data loading

B. Improved data encryption

C. Enhanced compression and query performance

D. Reduced storage space

17 / 25

17. In the Tabular Model, what is a filter context?

C. A context for evaluating DAX expressions based on filter conditions

A. A context for designing calculated tables

B. A context for defining relationships between tables

D. A context for organizing hierarchies

18 / 25

18. Which component of SQL Server Analysis Services (SSAS) is responsible for managing data security and access control in a Tabular Model?

B. Data Source View

C. Role Manager

A. Tabular Designer

D. Query Processor

19 / 25

19. What is the main purpose of a perspective in the Tabular Model?

B. Defining relationships between tables

A. Creating calculated columns

C. Simplifying the view of the model by selecting specific tables and columns

D. Storing calculated values

20 / 25

20. In the Tabular Model, what is a row-level security filter?

D. A filter used for sorting data

B. A filter applied to fact tables

C. A filter that restricts access to data at the row level based on user roles

A. A filter applied to dimension tables

21 / 25

21. What is the primary role of the Relationships tab in the Model Designer of the Tabular Model?

A. Creating calculated columns

C. Designing fact tables

B. Defining relationships between tables and columns

D. Browsing and exploring data

22 / 25

22. In the Tabular Model, what is the purpose of the Many-to-Many filter?

B. A filter applied to calculated columns

C. A filter used to restrict access to data

D. A filter applied to dimension tables

A. A filter used to define many-to-many relationships between tables

23 / 25

23. Which function is commonly used to aggregate data in DAX expressions in the Tabular Model?

C. AGGREGATE

D. EVALUATE

A. CALCULATE

B. SUMMARIZE

24 / 25

24. In DAX, which function is used to create a table expression for reporting purposes in the Tabular Model?

B. FILTER

D. SUMMARIZE

A. SELECTCOLUMNS

C. ADDCOLUMNS

25 / 25

25. What is the primary role of the Query Engine in the Tabular Model?

B. Creating calculated measures

A. Designing calculated tables

C. Processing and optimizing queries

D. Storing dimension attributes

Your score is

MS SQL Server – 86 – Tabular Model MCQ