Microsoft · AZ-305
Relational data
AZ-305 · Lesson 5 of 13 · 34:48
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the AZ-305 exam (Microsoft Azure Solutions Architect Expert). In this lesson: designing relational data: choosing between Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs, the vCore and DTU purchasing models, General Purpose, Business Critical and Hyperscale, serverless compute and elastic pools, scaling up, read scale-out and sharding, and data protection with transparent data encryption, Always Encrypted, dynamic data masking, row-level security and auditing. Includes three original practice questions.
Preview the topics
- A SaaS vendor hosts two hundred customer databases, each idle most of the day, with unpredictable peaks. Which design keeps costs lowest?
- A reporting dashboard slows down an order database in the Business Critical tier. The company wants the lowest extra cost, and minimal changes. What should the architect recommend?
- Card numbers must stay encrypted inside the database, and even database administrators must never see clear values. Only the payment application may decrypt them. Which feature fits?