Câu 17: 70-762: Developing SQL Databases

You have a reporting application that uses a table named Table1. You deploy a new batch update process to perform updates to Table1. The environment is configured with the following properties: ✑ The database is configured with the default isolation setting. ✑ The application and process use the default transaction handling. You observe the application cannot access any rows that are in use by the process. You have the following requirements: ✑ Ensure the application is not blocked by the process. ✑ Ensure the application has a consistent view of the data ✑ Ensure the application does not read dirty data. You need to resolve the issue and meet the requirements with the least amount of administrative effort. What should you do?

1. A. Enable the database for the ALLOW_SNAPSHOT_ISOLATION isolation level. Modify the application for the SERIALIZABLE isolation level.
2. B. Enable the database for the READ_COMITTED_SNAPSHOT isolation level. — đáp án hiện tại
3. C. Enable the application for the WITH (NOLOCK) hint.
4. D. Enable the database for the ALLOW_SNAPSHOT_ISOLATION isolation level. Modify the application and the update process for the SNAPSHOT isolation level.