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

I've spent most of my career working with software and cloud technologies, but at heart I'm simply someone who loves learning new things and sharing what I discover. Through this blog and my Azure 4 Everyone YouTube channel, I try to make Azure and cloud computing more approachable for developers, architects, and anyone curious about technology.