AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: On SQL Server, blocking occurs when one process azure video

Question 1
« Back   Next dp-300-database-admin-assoc Certification Question »

Full Certification Question

On SQL Server, blocking occurs when one process holds a lock on a specific resource (row, page, table, database), and a second process attempts to acquire a lock with an incompatible lock type on the same resource. Typically, locks are held for a very short period, and when the process holding the lock releases it, the blocked process can then acquire the lock and complete its transaction. Locking is normal behaviour and happens many times during a normal day. Which are types of performance issues that can be caused by blocking? (Select two)