Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A company is planning to migrate a legacy on-premises SQL Server database to Azure. The database has the following requirements:
* Requires the execution of Common Language Runtime (CLR) integration assemblies and SQL Server Agent.
* Requires operating system-level access to the database host to install and run a custom security agent.
* The database transaction log files must be stored on a disk configuration that guarantees at least 15,00015,000 IOPS and sub-millisecond write latency.

Which two configurations should you include in the design? (Select two.)

  1. Deploy SQL Server on Azure Virtual Machines for the database tierAnswer
  2. Configure Premium SSD or Ultra Disk storage for the database transaction logsAnswer
  3. C
    Deploy Azure SQL Database Managed Instance for the database tier
  4. D
    Configure Standard HDD storage for the database transaction logs

Answer

Deploy SQL Server on Azure Virtual Machines for the database tier and configure Premium SSD or Ultra Disk storage for the database transaction logs.
The correct design uses SQL Server on Azure Virtual Machines because the database requires operating system-level access to install custom security agents. Additionally, the storage subsystem for the database transaction logs must utilize Premium SSD or Ultra Disk to support the 15,00015,000 IOPS and sub-millisecond write latency requirements.

Step-by-Step Solution

1
Evaluate the database host access requirement.
The requirement for operating system-level access to run a custom security agent rules out fully managed Azure SQL offerings (such as Azure SQL Database and Azure SQL Database Managed Instance).
Managed database services abstract the underlying OS, preventing users from installing custom third-party agents on the host operating system.
2
Determine the database deployment model.
SQL Server on Azure Virtual Machines must be selected.
SQL Server on Azure VMs provides full administrative control over the operating system, allowing custom agents to be installed while still supporting legacy SQL Server features like SQL Server Agent and CLR.
3
Analyze the storage performance requirement for the transaction logs.
Standard storage tiers are eliminated, and high-performance tiers (Premium SSD or Ultra Disk) are selected.
A performance level of 15,00015,000 IOPS and sub-millisecond write latency requires Premium SSD or Ultra Disk storage. Standard HDD and Standard SSD storage options are limited by IOPS and throughput caps that make them unsuitable for high-performance transaction logs.

Key Concept

Selecting relational database deployment models based on administrative control and storage performance requirements.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic