70-463 試験問題を無料オンラインアクセス

You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages.
All packages in the project must connect to the same database. The server name for the database must be set by using a parameter named ParamConnection when any package in the project is executed.
You need to develop this project with the least amount of development effort.
What should you do? (Each answer presents a part of the solution. Choose all that apply.)

• A.Create a project parameter named ConnectionName.
• B.Edit the project Connection Manager in Solution Explorer. Set the ConnectionName property to @
  [$Project::ParamConnection].
• C.Edit each package Connection Manager. Set the ConnectionName property to
  @[$Project::ParamConnection].
• D.Set the Sensitive property of the parameter to True.
• E.Set the Required property of the parameter to True.
• F.Create a package parameter named ConnectionName in each package.

You administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition:

You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.
You need to ensure that the following requirements are met:
* The first row of the file contains the first row of data.
* Each record is of the same length.
* The date follows the U.S. date format.
* The file supports international characters.
What should you do? (To answer, simply select the option or options in the answer area that you would configure.)

A SQL Server Integration Services (SSIS) package named DataFeed interacts with an external vendor data feed. The package is executed several times a day, either as part of other packages' control flow or by itself.
The external data feed is unreliable because network failures and slow response times are frequent. The package is currently deployed on the file system.
To analyze the reliability of the external data feed, you must collect execution data.
Every time the DataFeed package is executed, the following information must be logged:
* Start Time
* End Time
* Execution Result
* Execution Duration
You need to design a logging solution that meets the requirements by using the least amount of administrative and development effort.
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
Box 1:

Box 2:

Box 3:

Ref: http://msdn.microsoft.com/en-us/library/hh479592.aspx

You are loading a dataset into SQL Server. The dataset contains numerous duplicates for the Artist and Song columns.
The values in the Artist column in the dataset must exactly match the values in the Artist domain in the knowledge base. The values in the Song column in the dataset can be a close match with the values in the Song domain.
You need to use SQL Server Data Quality Services (DQS) to define a matching policy rule to identify duplicates.
How should you configure the Rule Editor? (To answer, drag the appropriate answers to the answer area.)

正解：

Explanation

You have a database named Sales and a data warehouse named DataW.
From Sales, you plan to bulk insert to a table in DataW that is more than 2 TB. The process will insert a minimum of 11 million rows simultaneously.
You need to identify which data storage strategy must be used to minimize load times.
Which data storage strategy should you identify?

• A.a durable In-Memory OLTP
• B.FileStream
• C.a nonclustered columnstore
• D.non-durable staging table