Examkin

Soru

Zorluk: ZorRelational Data Storage Solutions

A manufacturing enterprise is migrating its on-premises SQL Server environment to Azure. The migration includes two databases with the following requirements:

* Database_Prod: A transaction processing system that requires SQL Server Agent for scheduling local ETL jobs, cross-database queries, and common language runtime (CLR) integration. The database must survive a primary datacenter outage within the chosen Azure region.
* Database_Archive: A legacy database that stores historical telemetry data. It requires the use of SQL Server FILESTREAM to store unstructured files, requires the installation of custom security agents directly on the hosting operating system, and requires sub-millisecond disk write latency for transaction logs.

Which two Azure SQL options should you recommend to meet the requirements? (Select two.)

  1. Azure SQL Managed Instance configured with zone-redundant backup storage for Database_ProdCevap
  2. SQL Server on Azure Virtual Machines using Premium SSD storage for Database_ArchiveCevap
  3. C
    Azure SQL Database single database for Database_Prod
  4. D
    Azure SQL Managed Instance for Database_Archive
  5. E
    Azure SQL Managed Instance configured with locally-redundant backup storage (LRS) for Database_Prod
  6. F
    SQL Server on Azure Virtual Machines using Standard HDD storage for Database_Archive

Cevap

Azure SQL Managed Instance configured with zone-redundant backup storage for Database_Prod, and SQL Server on Azure Virtual Machines using Premium SSD storage for Database_Archive.
The correct recommendations are Azure SQL Managed Instance with zone-redundant backup storage for the production database, and SQL Server on Azure Virtual Machines with Premium SSD storage for the archive database. Azure SQL Managed Instance provides full compatibility with SQL Server Agent, CLR, and cross-database queries while offering high availability and zone-redundant backup storage options to survive a datacenter outage. SQL Server on Azure Virtual Machines is the only deployment option that supports the FILESTREAM feature, grants full OS access to install custom security agents, and allows configuring Premium SSD storage to achieve sub-millisecond write latency for transaction logs.

Adım Adım Çözüm

1
Analyze the legacy features and redundancy requirements of Database_Prod.
Database_Prod requires SQL Server Agent, cross-database queries, and CLR. It also must survive a primary datacenter outage.
These application features rule out Azure SQL Database single database or elastic pools, pointing to Azure SQL Managed Instance. To survive a datacenter outage, zone-redundant storage is required instead of locally-redundant storage.
2
Analyze the legacy features, administrative access, and storage performance requirements of Database_Archive.
Database_Archive requires SQL Server FILESTREAM, OS-level security agent installation, and sub-millisecond write latency.
FILESTREAM and OS-level administration are not supported in PaaS offerings like Azure SQL Database or Azure SQL Managed Instance, making SQL Server on Azure VMs the only viable option. Sub-millisecond transaction log latency requires Premium SSD or Ultra Disk instead of Standard HDD.
3
Combine the recommended deployment patterns for both databases.
Select Azure SQL Managed Instance with zone-redundant storage for the production database, and SQL Server on Azure VMs with Premium SSD for the archive database.
This configuration satisfies all technical features, administrative restrictions, recovery objectives, and performance constraints.

Anahtar Kavram

Evaluating database deployment models in Azure SQL based on feature compatibility (SQL Agent, CLR, FILESTREAM), OS-level access, storage performance, and zone-redundancy requirements.
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru