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
    :Apr 08, 2025

Microsoft Microsoft Certifications DP-900 Questions & Answers

  • Question 131:

    What is used to define a query in a stream processing jobs in Azure Stream Analytics?

    A. XML

    B. KQL

    C. YAML

    D. SQL

  • Question 132:

    What is required to provision Azure Data Lake Storage in an Azure Storage account?

    A. Versioning must be enabled.

    B. Hierarchical namespace must be enabled.

    C. Hierarchical namespace must be disabled.

    D. Versioning must be disabled.

  • Question 133:

    You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?

    A. Azure Cosmos DB

    B. Azure Table storage

    C. Azure Files

    D. Azure Blob storage

  • Question 134:

    Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

    A. isolation

    B. durability

    C. consistency

    D. atomicity

  • Question 135:

    What should you use to automatically delete blobs from Azure Blob Storage?

    A. soft delete

    B. archive storage

    C. the change feed

    D. a lifecycle management policy

  • Question 136:

    What is a characteristic of a non-relational database?

    A. a fixed schema

    B. self-describ ing entities

    C. full support for Transact-SQL

  • Question 137:

    Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

    A. consistency

    B. durability

    C. isolation

    D. atomicity

  • Question 138:

    What ate three characteristics of an Online Transaction Processing (OLTP) workload?

    Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

    A. denormalized data

    B. schema on write

    C. schema defined when reading unstructured data from a database

    D. normalized data

    E. light writes and heavy reads

    F. heavy writes and moderate reads

  • Question 139:

    Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

    A. control flow

    B. linked services

    C. datasets

    D. the integration runtime

  • Question 140:

    You need to store event log data that is semi-structured and received as the logs occur.

    What should you use?

    A. Azure Table storage

    B. Azure Queue storage

    C. Azure Files

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.