DRAG DROP
You manage a SQL Server Reporting Services (SSRS) instance in native mode. You are
building a shared dataset for your weekly performance reports. The shared dataset uses a
data source that is configured to use credentials that are stored in the Report Server.
You have a predefined shared schedule to perform cleanup and maintenance tasks for SSRS.
You need to enable caching on the shared dataset. You also need to use an existing shared
schedule to discard the cache.
Which four actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation.
Explanation:
Box 1: Open Report Manager and then click the shared dataset.
We should use Report Manager (not SharePoint Central Administration).
Box 2: Select the Caching page and then click the Cache shared dataset checkbox.
We set up caching.
Box 3: Select the Expire the cache on the following schedule option and then select the
Shared Schedule option.
We configure caching further.
Box 4: From the combo box, select the shared schedule and then click Apply.
Finally we define scheduling.Note on caching:
To open the Caching properties page for a shared dataset
1. Open Report Manager, and locate the report for which you want to configure shared
dataset properties.
2. Point to the shared dataset, and click the drop-down arrow.
3. In the drop-down list, click Manage. The General properties page for the report
opens.
4. Click the Caching tab.
Options include:
Cache shared dataset (Box 2 above)
Places a temporary copy of the data in a cache when a user first opens a report that uses
this shared dataset. Subsequent users who run the report within the caching period receive
the cached copy of the data. Caching usually improves performance because the data is returned from the cache
instead of running the dataset query again.
Expire the cache on the following schedule (box 3 above)
Schedule the time when the cached data is no longer valid and is removed from the cache.
The schedule can be a shared schedule or one that is specific for only the current shared dataset.Reference: SQL Server 2012, Caching Page, Shared Datasets (Report Manager)
http://www.microsoft4shared.com/wp-content/uploads/2014/07/70-466-demo-25.jpg
http://www.microsoft4shared.com/wp-content/uploads/2014/08/clip_image00811.jpg
Exactly as Escort points to