Course 2 Microsoft Azure SQL Flashcards

1
Q

Azure SQL Database deployment is available with several options.

A

Elastic Pool and Single Database and Managed Instance Deployments

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A deployment where part of the operation runs on-premises and part in the cloud>

A

Hybrid Deployment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Azure SQL Database deployment options can restrict some of the administrative features available to SQL Server. Name of the deployment that allows the most adm. control?

A

Managed Instance Deployment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Azure Database for MariaDB is a PaaS implementation of the MariaDB management system. Features supported in the Azure Database for MariaDB?

A

Easy scaling and high availability

NOTE: You get the following features with Azure Database for MariaDB High availability. Easy scaling that responds quickly to demand. Secure data, both at rest and in motion. Automatic backups and point-in-time restore for the last 35 days

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

T or F Using Azure Data Services for your database management system provides the same features as an on-premises SQL Server database management system

A

False
Correct
Not all features of a database management system are available in Azure Data Services. This is because Azure Data Services takes on the task of managing the system and keeping it running using hardware situated in an Azure datacenter.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Azure SQL Database is commonly used for?

A

Applications that require high availability.
AND
Modern cloud applications that need to use the latest stable SQL Server features.
**Azure SQL Database is often used for Modern cloud applications that need to use the latest stable SQL Server features and also applications that require high availability.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Databases are managed using a database management system (DBMS). The DBMS handles which of the following aspects of a database?

A

Where and how data is stored AND Who can access the data.
The DBMS handles the physical aspects of a database, such as where and how it’s stored, who can access it, and how to ensure that it’s available when required.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Hosting a database such as SQL Server on Virtual Machines is an example of which of the following?

A

IaaS
Hosting SQL Server on Virtual Machines is an example of the IaaS cloud model.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

T or F The term lift and shift refers to database migrations and applications which require access to operating system features that might not be supported at the PaaS level.

A

TRUE
**For migrations and applications requiring access to operating system, there are features that might not be supported at the PaaS level. SQL virtual machines are lift and shift ready for existing applications that require fast migration to the cloud with minimal changes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Azure Data Services are available for a range of popular SQL-based database solutions. Which of the following database management systems are supported as a service in Azure?

A

PostgreSQL, MySQL, and MariaDB.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Azure Database for MySQL is a PaaS implementation of MySQL. Which of the following features are supported in Azure Database for MySQL.

A

High availability, Scaling, Automatic backups and point-in-time restore

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Azure Database for PostgreSQL single-server deployment option comes in three pricing tiers. Which of the following tiers are available for Azure Database for PostgreSQL

A

Basic, General and Memory Optimized

**The single-server deployment option for PostgreSQL provides similar benefits as Azure Database for MySQL. You choose from three pricing tiers: Basic, General Purpose, and Memory Optimized. Each tier supports different numbers of CPUs, memory, and storage sizes—you select one based on the load you expect to support.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Deployment of the Hyperscale (Citus) option which scales queries across multiple server nodes to support large database loads is a deployment option for which Azure Database service?

A

SQL server running on a virtual machine

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

When running a SQL Server on a virtual machine, which of the following is the responsibility of the Tenant?

A

Software installation and maintenance, as well as backups, are the responsibility of the tenant.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

T or F When using Azure SQL Managed Instances all communications are encrypted and signed using digital certificates.

A

TRUE:
When using Azure SQL Managed instances all communications are encrypted and signed using certificates. To check the trustworthiness of communicating parties, managed instances constantly verify these certificates through certificate revocation lists. If the certificates are revoked, the managed instance closes the connections to protect the data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

You are running a MySQL database on-premises and want to move the data to a database running the corresponding data services in Azure. What is the best way to transfer the data?

A

Azure Database Migration Service (DMS)