Azure Data Fundamentals (DP-900) · 18% practice allocation

Azure DP-900: Describe considerations for working with non-relational data on Azure Practice Questions

5 free sample questions from the Describe considerations for working with non-relational data on Azure domain, with answers and explanations. The full DP-900 bank has 62 questions across 4 domains. Questions are scenario-based and written from the official Azure exam guide.

1.

A development team wants to migrate a MongoDB application to Azure with MINIMAL code changes. Which Cosmos DB capability makes this possible?

  • A. Cosmos DB for MongoDB — a MongoDB-compatible API endpoint✓ Correct
  • B. Cosmos DB automatically converts MongoDB code to SQL
  • C. Cosmos DB requires rewriting the app in Cassandra Query Language
  • D. Cosmos DB for Gremlin
Explanation

Cosmos DB exposes multiple wire-compatible APIs; Cosmos DB for MongoDB speaks the MongoDB protocol, so existing drivers and most application code keep working against the new endpoint. Option B doesn't exist. Gremlin (D) is the graph API — wrong model. Option C is backwards: API choice exists precisely to avoid rewrites.

2.

An IoT solution ingests device telemetry as JSON, needs flexible schema (devices report different fields), enormous write throughput, and querying by device ID with millisecond latency. Which Azure data service is the BEST fit?

  • A. Azure Blob Storage archive tier
  • B. Azure Files
  • C. Azure Database for MySQL
  • D. Azure Cosmos DB✓ Correct
Explanation

Schemaless JSON items, massive write scale, key-based millisecond reads — that's the Cosmos DB profile. Azure Files (B) is a file share, not a queryable database. MySQL (C) imposes a relational schema and scales writes far less elastically. Archive-tier Blob (A) is offline cold storage — reads take hours, the opposite of millisecond telemetry lookups.

3.

Which Azure Storage service provides fully managed file shares accessible over the SMB protocol, so existing applications can use them like a traditional network drive?

  • A. Azure Cosmos DB
  • B. Azure Files✓ Correct
  • C. Azure Queue Storage
  • D. Azure Blob Storage
Explanation

Azure Files exposes cloud file shares over SMB (and NFS), mountable by Windows, Linux, and macOS exactly like a network drive — the lift-and-shift answer for apps expecting a file system. Blob (D) is object storage over HTTP, not a mountable SMB share. Queue Storage (C) passes messages between components. Cosmos DB (A) is a NoSQL database.

4.

Which TWO statements about Azure Cosmos DB are TRUE? (Select 2)

  • A. It offers turnkey global distribution, replicating data across any number of Azure regions✓ Correct
  • B. It requires customers to patch the underlying virtual machines
  • C. It only supports the SQL Server relational engine
  • D. It cannot scale beyond a single server
  • E. It provides single-digit-millisecond latency backed by SLAs✓ Correct
Explanation

Cosmos DB's headline features are global distribution with multi-region replication (A) and SLA-backed single-digit-millisecond reads/writes (E), plus elastic scale. Option C is false — it's a multi-model NoSQL service, not SQL Server. Option D contradicts its horizontally partitioned architecture. Option B is false — it's fully managed PaaS.

5.

Cosmos DB offers multiple APIs. Which pairing of API to data model is CORRECT?

  • A. Cosmos DB for NoSQL → JSON documents queried with a SQL-like syntax✓ Correct
  • B. Cosmos DB for Cassandra → graph vertices and edges
  • C. Cosmos DB for Gremlin → column-family wide rows
  • D. Cosmos DB for Table → relational tables with joins
Explanation

The native NoSQL API stores JSON documents and queries them with a SQL-like language. The other pairings are shuffled: Cassandra is the column-family API (not graph), Gremlin is the graph API (not column-family), and the Table API is key-value (no joins, not relational).

Test yourself across every DP-900 domain

The free DP-900 practice test mixes about 20 questions weighted like the exam. The full 62-question bank adds instant grading, flashcards and a timed mock exam.

Take the free DP-900 practice testPractice the full bank

Study this domain

Describe considerations for working with non-relational data on Azure study guide (DP-900) →

Other DP-900 domains

← All Azure Data Fundamentals study resources