DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ35

Configure and manage automation of tasks

You have an Azure subscription containing a resource group named RG1. RG1 includes a SQL Server on Azure Virtual Machines instance named SQ1.

You need to enable and configure automated patching for SQ1 by using PowerShell. The solution must include both SQL Server and Windows security updates.

How should you complete the command?

Select
$AutoPatchingConfig = New-AzVMSqlServerAutoPatchingConfig -Enable

-DayOfWeek "Sunday" -MaintenanceWindowStartingHour 2

-MaintenanceWindowDuration 120 -PatchCategory "Important"

Get-AzVM -ResourceGroupName "RG1" -Name "SQ1" |



-AutoPatchingSettings $AutoPatchingConfig | Update-AzVM

-SQLManagementType
Explanation

Set-AzVMSqlServerExtension applies SQL IaaS Agent extension settings, including -AutoPatchingSettings, to the VM. SQL IaaS Agent extension management type Full enables the full feature set, including automated patching of SQL Server and Windows updates; Lightweight does not support automated patching.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!