Examkin

Soru

Zorluk: Çok zorRelational Data Storage Solutions

A retail corporation is planning the deployment of a high-throughput transactional database system on Azure. The system must meet the following requirements:

* Maintain transaction log write latencies under 1 millisecond.
* Allow database administrators to execute legacy Common Language Runtime (CLR) functions using unsafe assembly permissions.
* Ensure that both the operating system and database engine updates are automatically applied by the cloud provider.
* Restrict all database ingress traffic to a dedicated private IP address within a customer-managed virtual network.

Which relational database solution should you recommend?

  1. Business Critical service tier of Azure SQL Managed InstanceCevap
  2. B
    General Purpose service tier of Azure SQL Managed Instance
  3. C
    Business Critical service tier of Azure SQL Database
  4. D
    SQL Server running on Azure Virtual Machines with Premium SSD storage

Cevap

Business Critical service tier of Azure SQL Managed Instance
The Business Critical service tier of Azure SQL Managed Instance meets all requirements. It is a fully managed PaaS solution where Microsoft automatically patches both the operating system and the database engine. It supports advanced SQL Server features, including unsafe CLR assemblies. Because it natively integrates with virtual networks, it provides secure ingress via a private IP address. Finally, the Business Critical tier uses local SSD storage for data and log files, delivering sub-millisecond write latencies for the transaction logs.

Adım Adım Çözüm

1
Analyze CLR capability requirements.
Identify that Azure SQL Database does not support custom CLR assemblies, whereas Azure SQL Managed Instance and SQL Server running on Azure Virtual Machines support CLR including unsafe assemblies.
Eliminates Azure SQL Database from the candidates.
2
Evaluate administrative and patching requirements.
Identify that SQL Server on Azure Virtual Machines requires the user to manage operating system updates, whereas Azure SQL Managed Instance handles OS and engine patching automatically.
Eliminates SQL Server on Azure Virtual Machines.
3
Evaluate storage performance and write latency requirements.
Identify that the General Purpose tier of Azure SQL Managed Instance uses remote Azure Premium Storage (resulting in higher latency), whereas the Business Critical tier uses fast local SSD storage to achieve sub-millisecond transaction log write latency.
Differentiates between Managed Instance service tiers and selects the Business Critical tier.

Anahtar Kavram

Azure SQL Managed Instance service tiers and compatibility
Tahmini Süre:3m 0s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru