Câu 7: 70-764: Administering a SQL Database Infrastructure
DRAG DROP -You plan to deploy SQL Server 2014. You are designing two stored procedures named SP1 and SP2 that have the following requirements:- Prevent data read by SP1 from being modified by other active processes.- Prevent SP2 from performing dirty reads. You need to recommend the isolation level for each stored pro…
Nội dung câu hỏi
DRAG DROP -You plan to deploy SQL Server 2014. You are designing two stored procedures named SP1 and SP2 that have the following requirements:- Prevent data read by SP1 from being modified by other active processes.- Prevent SP2 from performing dirty reads. You need to recommend the isolation level for each stored procedure. The solution must maximize concurrency. Which isolation levels should you recommend? To answer, drag the appropriate isolation level to the correct stored procedure in the answer area. Select and Place:
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
-
A. Lựa chọn A bằng hình ảnh — đáp án hiện tại
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.