ITP104 - Week 5 - Quiz

The practice of analyzing datasets to make judgments about the information they contain.

• Data Mart

• Query Tools

• Data Warehouse

• Data Analytics

It is also referred to as "consolidation" or "aggregation".

• Slice

• Pivot

• Roll-up

• Drill-down

They are tools the users use to communicate with the data warehouse system.

• Data Warehouse

• Query Tools

• Data Mart

• Data Analytics

It breaks the info into smaller pieces.

• Slice

• Pivot

• Roll-up

• Drill-Down

It is an access layer of a data warehouse used to distribute data to users.

• Data Warehouse

• Data Analytics

• Data Mart

• Query Tools

It is a type of information system that holds present and historical data from one or more sources.

• Query Tools

• Data Warehouse

• Data Mart

• Data Analytics

It is where a new sub-cube is made by choosing one dimension.

• Pivot

• Drill-Down

• Slice

• Roll-up

It is the central component of the OLAP concept.

• OLAP

• OLAP Cube

• ETL Tools

• Query Tools

It can change one data presentation for another by rotating the data axes.

• Roll-up

• Drill-Down

• Slice

• Pivot

It is a kind of software that enables users to simultaneously evaluate data from several database systems.

• ETL Tools

• OLAP Cube

• Query Tools

• OLAP