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 4Question 04
    Medium1 markMultiple Choice
    Domain 2.1: Relational Data StorageDatabaseSQLHyperscale
    This question is part of a case study — click to read the full scenario(Case 01)

    CASE STUDY: Tailspin Toys

    Tailspin Toys is a global manufacturing company with 50,000 employees across 30 countries. They currently operate a mix of on-premises infrastructure (500 servers across 5 data centers) and Azure (20 subscriptions with 100+ VMs and various PaaS services). Their annual IT budget is $50 million, with plans to migrate 70% of workloads to Azure within 2 years.

    Business Requirements: The company needs to reduce IT costs by 30%, improve disaster recovery (current RTO: 24 hours -> target: 2 hours), enhance security posture to meet ISO 27001 and SOC 2 compliance, and enable remote work for 80% of employees. All solutions must support future growth of 20% annually.

    Technical Constraints: Some legacy applications cannot be modified and must run on Windows Server 2012. Network connectivity requires 10 Gbps throughput to Azure with <20ms latency. GDPR compliance mandates that EU customer data must remain in European Azure regions.

    You need to design a migration strategy for the legacy Windows Server 2012 applications. The solution must minimize operational overhead and maintain compliance while ensuring the applications remain supported.

    Which compute solution should you recommend?

    View full case study page →

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

    CASE STUDY: Tailspin Toys

    Tailspin Toys is a global manufacturing company with 50,000 employees across 30 countries. They currently operate a mix of on-premises infrastructure (500 servers across 5 data centers) and Azure (20 subscriptions with 100+ VMs and various PaaS services). Their annual IT budget is $50 million, with plans to migrate 70% of workloads to Azure within 2 years.

    Business Requirements: The company needs to reduce IT costs by 30%, improve disaster recovery (current RTO: 24 hours -> target: 2 hours), enhance security posture to meet ISO 27001 and SOC 2 compliance, and enable remote work for 80% of employees. All solutions must support future growth of 20% annually.

    Technical Constraints: Some legacy applications cannot be modified and must run on Windows Server 2012. Network connectivity requires 10 Gbps throughput to Azure with <20ms latency. GDPR compliance mandates that EU customer data must remain in European Azure regions.

    Tailspin Toys has a 15 TB on-premises SQL Server database that supports their core ERP system. You need to migrate this database to Azure. The solution must support the 2-hour RTO requirement, minimize administrative overhead, and support databases larger than 10 TB.

    Which data storage solution should you recommend?

    Answer options:

    A.

    Azure SQL Database Business Critical

    B.

    Azure SQL Database Hyperscale

    C.

    SQL Server on Azure Virtual Machines

    D.

    Azure SQL Managed Instance General Purpose

    How to approach this question

    Match the size constraint (15 TB) and the administrative overhead constraint (PaaS preferred over IaaS).

    Full Answer

    B.Azure SQL Database Hyperscale✓ Correct
    Azure SQL Database Hyperscale
    Azure SQL Database Hyperscale is a highly scalable storage tier that supports up to 100 TB of data. It separates the compute and storage layers, allowing for rapid scale-out and nearly instantaneous backups and restores, easily meeting the 2-hour RTO requirement while minimizing administrative overhead (PaaS).

    Common mistakes

    Choosing Business Critical for high performance, forgetting the strict 4 TB size limit on that tier.
    Question 03All questionsQuestion 05

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

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ02CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ03CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...HardQ05CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...HardQ06Contoso Ltd has 50 Azure subscriptions managed via a complex Management Group hierarchy. They are...Medium
    View all 55 questions →