Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Microsoft Azure Synapse for Developers: Scaling Configuration

via LinkedIn Learning

Overview

Learn about your configuration options when setting up a data warehouse in Azure Synapse Analytics.

Syllabus

Introduction
  • Configuring Azure Synapse workspaces
  • What you should know
1. Configuring Synapse Analytics Workloads
  • Understanding performance levels
  • Working with built-in resource classes
  • Understanding workload management in Synapse Analytics
  • Creating workload groups
  • Configuring workload classifiers
  • Configuring workload isolation
  • Challenge: Create workload groups
  • Solution: Create workload groups
2. Configuring Autoscaling for Synapse Analytics Pools
  • Scaling dedicated SQL pools
  • Pausing and resuming using the management API
  • Creating a pause and resume Synapse Analytics pipeline
  • Using Synapse pipelines to scale dedicated SQL pools
  • Scheduling data warehouse scaling
  • Challenge: Create a pipeline to pause and resume pools
  • Solution: Create a pipeline to pause and resume pools
3. Configuring Security Options
  • Masking sensitive data
  • Classifying sensitive data
  • Enabling Azure SQL auditing
  • Challenge: Mark sensitive user information
  • Solution: Mark sensitive user information
4. Disaster Recovery Options
  • Restoring dedicated SQL pools
  • Creating restore points before risky data changes
  • Enabling geo-backups
  • Challenge: Create a restore point and restore the data warehouse
  • Solution: Create a restore point and restore the data warehouse
Conclusion
  • Next steps

Taught by

Nertil Poci

Reviews

4.6 rating at LinkedIn Learning based on 20 ratings

Start your review of Microsoft Azure Synapse for Developers: Scaling Configuration

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.