Azure SQL Family & Open-Source Database Services

Which of these is described as an infrastructure-as-a-service (IaaS) option within the Azure SQL family?

• AAzure SQL Managed Instance
• BSQL Server on Azure Virtual Machines✓
• CAzure SQL Database
• DAzure Database for MySQL

Answer: SQL Server on Azure Virtual Machines is an IaaS solution because it runs a full SQL Server installation on a virtual machine, virtualising the underlying hardware for compute, storage and networking. Azure SQL Database and Azure SQL Managed Instance are both platform-as-a-service offerings, and Azure Database for MySQL is a separate PaaS service for MySQL rather than SQL Server.

A company wants to lift-and-shift an on-premises SQL Server solution to Azure with the fewest possible code changes, while avoiding the administrative overhead of managing a virtual machine's operating system. Which Azure SQL service best fits this need?

• ASQL Server on Azure Virtual Machines
• BAzure SQL Managed Instance✓
• CAzure Database for PostgreSQL
• DAzure SQL Database

Answer: Azure SQL Managed Instance provides near-100% compatibility with on-premises SQL Server while automating software updates, backups and other maintenance tasks, making it well suited to lift-and-shift migrations with minimal changes. SQL Server on Azure Virtual Machines still requires managing the operating system, Azure SQL Database supports only core database-level capabilities rather than full compatibility, and Azure Database for PostgreSQL runs a different database engine entirely.

Which Azure SQL service is described as the best option for building a brand-new cloud application with minimal administration and low cost?

• AAzure Database for MySQL Flexible Server
• BAzure SQL Database✓
• CAzure SQL Managed Instance
• DSQL Server on Azure Virtual Machines

Answer: Azure SQL Database is a fully managed, highly scalable PaaS service designed for the cloud, offering the best option for low cost and minimal administration when creating a new application. SQL Server on Azure Virtual Machines requires managing the operating system, Azure SQL Managed Instance targets near-full compatibility for migrated workloads, and Azure Database for MySQL Flexible Server runs the MySQL engine rather than SQL Server.

In Azure SQL Database, what is the difference between a Single Database and an Elastic Pool?

• AAn Elastic Pool is always an on-premises deployment option, while a Single Database can only ever run inside a dedicated virtual machine
• BA Single Database can only be queried using PL/SQL, while an Elastic Pool uses T-SQL
• CAn Elastic Pool lets multiple databases share the same pool of resources, while a Single Database has its own dedicated resources✓
• DA Single Database supports only standard SQL queries, while an Elastic Pool additionally supports NoSQL-style queries across databases

Answer: A Single Database runs on a dedicated, managed server with its own resources, whereas an Elastic Pool lets multiple databases share resources such as memory, storage and processing power, which can reduce costs for databases with resource needs that vary over time. Both options use the SQL Server engine and T-SQL, and neither is an on-premises or purely virtual-machine deployment.

Which Azure SQL Database service tier supports very large databases of up to 100 TB with rapid, on-demand scaling?

• ASingle Database
• BElastic Pool
• CHyperscale✓
• DManaged Instance

Answer: The Hyperscale service tier of Azure SQL Database supports very large databases up to 100 TB, with rapid, on-demand scaling and fast backup and restore regardless of data size. Elastic Pool and Single Database are deployment options within Azure SQL Database that aren't described with this scale, and Managed Instance is a separate Azure SQL service rather than a tier of Azure SQL Database.

Before migrating an on-premises database to Azure SQL Database, which tool can be used to detect compatibility issues that might affect database functionality?

• ApgAdmin
• BData Migration Assistant✓
• CAzure Database Migration service
• DAdvanced threat protection

Answer: The Data Migration Assistant analyses on-premises databases and reports issues that could block migration or affect functionality in Azure SQL Database. Advanced threat protection instead helps detect security vulnerabilities after deployment, pgAdmin is a PostgreSQL management tool, and the Azure Database Migration service is used to perform migrations rather than to detect compatibility issues beforehand.

Azure SQL Managed Instance supports both SQL Server Database engine logins and logins integrated with which Microsoft identity service?

• AData Migration Assistant
• BMicrosoft Entra ID✓
• CAzure Database Migration service
• DAdvanced threat protection

Answer: Azure SQL Managed Instance supports logins integrated with Microsoft Entra ID, which use the credentials from a user's current computer sign-in rather than requiring a separate username and password each time. The Azure Database Migration service, Advanced threat protection and Data Migration Assistant are unrelated tools used for migration and security rather than identity-based sign-in.

PostgreSQL is described as a hybrid relational-object database with which additional capability beyond standard relational tables?

• AAutomatically converting all queries into the PL/SQL dialect
• BRunning exclusively on Linux, Apache, MySQL and PHP stacks
• CStoring and manipulating custom and geometric data types, such as lines, circles and polygons✓
• DReplacing SQL entirely with a completely proprietary query language that Microsoft calls T-SQL

Answer: PostgreSQL is a hybrid relational-object database that lets you store custom data types with their own nonrelational properties, including geometric data such as lines, circles and polygons. It isn't restricted to the LAMP stack, which describes MySQL's traditional use case, and it uses its own pgsql dialect of SQL rather than T-SQL or PL/SQL.

MySQL is described in the unit as the leading open-source relational database for which stack of technologies?

• AMicrosoft Entra ID, Azure Functions and Power BI
• BData Lake Storage Gen2, OneLake and Microsoft Fabric
• CLinux, Apache, MySQL and PHP (LAMP)✓
• DT-SQL, PL/SQL and pgSQL

Answer: MySQL is described as the leading open source relational database for Linux, Apache, MySQL and PHP, commonly known as the LAMP stack. The other options list unrelated Azure identity, analytics and SQL-dialect names rather than a web application stack.

How long can automatic backups be retained with point-in-time restore in Azure Database for MySQL?

• AUp to 100 TB, regardless of how many days have passed
• BUp to 12 months, matching the Flexible Server free trial
• CUp to 35 days, with seven days as the default✓
• DUp to 7 days, with no option to extend it

Answer: Azure Database for MySQL provides automatic backups with point-in-time restore for up to 35 days, with a default retention of seven days. The retention period is measured in days rather than data volume, and it is unrelated to the 12-month free trial offered for Flexible Server.

Which Azure Database for MySQL deployment option is described as providing more granular control over database management and is the recommended choice for new workloads?

• ASingle Database
• BFlexible Server✓
• CManaged Instance
• DElastic Pool

Answer: The Flexible Server deployment option for Azure Database for MySQL provides more granular control and flexibility over database management functions and is the recommended deployment option for new workloads. Elastic Pool, Managed Instance and Single Database are deployment concepts associated with Azure SQL rather than with Azure Database for MySQL.

A PostgreSQL administrator wants to review information about the queries that users have run against their Azure Database for PostgreSQL server. Where can they find this information?

• ABy running the Data Migration Assistant against the server
• BBy querying the query_store.qs_view view in the azure_sys database✓
• CBy opening and reviewing the audit sign-in log files stored in their Azure storage account
• DBy reviewing the Advanced threat protection alerts generated for the database server

Answer: Azure Database for PostgreSQL records information about queries in a database named azure_sys, which can be reviewed by querying the query_store.qs_view view. The audit log in Azure storage and Advanced threat protection are features associated with Azure SQL Database rather than PostgreSQL query monitoring, and the Data Migration Assistant is a migration compatibility tool, not a query monitor.