Topic 4, Mix Questions
You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named Sales. The Sales table includes a single date column.
The Sales table must meet the following requirements:
• Queries must be able to return all rows.
• Must be able to support four different processing schedules for different date ranges.
• Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?
A . Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.
B . Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.
C . Create four partitions for the Sales table. Use row filter queries for each partition.
D . Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.
Answer: C