Examkin

Soru

Zorluk: OrtaRelational Data Storage Solutions

A company is planning a new database deployment on Azure for two internal applications. The design must accommodate the following requirements:

- Application 1: Requires a database that supports SQL Server Agent for automated job scheduling and SQL Server Common Language Runtime (CLR) integration. You must minimize operational overhead.
- Application 2: Requires a database that experiences highly unpredictable query volume, with long periods of inactivity and sudden brief spikes in demand. You must minimize compute costs during idle periods.

Which two database solutions should you recommend?

  1. Azure SQL Managed Instance for Application 1Cevap
  2. Azure SQL Database serverless for Application 2Cevap
  3. C
    Azure SQL Database single database for Application 1
  4. D
    SQL Server on Azure Virtual Machines with Standard HDD storage for Application 2

Cevap

Azure SQL Managed Instance for Application 1 and Azure SQL Database serverless for Application 2
The correct options are Azure SQL Managed Instance for Application 1 and Azure SQL Database serverless for Application 2. Azure SQL Managed Instance supports features like SQL Server Agent and CLR integration while maintaining a fully managed service model, which minimizes operational overhead. Azure SQL Database serverless is designed for workloads with unpredictable query volume and idle periods, as it offers automatic compute scaling and database pausing to minimize costs.

Adım Adım Çözüm

1
Analyze the database requirements for Application 1.
Identified the need for SQL Server Agent and CLR integration, combined with the goal to minimize operational overhead.
These feature requirements rule out Azure SQL Database single database, while the operational overhead goal makes Azure SQL Managed Instance a better choice than SQL Server on Azure VMs.
2
Analyze the database requirements for Application 2.
Identified the need to handle unpredictable spikes in traffic and minimize costs during long periods of inactivity.
Azure SQL Database serverless automatically scales compute and pauses the database during idle periods, satisfying the cost and demand requirements.
3
Select the two options that match the required services.
Azure SQL Managed Instance for Application 1 and Azure SQL Database serverless for Application 2 are identified as the correct targets.
These two deployment models perfectly align with the compatibility and cost-saving constraints.

Anahtar Kavram

Matching application workload requirements to appropriate Azure SQL relational database services based on feature compatibility, operational overhead, and cost optimization tiers.
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru