Star Schema vs Galaxy Schema Quiz

EnergeticCalcite avatar
EnergeticCalcite
·
·
Download

Start Quiz

Study Flashcards

10 Questions

In the online music shop example, what is the business event?

A customer purchasing a song

What does master data consist of in relation to a business event?

The answers to who, what, and where questions about the event

In the online music shop example, which of the following is NOT considered master data?

Payment method

In the bus driving example, what is the business process or transaction?

Driving one trip

Which of the following is NOT considered master data in the bus driving example?

Transport company

How many transactions occur in the bus driving example each day?

1000

What is the first step in identifying transaction data and master data in a business process?

Identify the business event

In the context of the bus driving example, what is the purpose of mentioning the transport companies?

To show that the transport companies are not directly involved in the trip

What determines whether an entity is considered master data in a business process?

Whether the entity is directly involved in the business event

What is the key difference between master data and transaction data in a business process?

Master data describes the business event, while transaction data records the event

Test your knowledge on star schema and galaxy schema in data warehousing. Learn about the differences between these two schema models.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.

Get started for free

More Quizzes Like This

Use Quizgecko on...
Browser
Browser