Working with relational data on Azure (25% - 30%)

Question 1

What is PaaS?

Answer 1

PaaS (Platform as a Service) is a cloud model where the service provider handles infrastructure for you, letting you focus on developing your application.

Question 2

What are the three main Azure SQL offerings?

Answer 2

Azure SQL Managed Instance, Azure SQL Database and SQL Server for Azure Virtual Machines.

Question 3

What is SaaS?

Answer 3

SaaS (Software as a Service) is a cloud model where the service provider provides pay-as-you-go software solutions, allowing you to focus on creating and managing your data/content.

Question 4

What is IaaS?

Answer 4

IaaS (Infrastructure as a Service) is a cloud model that lets you provision compute resources as you need them.

Question 5

What is Azure Synapse Analytics?

Answer 5

Azure Synapse Analytics is an enterprise data warehouse and big data analytics service.

Question 6

What are the three open-source relational database engines Azure offers as a service?

Answer 6

PostgreSQL, MySQL and MariaDB.

Question 7

What is a table?

Answer 7

A logical grouping of rows and columns.

Question 8

What is a view?

Answer 8

A virtual (in-memory) table that contains the result of a query.

Question 9

What is a materialised view?

Answer 9

A view where the result of a query is stored in an actual (on-disk) table.

Question 10

What is an index?

Answer 10

A data structure that improves database read speed at the cost of storage.

Question 11

What is a constraint?

Answer 11

A rule applied to writes that can preserve data integrity.

Question 12

What is a trigger?

Answer 12

A stored procedure that runs when a specific database event occurs.

Question 13

What is a primary key?

Answer 13

A primary key (PK) indicates the column (or combination of columns) that uniquely identify each row. Every table should have a primary key.

Question 14

What is a foreign key?

Answer 14

A foreign key (FK) references, or links to, the primary key of another table and is used to maintain the relationships between tables.

Question 15

What is a clustered index?

Answer 15

An clustered index physically reorganises a table by an index key for further improved read performance.

Question 16

What is a RDBMS?

Answer 16

Relational database management system.

Question 17

What is a stored procedure?

Answer 17

A block of code that runs inside a database.

Question 18

When would you use Azure SQL Database Managed Instance?

Answer 18

When you want to lift-and-shift an on-premise SQL server to the cloud without the overhead of managing SQL server on a virtual machine.

Question 19

When would you use Azure SQL Database?

Answer 19

When you want to minimise the overhead of managing SQL servers and/or you don’t need all the features of SQL Server.

Question 20

When would you use SQL Server on Azure Virtual Machines?

Answer 20

When you want to lift-and-shift an on-premise SQL server to the cloud and you already have the IT staff to manage the SQL server or/and you need complete control of the server and its underlying systems.

Question 21

What is DML?

Answer 21

Data Manipulation Language (DML) is one of five logical groups of SQL statements. It is used to manipulate the rows in a relational table.

Question 22

What are the four major DML statements?

Answer 22

SELECT, INSERT, UPDATE and DELETE.

Question 23

What is DDL?

Answer 23

Data Definition Language (DDL) is one of five logical groups of SQL statements. It is used to create, modify and remove tables and other objects (views, stored procedures, etc) in a database.

Question 24

What are the four major DDL statements?

Answer 24

CREATE, DROP, ALTER and RENAME.