Course 1 – Introduction to Microsoft Azure Cloud Services

Module 3: Microsoft Azure Database, Analytics, & Compute Services

MICROSOFT AZURE FUNDAMENTALS AZ-900 EXAM PREP SPECIALIZATION

Complete Coursera Study Guide

Last updated:

INTRODUCTION – Microsoft Azure Database, Analytics, & Compute Services

This week, you will explore several of the database services available on Microsoft Azure, including Azure Cosmos DB, Azure SQL Database, Azure SQL Managed Instance, Azure Database for MySQL, and Azure Database for PostgreSQL. In addition to these database services, you will learn about various big data and analysis services offered by Azure. Furthermore, you will discover how to leverage Azure’s virtualization services within Azure Compute, enabling your applications to scale out quickly and efficiently to meet growing demands.

Learning Objectives

  • Describe Azure Cosmos DB
  • Describe Azure SQL Database and SQL Managed Instance
  • Describe Azure Database for MySQL and PostgreSQL
  • Explore big data and analytics
  • Explore Azure virtual machines and app services
  • Explain Azure container instances and Kubernetes services
  • Explore Azure functions and Windows virtual desktop
  • Describe the benefits and usage of Azure Data Lake Analytics
  • Describe the benefits and usage of Azure Synapse Analytics, Azure HDInsight, Azure Databricks
  • Describe the benefits and usage of Azure Database for PostgreSQL
  • Describe the benefits and usage of Azure Database for MySQL
  • Describe the benefits and usage of Azure Cosmos DB, Azure SQL Database, Azure SQL Managed Instance
  • Describe the benefits and usages of Azure Virtual Machines, Azure App Service, Azure Container Instances, Azure Kubernetes Service, Azure Functions, Windows Virtual Desktop

KNOWLEDGE CHECK 1

1. Which of the following cloud database solutions provides the capabilities of schema-less data, and lets you build highly responsive and always-on applications to support constantly changing data?

  • Azure Database for MySQL 
  • Azure Database for PostgreSQL 
  • Cosmos DB (CORRECT)
  • Azure SQL Database

Correct: Azure Cosmos DB supports schema-less data, which lets you build highly responsive and Always On applications to support constantly changing data. You can use this feature to store data that is updated and maintained by users around the world.

2. True or False?

One major benefit of using Azure Cosmos DB is the flexibility it allows developers to use the APIs they are most familiar with.

  • True (CORRECT)
  • False

Correct: Cosmos DB level of flexibility means that as you migrate your company’s databases to Azure Cosmos DB, your developers can stick with the API where they’re most comfortable.

3. True or False?

Azure Cosmos DB only supports proprietary APIs.

  • True
  • False (CORRECT)

Correct: Azure Cosmos DB supports open-source APIs and SDKs.

4. True or False?

Migration of on-premises SQL databases to Azure SQL Databases is not supported. The databases must be recreated from scratch.

  • True
  • False (CORRECT)

Correct: You can migrate your existing SQL Server databases with minimal downtime using the Azure Database Migration Service. The Azure Database Migration Service performs all the required steps. You just change the connection string in your apps.

5. Azure Database for MySQL is a relational database service in the Microsoft cloud, which is based on the MySQL Community Edition database engine. One feature of the Azure database for MySQL is support for Automatic backups and point-in-time-restore for up to how many days?

  • 15
  • 25
  • 35 (CORRECT)
  • 45

Correct: The Azure database for MySQL supports Automatic backups and point-in-time-restore for up to 35 days.

6. Microsoft Azure supports a broad range of technologies and services to provide big data and analytic solutions. Some of the most common big data and analytic service types in Azure are Azure Synapse Analytics, HDInsight, Databricks, and Data Lake Analytics. 

Which of the following provides a fully managed, open-source analytics service for enterprises that makes it easier and more cost-effective to process massive amounts of data while running popular open-source frameworks?

  • Azure HDInsight (CORRECT)
  • Azure Synapse Analytics
  • Azure Databricks
  • Azure Data Lake Analytics

Correct: Azure HDInsight is a fully managed, open-source analytics service for enterprises. It is a cloud service that makes it easier, faster, and more cost-effective to process massive amounts of data. HDInsight allows you to run popular open-source frameworks and create cluster types.

KNOWLEDGE CHECK 2

1. Azure supports a wide range of computing solutions for development and testing, running applications, and extending your data center.

When you require lightweight, virtualized application environments that can be quickly created, scaled out, and stopped dynamically, which of the following solutions is most suitable?

  • App Services
  • Virtual machine scale sets
  • Containers and Kubernetes (CORRECT)
  • Virtual machines

Correct: Azure Container Instances and Azure Kubernetes Service (AKS) are Azure compute resources that you can use to deploy and manage containers. These are lightweight, virtualized application environments that are designed to be quickly created, scaled out, and stopped dynamically. You can run multiple instances of a containerized application on a single host machine.

2. Azure supports a wide range of computing solutions for development and testing, running applications, and extending your data center.

When the demand for services targeting big compute, big data, and containerized workloads increases, one feature of Azure Compute Services is the ability to quickly deploy identical VMs. What is this feature known as?

  • Containers and Kubernetes
  • Functions
  • Virtual machines
  • Virtual machine scale sets (CORRECT)

Correct:  Virtual machine scale sets are an Azure compute resource that you can use to deploy and manage a set of identical VMs. With all VMs configured the same, virtual machine scale sets are designed to support true autoscale.

3. Azure Virtual Machines (VMs) let you create and use virtual machines in the cloud. They provide Infrastructure as a Service (IaaS) in the form of a virtualized servers and can be used in many ways. Just like a physical computer, you can customize all the software running on the VM. Who is responsible for maintaining, configuring, and updating Azure Virtual Machines (VMs)?

  • The Cloud provider
  • The Cloud Tenant (CORRECT)

Correct: An Azure VM gives you the flexibility of virtualization without having to buy and maintain the physical hardware that runs the VM. However, the cloud tenant still needs to configure, update, and maintain the software that runs on the VM.

4. What can you use to enable large-scale parallel and high-performance computing (HPC) jobs with the ability to scale to tens, hundreds, or thousands of VMs?

  • Azure Virtual Machines
  • Virtual Machine Scale Sets
  • Azure Batch (CORRECT)
  • Containers

Correct: Azure Batch enables large-scale parallel and high-performance computing (HPC) batch jobs with the ability to scale to tens, hundreds, or thousands of VMs.

5. The task of automating, managing, and interacting with a large number of containers is known as orchestration. Which of the following services allows you to manage and interact with a large number of containers?

  • Azure Container Instances (ACI)
  • Azure Kubernetes Service (AKS) (CORRECT)

Correct: The task of automating, managing, and interacting with a large number of containers is known as orchestration. Azure Kubernetes Service (AKS) is a complete orchestration service.

6. Which cloud service model allows you to run Azure Container Instances (ACI)?

  • PaaS (CORRECT)
  • IaaS
  • SaaS

Correct: Azure Container Instances offers the fastest and simplest way to run a container in Azure without having to manage any virtual machines or adopt any additional services. It is a PaaS offering that allows you to upload your containers, which it will run for you.

TEST PREP

1. Which of the following cloud database solutions provides developers with the ability to use multiple APIs that they may already be familiar with?

  • Azure SQL Database
  • Azure Database for MySQL 
  • Cosmos DB (CORRECT)
  • Azure Database for PostgreSQL 

2. Hyperscale (Citus) is a feature of which Cloud based Database solution?

  • Azure Database for MySQL 
  • Cosmos DB
  • Azure Database for PostgreSQL (CORRECT)
  • Azure SQL Database

Correct: Azure Database for PostgreSQL is a relational database service in Microsoft cloud. The server software is based on the community version of the open-source PostgreSQL database engine. Azure Database for PostgreSQL is available in two deployment options; Single Server and Hyperscale (Citus).

3. Azure Database for PostgreSQL is a relational database service in Microsoft cloud. The server software is based on the community version of the open-source PostgreSQL database engine. One feature of the Azure database for PostgreSQL is support for Automatic backups and point-in-time-restore for up to how many days?

  • 35 (CORRECT)
  • 45
  • 15
  • 25

Correct: Azure database for PostgreSQL supports Automatic backups and point-in-time-restore for up to 35 days. 

4. Azure Database for MySQL is a relational database service in the Microsoft cloud which is based on the MySQL Community Edition database engine. What level of SLA do you think is implemented?

  • 90.00%
  • 99.00%
  • 99.90%
  • 99.99% (CORRECT)

Correct: Azure Database for MySQL delivers built-in high availability with no additional cost of 99.99% SLA.

5. Azure supports a wide range of computing solutions for development and testing, running applications, and extending your data center. When you want to quickly build, deploy, and scale enterprise-grade web, mobile, and API apps running on any platform which of the following solutions is most suitable?

  • App Services (CORRECT)
  • Containers and Kubernetes
  • Virtual machine scale sets
  • Virtual machines

6. With App Services, you can quickly build, deploy, and scale enterprise-grade web, mobile, and API apps running on any platform. Who is responsible for managing the underlying platform?

  • The Cloud Tenant 
  • The Cloud provider (CORRECT)

Correct: App Services provides a managed hosting environment where developers can upload their web applications without having to worry about dealing with the physical hardware and software requirements.

7. What capabilities are built into the SQL Database that eliminates the need for Tailwind Traders to manage most of the management functions such as monitoring or upgrading?

  • Platform as a Service (CORRECT)
  • Azure Database Migration Service
  • Data storage layer

Correct: Azure SQL (sequel) Database is a platform as a service (PaaS) database engine. It handles most of the database management functions, such as upgrading, patching, backups, and monitoring, without user involvement.

8. Your team currently uses several on-premises servers running SQL Server, and would like to migrate their existing databases to a SQL database running in the cloud. However, several of their databases use Cyrillic characters for collation. Which service would be the best option in this scenario?

  • SQL Managed Instance (CORRECT)
  • Azure SQL Database
  • Azure Database Migration Service

Correct: Server-level collation in Azure SQL Managed Instance can be specified when the instance is created but cannot be changed later.

9. Your development team is interested in writing Graph-based applications that take advantage of the Gremlin API. Which option would be ideal for that scenario?

  • Azure Cosmos DB (CORRECT)
  • Azure SQL Database
  • Azure SQL Managed Instance

Correct: Azure Cosmos DB supports SQL, MongoDB, Cassandra, Tables, and Gremlin APIs.

10. Tailwind Traders has millions of log entries that it wants to analyze. Which option would be ideal for analysis?

  • Azure Synapse Analytics (CORRECT)
  • Azure Cosmos DB
  • Database for PostgreSQL

Correct: Azure Synapse Analytics is the logical choice for analyzing large volumes of data. Azure Synapse Analytics (formerly Azure SQL Data Warehouse) is a limitless analytics service that brings together enterprise data warehousing and big data analytics. 

11. In this scenario, your company want to provision Linux and Windows virtual machines with the configurations of their choice. What Azure compute service will you use for this purpose?

  • Azure App Service
  • Azure Virtual Machines (CORRECT)
  • Azure Kubernetes

Correct: Virtual Machines provides infrastructure as a service (IaaS) and can be used in different ways. If you want to provision Linux and Windows virtual machines with the configurations of your choice, you could so in seconds using Azure Virtual Machines services.

12. Your company wants to be able to manage both Docker and Microsoft-based containers.  What Azure compute services will you be able to use for this purpose? 

Select all options that apply.

  • Azure Kubernetes (AKS) (CORRECT)
  • Azure App Service
  • Azure Container Instances (ACI) (CORRECT)

Correct: Azure Kubernetes Service is a complete orchestration service for containers with distributed architectures and large volumes of containers. Orchestration is the task of automating and managing a large number of containers and how they interact.

Correct: Azure Container Instances offers the fastest and simplest way to run a container in Azure without having to manage any virtual machines or adopt any additional services. It’s a platform as a service (PaaS) offering that allows you to upload your containers, which it runs for you.

13. Tailwind Traders want to accelerate app development using an event-driven, serverless architecture. Which of the following services should be used? 

  • Azure Functions (CORRECT)
  • Azure App Service
  • Azure Container Instances (ACI)

Correct: Azure Functions is used when you need to perform work in response to an event (often via a REST request), timer, or message from another Azure service, and when that work can be completed quickly, within seconds or less.

CONCLUSION – Microsoft Azure Database, Analytics, & Compute Services

In conclusion, this week’s module provides an in-depth understanding of the diverse database services available on Microsoft Azure, such as Azure Cosmos DB, Azure SQL Database, Azure SQL Managed Instance, Azure Database for MySQL, and Azure Database for PostgreSQL.

Additionally, you have explored various big data and analysis services, gaining insights into how these can be utilized to manage and interpret large datasets effectively. Finally, by learning about Azure’s virtualization services within Azure Compute, you are now equipped to efficiently scale your applications to meet increasing demands, ensuring optimal performance and resource management.