web analytics

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A group of report writers develop reports. The report writers currently use Report Builder 1.0 and report
models. The report writers are not trained on SQL Server query writing. Their report assignments come
from various departments within the organization.
The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native
mode. After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an
instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from
only a subset of the data warehouse tables.
You are designing the data access strategy. You have the following requirements:
Ensure that report writers can create only reports that display data which they have database
permissions to view.
Minimize the effort required to update connection strings for all reports developed by the report writers.
Minimize the number of fields visible in a specific report for report writers who work for multiple
departments.
You need to design the data access strategy.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create report models by using SQL Server Data Tools (SSDT). Include data sources and data source
views for each department’s data requirements. Configure each data source to use integrated security.
B. Create one shared data source that uses integrated security. Create an embedded dataset for each
report.
C. Create one shared data source that uses integrated security. Create one shared dataset that includes
all tables required by the report writers.
D. Create one shared data source that uses integrated security. Create a shared dataset for each
department’s data requirements.
Answer: D