70-466日本語 無料問題集「Microsoft Implementing Data Models and Reports with Microsoft SQL Server (70-466日本語版)」
DRAG DROP
正解：
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* You can use the Linked Object Wizard to either link to or import cubes, dimensions, measure groups, calculations, and Key Performance Indicators (KPIs). You can link to or import these items from another database on the same server or from a database on a remote server
* On the Select a Data Source page of the Linked Object Wizard, choose the Analysis Services data source or create a new one.
* On the Select Objects page of the wizard, choose the dimensions you want to link to in the remote database. You cannot link to linked dimensions in the remote database.
* Incorrect:
The Business Intelligence Wizard can guide you through some or all the following steps:
Define time intelligence for cubes.
Define account intelligence for cubes and dimensions.
Define dimension intelligence for cubes and dimensions.
Define unary operators for cubes.
Set custom member formulas for cubes and dimensions.
Specify attribute ordering for dimensions.
Enable dimension writeback for dimensions.
Define semi-additive behavior for cubes.
Define currency conversion for cubes.
DRAG DROP
正解：
Explanation:
Box 1: On the Partitions tab, Click Storage Settings
We specify the Storage Settings for the correct partition.
Box 2: Enable proactive caching.
We enable proactive caching.
Box 3: Select the Client initiated notification type, and then select the tblOrders table.
On the Notifications tab, there are three options out of which, as shown below, you can select any one at a time.
* SQL Server - With this option, SSAS uses SQL Server notification services/specialized trace mechanism to identify data changes.
* Client initiated - With this option, client can specify the XMLA (XML for Analysis) command (NotifyTableChange) to identify data changes.
* Scheduled polling - With this option, SSAS uses a series of queries to see (polling at defined interval) if there is any data change at the underlying relational database.
Note:
You use the Storage Settings dialog box in BIDS (Business Intelligence Development Studio) to set the proactive caching feature, storage location, and notification settings for a dimension, cube, measure group, or measure group partition.
* In the Cube Browser, open your cube and select the Partitions tab.
* Expand the measure group and select the partition for which you want to enable proactive caching.
* Click the Storage Setting link to open the Partition Storage Settings dialog box similar to the one as shown in below image. (Box 1)
The Custom Setting allows you to explicitly enable proactive caching (if you don't want to use Standard Setting), set storage mode, and notification options. (Box 2)
DRAG DROP
正解：
Explanation: Box 1:
Box 2:
Box 3:
Note:
* (Step 1, step 2): The model requires a key performance indicator (KPI) named Defective Units to measure the rate of production of defective units. The rate of production of defective units is calculated by dividing the sum of the Defects column by the sum of the Units column.
* Step 3: The KPI has the following requirements.
*If the rate of production of defective products equals or exceeds 5% then the KPI must report a status of off target (red).
*If the rate of production of defective products is less than 5% and equals or exceeds 2% then the KPI must report a status of slightly off target (yellow).
*If the rate of production of defective products less than 2% then the KPI must report a status of on target (green).
