What should you recommend?

Posted by: Pdfprep Category: DP-201 Tags: , ,

You need to design a sharding strategy for the Planning Assistance database.

What should you recommend?
A . a list mapping shard map on the binary representation of the License Plate column
B . a range mapping shard map on the binary representation of the speed column
C . a list mapping shard map on the location column
D . a range mapping shard map on the time column

Answer: A

Explanation:

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

Leave a Reply

Your email address will not be published.