Share via

Resources not provided for learning this module

Madan Kartheessan 25 Reputation points
2023-11-26T16:38:49.6466667+00:00

Manage workloads in Azure Synapse Analytics

How can we create Lab 8 and other resources required for practicing the above module?

Azure | Azure Training
0 comments

Answer accepted by question author

AmaranS 7,290 Reputation points Microsoft External Staff
2023-11-27T10:05:22.5533333+00:00

Hi @Madan Kartheessan

Based on our understanding of the issue, you’re practicing the following Learn Path Exercise:

Learning path: Work with Data Warehouses using Azure Synapse Analytics - Training | Microsoft Learn

Module: Manage and monitor data warehouse activities in Azure Synapse Analytics - Training | Microsoft Learn

Unit 4 of 8: Manage workloads in Azure Synapse Analytics - Training | Microsoft Learn

Create an Azure Synapse Analytics workspace. This can be done through the https://portal.azure.com/ 

Lab 8 Setup:
1.Azure Synapse SQL Pools:

-Within your Synapse Analytics workspace, create SQL Pools for managing workloads.
-use the Azure portal.
-Navigate to the "Develop" tab and create a new SQL Pool.
-Configure the SQL Pool settings according to your requirements. 

2.Sample Databases and Tables:

-Use T-SQL scripts to create databases and tables.
-You can use the Synapse Studio like Azure Data Studio to run scripts.

3.Data Loading:

-Load sample data into your Synapse SQL Pools for practicing data loading and transformation.
-You can use tools like Azure Data Factory to load data. 

4.Developing and Managing Workloads:

-Use Synapse Studio to develop and manage your workloads.
-Write T-SQL queries, stored procedures, and other artifacts as needed for your workload.

Always refer to the latest https://docs.microsoft.com/en-us/azure/synapse-analytics/ for the most accurate and up-to-date information.
Kindly let us know if the issue persists along with screenshot, we'll be glad to assist you further.

(NOTE: Please conceal all your privacy details before posting).

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dillon Silzer 60,926 Reputation points Volunteer Moderator
    2023-11-26T19:23:52.7133333+00:00

    Hi Madan,

    You will need an Azure subscription to complete Lab 8. I'd recommend signing up for Azure Free to complete the training exercise:

    Build in the cloud with an Azure free account

    https://azure.microsoft.com/free

    If this is helpful please accept answer.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.