What should you recommend?

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?

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?

A.
Use a Dynamic Management View to check for locks.

B.
Use a Dynamic Management View to check for blocked queries.

C.
Use a Dynamic Management View to check for long-running queries.

D.
Use a Dynamic Management View to check the size and maximum size of the database.



Leave a Reply 0

Your email address will not be published. Required fields are marked *