Examkin

Question

Difficulty: EasyRelational Data Storage Solutions

An organization is planning to host a legacy vendor application in Azure. The application requires a relational database backend using SQL Server. The vendor documentation states that the application installer must run directly on the database server operating system to configure local registry keys and file path structures.

Which Azure SQL deployment option should you recommend to meet these requirements?

  1. SQL Server on Azure Virtual MachinesAnswer
  2. B
    Azure SQL Managed Instance
  3. C
    Azure SQL Database single database
  4. D
    Azure SQL Database elastic pool

Answer

SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines is an Infrastructure as a Service (IaaS) offering that gives you full administrative control over the SQL Server instance and the underlying operating system. This is required when third-party applications or installers need to make OS-level changes, write to the Windows Registry, or configure local file paths.

Step-by-Step Solution

1
Analyze the application requirements.
The application requires a relational SQL Server database and must write directly to the host operating system's registry and file paths.
Identifying the constraint of operating system access is critical for choosing the right deployment option.
2
Evaluate the management tiers of Azure SQL offerings.
PaaS options (Azure SQL Database and Azure SQL Managed Instance) abstract the operating system and do not allow administrative host access.
This determines whether a fully managed service can meet the requirements.
3
Select the option that provides host access.
SQL Server on Azure Virtual Machines (IaaS) provides full control over the OS.
This is the only deployment model that satisfies the requirement for OS-level installation and configuration.

Key Concept

SQL Server on Azure Virtual Machines vs. PaaS Database Services
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic