exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 9 discussion

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

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture

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
hmAZtime
Highly Voted 3 years, 11 months ago
It's A.
upvoted 54 times
valente_sven1
3 years, 6 months ago
agree. Yes it should be A.
upvoted 6 times
p2006
4 days, 5 hours ago
"A" looks correct for me, https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/media/overview-architecture/sql-architecture.png
upvoted 1 times
...
...
...
sreekarv
Highly Voted 5 months, 3 weeks ago
The correct answer is "across compute nodes". Distributions map to Compute nodes for processing. As you pay for more compute resources, distributions are remapped to available Compute nodes. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture [see the architecture diagram]
upvoted 14 times
...
man5484
Most Recent 4 months, 1 week ago
a. distributes processing across compute nodes, Azure Synapse Analytics uses a Massively Parallel Processing (MPP) architecture, which distributes data and processing tasks across multiple compute nodes to enhance performance and scalability.
upvoted 2 times
...
AGTraining
1 year ago
option A
upvoted 1 times
...
DavidPham1997
1 year ago
MPP systems are designed to be distributed parallel processing solutions, meaning they are not only able to scale up by adding more compute resources but can also scale out by adding more nodes to the system.
upvoted 1 times
...
bailaconsandra
2 years, 11 months ago
https://docs.microsoft.com/en-us/shows/learn-azure/understand-massively-parallel-processing-concepts
upvoted 1 times
...
AZ5cert
2 years, 11 months ago
Correct Answer: A
upvoted 1 times
...
RajeshAzure
3 years ago
Correct Answer
upvoted 1 times
...
sumanshu
3 years, 1 month ago
Vote for A
upvoted 1 times
...
AzureDP900
3 years, 5 months ago
It is A. https://docs.microsoft.com/en-us/learn/modules/explore-data-storage-processing-azure/2-describe-azure
upvoted 2 times
...
Armandoo
3 years, 9 months ago
The control node gets the process and distributes it across compute node. Therefore the answer is A.
upvoted 4 times
...
busyb
3 years, 10 months ago
It's A. Dedicated SQL pool (formerly SQL DW) uses a node-based architecture. Applications connect and issue T-SQL commands to a Control node. The Control node hosts the distributed query engine, which optimizes queries for parallel processing, and then passes operations to Compute nodes to do their work in parallel.
upvoted 4 times
...
faiqnsrl
3 years, 10 months ago
All of the source about MPP say that A is correct.
upvoted 4 times
...
erennkavak
3 years, 11 months ago
which one is the correct answer? A or C ?
upvoted 1 times
...
mroczyslaw
4 years ago
I think "A" is a correct answer - not redirecting connections ("C") but distributing processing
upvoted 3 times
...
Vithal1979
4 years, 5 months ago
Correct MPP across nodes
upvoted 3 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago