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 20 discussion

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

HOTSPOT -
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:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: No -
Short term retention is set to 21 days.
Note: Short term retention policy is used to address point-in-time restores whereas a long-term retention policy is used to address restores from long-term or older backups for various audit and compliance purposes. We can also save these backup files as part of a short-term retention policy for up to 7-35 days.

Box 2: Yes -
Weekly retention is set to P52W, which stands for a periodic frequency of 52 weeks (364 days).

Note: -WeeklyRetention -
The Weekly Retention. If just a number is passed instead of an ISO 8601 string, days will be assumed as the units. There is a minimum of 7 days and a maximum of 10 years.

Box 3: No -
Yearly retention is set to PSY.

Note: -YearlyRetention -
The Yearly Retention. If just a number is passed instead of an ISO 8601 string, days will be assumed as the units. There is a minimum of 7 days and a maximum of 10 years.
Reference:
https://strata.opengamma.io/apidocs/com/opengamma/strata/basics/schedule/Frequency.html https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackupshorttermretentionpolicy?view=azps-7.2.0 https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackuplongtermretentionpolicy?view=azps-7.2.0
by eric0718 at May 1, 2022, 11:32 p.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
jackdong
Highly Voted 1 year, 8 months ago
The PSY should be P5Y
upvoted 12 times
voodoo_sh
2 months, 2 weeks ago
Agree. Answer: No, Yes, No
upvoted 1 times
...
...
OBIJUAN88
Most Recent 12 months ago
Answers given are correct. As mentioned by jackdong PSY should be P5Y. Examples: # create LTR policy with WeeklyRetention = 12 weeks. MonthlyRetention and YearlyRetention = 0 by default. Set-AzSqlDatabaseBackupLongTermRetentionPolicy -ServerName $serverName -DatabaseName $dbName ` -ResourceGroupName $resourceGroup -WeeklyRetention P12W # create LTR policy with WeeklyRetention = 12 weeks, YearlyRetention = 5 years and WeekOfYear = 16 (week of April 15). MonthlyRetention = 0 by default. Set-AzSqlDatabaseBackupLongTermRetentionPolicy -ServerName $serverName -DatabaseName $dbName ` -ResourceGroupName $resourceGroup -WeeklyRetention P12W -YearlyRetention P5Y -WeekOfYear 16 https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql&tabs=powershell
upvoted 3 times
...
alexatl
1 year, 3 months ago
not seeing valid reference
upvoted 1 times
...
Alibaba143
1 year, 3 months ago
What is "PSY" ?
upvoted 2 times
igorclapa
7 months, 1 week ago
Should be "P5Y" which means 5-year retention in the context of question asked
upvoted 1 times
...
...
infblondi
1 year, 6 months ago
Reference page is not found
upvoted 1 times
...
eric0718
1 year, 11 months ago
Answer is correct
upvoted 3 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