You work as a Database Administrator (DBA) for a company named ABC.com. The
company has a Windows Azure subscription. The company uses a cloud-based SQL
Server environment hosted on SQL Azure.
You have multiple databases hosted on separate database servers.
You need to design a SQL Server Reporting Services (SSRS) report project that will access
each of your databases on SQL Azure.
You need to configure the report to enable users to select the database server when they
run the report. You also need to ensure report subscriptions are supported in the report.
You verify that the security configuration and the schema of each database are identical.
After configuring the data source in the report, which three of the following actions should
you perform next? (Choose three).
A.
Configure a report parameter to display the database servers.
B.
Configure a shared dataset.
C.
Configure an expression-based connection string.
D.
Configure the data source to use stored credentials.
E.
Configure the data source to use integrated security.
Explanation:
A C D
https://msdn.microsoft.com/en-us/library/ff519560.aspx#Credentials
ACD.
Create a data source in the report. Create a report parameter that displays available values of SQL Azure hosts. Create an expression-based connection string. Configure the data source to use stored credentials.
A C D ” You also need to ensure report subscriptions are supported in the report”