Câu 73: 70-764: Administering a SQL Database Infrastructure

HOTSPOT -You have a Microsoft SQL Server instance that hosts a database named DB1 that contains 800 gigabyte (GB) of data. The database is used 24 hours each day. You implement indexes and set the value of the Auto Update Statistics option set to True. Users report that queries take a long time to complete. You need to identify statistics that have not been updated for a week for tables where more than 1,000 rows changed. How should you complete the Transact-SQL statement? To answer, configure the appropriate Transact-SQL segments in the answer area. Hot Area:

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