Introduction to Azure Database Administration

Question 1

Nenne die 5 ‘Intelligent Data Platform Roles’ des Azure Database Admins

Answer 1

1. Azure Data Engineer
2. Azure Data Analyst
3. Azure Data Scientist
4. Azure Artificial Intelligence Engineer
5. Azure Database Administrator

Question 2

Versions of SQL Server available

Microsoft keeps images of all supported versions of SQL Server available in Azure Marketplace. If you have a need for an older version, that is covered by an extended support contract,

What do you need to do?

Answer 2

install your own SQL Server binaries

Question 3

Nenne 2 ‘Haupt’ Backup Solutions in Azure für SQL Server

Answer 3

1. Backup to URL
2. Azure Backup

Question 4

Name the Key differences between Backup to URL. &. Azure Backup

Answer 4

1. Backup to URL = Back up to URL allows you to use standard backup syntax to back up your databases to Azure Blob Storage service,
2. Azure Backup = Azure Backup for SQL Server Virtual Machines offers a complete enterprise backup solution that automatically handles your backups across your infrastructure.

Question 5

Is a SQL Server running in an Azure virtual machine (iaaS) equivalent to an on-premises SQL Server?

Answer 5

Yes

A SQL Server running in an Azure virtual machine (IaaS) is equivalent to an on-premises SQL Server.
several features described for SQL Server on Azure virtual machine are applicable to all your on-premises SQL Servers

Question 6

Many applications will require SQL Server running on a virtual machine (iaaS)

Name 2 Reasons and describe them

Answer 6

1. General application support and incompatibility

For applications requiring an older version of SQL Server for vendor support. In addition, some application services may have a requirement to be installed with the database instance in a manner that is not compatible with a PaaS offering.

2. Use of other SQL Server Services

In order to maximize licensing, many users choose to run SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and/or SQL Server Reporting Services (SSRS) on the same machine as the database engine.

Question 7

All resources in Azure share a common provider

Name the provider

Answer 7

Azure Resource Manager
acts as a management, and deployment service for cloud services

Question 8

Aus was bestehen die ‘Azure Resource Manager templates’ die maan für das Deployment braucht?

Answer 8

JSON Documents

Question 9

Name the 4 types of storage ( Disk ) for Deployment on Virtual Machines

Answer 9

• Standard
• Standard SSD
• Premium SSD
• Ultra Disk

Question 10

Which Storage Type shuold you use For production SQL Server data and transaction log files?

Answer 10

Premium SSD storage and Ultra Disk

Question 11

Which Storage Type is enough for database Backup & Restore Workloads

Answer 11

You can use Standard storage for your database backups, as the performance is adequate for most backup and restore workloads.

Question 12

Which Fetures offers Azure to support high availability

Answer 12

Availability sets, availability zones, and load-balancing techniques that provide high availability by distributing incoming traffic among Virtual Machines.

Question 13

When does Microsoft guarantee an uptime of 99% for single Instance Azure Virtual Machine ( Storage )

Answer 13

When Using Premium SSD or Ultra Disk for ALL Disks

Question 14

Which features does Azure offer to support high Availability, name 3

Answer 14

• Availability sets
• availability Zones
• load balancing

to provide high availability by distributing incoming traffic among VM’s

Question 15

SQL Database comes in two main purchaising models: name them

Answer 15

• vCore-based
• DTU-based model

Question 16

Is Azure SQL Database PaaS or IaaS ?

Answer 16

Azure SQL Database is a Platform as a Service ( PaaS ) that provides high scalability capabilities

Question 17

Name the 3 Service Tiers available for the purchaising model ‘vCore-based-model’

Answer 17

• General Purpose
• Business Critical
• Hyperscale

Question 18

Purcahse model ( vCore-Based ) :
Explain the ServiceTier ‘ General Purpose ‘

Answer 18

• Designed for less intensive operations.
• offers budget oriented balanced compute & Storage options
• provides both, provisioned compute tier & serverless compute tier

Question 19

What is the Purchasing model [ vCore-Based ]

Answer 19

Compute and Storage resources are decoupled ( getrennt / voneinander unabhängig )
You cane scale compute and Storage resources independently.

Question 20

Purcahse model ( vCore-Based ) :
Explain the ServiceTier ‘ Business Critical ‘

Answer 20

• Supports ‘in-Memory OLTP’
• Supports built-in read-only Replica
• includes more memory perCore & uses local SSD storage
• Designed for performance-sensitive workloads

Question 21

Purcahse model ( vCore-Based ) :
Explain the ServiceTier ‘ Hyperscale ‘

Answer 21

• Hyperscale introduces horizontal scaling features, that use advanced techniques to addcompute nodes as the data sizes grow
• it is only supported on Single SQL Database
• Hyperscale allows you to scale Storage and compute resources significantly over the limits available for thegeneral Purpose and Business Critical Service tiers ( business critical tier & general Purpose Tier )

Question 22

Name the 3 available Service Tiers in the purchasing model ( DTU-based )

Answer 22

• Basic
• Standard
• Premium