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
()
Ex_Files_Azure_SQL_Warehouse_for_Devs_Scaling_Config.zip
(132 KB)