Microsoft · DP-300
Choosing an Azure SQL offering
DP-300 · Lesson 1 of 22 · 4:12
YouTube loads only after you press play. Watch on YouTube ↗
In this lesson
Prepare for the DP-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: the Azure SQL family (SQL Server on Azure virtual machines for full control, Azure SQL Managed Instance for instance features as a managed service, and Azure SQL Database for cloud applications), the DTU and vCore purchasing models and the General Purpose, Business Critical, and Hyperscale service tiers, serverless compute and elastic pools, SQL Server enabled by Azure Arc, and SQL database in Microsoft Fabric. Includes three original practice questions.
Preview the topics
- Contoso’s prescriptions system uses SQL Server Agent jobs, cross-database queries, and Database Mail, and the team wants Microsoft to patch and back it up. Which offering fits best?
- Contoso’s loyalty app database is busy a few hours a day, idle at night, and its usage is hard to predict. The team wants to pay as little as possible for compute when nobody uses it. What should they choose?
- Contoso keeps twelve SQL Server 2014 instances in its stores, which must stay on site. The company wants a single inventory in Azure, Defender for Cloud alerts, and security updates past the end of support. What should it use?