Learn about your configuration options when setting up a data warehouse in Azure Synapse Analytics.
Overview
Syllabus
Introduction
- Configuring Azure Synapse workspaces
- What you should know
- 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
- 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
- Masking sensitive data
- Classifying sensitive data
- Enabling Azure SQL auditing
- Challenge: Mark sensitive user information
- Solution: Mark sensitive user information
- 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
- Next steps
Taught by
Nertil Poci