1. Home
  2. Microsoft
  3. DP-900

Microsoft Azure Data Fundamentals

Exam Details

  • Exam Code
    :DP-900
  • Exam Name
    :Microsoft Azure Data Fundamentals
  • Certification
    :Microsoft Certifications
  • Vendor
    :Microsoft
  • Total Questions
    :319 Q&As
  • Last Updated
    :Mar 31, 2025

Microsoft Microsoft Certifications DP-900 Questions & Answers

  • Question 221:

    In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

    A. bridge

    B. dimension

    C. fact

  • Question 222:

    SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

    A. Data Definition Language (DDL)

    B. Data Control Language (DCL)

    C. Data Manipulation Language (DML)

  • Question 223:

    You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?

    A. online transaction processing (OLTP)

    B. online analytical processing (OLAP)

    C. extract, transform and load (ETL)

    D. a data warehouse

  • Question 224:

    Which activity is most common for transactional workloads?

    A. recording small units of work events in real time

    B. aggregating massive amounts of data

    C. producing complex reports

    D. performing self-service data exploration

  • Question 225:

    Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?

    A. Hot to Cool

    B. Hot to Archive

    C. Cool to Archive

    D. Archive to Cool

  • Question 226:

    A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either action falls to complete, the other action must fail. Of which ACID semantic is this an example?

    A. consistency

    B. durability

    C. atomicity

    D. isolation

  • Question 227:

    Which Azure Cosmos DB API should you use for a graph database?

    A. Azure Cosmos DB for Table

    B. Azure Cosmos DB for Apache Cassandra

    C. Azure Cosmos DB for NoSQL

    D. Azure Cosmos DB for Apache Gremlin

  • Question 228:

    A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable. Of which ACID semantic is this an example?

    A. durability

    B. isolation

    C. atomicity

    D. consistency

  • Question 229:

    What is a difference between structured data and semi-structured data?

    A. Structured data has a fixed schema and semi-structured data has a flexible schema.

    B. Only Structured data supports entities.

    C. Structured data has a flexible schema and semi-structured data has a fixed schema.

    D. Only Structured data supports attributes.

  • Question 230:

    Which Azure Cosmos DB API should you use for a graph database?

    A. Table

    B. Cassandra

    C. NoSQL

    D. Gremlin

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Microsoft exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your DP-900 exam preparations and Microsoft certification application, do not hesitate to visit our Vcedump.com to find your solutions here.