Course Description
There are many variables to consider when deciding on a single-tenant or multi-tenant design for Windows Azure. This course covers the considerations for each, as well as the requirements and processes involved in migrating data to Azure SQL Databases. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.
Learning Objectives
Multiple Tenant Deployments
- start the course
- explain the difference between single-tenant and multi-tenant data architectures
- recognize the architectural considerations that influence choosing between a single vs multi tenant
- explain considerations, such as economic, security, tenant, relating to multiple tenants
- describe how to manage multi-tenant data in SQL Server 2016
- describe the benefits of partitioning and isolating tenant data
- demonstrate how to manage deployments that support multiple tenants
Migrating to Azure SQL Databases
- recognize the various steps and considerations involved with migrating on-premise SQL Server databases to Azure
- recognize the tools available to test for SQL Database compatibility
- describe how to migrate a non-SQL Server database
- demonstrate how to migrate a SQL Server database using the Microsoft Azure database wizard
- compare the BACPAC export and transactional replication migration methods
- demonstrate how to create a BACPAC file to use in a database migration
Migrating Data to Azure SQL Database
- explain the Azure data factory
- describe the data transformation activities supported by Azure data factory
- discuss how to install the data management gateway
- create linked services that connect to data sources in Azure data factory
- define and create tables to specify how to access datasets
- demonstrate how to define, create, and start the pipeline
Practice: Azure Data Factory
- manage data using the Azure Data Factory