← Back to exam page

70-463 – Implementing a Data Warehouse with Microsoft SQL Server 2012

Loading demo links...

Showing 7–9 of 15 questions

Question 7 (Volume A)

You have a SQL Server Integration Services (SSIS) package named Package1.

You discover that the Data Flow task for Package1 runs slower than expected.

You need to reduce the amount of time required to run the Data Flow task.

Which two actions should you perform? Each correct answer presents part of the solution.

Select all that apply, then click Submit answer.

  • ○

    Modify the DefaultBufferMaxRows package setting.
  • ○

    Configure the package to run by using the CallerInfooption.
  • ○

    Modify the ForceExecutionResult package setting.
  • ○

    Configure the package to run by using the MaxConcurrent option.
  • ○

    Modify the DefaultBufferSize package setting.
Question 8 (Volume C)

If you want to switch content from a nonpartitioned table to a partition of a partitioned table, what conditions must the nonpartitioned table meet? (Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    It must have the same constraints as the partitioned table.
  • ○

    It must have the same compression as the partitioned table.
  • ○

    It must be in a special PartitionedTables schema.
  • ○

    It must have a check constraint on the partitioning column that guarantees that all of the data goes to exactly one partition of the partitioned table.
  • ○

    It must have the same indexes as the partitioned table.
Question 9 (Volume C)

You need to extract data from a table in a SQL Server database.

What connection manager types can you use? (Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    An ODBC connection manager
  • ○

    An OLE DB connection manager
  • ○

    A File connection manager
  • ○

    An ADO.NET connection manager