Month: May 2026

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.

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, DP-900, Microsoft Certification May 10, 2026

Practice Questions: Describe normalization and why it is used (DP-900 Exam Prep)

Practice Questions

Question 1

What is the primary purpose of normalization in a relational database?

A. Increase data duplication
B. Improve query speed for analytics
C. Reduce data redundancy and improve integrity
D. Store unstructured data

✅ Answer: C

Explanation:
Normalization reduces duplicate data and improves consistency and integrity.

Question 2

Which issue is MOST likely to occur in a non-normalized table?

A. Faster query performance
B. Data redundancy
C. Reduced storage requirements
D. Simpler queries

✅ Answer: B

Explanation:
Without normalization, the same data is often stored multiple times.

Question 3

A database stores customer details repeatedly in every order record. What problem does normalization solve in this scenario?

A. Improves indexing
B. Reduces redundancy
C. Enhances encryption
D. Increases data size

✅ Answer: B

Explanation:
Normalization separates customer data into its own table to avoid duplication.

Question 4

Which anomaly occurs when updating the same data in multiple rows leads to inconsistent values?

A. Insert anomaly
B. Delete anomaly
C. Update anomaly
D. Query anomaly

✅ Answer: C

Explanation:
Update anomalies happen when duplicate data is not consistently updated.

Question 5

Which approach is commonly used in normalized database design?

A. Storing all data in a single table
B. Splitting data into related tables
C. Removing all relationships between data
D. Using only unstructured formats

✅ Answer: B

Explanation:
Normalization divides data into multiple related tables.

Question 6

Which statement best describes First Normal Form (1NF)?

A. Data must be encrypted
B. Tables must include foreign keys
C. Each column contains atomic (single) values
D. Tables must be denormalized

✅ Answer: C

Explanation:
1NF requires that each field contains indivisible values and no repeating groups.

Question 7

What is a trade-off of normalization?

A. Increased data redundancy
B. Simpler queries with no joins
C. More complex queries due to joins
D. Reduced data integrity

✅ Answer: C

Explanation:
Normalized databases often require joins, making queries more complex.

Question 8

Which type of workload benefits MOST from normalized data?

A. Analytical workloads
B. Transactional workloads
C. Streaming workloads
D. Machine learning workloads

✅ Answer: B

Explanation:
Transactional systems prioritize data integrity, which normalization supports.

Question 9

Which action is an example of normalization?

A. Combining multiple tables into one
B. Storing duplicate data for faster reads
C. Separating customer and order data into different tables
D. Removing relationships between tables

✅ Answer: C

Explanation:
Normalization separates data into logical entities and links them via keys.

Question 10

Why might a system choose denormalization instead of normalization?

A. To improve data integrity
B. To reduce redundancy
C. To improve read performance for analytics
D. To enforce strict schemas

✅ Answer: C

Explanation:
Denormalization is often used in analytical systems to improve query performance.

✅ Quick Exam Takeaways

For DP-900, remember:

✔ Normalization = reduce redundancy + improve integrity
✔ Involves splitting data into related tables
✔ Prevents:

Insert anomalies
Update anomalies
Delete anomalies

✔ Used primarily in transactional (OLTP) systems
✔ Trade-off = more joins / more complex queries
✔ Opposite concept = denormalization (used in analytics)

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, 2026May 10, 2026

Describe responsibilities for Database Administrators (DBAs) (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 administrators

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.

Database administrators (DBAs) play a critical role in ensuring that data systems are secure, available, performant, and reliable. For the DP-900 exam, you should understand what DBAs are responsible for and how their role fits into the broader data ecosystem.

What Is a Database Administrator (DBA)?

A Database Administrator (DBA) is responsible for managing and maintaining databases to ensure they operate efficiently, securely, and reliably.

DBAs work closely with:

Developers
Data engineers
Security teams
Business stakeholders

Their role focuses on the operational health of databases, rather than building analytics or models.

Core Responsibilities of a DBA

1. Database Installation and Configuration

DBAs are responsible for:

Installing database management systems (DBMS)
Configuring database settings
Setting up environments (development, testing, production)

In cloud environments like Azure, much of this is automated, but DBAs still configure:

Compute tiers
Storage options
Networking and access settings

2. Performance Monitoring and Optimization

Ensuring that databases run efficiently is a key DBA responsibility.

This includes:

Monitoring query performance
Identifying slow or inefficient queries
Creating and managing indexes
Optimizing database configurations

Goal: Maintain fast query response times and efficient resource usage.

3. Backup and Recovery

DBAs ensure data can be recovered in case of failure.

Responsibilities include:

Configuring automated backups
Managing backup schedules
Testing restore processes
Planning for disaster recovery

In Azure, services like Azure SQL Database provide automated backups, but DBAs are still responsible for:

Retention policies
Recovery strategies

4. Security Management

DBAs are responsible for protecting data from unauthorized access.

This includes:

Managing user accounts and roles
Assigning permissions (read, write, admin access)
Implementing authentication and authorization
Enabling encryption (at rest and in transit)

Security is a major focus area in DP-900.

5. High Availability and Disaster Recovery (HA/DR)

DBAs ensure databases remain available even during failures.

Tasks include:

Configuring replication
Setting up failover mechanisms
Monitoring system uptime
Planning redundancy strategies

In Azure, many HA features are built-in, but DBAs still configure and monitor them.

6. Data Integrity and Consistency

DBAs enforce rules to ensure data remains accurate and reliable.

This includes:

Defining constraints (PRIMARY KEY, FOREIGN KEY, NOT NULL)
Ensuring ACID compliance
Preventing data corruption

This is especially important in transactional systems.

7. Monitoring and Troubleshooting

DBAs continuously monitor database health and resolve issues such as:

Performance bottlenecks
Failed queries
Resource constraints
Connectivity issues

They use monitoring tools, logs, and alerts to maintain system stability.

8. Automation and Maintenance

DBAs automate routine tasks to improve efficiency:

Index maintenance
Statistics updates
Scheduled jobs
Patch management

In cloud environments, some tasks are automated, but DBAs still oversee and validate them.

DBA Responsibilities in Azure

In Azure, the DBA role shifts slightly due to Platform as a Service (PaaS) offerings:

What Azure Manages

Hardware
OS updates
Basic backups
High availability infrastructure

What DBAs Still Manage

Security and access control
Query performance
Data modeling support
Backup policies and restore strategies
Monitoring and tuning

This is often called the shared responsibility model.

DBA vs Other Data Roles

Understanding how DBAs differ from other roles is important for DP-900:

Role	Focus
DBA	Database management, performance, security
Data Engineer	Data pipelines, data movement
Data Analyst	Reporting and visualization
Data Scientist	Machine learning and advanced analytics

Why DBA Responsibilities Matter for DP-900

On the exam, you may be asked to:

Identify which tasks belong to a DBA
Distinguish DBA responsibilities from other roles
Understand how Azure simplifies some DBA tasks
Recognize responsibilities related to security, performance, and availability

Summary — Exam-Relevant Takeaways

✔ DBAs manage the health, security, and performance of databases
✔ Key responsibilities include:

Performance tuning
Backup and recovery
Security management
Monitoring and troubleshooting
High availability and disaster recovery

✔ In Azure, many tasks are automated, but DBAs still handle:

Configuration
Optimization
Access control

✔ DBAs focus on operational database management, not analytics or modeling

Go to the Practice Exam Questions for this topic.

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.