You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft
SQL Server 2012 environment and has recently deployed SQL Server 2012 Reporting
Services (SSRS).
The company will eventually use hundreds of SSRS reports. All the reports will use the
standard corporate branding, fonts and text styles. Many of the reports will also use
common functions that will be coded by developers.
You need to recommend a reporting strategy that enables all reports to use the corporate
branding and fonts and the function code. You need to be able to modify the corporate
branding and function code if required without recreating all the reports.
Where should the corporate branding, fonts and text styles and the function code should
be stored?
A.
The corporate branding, fonts and text styles and the function code should be stored in a SQL
Server database.
B.
The corporate branding, fonts and text styles and the function code should be stored in a web
service.
C.
The corporate branding, fonts and text styles and the function code should be stored in an
assembly on an SSRS server.
D.
The corporate branding, fonts and text styles and the function code should be stored in a report
template.
Explanation:
C