What should you recommend?

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

View Answer

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.

References: https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding