You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Reporting Services (SSRS) to create a report named Marketing Trends
for the Marketing department.
The Marketing Trends pulls data from a single SQL Server.
You need to modify the report to also pull data from a cloud database hosted on Microsoft SQL
Azure. The current SQL Server database must continue to be used by the report.
Which two of the following steps should you perform? (Choose two)
A.
You should create an additional SQL Server data source.
B.
You should create a SQL Azure data source.
C.
You should create a SQL Azure dataset.
D.
You should modify the current dataset to use the new data source.
E.
You should create an additional dataset that uses the new data source.
Explanation: