Pass with professional 070-463 actual quiz materials

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.)

You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.)


Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in the Employee table. You need to assign the appropriate constraints and table properties to ensure data integrity and visibility. On which column in the Employee table should you use an identity specification to include a seed of 1,000 and an increment of 1?

• A. MiddleName
• B. LastName
• C. EmployeeNum
• D. JobTitle
• E. EmployeeID
• F. ReportsToID
• G. DateHired
• H. FirstName
• I. DepartmentID

You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database.
The company's auditing policies have the following requirements:
*An entry must be written to a dedicated SQL Server log table named OrderLog.
*The entry must be written as soon as the file upload task completes.
You need to meet the company's policy requirements.
Which event handler should you use?

• A. OnWarning
• B. OnPostExecute
• C. OnExecStatusChanged
• D. OnVariableValueChanged

You are building a fact table in a data warehouse.
The table must have a columnstore index. The table cannot be partitioned.
You need to design the fact table and load it with data.
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 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 areathat you would configure.)