Câu 34: DP-203: Data Engineering on Microsoft Azure
You have an Azure Synapse Analytics dedicated SQL pool that contains a large fact table. The table contains 50 columns and 5 billion rows and is a heap. Most queries against the table aggregate values from approximately 100 million rows and return only two columns. You discover that the queries against the fact table…
Nội dung câu hỏi
You have an Azure Synapse Analytics dedicated SQL pool that contains a large fact table. The table contains 50 columns and 5 billion rows and is a heap. Most queries against the table aggregate values from approximately 100 million rows and return only two columns. You discover that the queries against the fact table are very slow. Which type of index should you add to provide the fastest query times?
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. nonclustered columnstore
- B. clustered columnstore — đáp án hiện tại
- C. nonclustered
- D. clustered
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.