You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables. Which distribution type should you recommend to minimize data movement?
Suggested Answer:B🗳️
A replicated table has a full copy of the table available on every Compute node. Queries run fast on replicated tables since joins on replicated tables don't require data movement. Replication requires extra storage, though, and isn't practical for large tables. Incorrect Answers: C: A round-robin distributed table distributes table rows evenly across all distributions. The assignment of rows to distributions is random. Unlike hash-distributed tables, rows with equal values are not guaranteed to be assigned to the same distribution. As a result, the system sometimes needs to invoke a data movement operation to better organize your data before it can resolve a query. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute
No, it's actually useful to confirm for each question that THIS ONE is not part of the actual DP-300 curriculum. My time is precious and I would rather not prepare for a different exam than the one I intend to take lol
base on the following the Correct ANswer is ... ==> B.Replicate
Cheat sheet for dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics
Use the following strategies, depending on the table properties:
Type: Replicated
Great fit for…: Small dimension tables in a star schema with less than 2 GB of storage after compression (~5x compression)
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet#distributed-or-replicated-tables
understand that these questions are going to be on dp 300, just stop saying that the website needs a fix. this is not a problem from website but from microsoft
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
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.
HichemZe
Highly Voted 2 years, 8 months agoIcyb3r
1 year, 8 months agomimi21212152
2 years, 4 months agoTheMCT
1 year, 1 month agoofzrgrz
8 months agogt002
Highly Voted 2 years, 4 months agoMS_KoolaidMan
Most Recent 11 months, 1 week agomatiandal
1 year, 4 months agogiuseppepacilli85
1 year, 6 months agobad_atitude
1 year, 6 months agoCiupaz
1 year, 6 months agoramelas
2 years, 4 months agomatongax
2 years, 6 months agojerkyflexoff
2 years, 6 months agogabriel3600
2 years, 7 months agoovokpus
2 years, 8 months ago