Section 3: Data Migration and Transformation

Question 1

What is Azure Data Factory primarily used for?

Answer 1

Azure Data Factory is primarily used for data integration and transformation.

Question 2

True or False: Azure Migrate helps in assessing and migrating on-premises workloads to Azure.

Answer 2

True

Question 3

Fill in the blank: ETL stands for ________.

Answer 3

Extract, Transform, Load

Question 4

What is the purpose of the integration processes in Azure Synapse?

Answer 4

The integration processes in Azure Synapse facilitate data movement and transformation across various data sources.

Question 5

Which Azure service allows you to create data pipelines?

Answer 5

Azure Data Factory

Question 6

Multiple Choice: Which of the following is NOT a feature of Azure Data Factory? A) Data movement B) Data orchestration C) Data visualization D) Data transformation

Answer 6

C) Data visualization

Question 7

What type of workloads does Azure Migrate assess?

Answer 7

Azure Migrate assesses on-premises workloads for migration to Azure.

Question 8

True or False: Azure Data Factory can only work with Microsoft data sources.

Answer 8

False

Question 9

What are the two main components of Azure Data Factory?

Answer 9

The two main components are the Data Pipeline and the Data Integration Runtime.

Question 10

Fill in the blank: In ETL processes, the ‘Transform’ step is responsible for ________.

Answer 10

modifying the data to fit operational needs

Question 11

What is the role of the Integration Runtime in Azure Data Factory?

Answer 11

The Integration Runtime provides the data integration capabilities across different network environments.

Question 12

Multiple Choice: Which of the following can be a source for Azure Data Factory? A) SQL Database B) Excel files C) Blob storage D) All of the above

Answer 12

D) All of the above

Question 13

What does Azure Synapse Analytics combine?

Answer 13

Azure Synapse Analytics combines big data and data warehousing.

Question 14

True or False: Azure Migrate supports only Windows-based servers.

Answer 14

False

Question 15

What is a key benefit of using Azure Data Factory for ETL processes?

Answer 15

A key benefit is its ability to orchestrate data workflows across different services.

Question 16

What is the primary function of Azure Synapse Pipelines?

Answer 16

Azure Synapse Pipelines orchestrate the movement and transformation of data.

Question 17

Fill in the blank: Azure Data Factory supports ________ data integration.

Answer 17

hybrid

Question 18

Multiple Choice: Which of the following is a common use case for Azure Migrate? A) Web app hosting B) Database migration C) Machine learning model training D) Video streaming

Answer 18

B) Database migration

Question 19

What does the term ‘data orchestration’ refer to in Azure Data Factory?

Answer 19

Data orchestration refers to managing and scheduling data workflows.

Question 20

True or False: Azure Data Factory allows for real-time data processing.

Answer 20

False

Question 21

What integration capabilities does Azure Data Factory provide?

Answer 21

Azure Data Factory provides data movement, data transformation, and data monitoring capabilities.

Question 22

Fill in the blank: The primary output of an ETL process is ________.

Answer 22

a transformed dataset ready for analysis

Question 23

What is a ‘data flow’ in Azure Data Factory?

Answer 23

A data flow is a visual way to design data transformation logic.

Question 24

Multiple Choice: What is the first step in an ETL process? A) Load B) Transform C) Extract D) Analyze

Answer 24

C) Extract

Question 25

What is the Azure service that allows users to analyze large volumes of data?

Answer 25

Azure Synapse Analytics