You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS).
Many of the SSRS reports will use common utilities and functions, including the following:
- Report utility functions and business logic in code - Standardized report formatting properties such as fonts and colors for report branding
Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Build a web service that retrieves formatting properties and runs code. Call the web service through a report dataset.
• B. Create an assembly that contains formatting properties and code. Deploy the assembly on the Reporting Server and reference the assembly from each report.
• C. Create a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template.
• D. Store the formatting properties and code in database objects. Use stored procedures to populate a default value for report parameters and map each parameter to a corresponding formatting property.

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 one shared data source that uses integrated security. Create a shared dataset for each department's data requirements.
• B. Create one shared data source that uses integrated security. Create one shared dataset that includes all tables required by the report writers.
• C. Create one shared data source that uses integrated security. Create an embedded dataset for each report.
• D. 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.

You need to develop an SSRS report that retrieves currency exchange rate data. How should you configure the data source for the report?

• A. Use the SQL Server data source type and then set a username and password for the credentials.
• B. Use the Windows Azure SQL Database data source type and then set a username and password for the credentials.
• C. Use the Windows Azure SQL Database data source type and then set Windows authentication for the credentials.
• D. Use the SQL Server data source type and then set Windows authentication for the credentials.

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Reports Writer is present on the server.
The Reports Writer role cannot view and modify report caching parameters.
You need to ensure that the Reports Writer role can view and modify report caching parameters.
What should you do?

• A. Add the Manage all subscriptions task to the Reports Writer role.
• B. Add the View data sources task to the Reports Writer role.
• C. Add the Manage report history task to the Reports Writer role.
• D. Add the Manage individual subscriptions task to the Reports Writer role.