StudyByteLearn
← AZ-305: Azure Infrastructure Solutions
AZ-305 · Relational data

Practice question 113 of 400 · hard

A SQL Database will grow well beyond conventional small-database sizes and needs distributed storage and several read replicas. Which recommendations are valid? Select 2 answers.

Select all that apply. Every correct option and no extras are required for credit in the app.

  1. A.Assume Hyperscale auto-pause is generally available for every production configuration
  2. B.Assess the supported provisioned, serverless, or elastic-pool Hyperscale configuration rather than relying on old exclusions
  3. C.Choose Managed Instance Hyperscale because every Azure SQL product has it
  4. D.Evaluate Hyperscale and its supported database size/replica configuration
Show the answer and explanation

✓ Correct answers

  • Assess the supported provisioned, serverless, or elastic-pool Hyperscale configuration rather than relying on old exclusions
  • Evaluate Hyperscale and its supported database size/replica configuration

Hyperscale offers distributed storage and supported deployment choices; exact limits/configuration still matter. Managed Instance does not inherit Hyperscale. The guide qualifies Hyperscale auto-pause as preview, so it is not an unconditional GA assumption. Source guide: PDF page 23-24.

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.

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.