070-463 無料問題集「Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014」
You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS).
The package includes custom scripts that must be upgraded.
You need to upgrade the package to SQL Server 2012.
Which tool should you use?
The package includes custom scripts that must be upgraded.
You need to upgrade the package to SQL Server 2012.
Which tool should you use?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model. The model consists of two entities: one named Customer and one named State. You open the Customer entity.
Currently, data stewards can enter any text value in the Customer entity's State attribute. You must restrict the entry of values in the State attribute to members defined in the State entity.
You need to configure the State attribute of the Customer entity.
Which option should you use? (To answer, select the appropriate area in the answer area.)
Currently, data stewards can enter any text value in the Customer entity's State attribute. You must restrict the entry of values in the State attribute to members defined in the State entity.
You need to configure the State attribute of the Customer entity.
Which option should you use? (To answer, select the appropriate area in the answer area.)
正解：
Explanation
You are designing a SQL Server Integration Services (SSIS) package. The package moves order-related data to a staging table named Order. Every night the staging data is truncated and then all the recent orders from the online store database are inserted into the staging table.
Your package must meet the following requirements:
*If the truncate operation fails, the package execution must stop and report an error.
*If the Data Flow task that moves the data to the staging table fails, the entire refresh operation must be rolled back.
*For auditing purposes, a log entry must be entered in a SQL log table after each execution of the Data Flow task.
The TransactionOption property for the package is set to Required.
You need to design the package to meet the requirements.
How should you design the control flow for the package? (To answer, drag the appropriate setting from the list of settings to the correct location or locations in the answer area.)
Your package must meet the following requirements:
*If the truncate operation fails, the package execution must stop and report an error.
*If the Data Flow task that moves the data to the staging table fails, the entire refresh operation must be rolled back.
*For auditing purposes, a log entry must be entered in a SQL log table after each execution of the Data Flow task.
The TransactionOption property for the package is set to Required.
You need to design the package to meet the requirements.
How should you design the control flow for the package? (To answer, drag the appropriate setting from the list of settings to the correct location or locations in the answer area.)
正解：
Explanation
References:
http://msdn.microsoft.com/en-us/library/ms137690.aspx
http://msdn.microsoft.com/en-us/library/ms141144.aspx
You have a SQL Server Integration Services (SSIS) package that runs on a server named SQL1 and connects to a SQL Server database on a server named SQL2.
You schedule the package to run via a SQL Server Agent job.
The package fails and generates the following error message: "Unknown server or Access is Denied".
You discover that the package is configured to authenticate by using Windows authentication and that the SQL Server Agent on SQL1 uses NT Service\SQLSERVERAGENT as a service account.
You verify that other jobs run on the server without errors.
You create a user account named CONTOSO\JobProcess1 and provide all of the required access to the tables on SQL2.
You need to ensure that the package runs successfully via the SQL Server Agent job.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You schedule the package to run via a SQL Server Agent job.
The package fails and generates the following error message: "Unknown server or Access is Denied".
You discover that the package is configured to authenticate by using Windows authentication and that the SQL Server Agent on SQL1 uses NT Service\SQLSERVERAGENT as a service account.
You verify that other jobs run on the server without errors.
You create a user account named CONTOSO\JobProcess1 and provide all of the required access to the tables on SQL2.
You need to ensure that the package runs successfully via the SQL Server Agent job.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation
You are the administrator of a server that hosts Data Quality Server for a large retail company.
The server had a hardware failure during business hours.
You need to restore the server that hosts Data Quality Server to another server. You have a recent backup of all the required databases.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
The server had a hardware failure during business hours.
You need to restore the server that hosts Data Quality Server to another server. You have a recent backup of all the required databases.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
正解：A、D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a SQL Server Integration Services (SSIS) package. The package contains a script task that has the following comment.
// Update DataLoadBeginDate variable to the beginning of yesterday
The script has the following code.
Dts.variables["User::DataLoadBeginDate''].Value = DataTime.Today.AddDays(-1); The script task is configured as shown in the exhibit. (Click the Exhibit button.)
When you attempt to execute the package, the package fails and returns the following error message: ''Error:
Exception has been thrown by the target of an invocation.''
You need to execute the package successfully.
What should you do?
// Update DataLoadBeginDate variable to the beginning of yesterday
The script has the following code.
Dts.variables["User::DataLoadBeginDate''].Value = DataTime.Today.AddDays(-1); The script task is configured as shown in the exhibit. (Click the Exhibit button.)
When you attempt to execute the package, the package fails and returns the following error message: ''Error:
Exception has been thrown by the target of an invocation.''
You need to execute the package successfully.
What should you do?
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.
Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.
You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.
What should you do?
Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.
You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.
What should you do?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are deploying a new SQL Server Integration Services (SSIS) project to the test environment.
A package in the project uses a custom task component.
You need to ensure that the custom object is deployed on the test environment correctly.
What should you do?
A package in the project uses a custom task component.
You need to ensure that the custom object is deployed on the test environment correctly.
What should you do?
正解：I
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a SQL Server data warehouse that contains all of the customer data for your company.
You plan to deploy an archiving solution.
You need to move a table named OLDCUSTOMERS to a new storage device. OLDCUSTOMERS contains a clustered index.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
You plan to deploy an archiving solution.
You need to move a table named OLDCUSTOMERS to a new storage device. OLDCUSTOMERS contains a clustered index.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
正解：
Explanation
You are developing a SQL Server Integration Services (SSIS) package.
The package uses custom functionality that accesses a SQL Server database. The custom functionality must be implemented by using Language Integrated Query (LINQ).
You need to ensure that the LINQ code can be debugged at design time.
What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in the answer area.)
The package uses custom functionality that accesses a SQL Server database. The custom functionality must be implemented by using Language Integrated Query (LINQ).
You need to ensure that the LINQ code can be debugged at design time.
What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in the answer area.)
正解：
Explanation
You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?
正解：D
解答を投票する
You are developing a SQL Server Integration Services (SSIS) package that loads data from a source transactional tables in a data warehouse.
You discover that one of the data flows loads incorrect data to one of the destination tables.
You need to identify the cause of the incorrect data flow. Which tool should you use?
You discover that one of the data flows loads incorrect data to one of the destination tables.
You need to identify the cause of the incorrect data flow. Which tool should you use?
正解：B
解答を投票する
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on SQL Azure. One of the columns in the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in the data flow.
You need to enable separate processing streams for a subset of rows based on the source product code.
Which data flow transformation should you use?
Some of the data to be loaded will reference products that need special processing logic in the data flow.
You need to enable separate processing streams for a subset of rows based on the source product code.
Which data flow transformation should you use?
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains records for each user permitted to run reports against the warehouse; and the dimDistrict table contains information about sales districts.
The system is accessed by users from certain districts, as well as by area supervisors and users from the corporate headquarters.
You need to design a table structure to ensure that certain users can see sales data for only certain districts.
Some users must be permitted to see sales data from multiple districts.
What should you do?
The system is accessed by users from certain districts, as well as by area supervisors and users from the corporate headquarters.
You need to design a table structure to ensure that certain users can see sales data for only certain districts.
Some users must be permitted to see sales data from multiple districts.
What should you do?
正解：D
解答を投票する