nerdexam
Microsoft

70-583 · Question #63

A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source…

The correct answer is D. Use a Dynamic Management View to check the size and maximum size of the database. See the full explanation below for the reasoning.

Question

A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend?

Options

  • AUse a Dynamic Management View to check for locks.
  • BUse a Dynamic Management View to check for blocked queries.
  • CUse a Dynamic Management View to check for long-running queries.
  • DUse a Dynamic Management View to check the size and maximum size of the database.

How the community answered

(50 responses)
  • A
    6% (3)
  • B
    12% (6)
  • C
    4% (2)
  • D
    78% (39)

Community Discussion

No community discussion yet for this question.

Full 70-583 Practice