02 - Explore Relational Data in Azure

Question 1

Azure Data Services

Answer 1

SQL

MySQL

Seal - Maria DB Server

Elephant - Postgres

Question 2

SQL Server on Azure

Answer 2

SQL Server on Azure Virtual Machines

Azure SQL Managed Instances

Azure SQL Database

Question 3

SQL Server on Virtual Maachines

Answer 3

IaaS solution that enables users to use full versions of SQL Server in the Could without having to manage any on-prem hardware

• Guaranteed compatibility to SQL Server on premises
• Customer manages everything - OS upgrades, software upgrades, backups, replication
• Pay for the server and licensing, not per database

Question 4

Azure SQL Database

Answer 4

PaaS offering where users create a managed database server in the cloud and then deploy the databases on the server

• Low-cost option with minimal administration
• Best for new cloud projects with flexible application design
• Supports system with variable loads - scale up and down quickly without restarting

Single Database

Elastic Pool

Question 5

Single Database

Answer 5

Create and run a DB server in the cloud and access the DB through the server

Question 6

Elastic Pool

Answer 6

Multiple DB share the same resources, such as memory, storage, and processing power

Question 7

Azure SQL Managed Instance

Answer 7

Allows you to pre-provision compute resources and deploy several individual managed instances up to your pre-provisioned compute level

Single Instance

Instance Pool

Question 8

Single Instance

Answer 8

One SQL Server instance, multiple databases

Question 9

Instance Pool

Answer 9

Multiple instances share the same resource

Question 10

Azure Database for PostgreSQL

Answer 10

Relational database service in MS cloud based on PostgreSQL Community Edition database engine

Question 11

Azure Database for MySQL

Answer 11

PaaS implementation of MySQL in Azure cloud, based on the MySQL Community Edition

Question 12

Azure Database for MariaDB

Answer 12

Implementation of MariaDB database management system adapted to run on Azure. Based on MariaDB Community Edition

Question 13

Policy of Redirect

Answer 13

First establish connection to database

All subsequent requests go to that database

Question 14

Policy of Proxy

Answer 14

Establish connection to Azure SQL database via gateway

Question 15

Read Replicas

Answer 15

Help improve performance and scale of read-intensive workloads such as BI and analytics

Useful when delays in synching data between primary and replicas are acceptable

Question 16

SQL

Answer 16

Standard language for use with relational databases

Question 17

SQL Statement Types

Answer 17

DML - Data Manipulation Language. Query and Manipulate.

DDL - Data Definition Language. Define DB Objects

DCL - Data Control Language. Manage security permissions

Question 18

Query relational data in Azure Database for PostgreSQL

Answer 18

Azure Cloud Shell

Azure Data Studio

Question 19

MySQL Workbench

Answer 19

Query a Database