Data Warehousing Quiz

Identify the correct definition of a Data Mart.

• A subset of a data warehouse focused on a specific business line

• A relational database

• A type of OLAP operation

• A metadata repository

Identify the schema that resembles a star-like structure.

• Star schema

• Fact constellation

• Snowflake schema

• Normal schema

Name the process of cleaning and converting data before loading it into a warehouse.

• ETL

• OLAP

• DBMS

• ROLAP

Identify the main reason for using concept hierarchies in dimensions.

• To allow data to be viewed at different granularities

• To create unique keys

• To replicate tables

• To perform ETL

Identify the correct reason why enterprise warehouses are preferred for large organizations.

• They provide a central data source for all departments

• They store only marketing data

• They do not require ETL

• They are web-based

State the role of dimension tables in a star schema.

• Provide context (descriptive data) for fact tables

• Store transaction-level records

• Perform aggregations

• Contain metadata

Identify the main purpose of data cube computation.

• To pre-compute aggregations for fast query response

• To store raw data

• To visualize entity relationships

• To normalize databases

Select the role of fact tables.

• Store measurable, quantitative data

• Describe dimension attributes

• Describe dimension attributes

• Contain only metadata

Identify why OLAP operations support slicing and dicing.

• To analyze data from multiple perspectives

• To perform CRUD operations

• To write to operational systems

• To index data

Identify a valid benefit of using OLAP over traditional querying.

• OLAP supports multidimensional analysis

• OLAP is faster for transactional queries

• OLAP replaces ETL

• OLAP doesn't need data modeling