nerdexam
Microsoft

70-583 · Question #60

An application connects to a SQL Azure database. The application occasionally loses the connection to the SQL Azure database. You need to recommend an approach for reliably completing data access…

The correct answer is C. Implement a retry policy in the data access layer. See the full explanation below for the reasoning.

Question

An application connects to a SQL Azure database. The application occasionally loses the connection to the SQL Azure database. You need to recommend an approach for reliably completing data access operations. What should you recommend?

Options

  • AUse Microsoft ADO.NET connection pooling.
  • BPass exceptions to the user interface layer.
  • CImplement a retry policy in the data access layer.
  • DBegin a transaction before each data access operation.

How the community answered

(41 responses)
  • A
    5% (2)
  • B
    5% (2)
  • C
    73% (30)
  • D
    17% (7)

Community Discussion

No community discussion yet for this question.

Full 70-583 Practice