DP-300 Certification Practice Question #55

Question

SIMULATION
 -

You need to ensure that db1 supports a minimum of one vCore, a maximum of four vCores, and a database of up to 45 GB.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Accepted Answer

The serverless compute tier in Azure SQL Database automatically scales compute resources based on workload demand. To meet the requirements of supporting a minimum of 1 vCore, a maximum of 4 vCores, and a database size of up to 45 GB, the database must be configured with the Serverless compute tier (typically under the General Purpose service tier) where Min vCores is set to 1, Max vCores is set to 4, and the Data max size (storage) is configured to 45 GB (or higher to accommodate up to 45 GB).

More DP-300 practice questions