Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 29 discussion

Actual exam question from Microsoft's DP-300

Question #: 29
Topic #: 6

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

Suggested Answer:

by Manuuzzz at Jan. 28, 2023, 10:03 a.m.

Comments

Submit Cancel

HSQL

Highly Voted 2 years, 3 months ago

52 backups: Azure uses the same weekly backup for the monthly backup and year backup.

upvoted 9 times

voodoo_sh

4 months, 2 weeks ago

Agree, 52 backups

upvoted 1 times

...

dryd

2 years, 3 months 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, 2 months 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, 11 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, 2 months ago

52-weeks + 12-month + 1 (The 52nd week) = 65

upvoted 6 times

...

bingomutant

Most Recent 8 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, 11 months ago

52 backups copies as the LTR policy states 52 weeks.

upvoted 2 times

...

MLCLUB

2 years, 4 months ago

The answer is correct. 52 Weekly backup + 12 Monthly backup + 1 Yearly backup

upvoted 2 times

testdumps2017

1 year, 10 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, 4 months ago

is PITR a long term retention? not sure that box 2 is 65

upvoted 1 times

dryd

2 years, 3 months ago

No PITR backup is not LTR backup

upvoted 1 times

...