70-433 · Question #81
You are tasked to analyze blocking behavior of the following query: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE WITH Customers AS ( SELECT * FROM Customer ), SalesTotal AS ( SELECT CustomerId…
The correct answer is D. The other queries will not be blocked by this query. See the full explanation below for the reasoning.
Question
You are tasked to analyze blocking behavior of the following query:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE WITH Customers AS ( SELECT * FROM Customer ), SalesTotal AS ( SELECT CustomerId, SUM(OrderTotal) AS AllOrderTotal FROM SalesOrder) SELECT CustomerId, AllOrderTotal FROM SalesTotal WHERE AllOrderTotal > 10000.00; You need to determine if other queries that are using the Customer table will be blocked by this query. You also need to determine if this query will be blocked by other queries that are using the Customer table. What behavior should you expect?
Options
- AThe other queries will be blocked by this query.
- BThe other queries will be blocked by this query.
- CThe other queries will not be blocked by this query.
- DThe other queries will not be blocked by this query.
How the community answered
(36 responses)- A3% (1)
- B8% (3)
- C19% (7)
- D69% (25)
Community Discussion
No community discussion yet for this question.