Loading demo links...
Showing 1–12 of 12 questions
What is a data warehouse primarily designed to support?
Select an option, then click Submit answer.
How does OLAP differ from OLTP in workload?
Select an option, then click Submit answer.
What does Inmon's definition emphasize for a warehouse?
Select an option, then click Submit answer.
What is the role of a data mart?
Select an option, then click Submit answer.
Which architecture feeds marts from a central warehouse?
Select an option, then click Submit answer.
What does time-variant mean in warehousing?
Select an option, then click Submit answer.
Which two are warehouse defining characteristics? (Choose two.)
Select all that apply, then click Submit answer.
Which two belong in a DW/BI architecture? (Choose two.)
Select all that apply, then click Submit answer.
Which two describe Kimball's approach? (Choose two.)
Select all that apply, then click Submit answer.
DRAG DROP
Match each architecture element to its function.
Items to match: Staging area, Warehouse database, Data mart, Presentation tools.
Answer is in the explanation below.
CORRECT TEXT
A warehouse is subject-oriented, integrated, time-variant and ______.
Answer is in the explanation below.
DRAG DROP
Match each modeling term to its meaning.
Items to match: Grain, Fact table, Dimension table, Surrogate key.
Answer is in the explanation below.
