You work as a database administrator at ABC.com. Your duties include managing a SQL Server
2008 database server named ABC-DB05, which hosts the SQL Server 2008 Reporting Services
(SSRS) role as well as a recovery instance.
The role contains the reports of the various divisions. To retrieve the information ABC.com users
make use of stored procedures.
How can you ensure that the reports will function?
A.
An expression should be inserted at the report footer.
B.
A filter should be added to the stored procedure.
C.
Encryption keys should be recovered.
D.
The configurations of the report need to be modified.