SnowPro Advanced: Architect — Question 163

An Architect is troubleshooting a long-running statement and needs to identify the list of transactions that are blocked and the queries that are blocking them.

Which views should be used for troubleshooting? (Choose two.)

Answer options

• A. QUERY_HISTORY
• B. OBJECT_DEPENDENCIES
• C. DATA_TRANSFER_HISTORY
• D. LOCK_WAIT_HISTORY
• E. ACCESS HISTORY

Correct answer: A, D

Explanation

The correct answers are QUERY_HISTORY and LOCK_WAIT_HISTORY. QUERY_HISTORY provides insight into the statements being executed, while LOCK_WAIT_HISTORY tracks the locks and waits that are causing blocks. The other options do not specifically address transaction blocks or the queries that are blocking them.