1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Exam Prep 70-533: Implementing Microsoft Azure Infrastructure Solutions

Implement Azure SQL Databases

Contents

keyboard_tab
Overview of the course
1
Course Intro
PREVIEW53s
2
Course Overview
PREVIEW1m 42s
play-arrow
Start course
Overview
DifficultyIntermediate
Duration56m
Students798

Description

Exam Prep 70-533: Implementing Microsoft Azure Infrastructure Solutions

The purpose of this course is to help prepare you for the Microsoft Azure 70-533 Exam. This course focuses on key points that are meant to fill in the learning gaps for those who already have a base foundational knowledge of Microsoft Azure.

What You'll Learn in this Exam Prep 70-533

Lesson What you'll learn
Overview of the Course Overview of the course and the Learning Objectives
About the 70-533 Exam Learn about the exam, its objectives, and certification paths
Design and Implement Azure App Service Apps Discuss App Service Plans and Web Apps
Create and Manage ARM Virtual Machines Understand ARM VMs, pricing, resiliency and configuration limits
Design and Implement a Storage Strategy Learn to Implement Azure Storage, SQL Databases, and Recovery Services
Implement an Azure Active Directory Discuss Azure AD, tools, App integration, and monitoring
Implement Virtual Networks Learn about Azure networking and cross-site connectivity
Design and Deploy ARM Templates Learn about ARM Templates and Deployment options
Summary Course summary including Exam Tips and Tricks

 

Transcript

Azure SQL DB is a PaaS service that takes care of much of the work of managing a SQL database for you. Pricing plans have built-in security, fault tolerance, scaling and data protection. You have 4 pricing tiers Basic, Standard, Premium and Premium RS. Services like SQL Backup is available in all tiers. The Basic service tier has a backup of 7 days while the Standard and Premium tiers have a backup of 35 days. But of course you have the option of long-term Backups which can last up to 10 years.

Other features are available such as Point-In-Time Restore which we’ll talk about in a bit, Geo-Redundant Replicas for reading and backup and rolling application upgrades. Without these plans you would have to buy or design, build, and manage all these features yourself which of course is still available if you want to take an IaaS VM, install SQL Server and do it all yourself.

Many companies moving to the cloud often have the task of migrating their on-premises SQL DB to Azure SQL DB. This process involves prepping the DB using the Data Migration Assistant, exporting the BACPAC file and Importing the BACPAC file into Azure SQL DB. One important bit of information to denote is that SQL BACPAC files are like compressed ZIP files containing both the Data and Schema of your SQL DB. Conversely a DAC file contains only the database schema. I’ve listed the import and export command-line and parameters here.

Azure SQL Point in Time Recovery allows you to restore a database as a replacement for the original database. The question is where do you want to restore the database backup to. If you’re restoring a database backup to a new database on the same logical server then you can restore to a specific point in time within the same retention period. If it’s an existing database on the same logical server, then you can backup to the deletion time for a deleted database. Finally if you have geo-replicated blob storage, then you can restore to a new database on any logical server in any region to a specific point in time of the most recent daily backup in the geo-replicated blob storage, but for RA-GRS storage only.

You must be the subscription owner or member of the SQL Contributor role in that subscription in order to do SQL DB Restores which can be done programmatically or through the Azure Portal. I’ve listed a few PowerShell commands below which all have the AzureRmSql prefix.

About the Author

Students6296
Labs1
Courses2
Learning paths2

Chris has over 15 years of experience working with top IT Enterprise businesses.  Having worked at Google helping to launch Gmail, YouTube, Maps and more and most recently at Microsoft working directly with Microsoft Azure for both Commercial and Public Sectors, Chris brings a wealth of knowledge and experience to the team in architecting complex solutions and advanced troubleshooting techniques.  He holds several Microsoft Certifications including Azure Certifications.

In his spare time, Chris enjoys movies, gaming, outdoor activities, and Brazilian Jiu-Jitsu.