Database backup and geo-replication in Azure - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create an Azure SQL database with geo-replication enabled.

Azure

az sql db create --resource-group myResourceGroup --server myServer --name myDatabase --service-objective [1]

Drag options to blanks, or click blank then click option'

AS0

BGP_Gen5_2

CBasic

DPremium

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing Basic or S0 which do not support geo-replication.

Using Premium which is more expensive but not required here.

The service objective GP_Gen5_2 enables geo-replication with General Purpose tier.

2fill in blank

medium

Complete the command to create a readable secondary database in a different region for geo-replication.

Azure

az sql db replica create --name myDatabaseSecondary --resource-group myResourceGroup --server myServerSecondary --partner-server [1] --read-only-routing-url https://myserversecondary.database.windows.net

Drag options to blanks, or click blank then click option'

AmyServer

BmyServerSecondary

CmyDatabase

DmyResourceGroup

Attempts:

3 left

💡 Hint

Common Mistakes

Using the secondary server name as partner-server.

Using the database name instead of server name.

The partner-server is the primary server name, here myServer, to link the secondary replica.

3fill in blank

hard

Fix the error in the command to enable geo-backup retention for 14 days.

Azure

az sql db backup [1] --resource-group myResourceGroup --server myServer --database myDatabase --retention-days 14

Drag options to blanks, or click blank then click option'

Aset

Bconfigure

Cupdate

Dpolicy

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'set' or 'update' which are invalid in this context.

Using 'configure' which is not a valid subcommand.

The correct command is az sql db backup policy to manage backup retention policies.

4fill in blank

hard

Fill both blanks to configure geo-replication failover group with automatic failover policy and grace period.

Azure

az sql failover-group create --name myFailoverGroup --resource-group myResourceGroup --server myServerPrimary --partner-server myServerSecondary --failover-policy [1] --grace-period [2]

Drag options to blanks, or click blank then click option'

AAutomatic

BManual

C1 hour

D0 minutes

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing manual failover policy which requires manual intervention.

Setting grace period to 0 minutes which can cause immediate failover.

Automatic failover policy with a 1 hour grace period is a common best practice for geo-replication failover groups.

5fill in blank

hard

Fill all three blanks to create a geo-replication link, set backup retention to 7 days, and enable zone redundancy.

Azure

az sql db replica create --name myReplica --resource-group myResourceGroup --server myServerSecondary --partner-server [1] --backup-retention [2] --zone-redundant [3]

Drag options to blanks, or click blank then click option'

AmyServerPrimary

B7

Ctrue

Dfalse

Attempts:

3 left

💡 Hint

Common Mistakes

Using secondary server as partner-server.

Setting backup retention to 0 or invalid values.

Disabling zone redundancy when it is required.

Use the primary server as partner-server, set backup retention to 7 days, and enable zone redundancy with true.