Question 1

Which of the following best describes the role of data transformation in the ETL process?

Options :

A : To directly load raw data into the target system

B : To cleanse and reformat data for storage in a target system

C : To aggregate data for reporting purposes only

D : To retrieve data from the source system

Answer: B

Question 2

Which of the following actions can be automated using Azure Data Factory in Microsoft Fabric?

Options :

A : Machine learning model prediction

B : Data ingestion from SQL databases

C : Data synchronization with Power BI

D : Data transformations in real-time

E : Data pipeline execution

Answer: B,E

Question 3

What is a potential impact of inefficient data workflows in Microsoft Fabric?

Options :

A : Increased data security risks

B : Improved system scalability

C : Reduced data redundancy

D : Slower data processing and longer query times

Answer: D

Question 4

What is the purpose of implementing data encryption in Microsoft Fabric?

Options :

A : To improve system uptime

B : To speed up data processing

C : To protect data from unauthorized access

D : To eliminate data access restrictions

Answer: C

Question 5

In Microsoft Fabric, which service is optimized for large-scale data warehousing and analytics?

Options :

A : Azure Synapse Analytics

B : Azure Data Factory

C : Azure Machine Learning

D : Azure Databricks

Answer: A