CGI: Azure Data Factory

What should you use to connect to a source system, such as Azure SQL or

from ADLS (gen2)

• Linked Services

• Linked Connection

• Dataset

• ConnectedApps

What should you use if you want to use a named view of the data? This

object is used inside the ADF pipeline in the Activites?

• LinkedServices

• LinkedConnection

• Dataset

• LinkedDataset

What object in ADF to logically group activities to source data from

Oracle to load into ADLS (gen2)?

• Pipeline

• Activities

• Arm-template

• Monitor

What are the components name in a pipeline to perform an action?

• Pipeline

• Activities

• Arm-template

• Monitor

Where would you go to view execution logs and exceptions in ADF?

• Author

• Activities

• Manage

• Monitor

Where would you go to setup Git for ADF?

• Git

• Git repository

• Azure DevOps

• Arm-template

What is used to as the processing engine in ADF?

• Runtimes

• Integration Runtimes

• Azure Devops

• Arm-Templates

What ADF Activity should I use to read from a control table?

• Lookup Activity

• Set Variable

• Stored Procedure

• Notebook

What would you use if you wanted to perform transformations in ADF?

• Lookup Acitivity

• Dataflow

• Stored Procedure

• Notebook

What engine is used under the covers in Dataflow?

• Spark

• Databricks

• Snowflake

• Python