最新的Microsoft Implementing Data Models and Reports with Microsoft SQL Server (70-466日本語版) - 70-466日本語免費考試真題

* Sales:=SUM(FactSales[Revenue])
* Sales %:=[Sales] / CALCULATE([Sales], ALL(FactSales))



正確答案: B
DRAG DROP




正確答案:

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
* Open Report Manager, and locate the report for which you want to configure shared dataset properties.
* Point to the shared dataset, and click the drop-down arrow.
* In the drop-down list, click Manage. The General properties page for the report opens.
* 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.

正確答案: B

正確答案: A

正確答案: C,D

正確答案: A

正確答案: C
說明:(僅 Fast2test 成員可見)

正確答案: A

---

正確答案: D

正確答案: C

正確答案: D

正確答案: C