Suggested Answer:A🗳️
Data used for Planning Assistance must be stored in a sharded Azure SQL Database. A shard typically contains items that fall within a specified range determined by one or more attributes of the data. These attributes form the shard key (sometimes referred to as the partition key). The shard key should be static. It shouldn't be based on data that might change. Reference: https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding
shard key should be static "The shard key should be static. It shouldn't be based on data that might change."
https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding
I believe that C is the best option:
A) A binary representation of the license plate could cause problems due to the non-numeric characters in the plate number.
B) Speeds will more often than not be similar leading to hotspots
D) Rush hour traffic will cause hotspots as well if you use timespans
Yes, some locations may have significantly more traffic than others but I think the likelihood of the differences being so great as to cause hotspots is minimal because real-world logic tells me that the planners are not going to put sensors in low-traffic areas.
I agree as "The shard key should be static. It shouldn't be based on data that might change."
https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding
I think the D is correct answer.
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-shard-map-management
The binary representation of plate number is not supported among available data types for sharding keys. Time range mapping is more appropriate solution.
C: Yes a list based mapping where sensors in similar locations are sharded together makes sense. You want to see the sensors over time in that area. Lat/Long would be mapped to shards. Time-based will cause hot-spots.
This section is not available anymore. Please use the main Exam Page.DP-201 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.
elimey
3 years, 10 months agoDhaval_Azure
3 years, 11 months agoBigMF
3 years, 11 months agoDhaval_Azure
3 years, 11 months agoZodiaC
3 years, 12 months agodbdev
4 years agoBobFar
4 years agoPlhiwndkro
4 years agoOus01
4 years agoMMM777
3 years, 12 months agoskbi570
4 years ago