A digital forensics firm is designing the cloud architecture for a new evidence tracking system. The solution will utilize multiple relational databases and must meet the following requirements:
* Support native cross-database queries across multiple database catalogs using standard three-part naming conventions.
* Enable automated database maintenance tasks scheduled and executed natively using the SQL Server Agent.
* Run custom .NET assemblies directly within the database engine using SQL Server Common Language Runtime (CLR).
* Eliminate the administrative overhead of managing, patching, and maintaining the underlying operating system.
Which Azure SQL deployment option should you recommend?
- AAzure SQL Database single database
- BSQL Server on Azure Virtual Machines
- Azure SQL Managed InstanceCevap
- DAzure SQL Database elastic pool
Cevap
Azure SQL Managed Instance
The correct answer is the option recommending Azure SQL Managed Instance. This service is a fully managed Platform as a Service (PaaS) database engine that eliminates the overhead of operating system management, patching, and backups. It provides near-100% compatibility with the SQL Server database engine, including support for instance-level features such as SQL Server Agent, SQL CLR, and native cross-database queries using standard three-part naming conventions.
Adım Adım Çözüm
Anahtar Kavram
Selecting the correct Azure SQL service tier based on SQL Server feature compatibility and administration boundaries.
Tahmini Süre:2m 0s