Câu 14: 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
HOTSPOT -A SQL Server Analysis Services (SSAS) cube contains billions of rows of data and is rapidly increasing in size. The cube consists of a single measure group and a single partition. The cube is currently processed by using the Process Full process option. You have the following requirements to reduce the cube p…
Nội dung câu hỏi
HOTSPOT -A SQL Server Analysis Services (SSAS) cube contains billions of rows of data and is rapidly increasing in size. The cube consists of a single measure group and a single partition. The cube is currently processed by using the Process Full process option. You have the following requirements to reduce the cube processing time: ✑ Partition the measure group by month. ✑ Create a staging table that contains only data which is more recent than the last time the cube was processed. ✑ Do not include data updates or deletions in the staging table. ✑ Insert records from the staging table into the appropriate partition. You need to change the process option to meet the requirements. Which process option should you choose?To answer, select the appropriate option from the drop-down list in the dialog box. 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.