Free Microsoft DP-700 Practice Test Questions

Question 1

Note: This question is part of a series of questions that present the same scenario. Each question in the seriescontains a unique solution that might meet the stated goals. Some question sets might have more than onecorrect solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questionswill not appear in the review screen.You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. Thetable contains the following columns:BikepointIDStreetNeighbourhoodNo_Bikes No_Empty_DocksTimestampYou need to apply transformation and filter logic to prepare the data for consumption. The solution mustreturn data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be orderedby No_Bikes in ascending order.Solution: You use the following code segment:Does this meet the goal?

A : Yes

B : no

Answer: A

Question 2

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

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

Which of the following transformations can be performed using Azure Data Factory?

A : Data classification

B : Data transformation using mapping data flows

C : Data aggregation

D : Data cleansing

E : Machine learning model training

Answer: B,C,D

Question 4

What is a key advantage of monitoring and auditing access to data resources?

A : It speeds up data processing times

B : It makes data analysis more efficient

C : It helps identify and prevent unauthorized access

D : It reduces the need for data backups

Answer: C

Question 5

Note: This question is part of a series of questions that present the same scenario. Each question in the seriescontains a unique solution that might meet the stated goals. Some question sets might have more than onecorrect solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questionswill not appear in the review screen.You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. Thetable contains the following columns:BikepointIDStreetNeighbourhoodNo_Bikes No_Empty_DocksTimestampYou need to apply transformation and filter logic to prepare the data for consumption. The solution mustreturn data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be orderedby No_Bikes in ascending order.Solution: You use the following code segment:Does this meet the goal?

A : Yes

B : no

Answer: A

Free Microsoft DP-700 Exam Practice Questions 2026