1. When handling the changes, we should use the actual production key instead of a surrogate key.

True or False

2. Which of the following is not the advantage of a top-down approach?

A) Inherently architected

B) Centralized control

C) Enterprise view of data

D) Central repository of data

E) Easy to implement

3. In Tableau, when is filtering your data using parameters helpful?

A) When you want to isolate your data to display the bottom data only

B) When you want to exclude certain data

C) When you want to isolate your data to display the top data only

D) When you want to obtain a visible control of your filter

E) None of the above

4. A local grocery company wants to develop a data warehouse system by adapting the bus architecture. They wish to first identify conformed dimensions for the system. Which of the following dimension(s) can be recognized as a conformed dimension(s)?

A) Customer dimension

B) Store dimension

C) Product dimension

D) All of the above

E) None of the above

5. Suppose there exists a heterogeneous product schema to represent the different services provided by AT&T. Where would you store number of text messages?

A) Custom Cell Phone Fact Table

B) Cell Phone Dimension Table

C) Custom Cell Phone Dimension Table

D) Core Fact Table

E) None of the above