Module 1+2+3+4 Flashcards

1
Q

What are the 2 types of IaaS licensing model, + explain

A

Pay as you go - SQL Licence included with machine cost

Bring your Own Licence - apply an existing license which must be reported by licence mobility verification in 10 days.

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

How are VM resources split up based on workload type

A

VMs Split into family types with different sizes within each family

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

At a high level how can HA be achieved when using IaaS

A

HA built into Azure Platform + additonal features specfic to SQL Server which can be used

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

What are Availability Zones and what do they do

A

a region
Each zone made up of one or more DCs with its own power, cooling, network.
Provides HA against data center failure when multiple VMs deployed to different zones
VM eco system can be spread across 3 zones in region
Increases Uptime SLA to 4-9s 99.99%

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

What are availabily sets and what do they do?

When should you use and when should you not use?

A

Similar to Availabilty zones yet do not spread workload over different data centers instead spreading across different servers and racks within a data center
Use Availability Sets to Spread AOAG workloads across different physical hardware
Use when Region doesn’t allow availability zones OR when an app cannot tolerate interzone latency

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

How many replicas can you implement SQL AOAG over

A

2 - 9

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

Where can you implement AOAG

A

Onprem or IaaS

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

What process does AOAG use to send TXs

A

TXs committed to primary then sent to sync or async replicas.
Sync ensures Tx is commtied to one or more secondaries before application can continue

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

Q
What dictates the availability mode to choose with AOAG

A

Physical distance of servers (i.e. latency involved)

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

What availability mode should you use in AOAG if workload requires lowest latency and/or nodes are far apart

A

Async

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

What availability mode should you use in AOAG if workload can withstand some latency or nodes are close together

A

Sync

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

What does an AOAG provide

A

HA and DR as single AOAG can support both sync and async modes

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

What is the unit of failover in an AOAG

A

The availability group of Databases (i.e. not the instance)

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

What (and where) does a SQL FCI protect

A

An entire instance with HA in a single region

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

How could you build DR into a FCI

A

By combining with AOAG or log shipping as DR not part of FCI

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

What does SQL FCI require

A

Shared Storage (either in Azure Shared File storage or Using storage spaces direct on Windows Server)

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

Is AOAG or FCI preferred for new Azure Deployments - and why

A

AOAG as no complexity or shared storage

18
Q

Why might you need to build a SQL FCI in Azure

A

For on-prem migrations requiring the use of FCI for App Support

19
Q

DR is still required in Azure, what methods are there for DR

A

Azure Platform Options (Geo-Replicated Storage and Azure Site Recovery)
SQL Offered Solutions like AOAG and Backups

20
Q

On a VM how can you control backups and where can you backup to

A

You have granular control and can backup to the IaaS disk or to Azure Blob Storage

21
Q

What is the Azure option to use Geo-Redundant Storage or Read-Access geo-Redundant Storage

A

So you can ensure your backups are stpred safely across geographic landscape

22
Q

What does the Azure SQL VM provider allow you to do for your backups

A

Allows SQL backups to be managed by the platform

23
Q

Give the headlines on Azure Backup for SQL Server

A

Requires Agent on VM that communicates with the Azure Service.
Provides central location to monitor backups to ensure meeting any specified RPO/RTO metrics
Comprehensive enterprise backup solution providing - Longterm backup rentention, Auto management and Added data protection
However there is an additional cost

24
Q

How can Availability Groups help with SQL Server on IaaS aside from HA

A

Can be used for DR as well as HA
Implement replicas and stretch this further with Distributed AOAGs
Ensures viable copy of data is at another location from the primary to protect against Human and Natural disasters

25
Q

Give the Headlines on Azure Site Recovery when thinking of SQL on IaaS

A

Low cost, providing block level replication of your VM.
Offers test and verify ability for DR strategy
Best utilized for stateless environment s as opposed to Transactional VMs
Relatively high RPO/RTO

26
Q

Define the Azure Market place

A

Central location to create Azure resource via a template

27
Q

What is the preferred storage type for SQL IaaS , what are is the SLA and Limit of this

A

Most cases use Azure Managed Disks (except FCI)
99.999% Availability
50,000 disks per instance

28
Q

What Disk types are there in IaaS

A

Standard HDD
Standard SSD
Premium SSD
Ultra Disk

29
Q

What are the best practices for storage on SQL IaaS

A

Use Premium Disks, pooled for best IOPS and storage capacity
Put data files in own pool with read caching
Log file get no benefit from read caching
Add TempDB on D:\ Drive

30
Q

What latency should you get when using Premium SSD and what should you do if you need better performance

A

When configured correctly Premium SSD will see single digit Ms latency - if need better performance utilise Ultra Disk

31
Q

What does PowerShell and CLI do for deployments

A

Powershell allows for programatical deployment with granular control over attributes
CLI is more simplistic and can achieve the same result with less code

32
Q

Give the headlines for ARM templates

A

Deploy full set of resources in a single declarative template
Parse in parameters at time of deployment
Deploy via Azure DevOps Pipeline or Custom Deployment in Portal
Export ARM Templates in JSON format

33
Q

What is often the first type of service used when migrating from on-prem

A

IaaS

34
Q

What does the Azure Migrate Server tool do?

A

Provides a central location to assess and migrate on-prem resources.

35
Q

What types of servers (physical, virtual) can the Azure Migrate Server tool discover and assess.

A

Both physical and virtual (either VMWare or Hyper V)

36
Q

What budget type info does the Azure Migrate Server tool provide

A

Suggests VM Sizes and estimates cost

37
Q

What is the infrastructure of the Azure Migrate Server Tool?

A

loud based application that has a lightweight agent deployed on prem which reports back to the cloud tool

38
Q

What is the MAP toolkit

A

Microsoft Assessment and Planning Toolkit

39
Q

What does the Map toolkit do

A

Gathers inventory of SQL Servers on network (Version and Server info) and reports on it’s findings.

40
Q
A