最新的Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 (70-463日本語版) - 70-463日本語免費考試真題

說明：（僅 Fast2test 成員可見）

Explanation

SSIS log provider: SQL Server
Event type: ExecutesSQLExecutingQuery
The following describes the custom log entry for the Execute SQL task:
ExecuteSQLExecutingQuery provides information about the execution phases of the SQL statement. Log entries are written when the task acquires connection to the database, when the task starts to prepare the SQL statement, and after the execution of the SQL statement is completed. The log entry for the prepare phase includes the SQL statement that the task uses.
Note: You can log the calls that the Execute SQL task makes to external data providers. You can use this logging capability to troubleshoot the SQL commands that the Execute SQL task runs. To log the calls that the Execute SQL task makes to external data providers, enable package logging and select the Diagnostic event at the package level.

說明：（僅 Fast2test 成員可見）

說明：（僅 Fast2test 成員可見）

說明：（僅 Fast2test 成員可見）

Explanation

Explanation

Ref: http://msdn.microsoft.com/en-gb/library/hh231191.aspx

Explanation
Box 2:

Box 3:

Box 1:

Box 4:

Note:
Step 1-2:
* SQL Server Data Quality Services (DQS) is a new feature in SQL Server 2012 that contains the following two components: Data Quality Server and Data Quality Client.
* You have to use the SQL Server 2012 Setup to install DQS components. When you run the SQL Server Setup, you have to go through a series of installation wizard pages to select appropriate options based on your requirements.
/ Feature Selection
Data Quality Services under Database Engine Services to install the Data Quality Server.
Data Quality Client to install Data Quality Client.
Step 3-4:
* The Data Quality Services (DQS) security infrastructure is based upon the SQL Server security infrastructure. A database administrator grants a user a set of permissions by associating the user with a DQS role. Doing so determines the DQS resources that the user has access to and the functional activities that the user is allowed to perform.
* There are four roles for DQS. One is the database administrator (DBA) who deals primarily with product installation, database maintenance, and user management. This role primarily uses the SQL Server Management Studio, rather than within the Data Quality Client application. Their server role is sysadmin.
The three other roles are information workers, data stewards who use the product directly by working in the Data Quality Client application. These roles include the following:
/ The DQS Administrator (dqs_administrator role) can do everything in the scope of the product.
/ The DQS KB Editor (dqs_kb_editor role) can perform all of the DQS activities, except for administration.
/ The DQS KB Operator (dqs_kb_operator role) can edit and execute a project. They cannot perform any kind of knowledge management; they cannot create or change a knowledge base. They can see the activity monitoring data, but cannot terminate an activity or perform administrative duties.
Ref: http://msdn.microsoft.com/en-gb