Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 2

© examsnet.com

Question : 32 of 40

Marks: +1, -0

HOTSPOT
You have an Azure SQL database.
You run the following PowerShell script.
$ serverName = "SERVER1"
$ resourceGroup = "RG1"
$ dbName= "DB1"
Connect-AzAccount
$ server = Get-A2Sq1Server -ServerName $ serverName -ResourceGroupName
$ resourceGroup
Set-AzSq1DatabaseBackupShortTermRetentionPolicy -ResourceGroupName $ resourceGroup
-ServerName $ server '
-DatabaseName $ dbName -RetentionDays 21
Set-AzSq1DatabaseBackupLongTermRetentionPolicy -ServerName $ serverName -
DatabaseName $ dbame
-ResourceGroupName $ resourceGroup -WeeklyRetention P52W -YearlyRetention PSY
-WeekofYear 52
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point

DB1 can be restored to a specific point in time 30 days ago. ______
Yes
No
DB1 can be restored from a weekly backup performed six months ago. ______
Yes
No
DB1 can be restored from a yearly backup performed six years ago. ______
Yes
No

Go to Question:

Prev Question

Next Question