Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 - 070-463 模擬練習
You are developing a SQL Server Integration Services (SSIS) package.
You use a Data Profiling task to examine the data from a source system. You need to establish:
* The minimum and maximum dates for the datetime columns in the source data
* The minimum, maximum, and average values for numeric columns in the source data You need to use the appropriate profile type in the Data Profiling task.
Which profile type should you use? (To answer, select the appropriate profile type in the answer area.)
You use a Data Profiling task to examine the data from a source system. You need to establish:
* The minimum and maximum dates for the datetime columns in the source data
* The minimum, maximum, and average values for numeric columns in the source data You need to use the appropriate profile type in the Data Profiling task.
Which profile type should you use? (To answer, select the appropriate profile type in the answer area.)
正解:
Explanation
Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed.
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?
正解: A
解説: (PassTest メンバーにのみ表示されます)
You plan to design an SQL Server Integration Services (SSIS) package to move data from a source system to an SQL Server database named Warehouse.
You need to implement a data loading strategy for the package. The solution must ensure that if a failure occurs, the connection automatically resumes from the point of failure.
How should you configure each package property? To answer, select the appropriate options in the answer area.
You need to implement a data loading strategy for the package. The solution must ensure that if a failure occurs, the connection automatically resumes from the point of failure.
How should you configure each package property? To answer, select the appropriate options in the answer area.
正解:
Explanation
Box 1 CheckPointUsage: Always
CheckpointUsage specifies whether checkpoints are used.
Always specifies that the checkpoint file is always used and that the package restarts from the point of the previous execution failure. If the checkpoint file is not found, the package fails.
Box 2: FailPackageOnFailure: False
You must set the FailPackageOnFailure property to true for all the containers in the package that you want to identify as restart points.
Box 3: SaveCheckPoints: Yes
SaveCheckpoints indicates whether the package saves checkpoints. This property must be set to True to restart a package from a point of failure.
Box 4: TransactionOption: Supported
TransactionOption in SSIS is used to start transactions, add executables to transactions or keep them out of transactions. It has 3 values; namely
-> Required :- The container which has the transactionoption set to this, joins any available transaction or else starts a new transaction .
-> Supported -> Joins any available transaction (started by its parent container) but if not available, does not start one.
-> Not Supported -> Does not support transactions.
The transactions follow all the
References:
https://docs.microsoft.com/en-us/sql/integration-services/packages/restart-packages-by-using-checkpoints?view
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 need to design a data load strategy for a data warehouse fact table. The solution must use an ordered data load.
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.
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 building a SQL Server Integration Services (SSIS) package to load product data sourced from a SQL Azure database to a data warehouse. Before the product data is loaded, you create a batch record by using an Execute SQL task named Create Batch. After successfully loading the product data, you use another Execute SQL task named Set Batch Success to mark the batch as successful.
You need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or Load Products task fails.
Which three steps 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 need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or Load Products task fails.
Which three steps 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
References:
http://msdn.microsoft.com/en-us/library/ms141003.aspx
http://msdn.microsoft.com/en-us/library/ms141261.aspx
http://msdn.microsoft.com/en-us/library/ms141722
http://msdn.microsoft.com/en-us/librar
You are installing SQL Server Data Quality Services (DQS).
You need to give users belonging to a specific Active Directory group access to the Data Quality Server.
Which SQL Server application should you use?
You need to give users belonging to a specific Active Directory group access to the Data Quality Server.
Which SQL Server application should you use?
正解: A
You are developing a SQL Server Integration Services (SSIS) package.
The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse.
You need to create a separate data flow path for data that has been modified since it was last processed.
Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.)
The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse.
You need to create a separate data flow path for data that has been modified since it was last processed.
Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.)
正解: A,B
解説: (PassTest メンバーにのみ表示されます)
To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is put in place.
The methodology has the following requirements:
*The deployment process must be simplified.
*All the logs must be centralized in SQL Server.
*Log data must be available via reports or T-SQL.
*Log archival must be automated.
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort.
What should you do?
The methodology has the following requirements:
*The deployment process must be simplified.
*All the logs must be centralized in SQL Server.
*Log data must be available via reports or T-SQL.
*Log archival must be automated.
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort.
What should you do?
正解: J
解説: (PassTest メンバーにのみ表示されます)