Online Access Free 070-463 Exam Questions

You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer dimension table by using a data flow task.
Changes to the customer attributes must be tracked over time.
You need to produce a checksum value to identify the rows that have changed since the last Extract, Transform and Load (ETL) process execution. You need to use the least amount of development effort to achieve this goal.
Which transformation should you use? (To answer, select the appropriate transformation in the answer area.)

Correct Answer:

Explanation

You have a data warehouse.
You need to create a SQL Server Integration Services (SSIS) package to meet the following requirements:
-The package must be deployed.
-The package must be parameterized.
-The package execution must be automated.
In which sequence should you perform the actions? To answer, move all of the actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.
You have the following requirements:
*Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time.
*Ensure that the deployment model automatically starts from calls to the catalog.start_execution stored procedure in the SSISDB database.
*Maximize performance at execution time.
*Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.
• B.Use a project deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.
• C.Use a package deployment model. Use a SQL Server package configuration with a common filter.
  Change the contents of the SSIS Configurations table at runtime.
• D.Use a project deployment model. Modify connection manager properties to use project parameters.
  Ensure that the SSISDB database is created.

You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors.
Products for each distributor source must be combined for insertion into a single product table destination.
You need to select the appropriate data flow transformation to meet this requirement.
Which transformation types should you use? (Each correct answer presents a complete solution. Choose all that apply.)

• A.Multicast
• B.union All
• C.Merge Join
• D.Term Extraction
• E.Merge

You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database. The package has been deployed to a production server that runs Windows Server 2008 R2 and SQL Server 2012.
The package fails when executed on the production server.
You need to ensure that the package can load the Excel workbook data without errors. You need to use the least amount of administrative effort to achieve this goal.
What should you do?

• A.Install a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
• B.Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.
• C.Enable Address Windowing Extensions (AWE) for the local SQL Server instance.
• D.Replace the SSIS Excel source with a SSIS Flat File source.