What should you do?

DRAG DROP
You are designing a SQL Server Reporting Services (SSRS) solution.
A report project must access multiple SQL Server databases. Each database is on a
different instance. 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.)

DRAG DROP
You are designing a SQL Server Reporting Services (SSRS) solution.
A report project must access multiple SQL Server databases. Each database is on a
different instance. 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.)

Answer:

Explanation:

Note:
The report need a data source.
Through a report parameter the user can select among the available SQL Server instances.
This selection is used through an expression-based connection string.
Authentication is handled through stored credentials.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Mahmoud Ibrahim

Mahmoud Ibrahim

ok