Start preparing for your Next Exam | Use coupon – TOGETHER | Avail 30% discount

Create linked services and datasets

  1. Home
  3. Create linked services and datasets

Go back to DP-200 Tutorials

In this tutorial, we will learn about creating linked services and datasets. Moreover, this will include various methods like using JSON and PowerShell.

Create a linked service

Here’s an example of how to create linked services in Azure Data Factory and Azure Synapse Analytics:

  1. Go to the Azure portal and create an Azure Synapse Analytics workspace and an Azure Data Factory instance.
  2. In the Azure Synapse Analytics workspace, create a linked service for the data source you want to use, such as an Azure Blob Storage account or an Azure SQL Database. To do this, click on “Linked services” in the left-hand menu, and then click on “New”.
  3. Select the type of linked service you want to create, such as “Azure Blob Storage” or “Azure SQL Database”. Enter the required information to connect to your data source, such as the storage account name and key for Blob Storage.
  4. Save the linked service by clicking on the “Create” button.
  5. In the Azure Data Factory instance, create a linked service for the Azure Synapse Analytics workspace you created in step 1. To do this, click on “Manage” in the left-hand menu, and then click on “Linked services”. Click on “New” to create a new linked service.
  6. Select “Azure Synapse Analytics” as the type of linked service you want to create, and enter the required information to connect to your Synapse workspace.
  7. Save the linked service by clicking on the “Create” button.
  8. You can now use these linked services in your Azure Data Factory pipelines to move and transform data between your data sources and destinations. To create a pipeline, click on “Author & Monitor” in the left-hand menu, and then click on “Author”. Click on “New pipeline”.
  9. Drag and drop the activities you want to use to move and transform data between your linked services.
  10. Save the pipeline by clicking on the “Create” button.
DP-200 practice tests

Create a Datasets

Example of how to create datasets in Azure Data Factory and Azure Synapse Analytics:

  1. In the Azure Synapse Analytics workspace, create a dataset for the data you want to work with. To do this, click on “Data” in the left-hand menu, and then click on “New dataset”.
  2. Select the type of dataset you want to create, such as “Azure Blob Storage” or “Azure SQL Database”. Enter the required information to define the dataset, such as the file path or table name.
  3. In the “Linked service” dropdown, select the linked service you created earlier for the data source you want to use.
  4. Save the dataset by clicking on the “Create” button.
  5. In the Azure Data Factory instance, create a dataset for the data you want to work with. To do this, click on “Author & Monitor” in the left-hand menu, and then click on “Author”. Click on “New dataset”.
  6. Select the type of dataset you want to create, such as “Azure Blob Storage” or “Azure Synapse Analytics”. Enter the required information to define the dataset, such as the file path or table name.
  7. In the “Linked service” dropdown, select the linked service you created earlier for the destination you want to use.
  8. Save the dataset by clicking on the “Create” button.
  9. You can now use these datasets in your Azure Data Factory pipelines to move and transform data between your data sources and destinations. To create a pipeline, click on “Author & Monitor” in the left-hand menu, and then click on “Author”. Click on “New pipeline”.
  10. Drag and drop the activities you want to use to move and transform data between your datasets.
  11. Save the pipeline by clicking on the “Create” button.
Create linked services and datasets DP-200 Online course

DP-200 Exam Practice Questions

Question: You need to create a linked service to connect to an Azure SQL Database from an Azure Synapse Analytics workspace. Which type of linked service should you select?

A. Azure Blob Storage

B. Azure SQL Database

C. Azure Synapse Analytics

D. Azure Data Lake Storage Gen1

Answer: B. Azure SQL Database

Explanation: To connect to an Azure SQL Database from an Azure Synapse Analytics workspace, you should select the “Azure SQL Database” type of linked service.

Question: You want to create a dataset for a file stored in an Azure Blob Storage account. Which type of dataset should you select in Azure Synapse Analytics?

A. Azure Blob Storage

B. Azure SQL Database

C. Azure Synapse Analytics

D. Azure Data Lake Storage Gen1

Answer: A. Azure Blob Storage

Explanation: To create a dataset for a file stored in an Azure Blob Storage account in Azure Synapse Analytics, you should select the “Azure Blob Storage” type of dataset.

Question: You need to create a linked service to connect to an Azure Blob Storage account from Azure Data Factory. Which type of linked service should you select?

A. Azure Blob Storage

B. Azure SQL Database

C. Azure Synapse Analytics

D. Azure Data Lake Storage Gen1

Answer: A. Azure Blob Storage

Explanation: To connect to an Azure Blob Storage account from Azure Data Factory, you should select the “Azure Blob Storage” type of linked service.

Question: You want to create a dataset for a table stored in an Azure Synapse Analytics workspace. Which type of dataset should you select in Azure Data Factory?

A. Azure Blob Storage

B. Azure SQL Database

C. Azure Synapse Analytics

D. Azure Data Lake Storage Gen1

Answer: C. Azure Synapse Analytics

Explanation: To create a dataset for a table stored in an Azure Synapse Analytics workspace in Azure Data Factory, you should select the “Azure Synapse Analytics” type of dataset.

Reference: Microsoft Documentation

Go back to DP-200 Tutorials

Menu