Câu 26: 70-765: Provisioning SQL Databases
HOTSPOT -You have Microsoft SQL Server on a Microsoft Azure virtual machine. The virtual machine has a database named DB1. DB1 contains a table named Table1 that has 4 billion rows. Users report that a query using Table1 takes longer than expected to execute. You review the execution plan for the query and discover th…
Nội dung câu hỏi
HOTSPOT -You have Microsoft SQL Server on a Microsoft Azure virtual machine. The virtual machine has a database named DB1. DB1 contains a table named Table1 that has 4 billion rows. Users report that a query using Table1 takes longer than expected to execute. You review the execution plan for the query and discover that the expected number of returned rows is one, while the actual number of returned rows is 1 million. You need to reduce the amount of time it takes for the query to execute. The solution must prevent additional performance issues from being introduced. Hot Area:
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.