Quiz 70-467, Designing Business Intelligence Solutions with Microsoft SQL Server 2012
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
You need to design the fact table to meet the requirements