Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

An organization plans to migrate two on-premises SQL Server databases to Azure. The migration must meet the following requirements:

* Database 1: Requires native SQL Server Agent jobs and cross-database queries. The organization wants to minimize administrative overhead, including operating system patching.
* Database 2: Requires access to the underlying operating system to run a proprietary third-party compliance agent. The database transaction log files require high-throughput and low-latency storage.

Which two database solutions should you include in the design?

  1. Azure SQL Managed Instance for Database 1Answer
  2. SQL Server on Azure Virtual Machines with Premium SSD storage for Database 2Answer
  3. C
    Azure SQL Database single database for Database 1
  4. D
    SQL Server on Azure Virtual Machines with Standard HDD storage for Database 2

Answer

Azure SQL Managed Instance for Database 1, and SQL Server on Azure Virtual Machines with Premium SSD storage for Database 2
Azure SQL Managed Instance is the correct choice for Database 1 because it supports instance-level features such as SQL Server Agent and cross-database queries while eliminating the overhead of OS management. SQL Server on Azure VMs with Premium SSD is the correct choice for Database 2 because it provides full control over the underlying OS to install third-party agents, and Premium SSD storage delivers the low latency and high performance required for database transaction logs.

Step-by-Step Solution

1
Analyze the requirements for Database 1.
Database 1 requires SQL Server Agent and cross-database queries, combined with reduced OS management overhead.
These parameters point to Azure SQL Managed Instance, which is a fully managed PaaS solution supporting these instance-scoped features.
2
Analyze the requirements for Database 2.
Database 2 requires direct OS access for third-party tools and high-performance storage for log files.
Direct OS access requires SQL Server on Azure VMs (IaaS). Transaction logs require Premium SSD or Ultra disk for low latency and high throughput.
3
Evaluate the options and select the correct match.
Azure SQL Managed Instance is selected for Database 1, and SQL Server on Azure VMs with Premium SSD is selected for Database 2.
This setup correctly satisfies both the OS access restriction and the database capability constraints.

Key Concept

Selecting the appropriate Azure SQL deployment option (PaaS vs. IaaS) and storage tier based on operational, feature, and performance requirements.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic