Microsoft
70-467 · Question #122
70-467 Question #122: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #122. The question stem and answer options stay visible for context.
Question
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 archived 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 archived data. You need to create a fully automated solution to ensure that reports do not deliver archived data. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- AWrite a script that calls the flushcache method to clear individual items from the SSRS cache.
- BCreate a SQL Server Agent job that uses a Transact-SQL (T-SQL) step to truncate the dbo.
- CCreate a SQL Server Agent job that restarts the SQL Server Reporting Services service.
- DCreate a shared schedule.
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.