Examkin

Soru

Zorluk: OrtaRelational Data Storage Solutions

An organization is designing a relational database solution in Azure to support a new large-scale analytics platform. The solution must meet the following requirements:
- Support a database size that is projected to grow to 35 TB35\text{ TB}.
- Ensure database backups are completed in under 15 minutes15\text{ minutes} regardless of the database volume size.
- Minimize database administrative and management overhead by using a fully managed Platform as a Service (PaaS) solution.
- Support up to 44 read-only replicas to offload reporting workloads.

Which Azure SQL database deployment option should you recommend?

  1. Azure SQL Database HyperscaleCevap
  2. B
    SQL Server on Azure Virtual Machines
  3. C
    Azure SQL Database General Purpose
  4. D
    Azure SQL Managed Instance Business Critical

Cevap

Azure SQL Database Hyperscale
Azure SQL Database Hyperscale is the only fully managed PaaS solution that supports database sizes up to 100 TB100\text{ TB}, allows instantaneous backups via file-snapshot technology regardless of database size, and supports up to 44 read-only replicas to offload read workloads.

Adım Adım Çözüm

1
Analyze storage capacity and scaling requirements.
The database size is projected to reach 35 TB35\text{ TB}, which exceeds the standard capacity limits of Azure SQL Database General Purpose (4 TB4\text{ TB}) and Azure SQL Managed Instance (16 TB16\text{ TB}).
This rules out General Purpose databases and standard Managed Instance options.
2
Analyze operational performance and backup constraints.
The requirement states that backups must complete in under 15 minutes15\text{ minutes} regardless of size. Traditional backup methods depend on size, but Azure SQL Database Hyperscale uses storage snapshots to perform instantaneous backups.
This confirms that Hyperscale satisfies the backup timing constraint for large database sizes.
3
Evaluate the management model constraint.
A PaaS solution is required to minimize management overhead. While SQL Server on Azure Virtual Machines can support 35 TB35\text{ TB} databases, it is an IaaS solution that requires significant administrative effort for OS and database management.
This rules out SQL Server on Azure Virtual Machines and leaves Azure SQL Database Hyperscale as the only option that satisfies all storage, management, replication, and backup requirements.

Anahtar Kavram

Azure SQL Database service tiers and scaling limits
Tahmini Süre:2m 0s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru