MS SQL Server - 84 - Cubes and Architectures MCQ

84 – Cubes and Architectures MCQ

1 / 25

1. What is a cube in the context of SQL Server Analysis Services (SSAS)?

A. A 3D geometric shape

B. A multidimensional data structure for analysis

D. A type of database backup

C. A data warehouse schema

2 / 25

2. Which type of cube in SSAS is optimized for query performance and typically used for large-scale data warehouses?

B. ROLAP (Relational OLAP)

A. MOLAP (Multidimensional OLAP)

C. HOLAP (Hybrid OLAP)

D. DOLAP (Dimensional OLAP)

3 / 25

3. What is the primary benefit of using a multidimensional cube in SSAS?

B. Real-time data processing

A. Enhanced data compression

C. Efficient querying of aggregated data

D. Support for unstructured data

4 / 25

4. Which component of SSAS is responsible for processing, aggregating, and storing data in a multidimensional cube?

D. Query Processor

A. Cube Designer

B. Data Source View

C. OLAP Storage Engine

5 / 25

5. In SSAS, what is a measure in the context of cubes?

B. A numeric value to be analyzed

A. A calculated dimension

D. A data source view

C. A type of hierarchy

6 / 25

6. Which language is commonly used to write calculations and expressions in SSAS for cube development?

C. C#

B. MDX (Multidimensional Expressions)

D. JavaScript

A. SQL

7 / 25

7. What is the purpose of a dimension in a multidimensional cube?

C. Managing security settings

D. Generating reports

B. Defining hierarchies for data analysis

A. Storing calculated values

8 / 25

8. In SSAS, what is a key attribute of a dimension?

C. A cube partition

B. A calculated measure

A. A unique identifier for each member

D. A data source view

9 / 25

9. What is a hierarchy in the context of multidimensional cubes in SSAS?

A. A type of data source

C. A collection of attributes organized by levels

D. A calculated measure

B. A folder structure for organizing dimensions

10 / 25

10. Which type of cube in SSAS stores data in a relational database and uses a star or snowflake schema?

B. ROLAP (Relational OLAP)

A. MOLAP (Multidimensional OLAP)

D. DOLAP (Dimensional OLAP)

C. HOLAP (Hybrid OLAP)

11 / 25

11. What is the primary advantage of using a MOLAP cube in SSAS?

A. Lower storage requirements

D. Real-time data processing

B. Faster query performance

C. Support for unstructured data

12 / 25

12. Which component of SSAS is responsible for designing the structure and relationships of a cube?

D. Query Processor

B. Cube Designer

A. Cube Browser

C. OLAP Storage Engine

13 / 25

13. What is a calculated measure in SSAS?

B. A measure that uses a custom expression or formula

A. A measure that is automatically calculated by SSAS

C. A measure that is stored in a separate cube

D. A measure that represents a dimension attribute

14 / 25

14. Which query language is used to query multidimensional cubes in SSAS?

D. JavaScript

A. SQL

C. C#

B. MDX (Multidimensional Expressions)

15 / 25

15. What is the primary role of the Query Processor in SSAS?

A. Creating calculated measures

D. Designing dimensions

C. Managing cube security

B. Processing and aggregating data for query execution

16 / 25

16. In SSAS, what is a parent-child hierarchy?

B. A hierarchy with a fixed number of levels

A. A hierarchy with only one level

D. A hierarchy with calculated members

C. A hierarchy that represents a tree-like structure

17 / 25

17. What is a dimension attribute in SSAS?

C. A hierarchy

B. A key attribute

D. A dimension property

A. A calculated measure

18 / 25

18. In SSAS, 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

19 / 25

19. Which type of cube in SSAS combines the benefits of both MOLAP and ROLAP cubes?

D. DOLAP (Dimensional OLAP)

B. ROLAP (Relational OLAP)

C. HOLAP (Hybrid OLAP)

A. MOLAP (Multidimensional OLAP)

20 / 25

20. What is the primary role of the Cube Browser in SSAS?

D. Processing and aggregating data

A. Designing dimensions

B. Creating calculated measures

C. Browsing and exploring cube data

21 / 25

21. In a star schema, what is the central fact table connected to?

C. A hierarchy

B. A single dimension table

D. A calculated measure

A. Multiple dimension tables

22 / 25

22. In SSAS, what is a perspective?

B. A type of hierarchy

D. A dimension attribute

C. A subset of a cube's dimensions and measures

A. A calculated measure

23 / 25

23. What is the main purpose of a named set in SSAS?

A. A set of named dimensions

D. A subset of cube data

B. A set of calculated measures

C. A set of dimension attributes

24 / 25

24. Which type of cube architecture in SSAS is ideal for handling complex, unstructured data?

A. MOLAP (Multidimensional OLAP)

B. ROLAP (Relational OLAP)

D. DOLAP (Dimensional OLAP)

C. HOLAP (Hybrid OLAP)

25 / 25

25. In SSAS, what is a write-back partition?

C. A partition that allows users to update data

B. A partition for storing calculated measures

D. A partition used for backup purposes

A. A partition used for read-only access

Your score is

MS SQL Server – 84 – Cubes and Architectures MCQ