Category: DP-900

azure, DP-900, Microsoft Certification May 10, 2026

Practice Questions: Describe Azure File storage (DP-900 Exam Prep)

Practice Questions

Question 1

What is the primary purpose of Azure Files?

A. Store relational data
B. Provide a cloud-based file share
C. Run virtual machines
D. Perform analytics queries

✅ Answer: B

Explanation:
Azure Files provides shared file storage accessible via standard file system protocols.

Question 2

Which protocols are supported by Azure Files?

A. HTTP and HTTPS only
B. SQL and T-SQL
C. SMB and NFS
D. FTP and SMTP

✅ Answer: C

Explanation:
Azure Files supports SMB (Windows) and NFS (Linux) protocols.

Question 3

Which scenario is BEST suited for Azure Files?

A. Storing large video archives for streaming
B. Hosting a NoSQL database
C. Migrating a traditional file server to the cloud
D. Running complex SQL queries

✅ Answer: C

Explanation:
Azure Files is ideal for lift-and-shift file share migrations.

Question 4

How is Azure Files structured?

A. Database → Table → Row
B. Storage Account → Container → Blob
C. Storage Account → File Share → Directory → File
D. Server → Disk → Partition

✅ Answer: C

Explanation:
Azure Files uses a hierarchical structure similar to traditional file systems.

Question 5

Which feature allows synchronization between on-premises file servers and Azure Files?

A. Azure Blob Sync
B. Azure File Sync
C. Azure Data Factory
D. Azure Backup Vault

✅ Answer: B

Explanation:
Azure File Sync enables hybrid scenarios and local caching.

Question 6

Which type of storage is Azure Files considered?

A. Object storage
B. File storage
C. Key-value storage
D. Graph storage

✅ Answer: B

Explanation:
Azure Files is a file-based storage service.

Question 7

Which Azure Files tier provides high-performance storage using SSDs?

A. Archive
B. Cool
C. Standard
D. Premium

✅ Answer: D

Explanation:
Premium tier uses SSDs for higher performance.

Question 8

Which statement best describes Azure Files compared to Azure Blob Storage?

A. Azure Files is used only for structured data
B. Azure Files uses file system protocols like SMB
C. Azure Files cannot be accessed from on-premises systems
D. Azure Files requires a predefined schema

✅ Answer: B

Explanation:
Azure Files supports file system protocols, unlike Blob Storage which uses REST APIs.

Question 9

Which feature ensures that Azure Files data remains available even if a virtual machine restarts?

A. Ephemeral storage
B. Persistent storage
C. Temporary storage
D. Local disk storage

✅ Answer: B

Explanation:
Azure Files provides persistent storage independent of compute resources.

Question 10

Which scenario would NOT be appropriate for Azure Files?

A. Sharing configuration files across applications
B. Hosting a shared drive for users
C. Storing large unstructured data for analytics
D. Migrating on-premises file shares

✅ Answer: C

Explanation:
Large-scale unstructured analytics data is better suited for Azure Blob Storage or Data Lake, not Azure Files.

✅ Quick Exam Takeaways

✔ Azure Files = cloud-based file share service
✔ Supports SMB and NFS protocols

✔ Structure:

Storage Account → File Share → Directory → File

✔ Key features:

Shared access
Persistent storage
Hybrid support (Azure File Sync)
Fully managed

✔ Tiers:

Standard (HDD)
Premium (SSD)

✔ Best for:

File shares
Lift-and-shift migrations
Shared application storage

Go to the DP-900 Exam Prep Hub main page.

azure, DP-900, Microsoft Certification May 10, 2026

Practice Questions: Describe Azure Blob storage (DP-900 Exam Prep)

Practice Questions

Question 1

What type of data is best suited for Azure Blob Storage?

A. Highly structured relational data
B. Unstructured data such as images and videos
C. Data requiring complex joins
D. Transactional financial records

✅ Answer: B

Explanation:
Blob Storage is optimized for unstructured data like media files, documents, and logs.

Question 2

What is the correct hierarchy in Azure Blob Storage?

A. Blob → Container → Storage Account
B. Container → Blob → Storage Account
C. Storage Account → Container → Blob
D. Storage Account → Blob → Container

✅ Answer: C

Explanation:
The hierarchy is Storage Account → Container → Blob.

Question 3

Which type of blob is BEST suited for storing log files that are continuously appended?

A. Block blob
B. Page blob
C. Append blob
D. Archive blob

✅ Answer: C

Explanation:
Append blobs are optimized for append operations, such as logging.

Question 4

Which access tier is MOST cost-effective for data that is rarely accessed?

A. Hot
B. Cool
C. Archive
D. Premium

✅ Answer: C

Explanation:
The Archive tier is designed for rarely accessed data at the lowest cost.

Question 5

Which Blob Storage feature ensures data is replicated to improve durability?

A. Indexing
B. Data redundancy options
C. Query optimization
D. Schema enforcement

✅ Answer: B

Explanation:
Blob Storage uses redundancy options (e.g., LRS, GRS) to ensure durability.

Question 6

Which blob type is typically used for storing virtual machine disks?

A. Block blob
B. Append blob
C. Page blob
D. Archive blob

✅ Answer: C

Explanation:
Page blobs support random read/write operations and are used for VM disks.

Question 7

Which scenario is BEST suited for Azure Blob Storage?

A. Running complex SQL queries
B. Storing large volumes of images for a website
C. Managing transactional order data
D. Performing real-time analytics

✅ Answer: B

Explanation:
Blob Storage is ideal for storing large volumes of unstructured data like images.

Question 8

What is a container in Azure Blob Storage?

A. A type of blob
B. A virtual machine
C. A logical grouping of blobs
D. A database schema

✅ Answer: C

Explanation:
Containers are used to organize blobs, similar to folders.

Question 9

Which feature allows secure, temporary access to Blob Storage resources?

A. SQL authentication
B. Shared Access Signature (SAS)
C. Primary key constraint
D. Indexing

✅ Answer: B

Explanation:
SAS tokens provide secure, time-limited access to storage resources.

Question 10

Which statement best describes Azure Blob Storage?

A. It requires a predefined schema
B. It is used only for relational data
C. It is an object storage solution for unstructured data
D. It is a transactional database system

✅ Answer: C

Explanation:
Blob Storage is an object storage service designed for unstructured data.

✅ Quick Exam Takeaways

✔ Blob Storage = unstructured/object storage
✔ Structure:

Storage Account → Container → Blob

✔ Blob types:

Block → general files
Append → logs
Page → VM disks

✔ Access tiers:

Hot (frequent access)
Cool (infrequent)
Archive (rare)

✔ Key features:

Scalable
Durable (replication)
Secure (SAS, RBAC)
Cost-optimized

Go to the DP-900 Exam Prep Hub main page.

azure, Databases, DP-900, Microsoft Certification May 10, 2026

Identify Azure Database Services for open-source database systems (DP-900 Exam Prep)

This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Identify considerations for relational data on Azure (20–25%)
   --> Describe relational Azure data services
      --> Identify Azure database services for open-source database systems

Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

In addition to the Azure SQL family, Microsoft Azure provides fully managed database services for popular open-source relational database systems. These services allow organizations to run familiar technologies like PostgreSQL and MySQL in the cloud without managing infrastructure.

For the DP-900 exam, you should understand which services are available, what they support, and when to use them.

What Are Open-Source Database Systems?

Open-source database systems are relational databases whose source code is publicly available and widely used across industries.

Common examples include:

PostgreSQL
MySQL
MariaDB

These systems are known for flexibility, cost-effectiveness, and strong community support.

Azure Services for Open-Source Databases

Azure offers managed services for these databases, allowing you to run them in a Platform as a Service (PaaS) model.

1. Azure Database for PostgreSQL

Azure Database for PostgreSQL

A fully managed PostgreSQL database service.

Key Features

Automated backups and patching
Built-in high availability
Scaling options for compute and storage
Security features (encryption, network isolation)
Support for PostgreSQL extensions

Deployment Options

Flexible Server (most commonly used)

Use Cases

Web and mobile applications
Analytics workloads
Applications already using PostgreSQL

✔ Best for: PostgreSQL-based applications moving to Azure

2. Azure Database for MySQL

Azure Database for MySQL

A fully managed MySQL database service.

Key Features

Automated backups and patching
High availability options
Scaling for performance
Built-in security features
Compatible with popular MySQL tools

Use Cases

Web applications (e.g., LAMP stack)
E-commerce platforms
Content management systems

✔ Best for: Applications built on MySQL

3. Azure Database for MariaDB (Legacy Note)

Azure Database for MariaDB

Previously offered as a managed service
Now being retired (important exam awareness point)

💡 DP-900 Tip:
Know that MariaDB exists, but focus primarily on PostgreSQL and MySQL.

Key Characteristics of Azure Open-Source Database Services

These services share common benefits:

Platform as a Service (PaaS)

No infrastructure management
Azure handles patching, backups, and updates

High Availability

Built-in redundancy
Automatic failover options

Scalability

Scale compute and storage independently

Security

Encryption at rest and in transit
Network security (firewalls, private endpoints)

When to Use Open-Source Database Services in Azure

Choose these services when:

You are already using PostgreSQL or MySQL
You want to migrate existing applications with minimal changes
You prefer open-source technologies
You want a managed service without infrastructure overhead

Comparison with Azure SQL Family

Feature	Azure SQL Services	Open-Source Azure Services
Database Engine	SQL Server	PostgreSQL / MySQL
Language	T-SQL	PostgreSQL SQL / MySQL SQL
Use Case	Microsoft ecosystem	Open-source ecosystem
Management	PaaS / IaaS options	Primarily PaaS

Why This Matters for DP-900

On the exam, you may be asked to:

Identify Azure services for PostgreSQL or MySQL
Choose the correct service for an open-source workload
Understand the benefits of managed database services
Compare Azure SQL vs open-source options

Summary — Exam-Relevant Takeaways

✔ Azure supports open-source relational databases:

Azure Database for PostgreSQL
Azure Database for MySQL

✔ These are PaaS services:

Azure manages infrastructure, backups, and patching

✔ Key benefits:

High availability
Scalability
Security

✔ Use them when:

Migrating existing open-source applications
Building apps using PostgreSQL or MySQL

✔ Be aware:

MariaDB support exists but is being phased out

Go to the Practice Exam Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.

azure, Databases, DP-900, Microsoft Certification May 10, 2026

Practice Questions: Identify Azure Database Services for open-source database systems (DP-900 Exam Prep)

Practice Questions

Question 1

Which Azure service is used to host a managed PostgreSQL database?

A. Azure SQL Database
B. Azure Database for PostgreSQL
C. Azure Cosmos DB
D. Azure Synapse Analytics

✅ Answer: B

Explanation:
Azure Database for PostgreSQL is the managed service for PostgreSQL workloads.

Question 2

Which Azure service is BEST suited for hosting a MySQL-based web application?

A. Azure SQL Managed Instance
B. Azure Database for MySQL
C. Azure Data Lake Storage
D. Azure Blob Storage

✅ Answer: B

Explanation:
Azure Database for MySQL is designed for MySQL workloads, commonly used in web apps.

Question 3

What type of service are Azure Database for PostgreSQL and Azure Database for MySQL?

A. Infrastructure as a Service (IaaS)
B. Platform as a Service (PaaS)
C. Software as a Service (SaaS)
D. On-premises solutions

✅ Answer: B

Explanation:
These services are PaaS offerings, meaning Azure manages infrastructure and maintenance.

Question 4

Which task is handled by Azure in open-source database PaaS services?

A. Writing SQL queries
B. Managing application code
C. Performing backups and patching
D. Designing database schema

✅ Answer: C

Explanation:
Azure handles operational tasks like backups, patching, and updates.

Question 5

Which scenario is BEST suited for Azure Database for PostgreSQL?

A. Running a NoSQL database
B. Migrating an existing PostgreSQL application to Azure
C. Storing unstructured files
D. Running machine learning models

✅ Answer: B

Explanation:
This service is ideal for migrating or running PostgreSQL workloads in Azure.

Question 6

Which of the following is an open-source relational database supported by Azure?

A. Microsoft SQL Server
B. Oracle Database
C. PostgreSQL
D. Azure Cosmos DB

✅ Answer: C

Explanation:
PostgreSQL is a widely used open-source relational database supported by Azure.

Question 7

Which Azure database service for open-source systems is being retired?

A. Azure Database for PostgreSQL
B. Azure Database for MySQL
C. Azure Database for MariaDB
D. Azure SQL Database

✅ Answer: C

Explanation:
Azure Database for MariaDB is being phased out.

Question 8

Which feature is commonly provided by Azure open-source database services?

A. Manual scaling only
B. No security features
C. Built-in high availability
D. No backup support

✅ Answer: C

Explanation:
These services include built-in high availability and redundancy.

Question 9

Which is a key benefit of using Azure Database for MySQL instead of installing MySQL on a VM?

A. Full OS control
B. Reduced management overhead
C. No support for scaling
D. Limited security features

✅ Answer: B

Explanation:
PaaS reduces administrative tasks like maintenance and patching.

Question 10

Which factor is MOST important when choosing Azure Database for PostgreSQL or MySQL?

A. Whether the data is unstructured
B. The need for OS-level access
C. The existing database engine used by the application
D. The need for NoSQL capabilities

✅ Answer: C

Explanation:
Choice is typically driven by the database engine already used (PostgreSQL vs MySQL).

✅ Quick Exam Takeaways

✔ Azure Database for PostgreSQL → PostgreSQL workloads
✔ Azure Database for MySQL → MySQL workloads
✔ Both are PaaS services (Azure manages infrastructure)

✔ Key benefits:

Automated backups
Patching and updates
High availability
Scalability

✔ Use when:

Migrating open-source databases
Building apps on PostgreSQL or MySQL

✔ Be aware:

MariaDB is being retired

Go to the DP-900 Exam Prep Hub main page.

Databases, DP-900, Microsoft Certification May 10, 2026

Identify common database objects (DP-900 Exam Prep)

This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Identify considerations for relational data on Azure (20–25%)
   --> Describe relational concepts
      --> Identify common database objects

Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

Relational databases are composed of several key database objects that define how data is stored, accessed, secured, and optimized. For the DP-900 exam, you should understand the purpose of these objects and how they support relational data systems.

What Are Database Objects?

Database objects are logical structures within a database used to:

Store data
Organize data
Enforce rules
Improve performance
Control access

They are created and managed using Structured Query Language (SQL).

Core Database Objects You Need to Know

1. Tables

A table is the primary object used to store data.

Organized into rows (records) and columns (fields)
Each table represents an entity (e.g., Customers, Orders)
Data is physically stored in tables

Example:

CustomerID	Name	City
1	John	Seattle

✔ Tables are the foundation of relational databases.

2. Views

A view is a virtual table based on a SQL query.

Does not store data physically (in most cases)
Displays data from one or more tables
Simplifies complex queries
Can restrict access to sensitive data

Example Use Case:

Show only customer names and cities, hiding confidential columns

✔ Views provide abstraction and security.

3. Indexes

An index is used to improve query performance.

Speeds up data retrieval
Works like an index in a book
Created on one or more columns
Improves SELECT performance but may slightly slow writes

Example:

Index on CustomerID for fast lookups

✔ Indexes are critical for performance optimization.

4. Stored Procedures

A stored procedure is a saved collection of SQL statements.

Stored and executed in the database
Can accept parameters
Can include logic (conditions, loops)
Improves performance and reusability

Example Use Case:

Retrieve all orders for a specific customer

✔ Stored procedures enable automation and reusable logic.

5. Schemas

A schema is a logical container for database objects.

Organizes tables, views, and other objects
Helps manage permissions
Improves structure and maintainability

Example:

Sales.Customers
HR.Employees

✔ Schemas help with organization and security management.

6. Keys

Keys define relationships and ensure data uniqueness.

Primary Key

Uniquely identifies each row
Cannot contain NULL values

Foreign Key

Links one table to another
Enforces referential integrity

✔ Keys are essential for relationships and data integrity.

7. Constraints

Constraints enforce rules on data to maintain accuracy.

Common constraints include:

PRIMARY KEY → unique identifier
FOREIGN KEY → enforces relationships
NOT NULL → requires a value
UNIQUE → prevents duplicates
CHECK → enforces conditions

✔ Constraints ensure data validity and consistency.

How These Objects Work Together

In a typical relational database:

Tables store the data
Keys and constraints enforce rules
Indexes improve performance
Views simplify access
Stored procedures automate operations
Schemas organize everything

Database Objects in Azure

These objects are used in Azure relational services such as:

Azure SQL Database
Azure Database for PostgreSQL
Azure Database for MySQL

These platforms support standard SQL-based database objects and functionality.

Why This Matters for DP-900

On the exam, you may be asked to:

Identify different database objects
Match objects to their purpose
Distinguish between tables, views, and indexes
Understand how objects support performance, security, and organization

Summary — Exam-Relevant Takeaways

✔ Tables → store data
✔ Views → virtual representation of data
✔ Indexes → improve query performance
✔ Stored procedures → reusable SQL logic
✔ Schemas → organize objects
✔ Keys → define relationships
✔ Constraints → enforce data rules

✔ Together, these objects ensure:

Efficient data storage
Fast data retrieval
Strong data integrity
Secure and organized systems

Go to the Practice Exam Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.

azure, DP-900, Microsoft Certification May 10, 2026

Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines (DP-900 Exam Prep)

This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Identify considerations for relational data on Azure (20–25%)
   --> Describe relational Azure data services
      --> Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines

Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

Microsoft Azure provides a family of relational database services collectively known as the Azure SQL family. These services are based on the Microsoft SQL Server engine and are designed to support a wide range of workloads—from fully managed cloud databases to lift-and-shift migrations.

For the DP-900 exam, you should understand the differences, use cases, and key features of:

Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure Virtual Machines

Overview of the Azure SQL Family

All Azure SQL offerings:

Use the Microsoft SQL Server engine
Support Structured Query Language (SQL)
Are designed for relational data workloads
Provide varying levels of management control vs automation

💡 The key difference is how much control you have vs how much Azure manages for you.

1. Azure SQL Database

Azure SQL Database is a fully managed Platform as a Service (PaaS) offering.

Key Features

Fully managed by Azure (patching, backups, updates)
Built-in high availability
Automatic scaling options
Intelligent performance tuning
Minimal administrative overhead

Deployment Options

Single database (isolated)
Elastic pool (shared resources across multiple databases)

Use Cases

Cloud-native applications
Modern web and mobile apps
Applications that do not require full SQL Server feature compatibility

✔ Best for: Simplicity, scalability, and minimal management

2. Azure SQL Managed Instance

Azure SQL Managed Instance is a Platform as a Service (PaaS) offering with near 100% compatibility with SQL Server.

Key Features

Managed service with automated patching and backups
Supports most SQL Server features (e.g., SQL Agent, linked servers)
Instance-level features (unlike Azure SQL Database)
Runs inside a virtual network (VNet)

Use Cases

Migration of on-premises SQL Server applications
Applications requiring instance-level features
Lift-and-shift scenarios with minimal changes

✔ Best for: Compatibility with existing SQL Server environments

3. SQL Server on Azure Virtual Machines

SQL Server on Azure Virtual Machines is an Infrastructure as a Service (IaaS) offering.

Key Features

Full control over the operating system and SQL Server
You manage patching, backups, and maintenance
Supports all SQL Server features
Easy lift-and-shift migration

Use Cases

Legacy applications requiring full control
Custom configurations or unsupported features in PaaS
Scenarios requiring OS-level access

✔ Best for: Maximum control and full SQL Server compatibility

Key Differences at a Glance

Feature	Azure SQL Database	Azure SQL Managed Instance	SQL Server on Azure VM
Service Type	PaaS	PaaS	IaaS
Management	Fully managed	Mostly managed	Customer-managed
SQL Server Compatibility	Partial	Near 100%	100%
OS Access	No	No	Yes
Use Case	Cloud-native apps	Migration with minimal changes	Full control / legacy apps

Choosing the Right Option

Think of the Azure SQL family as a spectrum:

Most managed → Azure SQL Database
Balanced → Azure SQL Managed Instance
Most control → SQL Server on Azure VM

💡 DP-900 Tip:
Questions often test your ability to match a scenario with the correct service based on:

Level of control required
Compatibility needs
Migration vs cloud-native design

Why This Matters for DP-900

On the exam, you may be asked to:

Identify differences between Azure SQL offerings
Choose the appropriate service for a scenario
Understand PaaS vs IaaS trade-offs
Recognize management responsibilities

Summary — Exam-Relevant Takeaways

✔ All Azure SQL services are based on SQL Server
✔ Use SQL for querying and management

✔ Azure SQL Database

Fully managed
Best for modern cloud apps

✔ Azure SQL Managed Instance

High compatibility with SQL Server
Best for migrations

✔ SQL Server on Azure VM

Full control (IaaS)
Best for legacy or highly customized environments

✔ Key decision factor = control vs management

Go to the Practice Exam Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.

azure, Databases, DP-900, Microsoft Certification May 10, 2026

Practice Questions: Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines (DP-900 Exam Prep)

Practice Questions

Question 1

Which Azure SQL offering is fully managed and requires the least administrative effort?

A. SQL Server on Azure Virtual Machines
B. Azure SQL Managed Instance
C. Azure SQL Database
D. Azure Synapse Analytics

✅ Answer: C

Explanation:
Azure SQL Database is a fully managed PaaS service with minimal administration.

Question 2

Which Azure SQL service provides the highest level of compatibility with on-premises SQL Server while still being a PaaS solution?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure Cosmos DB

✅ Answer: B

Explanation:
Azure SQL Managed Instance offers near 100% compatibility with SQL Server.

Question 3

Which Azure SQL option allows full control over the operating system?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Elastic Pool

✅ Answer: C

Explanation:
SQL Server on Azure VM is an IaaS offering, giving full OS-level control.

Question 4

Which service is BEST suited for a cloud-native application with minimal management overhead?

A. SQL Server on Azure Virtual Machines
B. Azure SQL Managed Instance
C. Azure SQL Database
D. Azure Data Lake

✅ Answer: C

Explanation:
Azure SQL Database is optimized for modern cloud applications.

Question 5

Which Azure SQL service supports instance-level features such as SQL Agent?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure Blob Storage

✅ Answer: B

Explanation:
Managed Instance supports many instance-level features not available in Azure SQL Database.

Question 6

A company wants to migrate an existing SQL Server database with minimal changes. Which service should they choose?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure Synapse Analytics

✅ Answer: B

Explanation:
Managed Instance is designed for lift-and-shift migrations with high compatibility.

Question 7

Which Azure SQL option requires you to manage backups, updates, and patching?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Elastic Pool

✅ Answer: C

Explanation:
In IaaS (Azure VM), the customer is responsible for management tasks.

Question 8

Which of the following best describes Platform as a Service (PaaS) in the Azure SQL family?

A. Full control over hardware and OS
B. No database management required at all
C. Azure manages infrastructure and database maintenance
D. Only supports non-relational data

✅ Answer: C

Explanation:
PaaS handles infrastructure, patching, backups, and high availability.

Question 9

Which Azure SQL service is MOST appropriate when you need maximum control and customization?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Elastic Pool

✅ Answer: C

Explanation:
SQL Server on Azure VM provides full control over configuration and environment.

Question 10

Which statement best describes the relationship between the Azure SQL family products?

A. They use completely different database engines
B. They all use the SQL Server engine with different management levels
C. Only Azure SQL Database supports SQL
D. Only SQL Server on Azure VM supports relational data

✅ Answer: B

Explanation:
All Azure SQL offerings are based on the SQL Server engine, differing mainly in management and control.

✅ Quick Exam Takeaways

✔ Azure SQL Database

Fully managed (PaaS)
Best for cloud-native apps

✔ Azure SQL Managed Instance

Near full SQL Server compatibility
Best for migrations

✔ SQL Server on Azure VM

Full control (IaaS)
You manage everything

✔ Key concept:
👉 More control = more responsibility
👉 More automation = less control

Go to the DP-900 Exam Prep Hub main page.

Databases, DP-900, Microsoft Certification May 10, 2026

Practice Questions: Identify common database objects (DP-900 Exam Prep)

Practice Questions

Question 1

Which database object is used to store data in rows and columns?

A. View
B. Table
C. Index
D. Schema

✅ Answer: B

Explanation:
Tables are the primary objects used to store structured data.

Question 2

Which database object provides a virtual representation of data without storing it physically?

A. Table
B. Index
C. View
D. Constraint

✅ Answer: C

Explanation:
Views display data based on a query but typically do not store data themselves.

Question 3

What is the primary purpose of an index?

A. Store data
B. Enforce relationships
C. Improve query performance
D. Organize database objects

✅ Answer: C

Explanation:
Indexes speed up data retrieval operations.

Question 4

Which database object allows you to store and reuse a set of SQL statements?

A. View
B. Stored procedure
C. Schema
D. Index

✅ Answer: B

Explanation:
Stored procedures contain reusable SQL logic and can include parameters and control flow.

Question 5

Which database object is used to logically group other database objects?

A. Table
B. Schema
C. Index
D. Constraint

✅ Answer: B

Explanation:
Schemas organize database objects and help manage permissions.

Question 6

Which object ensures that each row in a table is uniquely identified?

A. Foreign key
B. Index
C. Primary key
D. View

✅ Answer: C

Explanation:
A primary key uniquely identifies each record in a table.

Question 7

Which database object enforces relationships between tables?

A. Schema
B. Foreign key
C. Index
D. Stored procedure

✅ Answer: B

Explanation:
Foreign keys link tables and enforce referential integrity.

Question 8

Which constraint prevents duplicate values in a column?

A. NOT NULL
B. CHECK
C. UNIQUE
D. FOREIGN KEY

✅ Answer: C

Explanation:
The UNIQUE constraint ensures all values in a column are distinct.

Question 9

Which database object is MOST useful for restricting access to specific columns of data?

A. Table
B. Index
C. View
D. Primary key

✅ Answer: C

Explanation:
Views can limit which columns or rows are exposed to users.

Question 10

Which object may slightly decrease write performance due to maintenance overhead?

A. View
B. Index
C. Schema
D. Constraint

✅ Answer: B

Explanation:
Indexes improve read performance but can slow down inserts and updates.

✅ Quick Exam Takeaways

For DP-900, remember:

✔ Tables → store data
✔ Views → virtual tables (security + simplicity)
✔ Indexes → improve performance (reads ↑, writes ↓ slightly)
✔ Stored procedures → reusable SQL logic
✔ Schemas → organize objects
✔ Primary keys → unique identifiers
✔ Foreign keys → relationships
✔ Constraints → enforce rules (NOT NULL, UNIQUE, etc.)

Go to the DP-900 Exam Prep Hub main page.

Data Development, Data Education & Training, Data Modeling, Databases, DP-900, SQL, Uncategorized May 10, 2026

Identify common Structured Query Language (SQL) statements (DP-900 Exam Prep)

This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Identify considerations for relational data on Azure (20–25%)
   --> Describe relational concepts
      --> Identify common Structured Query Language (SQL) statements

Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

Understanding basic SQL statements is essential for working with relational data and is a key requirement for the DP-900 exam. You are not expected to be an advanced SQL developer, but you should recognize common SQL commands, their purpose, and when they are used.

What Is SQL?

Structured Query Language (SQL) is the standard language used to:

Query data
Insert new data
Update existing data
Delete data
Define database structures

SQL is used across relational database systems, including Azure services like:

Azure SQL Database
Azure Database for PostgreSQL
Azure Database for MySQL

Categories of SQL Statements

SQL statements are typically grouped into categories:

Category	Purpose
DDL (Data Definition Language)	Define and modify database structures
DML (Data Manipulation Language)	Work with data in tables
DQL (Data Query Language)	Retrieve data
DCL (Data Control Language)	Manage permissions

For DP-900, focus primarily on DDL, DML, and DQL.

1. Data Query Language (DQL)

SELECT

Used to retrieve data from a table.

			
SELECT Name, City
FROM Customers;

You can filter results:

			
SELECT Name
FROM Customers
WHERE City = 'Seattle';

💡 Key Points:

Most commonly used SQL statement
Can include filtering, sorting, and grouping

2. Data Manipulation Language (DML)

INSERT

Adds new rows to a table.

			
INSERT INTO Customers (Name, City)
VALUES ('John', 'Seattle');

UPDATE

Modifies existing data.

			
UPDATE Customers
SET City = 'Austin'
WHERE Name = 'John';

DELETE

Removes rows from a table.

			
DELETE FROM Customers
WHERE Name = 'John';

💡 Important:
Always use a WHERE clause with UPDATE and DELETE to avoid affecting all rows.

3. Data Definition Language (DDL)

CREATE

Creates new database objects such as tables.

			
CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    Name VARCHAR(100),
    City VARCHAR(50)
);

		

ALTER

Modifies an existing table.

			
ALTER TABLE Customers
ADD Email VARCHAR(100);

DROP

Deletes a table or database object.

DROP TABLE Customers;

💡 Warning:
DROP permanently removes the object and its data.

4. Additional Common SQL Clauses

WHERE

Filters rows:

			
SELECT * FROM Orders
WHERE Amount > 100;

ORDER BY

Sorts results:

			
SELECT * FROM Orders
ORDER BY Amount DESC;

GROUP BY

Aggregates data:

			
SELECT City, COUNT(*)
FROM Customers
GROUP BY City;

JOIN

Combines data from multiple tables:

			
SELECT Orders.OrderID, Customers.Name
FROM Orders
JOIN Customers
ON Orders.CustomerID = Customers.CustomerID;

💡 DP-900 Tip:
You don’t need deep JOIN knowledge — just understand that JOINs combine related tables.

SQL in Azure

SQL is used across many Azure services:

Azure SQL Database

Fully managed relational database
Uses T-SQL (Microsoft’s SQL variant)

Azure Synapse Analytics

Used for analytical queries on large datasets

Azure Database for PostgreSQL

Uses PostgreSQL SQL dialect

Why This Matters for DP-900

On the exam, you may be asked to:

Identify what a SQL statement does
Match commands to their purpose (SELECT, INSERT, etc.)
Recognize DDL vs DML
Understand basic query concepts like filtering and sorting

Summary — Exam-Relevant Takeaways

✔ SELECT → Retrieve data
✔ INSERT → Add new data
✔ UPDATE → Modify existing data
✔ DELETE → Remove data

✔ CREATE / ALTER / DROP → Define and modify structures
✔ WHERE → Filter results
✔ ORDER BY → Sort data
✔ GROUP BY → Aggregate data
✔ JOIN → Combine tables

✔ SQL is the standard language for relational databases

Go to the Practice Exam Questions for this topic.

Go to the Additional Practice Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.

DP-900, Microsoft Certification, SQL May 10, 2026

Additional Practice Questions: Identify common Structured Query Language (SQL) statements – SQL JOIN Focused (DP-900 Exam Prep)

Practice Questions – SQL JOIN focused questions

Question 1

What is the purpose of a SQL JOIN?

A. To delete duplicate rows
B. To combine data from multiple tables
C. To sort query results
D. To filter columns

✅ Answer: B

Explanation:
JOIN is used to combine rows from two or more related tables.

Question 2

Which type of JOIN returns only matching rows from both tables?

A. LEFT JOIN
B. RIGHT JOIN
C. INNER JOIN
D. CROSS JOIN

✅ Answer: C

Explanation:
INNER JOIN returns only rows where there is a match in both tables.

Question 3

A LEFT JOIN returns:

A. Only matching rows
B. All rows from the right table only
C. All rows from the left table and matching rows from the right
D. Only non-matching rows

✅ Answer: C

Explanation:
LEFT JOIN keeps all rows from the left table, even if there is no match.

Question 4

What happens when there is no matching row in a RIGHT JOIN?

A. The row is removed
B. NULL values are returned for missing matches
C. The query fails
D. Only matched rows are shown

✅ Answer: B

Explanation:
Unmatched columns return NULL values.

Question 5

Which JOIN type returns all possible combinations of rows between two tables?

A. INNER JOIN
B. LEFT JOIN
C. CROSS JOIN
D. FULL JOIN

✅ Answer: C

Explanation:
CROSS JOIN produces a Cartesian product (all combinations).

Question 6

Which SQL clause is used to define how tables are related in a JOIN?

A. WHERE
B. GROUP BY
C. ON
D. ORDER BY

✅ Answer: C

Explanation:
The ON clause specifies the relationship between tables.

Question 7

Given two tables: Customers and Orders. Each customer may have multiple orders. Which JOIN is typically used to retrieve all customers and their orders?

A. INNER JOIN
B. LEFT JOIN
C. CROSS JOIN
D. SELF JOIN

✅ Answer: B

Explanation:
LEFT JOIN ensures all customers appear, even those without orders.

Question 8

What does an INNER JOIN exclude?

A. Duplicate rows
B. Non-matching rows
C. NULL values only
D. Primary keys

✅ Answer: B

Explanation:
INNER JOIN only returns rows with matching values in both tables.

Question 9

Which JOIN is MOST likely to return fewer rows than the original tables?

A. CROSS JOIN
B. INNER JOIN
C. LEFT JOIN
D. FULL OUTER JOIN

✅ Answer: B

Explanation:
INNER JOIN returns only matches, often reducing row count.

Question 10

Which statement best describes a FULL OUTER JOIN?

A. Returns only matching rows
B. Returns all rows from both tables, matching where possible
C. Returns only left table rows
D. Returns only right table rows

✅ Answer: B

Explanation:
FULL OUTER JOIN returns all rows from both tables, with NULLs where no match exists.

✅ Quick Exam Takeaways

For DP-900 JOINs, remember:

✔ JOIN = combine related tables
✔ INNER JOIN = only matches
✔ LEFT JOIN = all left + matches
✔ RIGHT JOIN = all right + matches
✔ CROSS JOIN = all combinations
✔ ON clause defines relationships
✔ Unmatched values become NULL

Go to the DP-900 Exam Prep Hub main page.