DP-300 Certification Practice Question #228

Question

You have an Azure SQL database.
You run the following PowerShell script.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

The script configures Short Term Retention (PITR) to 21 days, meaning point-in-time restores are only available within a 21-day window. This makes the first statement "No" since 30 days exceeds this limit. Long Term Retention (LTR) is configured with a weekly retention of 52 weeks (`P52W`), so a weekly backup from 6 months ago is preserved, making the second statement "Yes". The yearly retention parameter contains a typo (`PSY` instead of `P5Y`), but even if corrected to 5 years, a yearly backup from 6 years ago exceeds this retention limit and is unavailable, making the third statement "No".

More DP-300 practice questions