nerdexam
Microsoft

70-583 · Question #72

You are planning the migration of an existing application to Windows Azure and SQL Azure. The original application includes a Microsoft SQL Server 2008 database. You need to recommend an approach…

The correct answer is B. Remove all dependencies on the Microsoft Distributed Transaction Coordinator (MSDTC) from C. Use SSL and SQL authentication to connect to the database. The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the

Designing and Developing Storage

Question

You are planning the migration of an existing application to Windows Azure and SQL Azure. The original application includes a Microsoft SQL Server 2008 database. You need to recommend an approach for ensuring that the database migrates successfully to SQL Azure. Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)

Options

  • ARemove all clustered indexes from the database.
  • BRemove all dependencies on the Microsoft Distributed Transaction Coordinator (MSDTC) from
  • CUse SSL and SQL authentication to connect to the database.
  • DUse SSL and Windows authentication to connect to the database.

How the community answered

(21 responses)
  • A
    5% (1)
  • B
    81% (17)
  • D
    14% (3)

Explanation

The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the

Topics

#SQL Azure migration#MSDTC dependency#SSL authentication#database migration

Community Discussion

No community discussion yet for this question.

Full 70-583 Practice