Quiz 70-467, Designing Business Intelligence Solutions with Microsoft SQL Server 2012
You need to modify the schema
Which set should you use?
You need to redesign the cube dimension to meet the requirements
Which relationship type should you choose?
Data is frequently queried at the day level and occasionally at the month level.
Which partitioning strategy should you choose?
You need to design an ETL process that meets the requirements
Which three actions should you perform in sequence?
What should you do?
You need to design a MOLAP cube that meets the requirements