You need to create a fully automated solution to ensure that reports do not deliver purged data

A company runs SQL Server Database Engine and SQL Server Reporting Services (SSRS)
in native mode. Reports are based on data that is cached in multiple shared datasets.
Source data is purged each day at midnight for regulatory compliance purposes. The shared
datasets may continue to cache data that should not be used in reports. Shared report
schedules are often paused during nightly server maintenance windows.
Reports must not return purged data.
You need to create a fully automated solution to ensure that reports do not deliver purged
data.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

A company runs SQL Server Database Engine and SQL Server Reporting Services (SSRS)
in native mode. Reports are based on data that is cached in multiple shared datasets.
Source data is purged each day at midnight for regulatory compliance purposes. The shared
datasets may continue to cache data that should not be used in reports. Shared report
schedules are often paused during nightly server maintenance windows.
Reports must not return purged data.
You need to create a fully automated solution to ensure that reports do not deliver purged
data.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

A.
Create a shared schedule. Configure the datasets to expire on the shared schedule.

B.
Write a script that calls the flushcache method to clear individual items from the SSRS
cache. Create a SQL Server Agent job that runs rs.exe with the script as an input file, and
schedule the job to run every day after the purge process completes.

C.
Create a SQL Server Agent job that uses a Transact-SQL (T-SQL) step to delete the data
from the dbo.ExecutionCache table in the ReportServerTempDB database. Schedule the job
to run every day after the purge process completes.

D.
Republish the cached datasets by using SQL Server Data Tools.



Leave a Reply 1

Your email address will not be published. Required fields are marked *