logo

Microsoft DP-420 Exam Questions & Verified Answers

Prepare for Azure Cosmos DB Developer Specialty with expert-reviewed DP-420 questions and answers. Try free samples, strengthen your understanding and rehearse your timing in the simulator.

211
Practice questions
Previews from the DP-420 free simulator sample

Try Free DP-420 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 105 free questions
Question 1
You need to provide a solution for the Azure Functions notifications following updates to con-product. The solution must meet the business requirements and the product catalog requirements. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Question 2
You have a Retrieval-Augmented Generation (RAG) application that uses an Azure Cosmos DB for NoSQL container. The container stores product items that have a property named description for searchable text and a property named descriptionVector for embeddings. The container has a full-text index on /description and a DiskANN vector index on /descriptionVector . You need to return the 10 items that rank the highest based on both semantic similarity and full-text relevance. How should you complete the hybrid search query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 3
You have an agent that uses Azure Cosmos DB for NoSQL to store agent memory. The agent has the following Python code. provider = CosmosMemoryContextProvider(...) agent = Agent(context_providers=[provider]) async with provider: session1 = agent.create_session() session1.state.setdefault(provider.source_id, {})["user_id"] = "user-101" await agent.run("I avoid sesame.", session=session1) await provider.flush() session2 = agent.create_session() session2.state.setdefault(provider.source_id, {})["user_id"] = "user-101" await agent.run( "Which seed should recipes exclude for me?", session=session2 ) session3 = agent.create_session() session3.state.setdefault(provider.source_id, {})["user_id"] = "user-202" await agent.run( "Which seed should recipes exclude for me?", session=session3 ) For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Question 4
You have the following T-SQL query that runs against Azure Cosmos DB data mirrored to Microsoft Fabric. SELECT s.id AS shipmentId, p.storageTemperature, i.itemId, x.weight FROM dbo.ShipmentEvents AS s CROSS APPLY OPENJSON(s.packages) WITH ( storageTemperature int '$.storageTemperature', items nvarchar(max) '$.items' AS JSON ) AS p OUTER APPLY OPENJSON(p.items) WITH ( itemId varchar(40) '$.id', properties nvarchar(max) '$.properties' AS JSON ) AS i OUTER APPLY OPENJSON(i.properties) WITH ( weight int '$.weight' ) AS x WHERE p.storageTemperature >= 5; For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Question 5
You have an Azure Cosmos DB for NoSQL account named Account1 that has public network access disabled and uses a private endpoint. Account1 contains the data shown in the following table. Database name Container name Propert y Commerce Transactions productId , amount , transactionType Commerce Customers customerId , name Catalog Products productId , category Catalog Suppliers supplierId , name You plan to implement a Microsoft Fabric workspace in the same Azure region as Account1. The workspace will contain mirrored databases from the account. You will use the SQL analytics endpoint to calculate daily net transaction amounts by product category and transaction type. You need to configure Fabric mirroring. The solution must mirror only the containers required for the analysis. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 6
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named db1. The subscription is linked to a Microsoft Entra tenant that contains a user named User1. You need to delegate permissions to User1 to meet the following requirements: Ensure that User1 can manage db1. Prevent User1 from accessing connection strings. Prevent User1 from accessing the data stored in db1. Which role should you assign to User1?

Download DP-420 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-420 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.

Azure Cosmos DB Developer Specialty

DP-420 Exam Topics and Study Plan

Skills Covered by the Exam

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

  • Design and develop database solutions40–45%
  • Secure, optimize, and deploy database solutions30–35%
  • Implement AI and analytics capabilities in database solutions20–25%

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-420, 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-420 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-420 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-420 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.