Examkin

Soru

Zorluk: ZorRelational Data Storage Solutions

A manufacturing company is planning the migration of two on-premises databases to Azure. The migration requirements for each database are as follows:

* **Database 11 (Operations)**: Requires native SQL Server Agent for scheduling jobs, cross-database queries to databases on the same server, and support for Common Language Runtime (CLR) modules.
* **Database 22 (Telemetry)**: Requires storage that can scale up to 12 TB12\text{ TB}. The database experiences high-frequency write operations, and backups must finish in less than 15 minutes15\text{ minutes} without impacting application performance.

Which two database solutions should you recommend to meet these requirements? (Select two.)

  1. Azure SQL Managed Instance for Database 11Cevap
  2. Azure SQL Database Hyperscale for Database 22Cevap
  3. C
    Azure SQL Database single database for Database 11
  4. D
    Azure SQL Database Business Critical for Database 22

Cevap

Azure SQL Managed Instance for Database 1 and Azure SQL Database Hyperscale for Database 2
Azure SQL Managed Instance is the correct recommendation for Database 11 because it provides near 100% compatibility with the SQL Server database engine, including native support for instance-level features like SQL Server Agent, cross-database queries, and CLR. Azure SQL Database Hyperscale is the correct recommendation for Database 22 because it supports up to 100 TB100\text{ TB} of database storage and utilizes a unique log-structured storage architecture to perform snapshots for backups in minutes, regardless of the database size.

Adım Adım Çözüm

1
Analyze Database 11 requirements
Identify that Database 11 requires instance-scoped features: native SQL Server Agent, cross-database queries, and CLR support.
These legacy features require Azure SQL Managed Instance, as they are not supported natively in Azure SQL Database single databases or elastic pools.
2
Analyze Database 22 requirements
Identify that Database 22 requires 12 TB12\text{ TB} of storage and fast, low-impact backups (under 15 minutes15\text{ minutes}).
Azure SQL Database Hyperscale is the only fully managed relational database service that scales to 100 TB100\text{ TB} and utilizes a cloud-native decoupled architecture to perform instantaneous backups via storage snapshots.

Anahtar Kavram

Choosing Azure SQL database deployment options based on legacy instance-level feature compatibility and high-scale storage performance requirements.
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru