Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

An organization is designing a relational data storage solution for a new patient scheduling portal. The database tier must support the following requirements:

* Run on a single database using a serverless compute model that automatically scales compute resources based on workload demand.
* Automatically pause the database during periods of inactivity to minimize costs.
* Ensure that database backups are resilient against a primary datacenter outage.

Which deployment option should you recommend?

  1. A
    Azure SQL Database serverless with Locally Redundant Storage (LRS) backup redundancy
  2. Azure SQL Database serverless with Zone-Redundant Storage (ZRS) backup redundancyAnswer
  3. C
    Azure SQL Managed Instance with Locally Redundant Storage (LRS) backup redundancy
  4. D
    SQL Server on Azure Virtual Machines using Standard HDD for transaction logs

Answer

Azure SQL Database serverless with Zone-Redundant Storage (ZRS) backup redundancy
The correct option is the one specifying Azure SQL Database serverless with Zone-Redundant Storage (ZRS) backup redundancy. Azure SQL Database serverless automatically scales compute for single databases and includes an auto-pause feature to optimize costs during inactive periods. Selecting ZRS replication for database backups ensures that the data is replicated across different availability zones, meeting the requirement to remain resilient against a primary datacenter outage.

Step-by-Step Solution

1
Analyze the database operational model requirements.
The solution requires a single database that supports auto-scaling and auto-pausing during periods of inactivity. This points directly to the serverless compute tier of Azure SQL Database, as Azure SQL Managed Instance and SQL Server on Azure VMs do not support auto-pausing.
To eliminate relational database deployment models that do not meet the primary cost and scalability requirements.
2
Evaluate backup redundancy options for disaster resilience.
The backups must survive a primary datacenter outage. Locally Redundant Storage (LRS) is insufficient because it replicates data within a single datacenter. Zone-Redundant Storage (ZRS) replicates data across three Azure availability zones within the region, providing resilience against datacenter failures.
To select the storage redundancy type that matches the organization's disaster recovery guidelines.
3
Cross-reference disk requirements and administrative limits.
SQL Server on Azure VMs is ruled out due to high management overhead, and using Standard HDD for transaction logs would cause severe performance bottlenecks.
To ensure no other options satisfy the constraints.

Key Concept

Selecting appropriate Azure SQL service tiers and storage redundancy configurations based on workload patterns and disaster recovery requirements.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic