Microsoft Azure Synapse for Developers: Scaling Configuration
1h 41mAdvanced2022-01-06
Authors
Nertil Poci
Freelance Software Architect
Course details
Do you know about all your options for configuration in Azure Synapse Analytics? There are so many different ways to optimize and secure your workspace that sometimes it’s hard to keep track. In this course, instructor Nertil Poci helps you navigate your options as a developer or DevOps engineer looking to set up your company data warehouse with Azure Synapse Analytics.
Learn how to customize and automate your tasks, making sure you manage all your resources efficiently so you can configure and scale your process. Get tips on keeping your workspace secure and cutting down on costs appropriately. Explore options such as autoscaling, configuring encryption, masking sensitive information, and managing projects with workload groups. Join Nertil and learn how to make the most of Synapse to quickly glean insights from your data.
Learn how to customize and automate your tasks, making sure you manage all your resources efficiently so you can configure and scale your process. Get tips on keeping your workspace secure and cutting down on costs appropriately. Explore options such as autoscaling, configuring encryption, masking sensitive information, and managing projects with workload groups. Join Nertil and learn how to make the most of Synapse to quickly glean insights from your data.
Skills covered
SQLCloud DevelopmentData EngineeringDatabase DevelopmentDatabase ManagementAzureSoftware Development ToolsNetwork AdministrationCloud PlatformsNetwork and System AdministrationCloud ComputingData ScienceOpen SourceMicrosoftSoftware DevelopmentDeep Dive (X:Y)
Concepts
Introduction
- Configuring Azure Synapse workspaces
- What you should know
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
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
Configuring Security Options
- Masking sensitive data
- Classifying sensitive data
- Enabling Azure SQL auditing
- Challenge - Mark sensitive user information
- Solution - Mark sensitive user information
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