ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 6 question 29 discussion

Actual exam question from Microsoft's DP-300
Question #: 29
Topic #: 6
[All DP-300 Questions]

HOTSPOT
-

You configure backups for an Azure SQL database as shown in the following exhibit.



Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by Manuuzzz at Jan. 28, 2023, 10:03 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
HSQL
Highly Voted 2 years, 1 month ago
52 backups: Azure uses the same weekly backup for the monthly backup and year backup.
upvoted 9 times
voodoo_sh
2 months, 2 weeks ago
Agree, 52 backups
upvoted 1 times
...
dryd
2 years, 1 month ago
Agree, only 1 copy is in LTR storage: https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql
upvoted 3 times
...
amazonalex
2 years ago
agreed. ex: W=6, M=12, Y=10, WeekOfYear=20 Each weekly full backup will be kept for six weeks. Except first full backup of each month, which will be kept for 12 months. Except the full backup taken on 20th week of year, which will be kept for 10 years. https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql
upvoted 1 times
...
Ziviola
1 year, 10 months ago
Agree with 52 backups. Go to table in the link https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql
upvoted 1 times
...
...
U_C
Highly Voted 2 years ago
52-weeks + 12-month + 1 (The 52nd week) = 65
upvoted 6 times
...
bingomutant
Most Recent 6 months, 1 week ago
52 backups - Azure SQL Database Long-Term Retention (LTR) works in a way where it reuses the same backup for both weekly, monthly, and yearly LTR, so the total number of backup copies does not accumulate. The weekly backup is used for the monthly and yearly backup, which is why the correct number of backups stored would still be 52.
upvoted 1 times
...
duzee
1 year, 9 months ago
52 backups copies as the LTR policy states 52 weeks.
upvoted 2 times
...
MLCLUB
2 years, 2 months ago
The answer is correct. 52 Weekly backup + 12 Monthly backup + 1 Yearly backup
upvoted 2 times
testdumps2017
1 year, 8 months ago
nope. "W=6, M=12, Y=10, WeekOfYear=20 Each weekly full backup will be kept for six weeks. Except first full backup of each month, which will be kept for 12 months. Except the full backup taken on 20th week of year, which will be kept for 10 years." - it kinda is stupid to use two different backups for w, m, y. so it will be 52.
upvoted 2 times
...
...
Manuuzzz
2 years, 2 months ago
is PITR a long term retention? not sure that box 2 is 65
upvoted 1 times
dryd
2 years, 1 month ago
No PITR backup is not LTR backup
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago