MDP(Custom)-Accenture-17/08/21 (Day 22)

You want to copy data from a SQL server database to Azure Blob storage. While creating Linked service against the SQL server, in the Integration runtime setup dialog box, you will select Self-hosted IR.

• True

• False

Which Azure Data Factory process involves using compute services to produce date to feed production environments with cleansed data?

• Monitor

• Connect and collect

• Publish

• Transform and enrich

You have the following code with you :

az datafactory factory create --resource-group ADFQuickStartRG

--factory-name ADFTutorialFactory

The above code is a/an :

• Azure PowerShell cmdlet

• Azure CLI command

• Python code

• Invalid command

Azure Data Factory components are also embedded with the same functionality within which Azure Data Platform service ?

• Azure Databricks

• Azure Stream Analytics

• Azure Synapse Analytics

• None of the above

A pipeline JSON definition is embedded into an Activity JSON definition.

• True

• False

Which of the following component of Azure Data Factory typically contains the analysis commands in context to the desired business logic needs to be get executed ?

• Dataset

• Integration Runtime

• Pipeline

• Activity

You want to connect to different databases on the same logical SQL server but at the same time you are supposed to create only one linked service against that server. You can make the linked service created reusable by making use of :

• Conditional execution

• ConnectVia property

• Parameters

• Not possible

Azure Data Factory has one of its key component called Linked Service which is used to provide a reference to a particular data store but not any compute resource.

• True

• False

Azure Data Factory, while have native functionality to ingest and transform data, sometimes call other compute resource such as Azure Databricks to perform the desired transformation as a part of business logic.

This capability of Azure Data Factory is termed as :

• Normalization

• Orchestration

• Serialization

• Incremental execution

When copying data into SQL database/Azure Synapse Analytics, if the destination table does not exist, copy activity supports automatically creating it based on the source data.

• True

• False