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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. You are developing a new application that uses a stored procedure. The stored procedure inserts thousands of records as a single batch into the Employees table. Users report that the application response time has worsened since the stored procedure was updated. You examine disk-related performance counters for theMicrosoft SQL Server instance and observe several high values that include a disk performance issue. You examine wait statistics and observe an unusually highWRITELOG value. You need to improve the application response time.Solution: You add a unique clustered index to the Employees table. Does the solution meet the goal?

1. A. Yes — đáp án hiện tại
2. B. No