Examkin

Question

Difficulty: HardRelational Data Storage Solutions

A company is planning the migration of two on-premises SQL Server databases to Azure. The databases have the following requirements:

* Database A hosts a customer management system that requires SQL Server Agent for scheduling maintenance tasks, Database Mail for system alerts, and cross-database queries. The company wants to minimize administrative overhead for managing the operating system and database patches.
* Database B hosts a legacy financial auditing tool. The application requires access to the underlying operating system registry to validate system configuration keys and must run a specialized host-based security agent directly on the database server operating system.

Which two design recommendations should you include? (Choose two.)

  1. Deploy Database A to Azure SQL Managed Instance.Answer
  2. Deploy Database B to SQL Server on Azure Virtual Machines.Answer
  3. C
    Deploy Database A to an Azure SQL Database single database.
  4. D
    Deploy Database B to an Azure SQL Managed Instance.
  5. E
    Configure Locally Redundant Storage (LRS) for Database A backups.

Answer

Deploy Database A to Azure SQL Managed Instance and deploy Database B to SQL Server on Azure Virtual Machines.
Deploying Database A to Azure SQL Managed Instance and Database B to SQL Server on Azure Virtual Machines is the correct recommendation. Azure SQL Managed Instance is a fully managed PaaS solution that supports SQL Server Agent, Database Mail, and cross-database queries, which satisfies all Database A requirements while eliminating OS-level administrative overhead. SQL Server on Azure Virtual Machines is an IaaS solution that provides full control over the underlying operating system and file system, which is required to meet Database B's need for OS registry access and host-based security agents.

Step-by-Step Solution

1
Analyze Database A's technical requirements and constraints.
Database A requires SQL Server Agent, Database Mail, and cross-database queries, with a desire to minimize OS-level administrative overhead.
These features map directly to Azure SQL Managed Instance, which provides full SQL Server compatibility without the management overhead of virtual machines.
2
Analyze Database B's technical requirements and constraints.
Database B requires OS registry access and the execution of a custom host-based security agent directly on the database server OS.
Managed services (PaaS) like Azure SQL Database and Managed Instance do not allow OS-level access. SQL Server on Azure VMs is the only option that grants full administrative control over the OS.
3
Combine the recommended deployment strategies.
Azure SQL Managed Instance for Database A, and SQL Server on Azure Virtual Machines for Database B.
This combination successfully meets all application feature requirements and OS-level constraints.

Key Concept

Selecting the appropriate Azure SQL deployment option based on application compatibility, OS-level dependencies, and administrative overhead.
Estimated Time:2m 0s
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic