Scribd
Upload
54 views4 pages

Azure SQL Database Service Overview

The document outlines assignments from an Azure SQL course on Coursera, covering topics such as database hosting models, migration strategies, and Azure Data Services features. It includes multiple-choice and true/false questions related to Azure SQL Database, PostgreSQL, MySQL, and security measures. Key concepts include Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS), and various Azure database functionalities.

Uploaded by

glen mnx
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
54 views4 pages

Azure SQL Database Service Overview

The document outlines assignments from an Azure SQL course on Coursera, covering topics such as database hosting models, migration strategies, and Azure Data Services features. It includes multiple-choice and true/false questions related to Azure SQL Database, PostgreSQL, MySQL, and security measures. Key concepts include Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS), and various Azure database functionalities.

Uploaded by

glen mnx
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

AZURE SQL (MICROSOFT COURSERA)

A. Module 1 Assignment:
1. Question 1
Q: Hosting a database such as SQL Server on Virtual Machines is an example of which of
the following?
A: Infrastructure-as-a-Service (IaaS)

2. Question 2
Q: True or False? 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

3. Question 3
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
 Azure SQL Database

4. Question 4
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
 Automatic backups and point-in-time restore
 Scaling

5. Question 5
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 Purpose

6. Question 6
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: Azure Database for PostgreSQL

7. Question 7
Q: When migrating on-premises SQL databases to Azure, which type of migration
requires the least amount of reconfiguration?
A: SQL Server running on a virtual machine

8. Question 8
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.

9. Question 9
Q: True or False? When using Azure SQL Managed Instances all communications are
encrypted and signed using digital certificates.
A: True

10. Question 10
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: Use the Azure Database Migration Service (DMS)

B. Module 2 Assignment:

Question 1
Q: Which two of the following commands can be used to send the template to Azure?
A: New-AzResourceGroupDeployment, az deployment group create

Question 2
Q: True or False? The default connectivity for Azure relational data services is to allow
access from anywhere.
A: False
Question 3
Q: Which of the following is implemented with the connection policy of Redirect?
A: Redirect means that after establishing a connection through a gateway all subsequent
requests go directly to the database.

Question 4
Q: DoSGuard provides which two of the following features?
A: Tracks failed logins from IP addresses, Authenticates users

Question 5
Q: Connections to Azure SQL Database server communicate over what port?
A: 1433

Question 6
Q: Azure Database for PostgreSQL supports replication from the master server for a total of
how many replicas?
A: Five

Question 7
Q: Which two of the following SQL statements are logically grouped as Data Definition
Language (DDL) statements?
A: ALTER, DROP

Question 8
Q: True or False? Query editor in Azure Portal allows only Azure Active Directory password
authentication.
A: False

Question 9
Q: True or False? A primary key uniquely identifies each row, and a foreign key references
another table’s primary key.
A: True

Question 10
Q: Additional threat protection and assessment for Azure Database systems can be enabled
through which method?
A: Advanced Data Security

C. Module 3 assignment:

D. Module 4 Assignment:
E. Module 5 Assignment:

Common questions

Powered by AI

The 'lift and shift' approach facilitates database migrations to Azure by allowing applications to be moved with minimal changes, thus retaining access to existing operating system features. However, this approach may face limitations at the PaaS level where certain OS features might not be supported .

Hosting a SQL Server on virtual machines uses the Infrastructure-as-a-Service (IaaS) model. In this setup, the tenant is responsible for software installation, maintenance, and backups .

The 'Redirect' connection policy in Azure Database services is significant because it enhances performance by allowing connections to be redirected for database queries directly, bypassing initial gateways. This reduces latency and increases efficiency during operations by ensuring subsequent requests go directly to the database .

Within Azure SQL, the ALTER and DROP statements are categorized under Data Definition Language. ALTER is used to modify existing database objects, while DROP is used to delete database objects .

Azure Database for MySQL offers features such as high availability, automatic backups with point-in-time restore options, and scaling capabilities. These features collectively enable reliability and scalability, making it a robust PaaS solution for MySQL databases .

Azure Database Migration Service (DMS) plays a crucial role in transferring MySQL data from on-premises environments to Azure by facilitating a smooth and efficient data migration process. It is specifically designed to simplify database migrations to Azure data services, minimizing downtime .

Azure SQL Managed Instances enhance security by ensuring all communications are encrypted and signed using digital certificates. This encryption protects data integrity and confidentiality during transmission, providing an additional security layer to prevent unauthorized access .

Azure Database for PostgreSQL single-server offers pricing tiers such as Basic and General Purpose. The Basic tier is suitable for smaller workloads that do not require high availability, while the General Purpose tier is designed for more demanding workloads that need balanced compute and memory with performance benefits .

Advanced Data Security enhances protection for Azure Database systems by offering additional threat protection and assessment capabilities. This includes features such as vulnerability assessments and advanced threat detection mechanisms to identify and mitigate potential risks .

The Azure Portal's Query Editor supports multiple authentication methods, not limited to Azure Active Directory password authentication. This flexibility enhances user accessibility but also necessitates careful management to prevent security vulnerabilities .

You might also like