This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the questions.
In which order should you load tables in the data warehouse?
Staging tables, then dimension tables, then fact tables
Staging tables, then fact tables, then dimension tables
Dimension tables, then staging tables, then fact tables
Which command should you use to load a staging table with data from files in the data lake?
COPY
LOAD
INSERT
When a customer changes their phone number, the change should be made in the existing row for that customer in the dimension table. What type of slowly changing dimension does this scenario require?
Type 0
Type 1
Type 2
You must answer all questions before checking your work.
Was this page helpful?