Microsoft Azure Data Fundamentals · Domain 3 · 18% of exam

Describe considerations for working with non-relational data on Azure

Drill 20 practice questions focused entirely on Describe considerations for working with non-relational data on Azure for the Microsoft DP-900 exam. Tap an answer for instant feedback and a full explanation — no sign-up, always free.

Verified answer20 questions
Question 1 of 20

A media company must retain original video masters for regulatory compliance for at least seven years. These files are almost never accessed, but when they are needed, a retrieval delay of several hours is acceptable. The company wants the lowest possible storage cost in Azure Blob storage. Which access tier should they choose?

Reviewed for accuracy · Report an issue
Question 2 of 20

A marketing team has built a single-page web application composed of static HTML, CSS, JavaScript, and image files. They want to host these files publicly at low cost without provisioning or managing any web server infrastructure. Which Azure storage feature should they use?

Reviewed for accuracy · Report an issue
Question 3 of 20

A DevOps team needs to continuously write incremental log entries from many application servers into a single object in Azure Blob storage. New data must always be added to the end of the object without rewriting existing content, and the solution must be optimized for frequent append operations. Which type of blob should they use?

Reviewed for accuracy · Report an issue
Question 4 of 20

A media company stores customer video files in Azure Blob storage. Analysis shows that most files are accessed frequently in their first month, then are rarely accessed but must remain available for on-demand playback within milliseconds when a request does arrive. The company wants to minimize storage costs for these older files without moving them offline. Which Blob storage access tier should be applied to the older files?

Reviewed for accuracy · Report an issue
Question 5 of 20

A company runs several Linux virtual machines that need to mount a shared, fully managed cloud file share using their native file-sharing protocol without deploying and maintaining a file server. Which Azure storage option and protocol combination should they use?

Reviewed for accuracy · Report an issue
Question 6 of 20

A company runs several Windows and Linux virtual machines in Azure. The application team needs a fully managed, cloud-based file share that all of these VMs can mount concurrently using standard file-system protocols, without deploying and maintaining a dedicated file server. Which Azure storage option should they choose?

Reviewed for accuracy · Report an issue
Question 7 of 20

A company is migrating an on-premises application to Azure. The application relies on a shared network drive that legacy Windows servers currently access using standard SMB file paths. The team wants to move this shared drive to Azure with minimal code changes so the migrated servers can mount it using the same file-sharing protocol. Which Azure storage service should they use?

Reviewed for accuracy · Report an issue
Question 8 of 20

A company runs a legacy accounting application on an on-premises Windows server. The application reads and writes files to a mapped network drive using a UNC path. The company wants to migrate the application to an Azure virtual machine without changing the application's file-access code. Which Azure storage service should host the shared files?

Reviewed for accuracy · Report an issue
Question 9 of 20

A development team stores customer preference records in Azure Table storage. A new lightweight mobile app, written in a language without an official Azure SDK, needs to read and write these entities directly. Which approach lets the app interact with the Table storage service?

Reviewed for accuracy · Report an issue
Question 10 of 20

A startup needs to store millions of customer profile records where each record is retrieved by a unique customer ID. The data has a simple structure of properties, requires no complex queries or joins, and the company wants the lowest-cost Azure storage option that still supports fast key-based lookups. Which Azure storage service should they choose?

Reviewed for accuracy · Report an issue
Question 11 of 20

A developer is designing an Azure Table storage solution to store customer session records. Each record must be retrievable with the fastest possible point lookup. Which combination of values does the developer need to supply to perform this most efficient single-entity retrieval?

Reviewed for accuracy · Report an issue
Question 12 of 20

A development team currently uses Azure Table storage to store user profile data for a mobile app. The app is expanding globally and now requires single-digit millisecond read latency for users in multiple regions, along with guaranteed throughput that can scale automatically as demand grows. The team wants to keep using a table-style key/value data model with minimal application code changes. Which Azure service should they migrate to?

Reviewed for accuracy · Report an issue
Question 13 of 20

A development team is building an application that stores customer profile records. Each customer entity may have a different set of optional attributes (for example, some have a loyalty number, others have a referral source), and the team wants a low-cost NoSQL store where entities in the same table are not required to share identical columns. Which Azure storage service best fits this requirement?

Reviewed for accuracy · Report an issue
Question 14 of 20

Your company runs an on-premises application that stores wide-column data in an Apache Cassandra cluster. You want to migrate the data platform to Azure Cosmos DB with minimal changes to the application's existing data access code and query patterns. Which Cosmos DB API should you choose?

Reviewed for accuracy · Report an issue
Question 15 of 20

A logistics company wants to model shipments, warehouses, and routes as interconnected entities and run queries that traverse relationships (for example, finding all warehouses connected to a given shipment within three hops). They plan to use Azure Cosmos DB. Which Cosmos DB API should they choose?

Reviewed for accuracy · Report an issue
Question 16 of 20

A development team is building a new e-commerce application that stores product documents in JSON format. The team is experienced with SQL query syntax and wants to query the document data using familiar SELECT-style statements without adopting a third-party query dialect. Which Azure Cosmos DB API should they choose?

Reviewed for accuracy · Report an issue
Question 17 of 20

A development team runs an existing application that stores data in MongoDB on-premises. They want to migrate to Azure Cosmos DB with minimal code changes, ideally keeping their current MongoDB drivers and query syntax. Which Cosmos DB API should they choose?

Reviewed for accuracy · Report an issue
Question 18 of 20

A development team is building a globally distributed mobile gaming backend on Azure Cosmos DB. They need to store player profiles and leaderboard data across multiple regions. Different features have different requirements: some need the freshest data possible, while others can tolerate slightly stale reads to reduce latency and cost. Which capability of Azure Cosmos DB directly addresses this need to balance data freshness against latency on a per-application basis?

Reviewed for accuracy · Report an issue
Question 19 of 20

A retail company runs a global e-commerce catalog that experiences sudden, unpredictable traffic spikes during flash sales. The team wants a NoSQL database that can automatically scale throughput up and down within seconds to handle these bursts without over-provisioning during quiet periods. Which capability of Azure Cosmos DB makes it a good fit for this requirement?

Reviewed for accuracy · Report an issue
Question 20 of 20

A gaming company launches a mobile app played by users across North America, Europe, and Asia. They need a database that stores player profiles and game state with single-digit millisecond read and write latency for users regardless of their geographic region, and that can automatically scale as the player base grows. Which Azure data service best meets these requirements?

Reviewed for accuracy · Report an issue

More DP-900 practice

Keep going with the other Microsoft Azure Data Fundamentals domains, or take a full timed mock exam.

← Back to DP-900 overview