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

Question

SIMULATION You need to configure db1 to pause automatically after one hour of inactivity. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal. Answer: Azure SQL elastic pool pausing feature Aan elastic pool vCore provisioned server can be paused. You can do this by changing the compute tier of the elastic pool to Serverless. In the serverless compute tier, the database is automatically paused when it is inactive for a period of time that you specify. The database is automatically resumed when the next login or other activity occurs. Part 1: Change to the serverless compute tier To change the compute tier of an elastic pool, you can follow these steps: Step 1: Go to the Azure portal and sign in to your account. Step 2: Select the Azure SQL resource that contains the elastic pool. Step 3: In the left navigation menu, select Elastic Pools. Step 4: Select the elastic pool that you want to change the compute tier for. Step 5: In the Settings section, select Compute Tier. Step 6: Select Serverless. Step 7: Click Save. Part 2: Configure the Auto-pause setting. Step 1: Select db1. Once you have changed the compute tier to serverless, the database will be paused after the idle time that you specified. You can view the idle time in the Auto-pause delay setting. Step 2: Open database settings. Step 3: Change the Auto-pause delay setting to 1 hour. Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

Options

• taskConfigure db1 to pause automatically after one hour of inactivity.
• prerequisitesAzure portal access