Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server (070-467日本語版) - 070-467日本語무료 덤프문제 풀어보기

Explanation

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

Explanation
Box 1:

Box 2:

Box 3:

설명: (Fast2test 회원만 볼 수 있음)

Explanation
Box 1:

Box 2:

Box 3:

Note:
* In Report Designer, after you create tables, charts, and other report items in a project, you can publish them asreport partsto a report server or SharePoint site integrated with a report server so that you and others can reuse them in other reports.
* . By using Report Builder, you can customize and update reports that were created in SQL Server Data Tools (SSDT) Report Designer.
* InReport Builder, IT pros and power users can create powerful operational reports, and reusable report parts and shared datasets.
Incorrect:
* (incorrect) Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from data models based on PowerPivot workbooks published in a PowerPivot Gallery, or tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances. Power View is a browser-based Silverlight application launched from SharePoint Server 2010 that enables users to present and share insights with others in their organization through interactive presentations.
Reference: Getting Started with Report Builder
Reference: Report Parts in Report Designer (SSRS)