Search Header Logo

Data Warehousing and Mining Quiz

Authored by JENEFA NAVEEN

Computers

University

Data Warehousing and Mining Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a type of Data Warehouse model?

Enterprise Warehouse

Data Mart

Virtual Warehouse

Distributed Transaction Store

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In OLAP, which operation involves viewing data from different perspectives?

Drill-down

Roll-up

Slice and Dice

Pivot

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which schema uses fact tables linked to multiple dimension tables?

Star Schema

Snowflake Schema

Fact Constellation

Dimension Schema

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The role of concept hierarchies in OLAP is to:

Support data summarization

Store raw data

Improve transaction speed

Index cube dimensions

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT an OLAP operation?

Roll-up

Drill-down

Join

Pivot

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Fact constellation schema is also called:

Galaxy Schema

Star Schema

Snowflake Schema

Fact Table

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Metadata repository in Data Warehousing is used for:

Storing operational data

Storing data about data

Transaction processing

ETL only

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?