Module 1 - Role of Azure DBA Flashcards
What are some of the reasons to use a PaaS DB Solution
Less management required
Automated Patching
Automated Backups
More scaling options
What are some of the reasons to use an IaaS DB solution
If you need an older version of SQL Server
Use of SQL Fringe products (SSIS, SSAS, SSRS) even thought there are Azure offerings for these
Application Incompatability with PaaS (i.e. Azure SQL DB cannot use Cross DB Queries
No additional services can be colocated with PaaS
Which has the easier migration path, IaaS or PaaS?
IaaS
What does the SQL IaaS extension allow for?
SQL Automated Backups
SQL Automated Patching
Azure KeyVault Intergration
Viewing of SQL Config and Storage Info via the Azure Portal
What features have been developed to support the use of Azure whilst running SQL on a VM
Backup to URL - use of the SQL backup syntax to backup to Azure Storage
Azure Backup for SQL VMs - Complete enterprise backup solution to automatically handle backups across your infrastructure
Azure Resource Manager (ARM) allows for the management and deployment of Azure Resources, how are ARM templates stored
ARM Templates are stored as JSON files
What does the use of ARM templates allow
Deploying full set of resources in a single declarative template
Include Parameters to supply values at the time of deployment
Build dependencies into the template
What options do you have to carry out the deployment of an ARM template
Azure DevOps Pipe line
Custom Deployment via the Azure Portal
Azure is a Fault Tolerant and Quick Recovery platform however, what is the requirement of a single VM to have an uptime of 99.9%
A single VM with PREMIUM STORAGE has a 99.9% uptime SLA
Azure SQL Managed Instance allows an easy migration path - what feature makes this so
Allowing restores from On-Prem backups
Azure SQL MI Provides a SQL instance allowing how many DBs
Up to 100DBs + System databases
List some of the other features of Azure SQL MI that Azure SQL DB does not have
Allows Cross DB Queries
Allows access to the CLR (Common Language Runtime)
Allows SQL Agent jobs and the use of the Sys DB MSDB
What levels of offerings does azure SQL MI have
General Purpose
Business Critical
What are the advantages of using Azure SQL MI in Business critical as opposed to General Purpose
Business Critical allows:
In-Memory OLTP,
Readable Secondaries
as well as more memory per core and direct attached storage (as opposed to network attached storage)
How can you reduce you PaaS Licensing costs and what are the specifics of this
Using existing SQL licences with PaaS Reduces cost
1x Enterprise Core License = 1vCore of Azure SQL PaaS at Business critical OR 8vCores at General Purpose
1x Standard Core Licence allows 1vCore of General Purpose
This can reduce costs up to 40% and cause you only to pay for storage and compute costs