dw.q1

Witch of this statements does not represent a goal of an ETL process:

• Extract, transform and load data to the data warehouse;

• Update the OLTP system with more recent data;

• Combine data from different sources and apply data quality rules

• Data modeling and data cleansing

Using Azure Data Factory, what statement is not true when comparing the difference between a pipeline and Data Flow?

• Pipeline perform various activities, provide structure, and control the order in which elements run

• A pipeline elements extract data, and load data into other data sources.

• Data flow performs transformations over datasets.

• There must be at least one data flow element in a pipeline.

What is the main (and more unique) feature that Data Flow add to ADF ?

• allow you to transform data

• allow to use C# in expressions

• allows you to develop graphical data transformation logic

• can join pipelines

ADF allow to (choose all that apply)

• get data from other sources and clouds

• create a linked service to describe a connection to a data source

• schedule pipelines to run in specific schedule

• create a linked service to describe a dataset

in ADF objects are organized

• in services

• in folders

• in activities

• in queries

In ADF we can use a ____ activity to ingest information from source to sink.