
Note: Sign in to the Azure portal using an account that has the Owner or Contributor role in the Azure subscription you are using for this lab. In this task, you will deploy an Azure VM, which will automatically install Visual Studio 2019 and SQL Server Management Studio 2018 as part of the deployment. Task 1: Deploy an Azure VM and an Azure SQL database Task 1: Deploy an Azure VM and an Azure SQL database.In this exercise, you will complete the following tasks: Total Lab Time estimate: 60 minutes Exercise 1: Deploy the base infrastructure from an ARM template Exercise 4: Demonstrate the use of Azure Key Vault in encrypting the Azure SQL database.Exercise 3: Configure an Azure SQL database and a data-driven application.Exercise 2: Configure the Key Vault resource with a key and a secret.Exercise 1: Deploy the base infrastructure from an ARM template.In this lab, you will complete the following exercises: To keep the focus on the security aspects of Azure, related to building this proof of concept, you will start from an automated ARM template deployment, setting up a Virtual Machine with Visual Studio 2019 and SQL Server Management Studio 2018. Verify with your instructor this is the region to use for class. Note: For all the resources in this lab, we are using the East US region.

Create a SQL Database and encrypting content of columns in database tables by using Always Encrypted.Creating an Azure Key Vault and storing keys and secrets in the vault.To accomplish these objectives, the proof of concept should include: The application should be registered in Azure Active Directory (Azure AD) in order to enhance its security posture. All of the secrets and keys used in this scenario should be stored in Key Vault. You have been asked to create a proof of concept application that makes use of the Azure SQL Database support for Always Encrypted functionality. Lab 10: Key Vault (Implementing Secure Data by setting up Always Encrypted) Student lab manual Lab scenario
