DP-300 Question #399: Real Exam Question with Answer & Explanation

SIMULATION You need to prevent users from accidentally deleting db1 from the Azure portal. You may need to use SQL Server Management Studio and the Azure portal. Answer: To protect your Azure resources, you can use Resource Locks. To prevent accidental deletion of an Azure database, use the Azure portal to create a "Delete" lock on the database or its parent resources, such as the SQL server or resource group. This lock will prevent any user, including owners, from deleting the database. Step 1: Navigate to the resource: Go to the Azure portal and locate the Azure SQL database you want to protect. You can do this by searching for "SQL databases" or navigating through your resource groups. [Select db1] Step 2: Open the Locks tab: In the database's overview, locate the "Locks" tab under the "Settings" section. Step 3: Add a new lock: Click the "Add" button to create a new lock. Step 4: Configure the lock: Lock Name: Give the lock a descriptive name (e.g., "PreventDeleteLock"). Lock Type: Select "Delete". Level: Set the level to "CanNotDelete". Notes (Optional): Add any relevant notes about the lock. Step 5: Apply the lock: Click "OK" to save the lock. Reference: https://techcommunity.microsoft.com/blog/adformysql/preventing-and-recovering-from-accidental- deletion-of-an-azure-database-for-mysq/4388503