Tag: Microsoft Certification

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.

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

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

Practice Questions

Question 1

Which SQL statement is used to retrieve data from a database?

A. INSERT
B. SELECT
C. UPDATE
D. DELETE

✅ Answer: B

Explanation:
The SELECT statement is used to query and retrieve data from tables.

Question 2

Which SQL statement adds new rows to a table?

A. INSERT
B. CREATE
C. ALTER
D. SELECT

✅ Answer: A

Explanation:
INSERT is used to add new records to a table.

Question 3

Which SQL statement modifies existing data in a table?

A. UPDATE
B. DELETE
C. SELECT
D. DROP

✅ Answer: A

Explanation:
UPDATE changes existing values in one or more rows.

Question 4

Which SQL statement removes rows from a table?

A. DROP
B. DELETE
C. ALTER
D. TRUNCATE

✅ Answer: B

Explanation:
DELETE removes specific rows based on a condition.

Question 5

Which SQL statement creates a new table?

A. ALTER
B. CREATE
C. INSERT
D. SELECT

✅ Answer: B

Explanation:
CREATE is used to define new database objects such as tables.

Question 6

Which clause is used to filter rows in a SQL query?

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

✅ Answer: C

Explanation:
WHERE filters rows based on conditions.

Question 7

Which SQL clause is used to sort query results?

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

✅ Answer: A

Explanation:
ORDER BY sorts results in ascending or descending order.

Question 8

Which SQL statement permanently removes a table and its structure?

A. DELETE
B. DROP
C. REMOVE
D. CLEAR

✅ Answer: B

Explanation:
DROP deletes the table and its structure completely.

Question 9

Which SQL operation is used to combine data from two related tables?

A. GROUP BY
B. JOIN
C. UNION
D. FILTER

✅ Answer: B

Explanation:
JOIN combines rows from multiple tables based on related columns.

Question 10

Which category of SQL statements is used to define or modify database structures?

A. DML
B. DQL
C. DDL
D. DCL

✅ Answer: C

Explanation:
DDL (Data Definition Language) includes CREATE, ALTER, and DROP.

✅ Quick Exam Takeaways

For DP-900, remember:

✔ SELECT → retrieve data
✔ INSERT → add data
✔ UPDATE → modify data
✔ DELETE → remove data
✔ CREATE / ALTER / DROP → manage structure
✔ WHERE → filter results
✔ ORDER BY → sort results
✔ JOIN → combine tables
✔ SQL categories: DDL, DML, DQL

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

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

Describe normalization and why it is used (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
      --> Describe normalization and why it is used

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.

Normalization is a foundational concept in relational database design. For the DP-900 exam, you are expected to understand what normalization is, why it is important, and how it improves data quality and efficiency.

What Is Normalization?

Normalization is the process of organizing data in a relational database to:

Reduce data redundancy (duplicate data)
Improve data integrity
Ensure logical data relationships

This is done by splitting data into multiple related tables and defining relationships between them using keys.

Why Normalization Is Used

Normalization is used to solve common data problems in poorly designed tables.

1. Reduce Data Redundancy

Without normalization, the same data may be repeated across multiple rows.

Example (Unnormalized Table):

OrderID	CustomerName	CustomerCity	Product
1	John	Seattle	Laptop
2	John	Seattle	Mouse

Here, customer information is duplicated.

After Normalization:

Customers Table

CustomerID	Name	City
1	John	Seattle

Orders Table

OrderID	CustomerID	Product
1	1	Laptop
2	1	Mouse

Now, customer data is stored once and referenced using a key.

2. Improve Data Integrity

Normalization ensures that data remains accurate and consistent.

Without normalization:

Updating a customer’s city requires changing multiple rows
Missing one update leads to inconsistent data

With normalization:

Data is updated in one place only
Consistency is maintained automatically

3. Prevent Data Anomalies

Normalization helps prevent common issues:

Insert anomaly: Cannot add data without unrelated data
Update anomaly: Inconsistent updates across rows
Delete anomaly: Deleting one record removes important data

Normalized designs eliminate these problems.

4. Improve Data Organization

Normalized databases:

Clearly separate different entities (customers, orders, products)
Use relationships to connect data logically
Make databases easier to maintain and scale

Understanding Normal Forms (Simplified for DP-900)

Normalization is often described in stages called normal forms. For DP-900, you only need a basic understanding:

First Normal Form (1NF)

No repeating groups or multi-valued fields
Each column contains atomic (single) values

Second Normal Form (2NF)

Meets 1NF
All non-key columns depend on the entire primary key

Third Normal Form (3NF)

Meets 2NF
No dependency between non-key columns

💡 DP-900 Tip:
You do NOT need to memorize formal definitions — just understand that normalization reduces redundancy and improves integrity.

Trade-Offs of Normalization

While normalization has many benefits, there are trade-offs:

Advantages

✔ Reduces duplicate data
✔ Improves consistency
✔ Simplifies updates
✔ Enhances data integrity

Disadvantages

✖ Requires more tables
✖ Queries may require joins
✖ Can slightly impact performance for complex queries

Normalization vs Denormalization

Understanding this comparison is important for the exam:

Feature	Normalization	Denormalization
Data Redundancy	Reduced	Increased
Data Integrity	High	Lower
Query Complexity	Higher (joins required)	Lower
Performance	Slower for reads	Faster for analytics
Use Case	Transactional systems (OLTP)	Analytical systems (OLAP)

Where Normalization Is Used in Azure

Normalization is commonly applied in relational database services such as:

Azure SQL Database
Azure Database for PostgreSQL
Azure Database for MySQL

These services are typically used for transactional workloads, where data integrity is critical.

Why This Matters for DP-900

On the exam, you may be asked to:

Identify why normalization is used
Recognize normalized vs unnormalized structures
Understand how normalization affects data integrity
Distinguish normalization from denormalization

Summary — Exam-Relevant Takeaways

✔ Normalization organizes data into multiple related tables
✔ It reduces data redundancy
✔ It improves data integrity and consistency
✔ It prevents insert, update, and delete anomalies
✔ It is commonly used in transactional (OLTP) systems
✔ It may require joins when querying data

Go to the Practice Exam Questions for this topic.

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

Data Modeling, Databases, DP-900, Microsoft Certification, SQL May 10, 2026

Identify features of relational data (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 features of relational data

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 data is one of the most fundamental concepts in data management and a core focus area for the DP-900 exam. Understanding how relational data is structured, stored, and accessed will help you confidently answer questions related to databases, querying, and Azure data services.

What Is Relational Data?

Relational data is data that is organized into tables (relations) consisting of:

Rows (records)
Columns (attributes or fields)

Each table represents a specific entity, such as customers, orders, or products. Relationships between tables are defined using keys.

Core Features of Relational Data

1. Tabular Structure (Rows and Columns)

Relational data is stored in a structured, tabular format:

Each row represents a single record
Each column represents a specific attribute

Example:

CustomerID	Name	City
1	John	Seattle
2	Maria	Austin

This structure makes relational data easy to query and understand.

2. Predefined Schema

Relational databases enforce a fixed schema, which defines:

Table structure
Column names
Data types (e.g., INT, VARCHAR, DATE)

This ensures:

Data consistency
Data validation
Predictable structure

3. Use of Keys

Keys are essential for uniquely identifying records and linking tables.

Primary Key

Uniquely identifies each row in a table
Cannot contain duplicate or null values

Example: CustomerID

Foreign Key

Links one table to another
Establishes relationships between tables

Example: Order.CustomerID → Customer.CustomerID

4. Relationships Between Tables

Relational data supports relationships such as:

One-to-One
One-to-Many
Many-to-Many

Example:

One customer can have many orders (one-to-many)

These relationships allow complex data models to be built efficiently.

5. Structured Query Language (SQL)

Relational data is accessed and manipulated using Structured Query Language (SQL).

SQL is used to:

Query data (SELECT)
Insert data (INSERT)
Update data (UPDATE)
Delete data (DELETE)

Example:

SELECT Name FROM Customers WHERE City = 'Seattle';

6. Data Integrity and Constraints

Relational databases enforce data integrity through constraints such as:

PRIMARY KEY
FOREIGN KEY
NOT NULL
UNIQUE
CHECK

These rules ensure that:

Data is accurate
Relationships remain valid
Invalid data is prevented

7. Normalization

Relational data is often normalized to reduce redundancy and improve consistency.

Normalization involves:

Splitting data into multiple related tables
Eliminating duplicate data
Ensuring dependencies are logical

Example:

Instead of storing customer details in every order row, store them in a separate Customers table.

8. ACID Transactions

Relational databases support ACID properties, ensuring reliable transactions:

Atomicity → All or nothing
Consistency → Valid state maintained
Isolation → Transactions don’t interfere
Durability → Changes persist

This is especially important for transactional workloads.

Relational Data in Azure

Azure provides several services for working with relational data:

Azure SQL Database

Fully managed relational database
Supports SQL queries
High availability and scalability
Ideal for OLTP applications

Azure Database for PostgreSQL

Managed open-source relational database
Supports PostgreSQL features and extensions

Azure Database for MySQL

Managed MySQL database service
Suitable for web and application workloads

These services support structured data, relationships, and SQL-based querying.

Why This Matters for DP-900

On the exam, you may be asked to:

Identify characteristics of relational data
Recognize table-based structures
Understand keys and relationships
Distinguish relational data from non-relational data
Match relational workloads to Azure services

Summary — Exam-Relevant Takeaways

✔ Relational data is stored in tables (rows and columns)
✔ It uses a fixed schema with defined data types
✔ Primary and foreign keys define relationships
✔ Data is accessed using SQL
✔ Supports data integrity constraints
✔ Often normalized to reduce redundancy
✔ Ensures reliability with ACID transactions

✔ Common Azure services:

Azure SQL Database
Azure Database for PostgreSQL
Azure Database for MySQL

Go to the Practice Exam Questions for this topic.

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

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

Practice Questions: Identify features of relational data (DP-900 Exam Prep)

Practice Questions

Question 1

Which structure is used to store relational data?

A. Key-value pairs
B. Graph nodes and edges
C. Tables with rows and columns
D. JSON documents

✅ Answer: C

Explanation:
Relational data is organized in tables consisting of rows and columns.

Question 2

What is the purpose of a primary key in a relational table?

A. To link tables together
B. To uniquely identify each row
C. To store duplicate values
D. To define column data types

✅ Answer: B

Explanation:
A primary key uniquely identifies each record and cannot contain duplicates or null values.

Question 3

Which element is used to create relationships between tables?

A. Index
B. Column constraint
C. Foreign key
D. Schema

✅ Answer: C

Explanation:
A foreign key links one table to another by referencing a primary key.

Question 4

Which statement best describes a schema in a relational database?

A. A collection of unstructured files
B. A visual report of data
C. The structure defining tables, columns, and data types
D. A backup of the database

✅ Answer: C

Explanation:
A schema defines how data is structured, including tables, columns, and data types.

Question 5

Which language is used to query relational databases?

A. Python
B. JSON
C. SQL
D. HTML

✅ Answer: C

Explanation:
Structured Query Language (SQL) is used to query and manage relational data.

Question 6

Which constraint ensures that a column cannot contain null values?

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

✅ Answer: C

Explanation:
The NOT NULL constraint ensures that a value must be provided for that column.

Question 7

Which concept reduces data redundancy by organizing data into multiple related tables?

A. Indexing
B. Normalization
C. Partitioning
D. Replication

✅ Answer: B

Explanation:
Normalization reduces redundancy and improves data integrity.

Question 8

Which type of relationship allows one record in a table to relate to many records in another table?

A. One-to-one
B. One-to-many
C. Many-to-one
D. Many-to-many

✅ Answer: B

Explanation:
One-to-many relationships are common in relational databases (e.g., one customer → many orders).

Question 9

Which property ensures that all parts of a transaction succeed or fail together?

A. Consistency
B. Isolation
C. Atomicity
D. Durability

✅ Answer: C

Explanation:
Atomicity ensures transactions are completed fully or not at all.

Question 10

Which Azure service is specifically designed for relational data?

A. Azure Blob Storage
B. Azure Cosmos DB
C. Azure SQL Database
D. Azure Data Lake Storage

✅ Answer: C

Explanation:
Azure SQL Database is a fully managed relational database service.

✅ Quick Exam Takeaways

For DP-900, remember:

✔ Relational data = tables (rows + columns)
✔ Schema defines structure
✔ Primary keys uniquely identify rows
✔ Foreign keys create relationships
✔ Use SQL for querying
✔ Constraints enforce data integrity
✔ Normalization reduces redundancy
✔ Supports ACID transactions

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

DP-900, Microsoft Certification May 10, 2026

Practice Questions: Describe responsibilities for Database Administrators (DBAs) (DP-900 Exam Prep)

Practice Questions

Question 1

Which task is a primary responsibility of a database administrator (DBA)?

A. Creating machine learning models
B. Designing data visualizations
C. Managing database security and access
D. Writing business reports

✅ Answer: C

Explanation:
DBAs are responsible for security, access control, and permissions within databases.

Question 2

Which activity is most closely associated with database performance tuning?

A. Creating dashboards
B. Optimizing queries and indexes
C. Cleaning raw data files
D. Training AI models

✅ Answer: B

Explanation:
DBAs improve performance by analyzing queries and managing indexes.

Question 3

Who is primarily responsible for configuring database backups and ensuring data can be restored?

A. Data Analyst
B. Data Scientist
C. Database Administrator
D. Business User

✅ Answer: C

Explanation:
DBAs handle backup and recovery strategies to protect data.

Question 4

Which responsibility ensures that a database remains available during system failures?

A. Data transformation
B. High availability and disaster recovery planning
C. Data visualization
D. Schema design for analytics

✅ Answer: B

Explanation:
DBAs configure failover, replication, and disaster recovery solutions.

Question 5

A DBA creates user roles and assigns permissions to control access to data.

What area of responsibility does this represent?

A. Performance optimization
B. Data modeling
C. Security management
D. Data ingestion

✅ Answer: C

Explanation:
Managing roles and permissions is part of database security.

Question 6

Which task is typically handled by a DBA in an Azure environment?

A. Maintaining physical server hardware
B. Configuring database access and monitoring performance
C. Building dashboards in Power BI
D. Writing ETL pipelines

✅ Answer: B

Explanation:
In Azure, Microsoft manages infrastructure, while DBAs focus on configuration, performance, and access control.

Question 7

Which of the following is part of ensuring data integrity?

A. Creating visual reports
B. Defining primary and foreign keys
C. Running batch analytics queries
D. Exporting data to CSV files

✅ Answer: B

Explanation:
DBAs enforce data integrity using constraints like primary and foreign keys.

Question 8

Which task is LEAST likely to be performed by a DBA?

A. Monitoring database performance
B. Configuring backups
C. Building machine learning models
D. Managing user permissions

✅ Answer: C

Explanation:
Machine learning is typically handled by data scientists, not DBAs.

Question 9

A database experiences slow query performance. What is the DBA’s most appropriate action?

A. Create a dashboard
B. Increase data volume
C. Analyze and optimize queries or indexes
D. Delete historical data

✅ Answer: C

Explanation:
DBAs troubleshoot performance issues by optimizing queries and indexes.

Question 10

Which concept describes the division of responsibilities between Azure and the DBA?

A. Data normalization
B. Shared responsibility model
C. Data pipeline architecture
D. Schema-on-read

✅ Answer: B

Explanation:
In Azure, Microsoft manages infrastructure, while DBAs manage data, access, and performance — this is the shared responsibility model.

✅ Quick Exam Takeaways

For DP-900, remember DBAs are responsible for:

✔ Security (users, roles, permissions)
✔ Performance (query tuning, indexing)
✔ Backup & recovery
✔ High availability & disaster recovery
✔ Monitoring & troubleshooting
✔ Data integrity

And in Azure:

✔ Microsoft manages infrastructure
✔ DBAs manage configuration, access, and optimization

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

Data Engineering, DP-900, Microsoft Certification May 10, 2026May 10, 2026

Describe responsibilities for data engineers (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:
Describe core data concepts (25–30%)
   --> Identify roles and responsibilities for data workloads
      --> Describe responsibilities for database engineers

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.

Data engineers play a foundational role in modern data ecosystems. They are responsible for designing, building, and maintaining data systems and pipelines that enable organizations to collect, store, and process data for analysis.

For the DP-900 exam, you should understand what data engineers do, how they differ from other roles, and how their work supports analytics and business intelligence.

What Is a Data Engineer?

A data engineer is responsible for:

Designing and building data pipelines
Integrating data from multiple sources
Transforming raw data into usable formats
Ensuring data is available, reliable, and scalable

They act as the bridge between raw data sources and analytics systems.

Core Responsibilities of a Data Engineer

1. Data Ingestion

Data engineers collect data from various sources, such as:

Transactional databases
Application logs
IoT devices
External APIs

They design processes to ingest data into storage systems like data lakes or data warehouses.

This can be:

Batch ingestion (scheduled loads)
Streaming ingestion (real-time data flow)

2. Data Transformation and Processing

Raw data is often messy and inconsistent. Data engineers:

Clean and validate data
Transform it into structured formats
Aggregate and enrich datasets

This process is often referred to as ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform).

3. Building Data Pipelines

Data engineers design and maintain data pipelines, which automate the movement and transformation of data.

Pipelines typically include:

Data ingestion
Data transformation
Data storage
Data delivery to analytics tools

Pipelines must be:

Reliable
Scalable
Efficient

4. Managing Data Storage Solutions

Data engineers choose and manage appropriate storage systems based on use cases:

Data lakes for raw and large-scale data
Data warehouses for structured analytical data
Databases for operational data

They ensure data is stored in formats optimized for processing (e.g., Parquet).

5. Ensuring Data Quality

Data engineers are responsible for maintaining high-quality data by:

Validating data accuracy
Handling missing or inconsistent data
Implementing data validation rules

High-quality data is essential for reliable analytics.

6. Optimizing Data Performance

To ensure efficient data processing, data engineers:

Optimize data pipelines
Choose efficient file formats (e.g., columnar formats)
Partition and index data where appropriate

This improves performance for downstream analytics.

7. Supporting Analytical Workloads

Data engineers prepare data for:

Data analysts
Data scientists
Business intelligence tools

They ensure that curated datasets are:

Clean
Structured
Easy to query

8. Monitoring and Maintaining Data Systems

Data engineers monitor pipelines and systems to ensure:

Data is processed successfully
Failures are detected and resolved
Systems remain scalable and reliable

They often use logging, alerts, and monitoring tools.

Data Engineer Responsibilities in Azure

Azure provides a wide range of services that data engineers use:

Data Ingestion & Integration

Azure Data Factory → Orchestrates ETL/ELT pipelines
Azure Event Hubs → Handles streaming data ingestion

Data Storage

Azure Data Lake Storage Gen2 → Scalable storage for raw and processed data
Azure Blob Storage → General-purpose object storage

Data Processing

Azure Databricks → Apache Spark-based data processing
Azure Synapse Analytics → Unified analytics platform

Data Transformation & Orchestration

Pipeline orchestration using Data Factory or Synapse pipelines
Batch and streaming transformations

Data Engineer vs Other Roles

Understanding role distinctions is important for DP-900:

Role	Primary Focus
Data Engineer	Build pipelines, manage data flow
DBA	Manage database performance and security
Data Analyst	Analyze data and create reports
Data Scientist	Build predictive models and ML solutions

Why This Matters for DP-900

On the exam, you may be asked to:

Identify tasks performed by data engineers
Distinguish data engineers from DBAs or analysts
Recognize tools and services used in data engineering
Understand how data pipelines support analytics

Summary — Exam-Relevant Takeaways

✔ Data engineers build and manage data pipelines
✔ They handle data ingestion, transformation, and storage
✔ They ensure data quality, reliability, and scalability
✔ They support analytical workloads by preparing clean datasets
✔ In Azure, they commonly use:

Azure Data Factory
Azure Data Lake Storage
Azure Databricks
Azure Synapse Analytics

✔ They act as the bridge between raw data and insights

Go to the Practice Exam Questions for this topic.

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

Data Analysis, DP-900, Microsoft Certification May 10, 2026

Practice Questions: Describe responsibilities for data analysts (DP-900 Exam Prep)

Practice Questions

Question 1

Which task is a primary responsibility of a data analyst?

A. Building data pipelines
B. Managing database security
C. Creating dashboards and reports
D. Configuring storage systems

✅ Answer: C

Explanation:
Data analysts focus on visualizing data and creating reports/dashboards.

Question 2

A company wants to understand sales trends over the past year using visual reports.

Which role is MOST appropriate?

A. Data Engineer
B. Database Administrator
C. Data Analyst
D. Network Engineer

✅ Answer: C

Explanation:
Data analysts analyze historical data and create insights through reports and dashboards.

Question 3

Which tool is most commonly used by data analysts in Azure environments?

A. Azure Data Factory
B. Azure DevOps
C. Power BI
D. Azure Kubernetes Service

✅ Answer: C

Explanation:
Power BI is the primary tool for data visualization and reporting.

Question 4

Which activity is MOST associated with a data analyst?

A. Designing ETL pipelines
B. Writing SQL queries to explore data
C. Managing server infrastructure
D. Encrypting databases

✅ Answer: B

Explanation:
Data analysts commonly use SQL to query and analyze data.

Question 5

What is the main goal of a data analyst?

A. Store large volumes of raw data
B. Build machine learning models
C. Turn data into actionable insights
D. Manage database performance

✅ Answer: C

Explanation:
Data analysts focus on interpreting data and generating insights for decision-making.

Question 6

Which task is LEAST likely to be performed by a data analyst?

A. Creating a sales dashboard
B. Identifying trends in data
C. Building data ingestion pipelines
D. Summarizing business performance

✅ Answer: C

Explanation:
Building pipelines is a data engineer responsibility, not an analyst task.

Question 7

A data analyst receives cleaned and structured data from a data warehouse. What is their PRIMARY focus?

A. Data ingestion
B. Data transformation
C. Data visualization and analysis
D. Database administration

✅ Answer: C

Explanation:
Analysts work with prepared data to analyze and visualize insights.

Question 8

Which statement best describes the role of a data analyst?

A. They design physical database servers
B. They create and maintain ETL pipelines
C. They analyze data to support business decisions
D. They manage user permissions in databases

✅ Answer: C

Explanation:
Data analysts focus on interpreting data and supporting decision-making.

Question 9

Which Azure service is MOST directly associated with data analyst reporting?

A. Azure Data Lake Storage
B. Azure Synapse Analytics (SQL querying)
C. Azure Virtual Machines
D. Azure Key Vault

✅ Answer: B

Explanation:
Data analysts often query and analyze data using Azure Synapse Analytics.

Question 10

Which activity involves communicating insights from data to business stakeholders?

A. Data encryption
B. Data visualization and reporting
C. Database replication
D. Network configuration

✅ Answer: B

Explanation:
Data analysts communicate findings through visualizations, dashboards, and reports.

✅ Key Exam Takeaways

For DP-900, remember:

✔ Data analysts focus on analysis, visualization, and reporting
✔ They work with cleaned, structured data
✔ They commonly use Power BI and SQL
✔ Their goal is to support business decision-making
✔ They do NOT typically build pipelines or manage databases

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