← Back to exam page

DP-900 – Microsoft Azure Data Fundamentals

Loading demo links...

Showing 7–9 of 15 questions

Question 7 (Describe an analytics workload on Azure)

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    denormalized data
  • ○

    heavy writes and moderate reads
  • ○

    light writes and heavy reads
  • ○

    schema on write
  • ○

    schema on read
  • ○

    normalized data
Question 8 (New Update)

In Azure Table storage, each row in a table must be uniquely identified by which two components?

Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    a timestamp
  • ○

    a range
  • ○

    a row key
  • ○

    a partition key
Question 9 (Describe how to work with relational data on Azure)

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    You must be assigned the Reader role for the resource group that contains the database.
  • ○

    You must have SELECT access to the Products table.
  • ○

    You must have a user in the database.
  • ○

    You must be assigned the Contributor role for the resource group that contains the database.
  • ○

    Your IP address must be allowed to connect to the database.