← Back to exam page

70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2014

Loading demo links...

Showing 4–6 of 10 questions

Question 4 (Mixed Questions)

HOTSPOT

You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database.

You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns.

Which report item should you add? To answer, select the appropriate setting in the answer area.

Hot Area:

Answer is in the explanation below.

Question 5 (Case Study 2)

You need to develop the executive reports.

What should you do? (Each correct answer presents part of the solution. Choose ail that apply.)

Select all that apply, then click Submit answer.

  • ○

    Provide default values for all parameters.
  • ○

    Set the data source to use Windows authentication.
  • ○

    Remove default values from all parameters.
  • ○

    Implement dataset filters to filter data.
  • ○

    Set the data source to use stored Windows credentials.
  • ○

    Implement dataset query parameters to filter data.
Question 6 (Mixed 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.

Select all that apply, then click Submit answer.

  • ○

    Enable versioning.
  • ○

    Enable caching.
  • ○

    Enable report history.
  • ○

    Create snapshots.
  • ○

    Implement pagination.