Câu 47: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases

HOTSPOT -You have a server named SQL1 that hosts a reporting database named REPORTING. REPORTING contains data that is also stored in a production database. You discover many blocking locks in REPORTING. The blocked queries are SELECT statements. The queries that hold the blocking locks are INSERT statements that wait on the WRITELOG wait type. You need to prevent the INSERT statements from creating the blocking locks. The solution must also minimize the amount of time the INSERT statements wait on the WRITELOG wait type. Which two database settings should you modify? To answer, select the appropriate settings in the answer area. Hot Area:

1. A. Lựa chọn A bằng hình ảnh — đáp án hiện tại