You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in staging tables in preparation for a data warehouse load.
The package and all three Execute SQL product tasks have their TransactionOption property set to Supported.
You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will roll back their changes.
What should you do?

• A. Move the three Execute SQL product tasks into a Sequence container.
• B. Change the TransactionOption property of all three Execute SQL product tasks to Required.
• C. Change the TransactionOption property of the package to Required.
• D. Move the three Execute SQL product tasks into a Foreach Loop container.

解説: (GoShiken メンバーにのみ表示されます)

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base.
In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain.
You need to complete the mapping of the Group column.
What should you do?

• A. Map a composite domain to the source column.
• B. Add a column mapping for the Group column.
• C. Create a composite domain that includes the Group column.
• D. Add a domain for the Group column.

To support the implementation of new reports, Active Directory data will be downloaded to a SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package.
The following requirements must be met:
All the user information for a given Active Directory group must be downloaded to a SQL Server table. The download process must traverse the Active Directory hierarchy recursively.
You need to configure the package to meet the requirements by using the least development effort.
What should you use?

• A. script task
• B. custom component
• C. XML source
• D. script component

You are designing a data warehouse that contains a product dimension.
The product dimension contains the original product attributes as well as the most recent set of updated attributes. When a product is updated, the original product attributes must be preserved.
The product dimension design must:
* Support a Type 3 Slowly Changing Dimension (SCD) process
* Minimize the total storage consumed
You need to design a solution that meets these requirements.
What should you do?

• A. Design a table to hold the surrogate key for each product and its attributes as well as additional columns to store the original attributes.
• B. Design a table as a Type 2 SCD dimension that holds the surrogate key for each product and its attributes. Limit the number of records per product within the table to two.
• C. Design two tables. One table will hold the original product surrogate key and attributes. The other table will hold the most recent product surrogate key and attributes.
• D. Design a table to hold the surrogate key for each product and its attributes. Add a column to store an indicator that identifies the record as original data or recent data.

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse.
You add an Execute SQL task to the control flow.
The task must execute a simple INSERT statement. The task has the following requirements:
*The INSERT statement must use the value of a string package variable. The variable name is StringVar.
*The Execute SQL task must use an OLE DB Connection Manager.
In the Parameter Mapping tab of the Execute SQL task, StringVar has been added as the only parameter.
You must configure the SQLStatement property of the Execute SQL task.
Which SQL statement should you use?

• A. INSERT INTO dbo.Table (variablevalue) VALUES (0)
• B. INSERT INTO dbo.Table (variablevalue) VALUES (@0)
• C. INSERT INTO dbo.Table (variablevalue) VALUES (?)
• D. INSERT INTO dbo.Table (variablevalue) VALUES ($StringVar)

解説: (GoShiken メンバーにのみ表示されます)