Microsoft
70-768 · Question #50
70-768 Question #50: Real Exam Question with Answer & Explanation
The correct answer is B. Create four partitions for the Sales table. Use row filter queries for each partition.. See the full explanation below for the reasoning.
Question
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?
Options
- AConvert the Sales table into four smaller tables by using row filter queries. Use one perspective
- BCreate four partitions for the Sales table. Use row filter queries for each partition.
- CConvert the Sales table into four smaller tables by using row filter queries. Use one perspective
- DCreate four partitions for the Sales table. Create four roles. Use the same row filter queries for
Community Discussion
No community discussion yet for this question.