You need to implement a solution that meets the requirements

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?

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.



Leave a Reply 9

Your email address will not be published. Required fields are marked *


marie

marie

I think C is correct

Hanz

Hanz

Hi anybody
which one is now quite right? A or C?

I prefer C, that makes more sense.
please help me?

rgds hanz

Ralph

Ralph

Definitywnie c. You will be ale to return all rowy and you will be ale to Process ech partii on separatory.

Andres

Andres

C – No need for roles in this case.

Ninja!

Ninja!

When in doubt, check Ralph his comments. 🙂

leo

leo

Agree 🙂