Examkin

Soru

Zorluk: KolayMigration Assessment and Strategy

Your company is assessing the migration of an on-premises Microsoft SQL Server database to Azure. The database relies on cross-database queries and SQL Server Agent jobs to perform nightly transactional processing. Which Azure SQL deployment option should you select to support these features with minimal modification to the database or application code?

  1. Azure SQL Managed InstanceCevap
  2. B
    Azure SQL Database single database
  3. C
    Azure SQL Database elastic pool
  4. D
    Azure SQL Database serverless

Cevap

Azure SQL Managed Instance
Azure SQL Managed Instance is designed for migrating on-premises SQL Server instances to Azure with minimal migration effort. It provides near-complete compatibility with the on-premises SQL Server database engine, including support for instance-level features such as SQL Server Agent, SQL Server Database Mail, Service Broker, and cross-database queries.

Adım Adım Çözüm

1
Identify the key technical requirements from the assessment phase.
The requirements are native support for SQL Server Agent jobs and cross-database queries.
These are specific features used by the database that must be supported in the target environment.
2
Evaluate the capabilities of Azure SQL Database vs. Azure SQL Managed Instance.
Azure SQL Database (single databases, elastic pools, serverless) does not natively support SQL Server Agent or cross-database queries. Azure SQL Managed Instance supports these instance-level features.
This determines which deployment option minimizes code modification.
3
Select the option that meets the requirements with minimal modification.
Azure SQL Managed Instance is selected.
It offers near-complete compatibility with SQL Server, directly supporting the identified features.

Anahtar Kavram

Selecting the appropriate Azure SQL deployment option during migration assessment based on database dependencies and instance-level features.
Bu soruyu puanla

Konular

Migration Assessment and Strategy

Bu konudan daha fazla soru