Architecting Microsoft Azure Solutions: Plan Azure SQL-Compliant Database Usage


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

This course covers SQL-compliant Azure solutions. You'll learn how to plan and deploy an Azure SQL Database deployment for high availability. This course helps to prepare for the 70-535: Architecting Microsoft Azure Solutions exam.



Expected Duration (hours)
0.9

Lesson Objectives

Architecting Microsoft Azure Solutions: Plan Azure SQL-Compliant Database Usage

  • recognize Azure SQL, MySQL and PostGRE database options
  • design a SQL Server implementation that meets business needs
  • use the portal to deploy an Azure SQL Database
  • use PowerShell to deploy an Azure SQL Database
  • use the CLI to deploy an Azure SQL Database
  • use on-premises SQL Server Management Studio to connect to Azure SQL
  • use SQL Server Management Studio on-premises to connect to Azure SQL Database
  • change Azure SQL Database geo-replication settings in the portal
  • describe how to migrate on-premises cold data to the cloud
  • configure Azure SQL Stretch Database
  • choose the appropriate backup and restore options for Azure SQL Database
  • perform an Azure SQL Database export using the portal
  • perform a restore of Azure SQL Database information
  • deploy and manage Azure SQL Database
  • Course Number:
    it_clarma_07_enus

    Expertise Level
    Intermediate