Identify Considerations for Relational Data on Azure

Question 1

What fundamental cloud computing classification applies to Azure SQL Database and Azure SQL Managed Instance?

Infrastructure as a Service (IaaS) solutions maintained by the customer Database as a Service (DBaaS) running on dedicated physical hosts Platform as a Service (PaaS) offerings managed by Microsoft Software as a Service (SaaS) applications hosted via web portals

Correct Answer: Platform as a Service (PaaS) offerings managed by Microsoft

Azure SQL Database and Azure SQL Managed Instance are classified as Platform as a Service offerings because Microsoft handles the underlying infrastructure, operating system, and database software updates automatically.

Infrastructure as a Service is incorrect because it requires the customer to manage the operating system and database software. Software as a Service is incorrect because these are data platforms rather than finished end-user applications. The physically hosted Database as a Service option is incorrect because Azure SQL utilizes abstracted cloud infrastructure rather than dedicated hardware.

The key concept tested is the cloud service model classification of Azure relational database services.

Question 2

Which open-source relational database engine does Azure Database for PostgreSQL Flexible Server run on?

PostgreSQL, a Microsoft-proprietary relational database engine MySQL, a community-developed relational database engine with PostgreSQL compatibility MariaDB, a community-developed relational database engine PostgreSQL, a community-developed relational database engine

Correct Answer: PostgreSQL, a community-developed relational database engine

Azure Database for PostgreSQL Flexible Server runs on PostgreSQL, which is a well-known open-source, community-developed relational database management system, not owned or developed by any single company.

MariaDB is a separate open-source database engine and is not what powers Azure Database for PostgreSQL. PostgreSQL is not a Microsoft-proprietary engine; it is developed and maintained by the open-source community under the PostgreSQL Global Development Group. MySQL is a distinct database engine from PostgreSQL and does not provide PostgreSQL compatibility.

The key concept tested is understanding that Azure Database for PostgreSQL is a managed service built on the open-source community PostgreSQL engine.

Question 3

A team is building a small application that tracks employee training records in an Azure SQL Database. They need to write a sequence of SQL statements that will: (1) add a new training course to the courses table, (2) assign three employees to that course, and (3) update the enrollment count in the courses table. Which combination of DML statements should be included in their script to accomplish all three tasks?

Use INSERT to add the course, INSERT to assign employees, and ALTER to change the enrollment count Use INSERT to add the course, INSERT to assign employees, and UPDATE to change the enrollment count Use CREATE to add the course, INSERT to assign employees, and UPDATE to change the enrollment count Use INSERT to add the course, MERGE to assign employees, and SELECT to retrieve and change the enrollment count

Correct Answer: Use INSERT to add the course, INSERT to assign employees, and UPDATE to change the enrollment count

The correct answer uses INSERT to add a new row to the courses table, INSERT again to add three employee-course assignment rows, and UPDATE to modify the existing enrollment count value, which are all Data Manipulation Language (DML) operations that work on data within existing tables.

CREATE is a Data Definition Language (DDL) statement used to create database objects like tables, not to add data rows. ALTER is also a DDL statement that changes table structure (columns, constraints), not data values. MERGE is used for combined insert/update operations based on conditions, and SELECT only retrieves data without modifying it.

Key concept tested: distinguishing DML statements (INSERT, UPDATE, DELETE, SELECT) from DDL statements (CREATE, ALTER, DROP).

Identify Considerations for Relational Data on Azure

DP-900 - Identify Considerations for Relational Data on Azure Example Questions

Question 1

Question 2

Question 3

Master Data Fundamentals on Azure