ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam
Go to Exam

Exam DP-900 topic 1 question 253 discussion

Actual exam question from Microsoft's DP-900
Question #: 253
Topic #: 1
[All DP-900 Questions]

HOTSPOT
-

Select the answer that correctly completes the sentence.

Show Suggested Answer Hide Answer
Suggested Answer:
by XtraWest at March 26, 2023, 11:43 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
XtraWest
Highly Voted 1 year, 8 months ago
In an OLAP system, data is typically organized in a multidimensional model so.. 'Pre-aggregated' makes more sense
upvoted 10 times
...
AGTraining
Most Recent 9 months, 2 weeks ago
'Pre-aggregated
upvoted 2 times
...
fiksarion
1 year, 5 months ago
Online analytical processing (OLAP) systems are particularly suitable for analytical workloads because data is: pre-aggregated. OLAP systems are designed to handle complex analytical queries and provide fast query response times. They achieve this by pre-aggregating data, meaning that calculations and aggregations are performed in advance and stored in a way that allows for efficient retrieval. This pre-aggregation reduces the need for complex calculations at query time and significantly improves the performance of analytical queries.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel