Skills Learned
- Describe the benefits and usage of Cosmos DB, Azure SQL Database, Azure Database for MySQL, Azure Database for PostgreSQL, and SQL Managed Instance
Study Guide
Expand your knowledge - extra resources

Practice Test

Question 2

Which services in Azure allow for storing of strctured data.

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Cosmos DB

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL Database

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL Managed Instance

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Database for MySQL

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Database for PostgreSQL

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL Datawarehouse

❌ ✔ ⚪ 🔵 ⬜ 🟦 All of the above

❌ ✔ ⚪ 🔵 ⬜ 🟦 All of the above except for Cosmos DB

✔ That's correct

❌ That's not correct

👨‍🦱 💬 All services on this list except for Cosmos DB are part of Azure SQL family of products. Azure SQL is a PaaS offering where all of the services are built with scalable structured data storage capabilities.

Question 3

Constoso company wants to migrate existing SQL Server workloads to Azure. During the assessment they found out that they need a fully fledged SQL server with all of the capabilities. Contoso also wants to minimize the management requirements. Which service should they choose?

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Cosmos DB

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL Database

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL Managed Instance

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL for VM

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Database for MySQL

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Database for PostgreSQL

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL Datawarehouse

✔ That's correct

❌ That's not correct

👨‍🦱 💬 Azure SQL Managed Instance and SQL for VM both provide fully fledged SQL server. But SQL Managed Instance is a PaaS where as SQL for VM is IaaS, so to minimize management Contoso should use SQL Managed Instance

Question 5

Which of the following services allow customers to store semi-structured datasets in Azure.

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Cosmos DB

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL Database

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL for VM

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Table Storage

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Blob Storage

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure File Storage

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure Content Delivery Network (CDN)

❌ ✔ ⚪ 🔵 ⬜ 🟦 Azure SQL Datawarehouse

✔ That's correct

❌ That's not correct

👨‍🦱 💬 Azure Table Storage and Cosmos DB are both semi-structured (NoSQL) database services in Azure.

◀ Previous Episode Next Episode ▶

Adam Marczak

Programmer, architect, trainer, blogger, evangelist are just a few of my titles. What I really am, is a passionate technology enthusiast. I take great pleasure in learning new technologies and finding ways in which this can aid people every day. My latest passion is running an Azure 4 Everyone YouTube channel, where I show that Azure really is for everyone!