Free Microsoft DP-700 Exam Questions

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

Page: 1 / 74

Total 368 Questions | Updated On: Nov 04, 2024

Add To Cart

Question 1

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 2

Which of the following is a feature of Azure Data Lake Storage Gen2 in Microsoft Fabric?

A : Real-time data streaming capabilities

B : Data visualization and reporting

C : Supports ACID transactions

D : Supports hierarchical namespace

Answer: D

Question 3

You have a Fabric workspace that contains a data pipeline named Pipeline! as shown in the exhibit.(Click the Exhibit tab.) What will occur the next time Pipelinel tuns?

A : Both activities will run simultaneously.

B : Both activities will be skipped.

C : Execute procedurel will run and Copy_kdi will be skipped.

D : Copy.kdi will run and Execute procedurel will be skipped.

E : Execute procedure1 will run first, and then Copy_kdi will run.

F : Copy.kdi will run first, and then Execute procedurel will run.

Answer: A

Question 4

You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.Users report that from OneLake file explorer, they cannot see the data from the eventhouse.You enable OneLake availability for the eventhouse.What will be copied to OneLake?

A : only data added to new databases that are added to the eventhouse

B : only the existing data in the eventhouse

C : no data

D : both new data and existing data in the eventhouse

E : only new data added to the eventhouse

Answer: D

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 / 74

Total 368 Questions | Updated On: Nov 04, 2024

Add To Cart