Quick Answer
The answer is point-in-time restore (PITR). This feature is correct because it enables you to recover an Azure SQL Managed Instance to any precise moment within its retention period—defaulting to 7 days and configurable up to 35—allowing you to reverse a user error, such as an accidental deletion or data modification, within the required 15-minute window. PITR works by leveraging automated backups to create a new database restored to the exact second just before the mistake occurred, making it the ideal solution for user error recovery scenarios. On the DP-900 exam, this question tests your understanding of Azure SQL’s backup and restore capabilities, often appearing as a scenario where you must distinguish PITR from features like geo-restore or long-term retention. A common trap is confusing PITR with failover groups, but remember: PITR is about going back in time, not switching locations. Memory tip: “PITR puts you back in the pit of time before the error.”
This DP-900 practice question tests your understanding of identify considerations for relational data on azure. This is a configuration task: choose the command set that satisfies every stated requirement. Small differences — like 'secret' vs 'password' or 'transport input ssh' vs 'all' — change whether the answer is correct. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A financial services company runs a critical application on Azure SQL Managed Instance. They need to ensure that a recent transaction can be recovered within 15 minutes of a user error. Which feature should they configure?
Geo-restore
Why wrong: For recovery from regional disasters, not user errors.
Point-in-time restore (PITR)
Restores to a specific time, ideal for recovering from user errors.
Automatic failover groups
Why wrong: For high availability, not recovery from logical errors.
Long-term retention (LTR)
Why wrong: Used for archival backups, not for recent point-in-time recovery.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Point-in-time restore (PITR)
Point-in-time restore (PITR) is the correct feature because it allows you to restore an Azure SQL Managed Instance to a specific point in time within the retention period (default 7 days, configurable up to 35 days). This directly addresses the requirement to recover a recent transaction after a user error, such as an accidental data modification or deletion, within 15 minutes. PITR creates a new database from automated backups, enabling precise recovery to the moment just before the error occurred.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Geo-restore
Why it's wrong here
For recovery from regional disasters, not user errors.
Point-in-time restore (PITR)
Why this is correct
Restores to a specific time, ideal for recovering from user errors.
Related concept
Read the scenario before looking for a memorised answer.
Automatic failover groups
Why it's wrong here
For high availability, not recovery from logical errors.
Long-term retention (LTR)
Why it's wrong here
Used for archival backups, not for recent point-in-time recovery.
Common exam traps
The trap here is that candidates confuse disaster recovery features (Geo-restore, failover groups) with data recovery features (PITR), assuming any backup-related option can recover from a user error, but only PITR provides the granular, time-specific restore needed for transactional errors.
Detailed technical explanation
Azure SQL Managed Instance uses automated full, differential, and transaction log backups. PITR leverages these log backups to replay transactions up to a specified timestamp, allowing recovery to any point within the retention window. The recovery time objective (RTO) depends on the size of the database and the number of log backups to apply, but for a recent transaction, the restore can often complete within minutes if the log chain is intact. A common real-world scenario is an accidental DELETE or UPDATE statement; PITR can restore the database to a time just before that statement executed, minimizing data loss.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Identify considerations for relational data on Azure — study guide chapter
Learn the concepts, then practise the questions
Identify considerations for relational data on Azure practice questions
Targeted practice on this topic area only
All DP-900 questions
982 questions across all exam domains
Microsoft Azure Data Fundamentals DP-900 study guide
Full concept coverage aligned to exam objectives
DP-900 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise DP-900 questions linked to Describe core data concepts.
Practise DP-900 questions linked to Describe an analytics workload on Azure.
Practise DP-900 questions linked to Identify considerations for relational data on Azure.
Practise DP-900 questions linked to Describe considerations for working with non-relational data on Azure.
Practise DP-900 questions linked to DP-900 fundamentals.
Practise DP-900 questions linked to DP-900 scenario.
Practise DP-900 questions linked to DP-900 troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Identify considerations for relational data on Azure — This question tests Identify considerations for relational data on Azure — Read the scenario before looking for a memorised answer..
The correct answer is: Point-in-time restore (PITR) — Point-in-time restore (PITR) is the correct feature because it allows you to restore an Azure SQL Managed Instance to a specific point in time within the retention period (default 7 days, configurable up to 35 days). This directly addresses the requirement to recover a recent transaction after a user error, such as an accidental data modification or deletion, within 15 minutes. PITR creates a new database from automated backups, enabling precise recovery to the moment just before the error occurred.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 24, 2026
This DP-900 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-900 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.