What is the purpose of Dataset in Data Factory?

 Posted by Rajnilari2015 on 3/10/2017 | Category: Azure Interview questions | Views: 595 | Points: 40
Answer:

Linked services link data stores to an Azure data factory. Datasets represent data structures with in the data stores.
E.g
The below is a linked service created for a AzureSqlDatabase
{

"name": "AzureSqlLinkedService",
"properties": {
"hubName": "rnadf_hub",
"type": "AzureSqlDatabase",
"typeProperties": {
"connectionString": "Data Source=tcp:xxxx.database.windows.net,1433;Initial Catalog=xxxx;Integrated Security=False;User ID=xxx@yyyy;Password=**********;Connect Timeout=30;Encrypt=True"
}
}
}

The corresponding DataSet for an AzureSQLTable will be
{

"name": "InsertStudentDS",
"properties": {
"published": false,
"type": "AzureSqlTable",
"linkedServiceName": "AzureSqlLinkedService",
"typeProperties": {
"tableName": "tblStudent"
},
"availability": {
"frequency": "Hour",
"interval": 1
}
}
}


We can figure out that the Dataset picks up the information from the Linked Service from the property
"linkedServiceName": "AzureSqlLinkedService"


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response