Drag a concept onto its matching description — or click a concept then click the description.
Concepts
Matches
Complete copy of the database
Changes since the last full backup
All log records since the last log backup
DP-300 Practice Question: Monitor, configure, and optimize database resources
Match each Azure SQL Database backup type to its description.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Full backup: Contains all data in the database.
These are the three types of backups used for point-in-time restore in Azure SQL Database.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Full backup: Contains all data in the database.
Why this is correct
A full backup is the baseline backup that includes the entire database.
- ✓
Differential backup: Contains all changes since the last full backup.
Why this is correct
A differential backup captures all data modifications since the last full backup.
- ✓
Transaction log backup: Contains all committed transactions since the last transaction log backup.
Why this is correct
Transaction log backups record individual transactions for point-in-time recovery.
- ✗
Full backup: Contains only changes since the last full backup.
Why it's wrong here
Incorrect — this describes a differential backup, not a full backup.
- ✗
Differential backup: Contains all committed transactions since the last full backup.
Why it's wrong here
Incorrect — differential backups contain data changes, not individual transactions; that is the role of transaction log backups.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
Key term
Azure SQL Database Backup
Azure SQL Database Backup is a fully managed, automated service that creates and stores copies of your SQL database data and transaction logs in Azure storage, enabling point-in-time recovery and long-term retention for data protection and business continuity.
About these practice questions
Courseiva writes every DP-300 question from scratch — 906 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.