Designing and implementing a data warehouse with SQL Server requires an understanding of both the business processes that users want to report, analyze, and derive insights from and the structures that make up the logical and physical design of a data warehouse. The combination of these skills results in the design of a practical data model that can be used by business users to quickly answer business questions that most transactional systems cannot address efficiently.
IMPORTANT Have you read page xvii?
It contains valuable information regarding the skills you need to pass the exam.
This chapter covers how to create a logical and physical model of common business processes in a data warehouse ...