What should you do?

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.

View Answer

Answer: C