Administering Relational Databases on Microsoft Azure (DP-300) Test 2
© examsiri.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
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. ______
- DB1 can be restored from a weekly backup performed six months ago. ______
- DB1 can be restored from a yearly backup performed six years ago. ______
Go to Question: