Question 1

Which of the following is a cloud-based integration service that orchestrates and automates data movement or transformation?

Accepted Answer

Azure data factory

Answer

Azure data pipeline

Answer

Azure data lake storage

Answer

Azure data storage

Question 2

What is the first step to be done before creating a data factory in Azure portal?

Accepted Answer

Download and install SSMS

Answer

Create a data warehouse

Answer

Create a storage account

Answer

Create a SQL server

Question 3

Which of the following is used to store data in Azure data factory?

Accepted Answer

SQL server only

Answer

Data Lake Storage

Answer

None of the above

Answer

Blob storage only

Question 4

Which of the following statements is true about Data Lake Storage?

Accepted Answer

It is a relational database management system.

Answer

It can store unstructured data.

Answer

It has a limited storage capacity.

Answer

It is a data storage that is highly scalable and distributed.

Question 5

What are the two main concepts of Azure Data Lake Storage?

Accepted Answer

Storage and Management

Answer

Transformation and Visualization

Answer

Storage and Analytics

Answer

Input and Output

Question 6

Which of the following analytical software can be used with Azure Data Lake Storage?

Accepted Answer

MS SQL only

Answer

None of the above

Answer

Apache Spark

Answer

MySQL only

Question 7

What is the purpose of using a data factory in Azure?

Accepted Answer

To create and manage databases

Answer

To automate data movement and transformation

Answer

To visualize data

Answer

None of the above

Question 8

What is the output format of the data after it goes through the pipeline in Azure data factory?

Accepted Answer

Unstructured format

Answer

None of the above

Answer

Raw format

Answer

Structured format

Question 9

Linked services in Azure data factory are used for?

Accepted Answer

Data transformation

Answer

Data visualization

Answer

Connecting to external sources

Answer

None of the above

Question 10

Which of the following is NOT a component of Azure data factory?

Accepted Answer

Input dataset

Answer

Output dataset

Answer

Pipeline

Answer

Data visualization tool

Related quizzes

Related quizzes