Security in Azure Synapse Analytics

45 minutes
  • 5 Learning Objectives

About this Hands-on Lab

In this lab, we will be creating and securing an Azure Synapse Analytics instance. We will secure the environment by creating a delete lock, enabling transparent data encryption, configuring auditing, and configuring a firewall.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Provision the Environment

To start our lab, we will provision an Azure Synapse instance. The goal will be a quick refresh on how to provision an instance and quickly navigate the provisioning blades.

Create a Gen2 DW200c instance with a new SQL pool and server. The environment should use sample data as a data source.

Note: Do not select Start Free Trial.

Create a Delete Lock

In this objective, we will learn how to create a delete lock to service the environment.

Enable Transparent Data Encryption

Next, we will learn how to enable transparent data encryption to encrypt your databases, backups, and logs at rest.

Configure Firewall and Network Settings

In this objective, we will review firewalls and learn how to set a minimum TLS version (set to reject any TLS less than 1.0) and how to create a VNet and add our SQL pool to that VNet.

Configure Auditing

Finally, we will turn on auditing and deposit logs into a storage account.

  1. Set storage (general purpose v2) as standard and replicate with LRS.
  2. Set the number of retention days to 180.

Additional Resources

I mentioned that I would include an Azure Active Directory resource in the lab guide. I would suggest AZ-500: Microsoft Azure Security Technologies. It is a fantastic course covering all aspects of Azure Security including a very detailed walkthrough of Azure Active Directory.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


Sign In
Welcome Back!
Thanks for reaching out!

You’ll hear from us shortly. In the meantime, why not check out what our customers have to say about ACG?