nerdexam
Microsoft

70-459 · Question #38

You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media. You plan to synchronize SQLDev and SQLProd. You need to recommend a solution that meets the…

The correct answer is D. SQL Server IntegrationServices (SSIS). See the full explanation below for the reasoning.

Question

You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media. You plan to synchronize SQLDev and SQLProd. You need to recommend a solution that meets the following requirements: - The database schemas must be synchronized from SQLDev to SQLProd. - The database on SQLDev must be deployed to SQLProd by using a package. - The package must support being deployed to SQL Azure. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

Options

  • Aa database snapshot
  • Bchange data capture
  • Ca data-tier application
  • DSQL Server IntegrationServices (SSIS)
  • ESQL Data Sync

How the community answered

(60 responses)
  • A
    7% (4)
  • B
    13% (8)
  • C
    3% (2)
  • D
    75% (45)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice