Graded Quiz: Designing, Modeling And Implementing Data Warehouses » Week 2 » Getting Started With Data Warehousing And BI Analytics

Q: Considering a general architectural model for an Enterprise Data Warehouse, which of these components is holding data and developing workflows?

Correct, these components are holding data and developing workflows.

Q: Materialized views can be used to __________.

Correct, they can be used to replicate data, for example to be used in a staging database.

Q: Accumulating snapshot fact tables are used to __________.

Correct, “Accumulating snapshot” fact tables are used to record events that take place during a well-defined business process.

Q: What do we call a normalized version of the star schema?

Correct, the normalized version of the star schema is called a snowflake schema, due to its multiple layers of branching which resembles a snowflake pattern.

Q: In what location is data from source systems extracted to?

Correct, a staging area is a separate location where data from source systems is extracted to.

Practice More Quizzes:

Getting Started with Data Warehousing and BI Analytics

Graded Quiz: An Introduction to Data Warehouses, Data Marts, and Data Lakes

6 Questions Week 1

Graded Quiz: Designing, Modeling and Implementing Data Warehouses

6 Questions Week 2

Graded Quiz: Data Warehouse Analytics

6 Questions Week 3

Final Quiz

12 Questions Week 4

Q:

Considering a general architectural model for an Enterprise Data Warehouse, which of these components is holding data and developing workflows?

View Solution

Q:

Materialized views can be used to __________.

View Solution

Q:

Accumulating snapshot fact tables are used to __________.

View Solution

Q:

What do we call a normalized version of the star schema?

View Solution

Q:

In what location is data from source systems extracted to?

View Solution

Q:

Materialized Views can be set up to have different refresh options, such as: (Select 1 answer).

View Solution

Name*

Email*

Website

0 Comments

Inline Feedbacks

View all comments

Find Questions in This Page: "CTRL+F"