Creating Azure SQL Database - Quick Revision & Summary

Recall & Review

beginner

What is an Azure SQL Database?

Azure SQL Database is a cloud-based service that provides a managed relational database. It lets you store and access data without managing the underlying hardware or software.

beginner

What is a resource group in Azure?

A resource group is like a folder in Azure that holds related resources such as databases, servers, and apps. It helps organize and manage resources together.

beginner

Why do you need a server when creating an Azure SQL Database?

The server acts as a container for your database. It manages security, access, and connection settings for your Azure SQL Database.

beginner

What is the purpose of choosing a pricing tier when creating an Azure SQL Database?

The pricing tier determines the performance, storage size, and cost of your database. You pick one based on how much power and space your app needs.

beginner

How do you connect to an Azure SQL Database after creation?

You connect using a connection string that includes the server name, database name, username, and password. This string is used by apps to access the database.

What is the first step when creating an Azure SQL Database?

A Create a web app

B Create a virtual machine

C Create a storage account

D Create a resource group

You start by creating a resource group to organize your database and related resources.

Which component acts as a container for your Azure SQL Database?

A Server

B Resource group

C Storage account

D Virtual network

The server holds your database and manages access and security.

What does the pricing tier affect in an Azure SQL Database?

A Database color theme

B Performance and storage size

C Number of users allowed

D Type of programming language

Pricing tier sets the performance level and storage capacity of the database.

How do applications connect to an Azure SQL Database?

A Using a web browser only

B Using a USB drive

C Using a connection string

D Using a virtual machine

Applications use a connection string with server and login details to connect.

Which of these is NOT required to create an Azure SQL Database?

A Virtual machine

B Server

C Pricing tier

D Resource group

A virtual machine is not needed to create an Azure SQL Database.

Explain the main steps to create an Azure SQL Database.

Think about organizing resources, setting up the server, and picking performance options.

Describe how an application connects to an Azure SQL Database after it is created.

Connection strings hold all the info apps need to reach the database.