NEW
Font size
WorksheetsData Warehouse and Data Mining_Module1
Total questions: 15
Worksheet time: 5mins
What is the main purpose of a data warehouse?
To store temporary data
To support decision making
To perform real-time transaction processing
To replace operational databases
In a multitier architecture of a data warehouse, the bottom tier is:
OLAP server
Data warehouse
Data source
Client
A _______ is a subset of a data warehouse that supports a specific group of users.
Data Lake
Data Mart
Data Hub
Data Grid
Which data warehouse model does not store data physically?
Enterprise warehouse
Data mart
Virtual warehouse
Operational warehouse
The process of extracting, cleaning, and loading data into a data warehouse is called:
ETL
OLAP
OLTP
ERP
Which component stores information about data in the data warehouse?
Metadata Repository
Data Mart
Fact Table
Data Cube
A data cube allows data to be modeled and viewed in:
One dimension
Two dimensions
Multiple dimensions
None of the above
A fact table contains:
Only dimension attributes
Only textual data
Measurable, quantitative data
Metadata
Which of the following is NOT a type of schema used in multidimensional models?
Star schema
Ring schema
Snowflake schema
Fact constellation schema
A fact constellation schema is also known as:
Flat schema
Galaxy schema
Virtual schema
Hybrid schema
Which OLAP operation provides a more detailed view?
Roll-up
Drill-down
Slice
Pivot
Which OLAP operation selects a single dimension from a cube?
Roll-up
Drill-down
Pivot
Slice
What is a Starnet Query Model?
A graphical model to express multidimensional queries
A method for data visualization
A query optimization algorithm
A type of metadata
Which schema allows dimension tables to be shared across fact tables?
Star schema
Snowflake schema
Fact constellation schema
Flat schema
Roll-up operation results in:
More detailed data
Aggregated data
Rotation of axes
Filtering data
