logo

Microsoft DP-700 Exam Questions & Verified Answers

Prepare for Fabric Data Engineer Associate with expert-reviewed DP-700 questions and answers. Try free samples, strengthen your understanding and rehearse your timing in the simulator.

139
Practice questions
Previews from the DP-700 free simulator sample

Try Free DP-700 Practice Questions

Explore the questions below, browse the question library or try a free five-question simulator sample to find the study format that works for you.

View 69 free questions
Question 1
You need to recommend a method to populate the POS1 data to the lakehouse medallion layers. What should you recommend for each layer? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 2
You need to schedule the population of the medallion layers to meet the technical requirements. What should you do?
Question 3
You have a Fabric warehouse named Warehouse1 that contains a table named Table1 . Table1 contains the following columns that store string values: FirstName Phone Email You have two Microsoft Entra security groups named Group1 and Group2. The members of both groups can query Table1 and see full values for FirstName , Phone , and Email . You need to configure Table1 to meet the following requirements: The members of Group1 must see masked values for Phone , showing only the last three characters of each phone number. The Group1 members must see unmasked values for FirstName . The members of Group2 must see unmasked values for all the columns. The solution must use Fabric warehouse-supported permissions and T-SQL. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 4
You have a Fabric workspace that contains a warehouse named WH1. Daily sales files are delivered as CSV files to an Azure Data Lake Storage Gen2 account named storage1. You need to ingest the daily sales files into WH1 every night, validate the row counts, and then execute a T-SQL statement to update the load metadata. The solution must meet the following requirements: Run repeatedly on a schedule. Load the data from storage1 into WH1. Use a code-free or low-code experience. Support the orchestration of multiple activities in a single workflow. What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 5
You have a Fabric workspace named Workspace1 that uses Git integration and is connected to the main branch of an Azure Repos Git repository named Repo1. Multiple developers sync from Workspace1. A hotfix was introduced two commits ago in main. The most recent commit in main contains unrelated changes that are NOT approved for release. You need to deploy only the hotfix, while keeping the main branch history intact. The solution must minimize disruptions for other developers working in main. What should you do?
Question 6
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct 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 questions will not appear in the review screen. You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns: BikepointID Street Neighbourhood No_Bikes No_Empty_Docks Timestamp You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order. Solution: You use the following code segment: Bike_Location | where Neighbourhood == "Sands End" and No_Bikes >= 15 | sort by No_Bikes | project BikepointID, Street, Neighbourhood, No_Bikes, No_Empty_Docks, Timestamp | project BikepointID, Street, Neighbourhood, No_Bikes, No_Empty_Docks, Timestamp Does this meet the goal?

Download DP-700 Sample Questions

Download up to 10 single-answer or multiple-answer questions with recorded answers from the latest five captured sessions. The sample uses questions from the free half first, then the paid half if needed.

Study Tools for Your DP-700 Preparation

Start with a sample, then choose the study tools that fit your revision. Paid access covers this exam for the duration of your selected plan.

Check Your Knowledge with Verified Answers

Work through questions checked by expert trainers before publication. Review your answers to identify what you understand and where to spend more time.

Practise Exam Timing in the Simulator

Use learning, practice or timed exam mode to build familiarity and work on pacing. Vendor-style layouts and supported interactions vary by exam.

Choose How You Read and Review

With paid access, display 6, 10, 25, 50 or 100 questions per page, choose a question range, focus on hot questions and show answers while reading.

Discuss Individual Questions

Ask about a question, compare perspectives and contribute an answer vote. Use the discussion to explore reasoning alongside the expert-reviewed answer.

Download Questions for Offline Revision

Try a PDF sample of up to 10 questions. Paid reading access also offers PDF export for supported single- and multiple-choice questions, answers and images. Interactive formats stay on the website.

Keep Track of Your Exam Access

Unlock the full question bank and simulation features without CAPTCHA checks. Find purchased exams, direct study links and expiry dates in your profile.

Fabric Data Engineer Associate

DP-700 Exam Topics and Study Plan

Skills Covered by the Exam

Use these topics from the linked official guide to plan your preparation for DP-700. Check the current guide before booking, because objectives can change.

  • Implement and manage an analytics solution30–35%
  • Ingest and transform data30–35%
  • Monitor and optimize an analytics solution30–35%

Official exam weights describe the vendor’s blueprint. They do not measure coverage in this question bank.

Recommended Experience Before You Start

Before preparing for DP-700, check Microsoft's current eligibility and experience guidance. Compare the published objectives with work you have completed and plan hands-on practice for gaps.

Plan Your Revision

Suggested preparation sequence; adjust the pace to your experience.

  1. 1

    Check the current objectives

    Make a checklist from the official DP-700 objectives and mark the skills you can already demonstrate.

  2. 2

    Build understanding

    Study one objective at a time. Use official documentation and practical exercises to work on gaps.

  3. 3

    Practise and review

    Use the DP-700 question library to check your understanding. Review why each answer is correct before moving on.

  4. 4

    Rehearse and revisit

    With paid access, run a timed simulation. Revisit weaker topics and repeat practical exercises before booking your exam.

Official Microsoft Study Resources

This date refers to the exam guide, not the review date of every question.

DP-700 Practice and Access FAQs

Understand review, study tools and access before choosing your next step.

Who verifies the questions and answers?

Subject matter expert trainers in each niche review every question and answer before it enters the ExamPrepare database. Answer votes and discussions add perspectives after publication; they do not replace this review. Learn more on our methodology page.

How closely does the simulator match an exam?

The simulator uses vendor-style layouts and supported question interactions to help you practise navigation and pacing. Choose learning, practice or timed exam mode. Formats vary by exam; try the five-question sample to see the experience available for your certification.

What are hot questions?

Hot questions help you prioritise questions with stronger reporting or answer-vote activity. In the reading library, the filter selects questions with at least three recorded sightings or at least three votes for an answer. It has no recency cutoff and does not predict your exam questions. Use it alongside weaker topics and the exam objectives.

Can I read questions without starting a simulation?

Yes. Paid reading access lets you display 6, 10, 25, 50 or 100 questions per page, select a question range, filter for hot questions and show answers while reading. Choose the simulator whenever you want a learning, practice or timed exam session.

Can I download questions and answers as a PDF?

Each exam overview offers a free PDF sample of up to 10 supported questions. With paid reading access, you can also export supported single- and multiple-choice questions with their answers and images. Interactive question formats need the website and are not included as interactive PDF exercises.

How do votes and discussions relate to verified answers?

SME trainers review the questions and answers before publication. Imported answer reports show aggregate responses, while on-site votes and comments reflect participation on ExamPrepare. Use discussion to compare reasoning and investigate disagreements; a majority vote alone does not prove an answer correct.

What does a purchase unlock?

A purchase unlocks the complete question bank for the selected exam, access without CAPTCHA checks, reading controls, supported PDF exports and full learning, practice and timed simulation features. It covers that exam for the duration of the plan you choose, rather than every certification in the catalogue.

Where can I find my purchased exams and expiry dates?

Sign in to the account used for your purchase and open your profile. Your purchased exam library shows study links and access expiry dates so you can return to an exam and check how much access time remains.

View all feature FAQs
bg

Find Your Next Certification Practice Exam

Choose your certification to explore verified answers, free question samples and exam simulations.