Online Access Free 70-466 Exam Questions

You have a SQL Server Reporting Services (SSRS) instance. The instance has a report that displays 3 million records.
Users report that they experience performance issues when they use the report.
You need to ensure that the report renders as quickly as possible.
Which two actions should you perform? Each correct answer presents part of the solution.

• A.Create snapshots.
• B.Enable report history.
• C.Enable caching.
• D.Implement pagination.
• E.Enable versioning.

You have an application that uses a view to access data from multiple tables.
You need to ensure that you can insert rows into the underlying tables by using the view.
What should you do?

• A.Define the view by using the SCHEMABINDING option.
• B.Materialize the view.
• C.Define the view by using the CHECK option.
• D.Create an INSTEAD OF trigger on the view.

You need to modify the Sales cube to support the planning requirements.
Which SSAS feature should you use?

• A.A perspective
• B.A KPI
• C.A writeback partition
• D.A translation

You are working with a SQL Server Reporting Services (SSRS) instance in native mode.
An item role named Reports Writer is present on the server.
The Reports Writer role cannot view and modify report caching parameters.
You need to ensure that the Reports Writer role can view and modify report caching parameters.
What should you do?

• A.Add the Manage report history task to the Reports Writer role.
• B.Add the Manage individual subscriptions task to the Reports Writer role.
• C.Add the Manage all subscriptions task to the Reports Writer role.
• D.Add the View data sources task to the Reports Writer role.

You need to develop the multidimensional project to meet the requirements of the Excel users.
What should you do?

• A.Create security roles to restrict access to the executive team.
• B.Create a separate cube for the executive team so that it contains only the data they want to see.
• C.Create a view for the executive team.
• D.Create a perspective for the executive team.