Course 2 Microsoft Azure SQL Flashcards
Azure SQL Database deployment is available with several options.
Elastic Pool and Single Database and Managed Instance Deployments
A deployment where part of the operation runs on-premises and part in the cloud>
Hybrid Deployment
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?
Managed Instance Deployment
Azure Database for MariaDB is a PaaS implementation of the MariaDB management system. Features supported in the Azure Database for MariaDB?
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
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
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.
Azure SQL Database is commonly used for?
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.
Databases are managed using a database management system (DBMS). The DBMS handles which of the following aspects of a database?
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.
Hosting a database such as SQL Server on Virtual Machines is an example of which of the following?
IaaS
Hosting SQL Server on Virtual Machines is an example of the IaaS cloud model.
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.
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.
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?
PostgreSQL, MySQL, and MariaDB.
Azure Database for MySQL is a PaaS implementation of MySQL. Which of the following features are supported in Azure Database for MySQL.
High availability, Scaling, Automatic backups and point-in-time restore
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
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.
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?
SQL server running on a virtual machine
When running a SQL Server on a virtual machine, which of the following is the responsibility of the Tenant?
Software installation and maintenance, as well as backups, are the responsibility of the tenant.
T or F When using Azure SQL Managed Instances all communications are encrypted and signed using digital certificates.
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.