最新的Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server (70-467日本語版) - 70-467日本語免費考試真題

Explanation
Box 1: Restore the SSISDB database from the last backup.
Box 2: Restore the SSISDB master key.
Box 3: Open the SSISDB database master key
Note:
To Restore the SSIS Database
* Restore the SSISDB database from the backup by using the Restore Database dialog box in SQL Server Management Studio.
* Restore the master key (Use this method if you have the original password that was used to create SSISDB), open master key decryption by password = 'LS1Setup!' --'Password used when creating SSISDB'Alter Master Key Add encryption by Service Master Key

說明：（僅 Fast2test 成員可見）

Explanation
Box 1: Connect to the SSISDB database.
Box 2:

Box 3: Execute the query
Note:
* execution_component_phases
Displays the time spent by a data flow component in each execution phase.
* The following example uses the catalog.execution_component_phases view to find the total amount of time that a specific package has spent executing in all phases (active_time), and the total elapsed time for the package (total_time).
Use SSISDB
Select package_name, task_name, subcomponent_name, execution_path,
SUM(DATEDIFF(ms,start_time,end_time)) as active_time,
DATEDIFF(ms,min(start_time), max(end_time)) as total_time
From catalog.execution_component_phases
Where execution_id = 1841
Group by package_name, task_name, subcomponent_name, execution_path
Order by package_name, task_name, subcomponent_name, execution_path
* catalog.executables
This view displays a row for each executable in the specified execution.
An executable is a task or container that you add to the control flow of a package.
*(incorrect) catalog.executions (SSISDB Database)
Displays the instances of package execution in the Integration Services catalog. Packages that are executed with the Execute Package task run in the same instance of execution as the parent package.
This view displays a row for each instance of execution in the catalog.
* (incorrect) catalog.operation_messages
Displays messages that are logged during operations in the Integration Services catalog.
This view displays a row for each message that is logged during an operation in the catalog. The message can be generated by the server, by the package execution process, or by the execution engine.
Reference: catalog.execution_component_phases
Reference: catalog.executables

Explanation
Box 1:

Box 2:

Box 3:

Box 4:

Ref: http://technet.microsoft.com/en-us/library/ms170463.aspx

Explanation

Note:
To set a filter on the dataset
* Open a report in Design view.
* Right-click a dataset in the Report Data pane and then clickDataset Properties. TheDataset Properties dialog box opens.
* ClickFilters. This displays the current list of filter equations. By default, the list is empty.
* ClickAdd. A new blank filter equation appears.
* InExpression, type or select the expression for the field to filter. To edit the expression, click the expression (fx) button.
Box 1: Here we use the Fields expression.
* From the drop-down box, select the data type that matches the type of data in the expression you created
* in step 5.
* In theOperatorbox, select the operator that you want the filter to use to compare the values in the Expressionbox and theValuebox. The operator you choose determines the number of values that are used from the next step.
Box 2: we test for equality.
* In theValuebox, type the expression or value against which you want the filter to evaluate the value in Expression.
Box 3: we compare to the value of the Parameter named Site.
* Click OK.
Reference: How to: Add a Filter (Reporting Services)

Explanation

說明：（僅 Fast2test 成員可見）