For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeAzure Solutions Architect Expert (AZ-305)Azure Solutions Architect Expert AZ-305 Practice Exam 3Question 17
    Medium1 markMultiple Choice
    Domain 2.1: Relational Data StorageDomain 2Relational DataAzure SQLHyperscale

    AZ-305 · Question 17 · Domain 2.1: Relational Data Storage

    An e-commerce company is designing the database architecture for their new product catalog.

    The database is expected to grow rapidly and may exceed 50 TB within the first year. The application requires extremely fast storage scaling and the ability to nearly instantaneously scale out read workloads to multiple compute nodes during holiday sales.

    Which Azure SQL Database service tier should you recommend?

    Answer options:

    A.

    General Purpose

    B.

    Business Critical

    C.

    Hyperscale

    D.

    Serverless

    How to approach this question

    Identify the storage limit constraint (>50 TB) and match it to the only Azure SQL tier that supports it.

    Full Answer

    C.Hyperscale✓ Correct
    The Hyperscale service tier in Azure SQL Database is designed for very large databases. It separates the compute and storage layers, allowing storage to scale up to 100 TB. It also supports rapid scale-up of compute and the addition of up to four high-availability replicas that can be used for read scale-out.

    Common mistakes

    Selecting Business Critical because of the 'fast storage' requirement, failing to realize it has a strict 4 TB storage limit.
    Question 16All questionsQuestion 18

    Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 3

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01Contoso Ltd is a global manufacturing company with 50,000 employees across 30 countries. They cur...MediumQ02Fabrikam Inc. is a Managed Service Provider (MSP) managing Azure environments for 50 different en...HardQ03A financial institution generates 5 TB of telemetry and audit logs daily across its Azure environ...MediumQ04A retail company has recently migrated several workloads to Azure. The IT Director wants a centra...EasyQ05A healthcare organization with 10,000 employees uses on-premises Active Directory. They are migra...Hard
    View all 55 questions →