← Back to exam page

70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Loading demo links...

Showing 4–6 of 10 questions

Question 4 (Mixed Questions)

HOTSPOT

A company maintains separate environments for test, production, and quality assurance. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.

You create an SSIS project to perform a weekly refresh of the company's data warehouse and cubes. The project has three packages.

You need to configure the project to ensure so that the test and production teams can run each package without manually adding server-specific information.

Which program should you use?

To answer, select the appropriate program in the answer area.

Hot Area:

Answer is in the explanation below.

Question 5 (Case Study 5)

You need to ensure that the Sales measure in the Power View field list meets the requirements. What should you do? (Each correct answer presents a part of the solution. Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    Format the column to display zero decimal places.
  • ○

    Hide the column from client tools.
  • ○

    Create a measure named Sales based on the column by using the Data Analysis Expressions (DAX) SUM() function.
  • ○

    Rename the column to Sales.
  • ○

    Format the measure to display zero decimal places.
Question 6 (Case Study 2)

You need to design the recovery strategy for SSRS01.

What should the strategy include? (Each correct answer presents part of the solution. Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    Re-create the SQL Server Agent jobs that are used to trigger schedules.
  • ○

    Restore the ReportServer and ReportServerTempDB databases with recovery.
  • ○

    Restore the ReportServer and ReportServerTempDB databases with no recovery.
  • ○

    Restore the msdb database.
  • ○

    Restore the Report Server encryption key.
  • ○

    Restore the database encryption key.