Exam Code: 70-467
Exam Name: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
You are designing a SQL Server Reporting Services (SSRS) solution. A report project must access multiple SQL Azure databases. Each database is on a different host. The databases have identical schema and security configurations. You have the following requirements:
The report must support subscriptions.
Users must be able to select the host when running the report.
What should you do?
To answer, drag the appropriate phrase or phrases from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Select and Place:
You are designing a SQL Server Reporting Services (SSRS) solution. An existing report aggregates data from a SQL Server database in a chart. You need to use the chart in a new report and ensure that other users can use the chart in their reports. Which three actions should you perform in sequence?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription schedules and report formats. You need to ensure that users can receive reports by email according to their preferences. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a standard subscription for each record in the table.
B. Create a data-driven subscription for each record in the schedule table.
C. Create one data-driven subscription. Schedule the subscription to frequently retrieve user preferences.
D. Create a standard subscription for each subscription schedule.
Correct Answer: C