List any four of the physical design steps. For two of the selected four, describe the activities.
Name the physical design objectives. Which objective do you think ranks as the most important?
What are the components that make up the physical model? How are these related to components of the logical model?
Give two reasons why naming standards are important in a data warehouse environment.
List any three techniques for optimizing storage. Describe these briefly.
What is index-only read? How does it improve performance?
Give two reasons why B-Tree indexing is superior to other indexing methods.
What is meant by the selectivity for a column in a physical table? What type of indexing technique is suitable for low-selectivity data? Why?
What is data partitioning? Give two reasons why data partitioning is helpful in a data warehousing environment.
What is data clustering? Give an example.