Tenant-scoped queries are common, but a single large tenant will exceed a conventional 20-GB single-level logical partition. Which design should be evaluated?

Choose the single best answer.

A.Assume any new physical partition automatically makes one conventional logical partition unlimited
B.Supported hierarchical partition keys that distribute the tenant across lower-level key values while enabling tenant-prefix queries
C.A constant key for every tenant because logical partitions have no size limit
D.A random key without checking the resulting query cost

Show the answer and explanation

✓ Correct answer

Supported hierarchical partition keys that distribute the tenant across lower-level key values while enabling tenant-prefix queries

Hierarchical keys can distribute a tenant prefix across full key values under documented limits. Constant/hot keys retain limits; random keys can force expensive scans. Physical scaling does not remove a conventional logical partition's limits. Source guide: PDF page 30.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.