Azure SQL DB

Question 1

What is Azure SQL Database?

Answer 1

Azure SQL Database is a general-purpose relational database, provided as a managed service

Question 2

What are the 3 different types of purchasing models?

Answer 2

1. vCore-based purchasing model
2. DTU-based purchasing model
3. Serverless Model

Question 3

What are the 3 different deployment options for Azure SQL DB?

Answer 3

1. Single Database
2. Managed Instance
3. Elastic Pool

Question 4

What is an Azure SQL Database, Single Database

Answer 4

Single database represents a fully managed, isolated database. You might use this option if you have modern cloud applications and microservices that need a single reliable data source. A single database is similar to a contained database in Microsoft SQL Server Database Engine.

Question 5

What is an Azure SQL Database, Managed Instance

Answer 5

Managed instance is a fully managed instance of the Microsoft SQL Server Database Engine. It contains a set of databases that can be used together. Use this option for easy migration of on-premises SQL Server databases to the Azure cloud, and for applications that need to use the database features that SQL Server Database Engine provides.

Question 6

What is an Azure SQL Database, Elastic Pool

Answer 6

Elastic pool is a collection of single databases with a shared set of resources, such as CPU or memory. Single databases can be moved into and out of an elastic pool.

Question 7

What’s the difference between dynamic scalability and autoscale?

Answer 7

Autoscale is when a service scales automatically based on criteria, whereas dynamic scalability allows for manual scaling without downtime. All deployment models allow for dynamic scalabililty. Using scripts you can help monitor and scale databases.

Question 8

Describe the vCore-baed purchasing model

Answer 8

The vCore-based purchasing model lets you choose the number of vCores, the amount of memory and the amount and speed of storage. The vCore-based purchasing model also allows you to use Azure Hybrid Benefit.

Question 9

Describe the DTU-based purchasing model

Answer 9

The DTU-based purchasing model offers a blend of compute, memory, and I/O resources in three service tiers, to support light to heavy database workloads. Compute sizes within each tier provide a different mix of these resources, to which you can add additional storage resources

Question 10

Describe the serverless purchasing model

Answer 10

The serverless model automatically scales compute based on workload demand, and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed, and automatically resumes databases when activity returns.

Question 11

What are the 3 different service tiers

Answer 11

1. General Purpose / Standard
2. Business Critical / Premium
3. Hyperscale

Question 12

Describe the General Purpose / Standard service tier

Answer 12

The general purpose / standard service tier is designed for common workloads. It offers budget-oriented balanced compute and storage options

Question 13

Describe the Business Critical / Premium service tier

Answer 13

The business critical / premium service tier is designed for OLTP applications with high transaction rate and lowest-latency I/O. It offers the highest resilience to failures by using several isolated replicas

Question 14

Describe the Hyperscale service tier

Answer 14

The hyperscale service tier is designed for very large OLTP databases and the ability to auto-scale storage and scale compute fluidly.