Free Microsoft DP-700 Exam Questions

Become Microsoft Certified with updated DP-700 exam questions and correct answers

Page: 1 / 68

Total 337 Questions | Updated On: Jan 28, 2025

Add To Cart

Question 1

You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 readsdata into a DataFrame from a table named Table1 and applies transformation logic. The data from theDataFrame is then written to a new Delta table named Table2 by using a merge operation.You need to consolidate the underlying Parquet files in Table1.Which command should you run?

A : VACUUM

B : BROADCAST

C : OPTIMIZE

D : CACHE

Answer: C

Question 2

In Microsoft Fabric, what does the term 'ETL' stand for in the context of data transformation?

A : Extract, Transform, Load

B : Extract, Test, Load

C : Extract, Transfer, Load

D : Enter, Test, Load

Answer: A

Question 3

Which of the following methods can be used to trigger a data pipeline based on an event in Azure Data Factory?

A : Using an HTTP request

B : Using an event trigger

C : Using a manual trigger

D : Using a schedule trigger

Answer: A,B

Question 4

Which of the following methods can be used to trigger a data pipeline based on an event in Azure Data Factory?

A : Using an HTTP request

B : Using an event trigger

C : Using a manual trigger

D : Using a schedule trigger

Answer: A,B

Question 5

Which of the following services is commonly used in Microsoft Fabric for handling large-scale data transformation workflows?

A : Azure Synapse Analytics

B : Power BI

C : Azure Data Factory

D : Azure Machine Learning

Answer: C

Page: 1 / 68

Total 337 Questions | Updated On: Jan 28, 2025

Add To Cart