Microsoft Azure Synapse for Developers: Scaling Configuration

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

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