Exam Code: 70-466
Exam Name: Implementing Data Models and Reports with Microsoft SQL Server 2012
You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server. The Developer role cannot view and modify report caching parameters. You need to ensure that the Developer role can view and modify report caching parameters. Which task should you add to the Developer role?
A. View data sources
B. Manage individual subscriptions
C. Manage all subscriptions
D. Manage report history
Correct Answer: D
You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color. You need to modify the report so that users can sort products by the Price column. What should you do?
A. Add a group for the Price field.
B. Add a custom action to the Price text box.
C. Set the SortExpression property to =Fields!Price.Name for the Price text box.
D. Set the SortExpression property to =Fields!Price.Value for the Price text box.
E. Set the SortExpression value to =Fields!Price.Description for the Price text box.
F. In the Expression dialog box for the Price text box, enter the =SortBy Fields!Price.Value expression.
G. On the Row Visibility dialog box, select the Display can be toggled by this report item check box. Then select the Price text box.
H. In the Interactive Sorting page of the Price text box properties, select the Enable interactive sorting on this text box check box, and then select the Price field for the Sort by property.
Correct Answer: DH
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. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.
B. Create four partitions for the Sales table. Use row filter queries for each partition.
C. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.
D. Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.
Correct Answer: B