DP-900 Describe Considerations for Non-Relational Data Practice Questions

Free DP-900 Describe Considerations for Non-Relational Data practice test questions

8 questions from this domain with answers and explanations - different from the samples on the main DP-900 page. Sign up free to practice the full set.

1. Question 1Describe Considerations for Non-Relational Data

   A social media company needs to store user profiles as JSON documents. Each profile can have different attributes depending on the user type (personal, business, creator). The application must support global distribution with single-digit millisecond read latency. Which Azure service is the best choice?

   • AAzure Table Storage
   • BAzure Cosmos DBCorrect
   • CAzure Blob Storage
   • DAzure SQL Database
   ✓ Correct answer: B

   Azure Cosmos DB is a globally distributed NoSQL database that stores JSON documents with automatic multi-region replication. It guarantees single-digit millisecond read latency at global scale and supports flexible schemas where different documents can have different attributes. For the social media scenario with varying user profile structures and global distribution requirements, Cosmos DB provides the performance, flexibility, and scalability needed.

   Why the other options are wrong

   • AAzure Table Storage is incorrect because while it supports key-value storage, it does not provide the single-digit millisecond latency globally or flexible JSON document support for complex user profiles.
   • CAzure Blob Storage is incorrect because it is object storage designed for large files, not for structured JSON document queries and global distribution.
   • DAzure SQL Database is incorrect because it requires fixed schemas and does not provide the same global distribution capabilities or single-digit millisecond latency across regions.
2. Question 2Describe Considerations for Non-Relational Data

   A web application stores user profile photos in Azure Blob Storage. The operations team wants to organize the photos into a two-level hierarchy, with a top-level grouping per year and virtual folders by month beneath it. In Azure Blob Storage, what is the highest-level organizational unit that directly holds blobs?

   • AStorage account
   • BBlob index
   • CResource group
   • DContainerCorrect
   ✓ Correct answer: D

   In Azure Blob Storage the hierarchy is storage account -> container -> blob. A container is the highest-level unit that directly holds blobs; every blob lives inside exactly one container, and a storage account can contain many containers. Blob Storage has no true nested folders, so a year/month structure is created with virtual folders - slashes in the blob name that tools display as a hierarchy - rather than real directories. The container therefore sits directly above the blobs, with virtual folders only a naming convention beneath it.

   Why the other options are wrong

   • AA storage account contains containers, and containers contain blobs organized into a flat namespace. While virtual folder hierarchies can be created within containers using naming conventions (like "year/month/photo.jpg"), the container itself is the organizational unit responsible for holding the actual blob objects. Storage account is incorrect because while the storage account is the parent resource that contains containers, the question specifically asks for the organizational unit that holds blobs; containers are the immediate holders of blobs.
   • BBlob index is incorrect because blob indexes are metadata tags applied to individual blobs for filtering and organization, not organizational containers that hold blobs.
   • CResource group is incorrect because it is an Azure-level organizational construct for managing related resources, not a Blob Storage-specific structure for organizing blobs within storage accounts.
3. Question 3Describe Considerations for Non-Relational Data

   Wingtip Toys needs to store product catalog data where each product can have a completely different set of attributes. For example, a toy might have age range and material, while a book might have author and page count. Which type of NoSQL data store is best suited for this scenario?

   • AA columnar database
   • BA document databaseCorrect
   • CA graph database
   • DA key-value store
   ✓ Correct answer: B

   Document databases excel at storing entities with varying schemas and attributes, making them perfect for product catalogs where different product types have completely different properties. Unlike relational databases that enforce schemas, document stores like MongoDB and Cosmos DB allow each document to have its own structure, enabling flexible attribute sets.

   Why the other options are wrong

   • AA columnar database is incorrect because columnar stores require predefined column schemas and are optimized for analytical queries on many rows, not flexible schema scenarios.
   • CA graph database is incorrect because graph databases optimize relationship traversal, not flexible attribute storage.
   • DA key-value store is incorrect because key-value stores do not support complex queries or filtering by different attributes within values.
4. Question 4Describe Considerations for Non-Relational Data

   Lucerne Publishing needs a simple key-value store in Azure to cache frequently accessed session data for their web application. Which Azure service is most appropriate?

   • AAzure Synapse Analytics
   • BAzure Data Lake Storage
   • CAzure Cache for RedisCorrect
   • DAzure SQL Database
   ✓ Correct answer: C

   Azure Cache for Redis is a fully managed, in-memory data store specifically designed for caching frequently accessed data with extremely low latency access patterns. It provides a key-value store model where you can store and retrieve session data using simple key lookups, making it ideal for web application session caching. Redis supports various data structures (strings, hashes, lists, sets, sorted sets) and offers sub-millisecond response times, making it perfect for high-performance caching scenarios where data needs to be accessed with minimal latency.

   Why the other options are wrong

   • AAzure Synapse Analytics is incorrect because it is a data warehouse and analytics service designed for complex analytical queries on large datasets, not for caching simple session data.
   • BAzure Data Lake Storage is incorrect because it is an object storage service for big data analytics, not optimized for fast key-value lookups or caching frequently accessed session data.
   • DAzure SQL Database is incorrect because it is a relational database optimized for transactional workloads and complex queries, not designed for the low-latency, high-throughput requirements of session caching.
5. Question 5Describe Considerations for Non-Relational Data

   In Azure Cosmos DB, a partition key determines how data is distributed across physical partitions for scalability.

   • ATrueCorrect
   • BFalse
   ✓ Correct answer: A

   True. In Azure Cosmos DB, the partition key is a critical design element that determines how data is logically and physically distributed across partitions. The partition key value is hashed to create a partition ID, which maps the data to specific physical partitions on backend servers. Selecting an appropriate partition key with high cardinality and even distribution is essential for achieving horizontal scalability and optimal performance, as it directly influences how evenly the workload and storage are distributed across the service.

   Why the other options are wrong

   • BFalse is incorrect. The statement is true. In Azure Cosmos DB, the partition key is a critical design element that determines how data is logically and physically distributed across partitions. The partition key value is hashed to create a partition ID, which maps the data to specific physical partitions on backend servers.
6. Question 6Describe Considerations for Non-Relational Data

   Azure Cosmos DB guarantees single-digit millisecond read and write latency at the 99th percentile when deployed with the proper consistency level.

   • ATrueCorrect
   • BFalse
   ✓ Correct answer: A

   Azure Cosmos DB is specifically architected to deliver single-digit millisecond latency for both read and write operations at the 99th percentile of requests. This latency guarantee is a core feature of the platform when configured with appropriate consistency levels such as eventual or session consistency. The database is designed with globally distributed architecture and optimized indexing to meet these strict performance requirements, making it suitable for latency-critical applications. This performance characteristic is measured across all operations and is a defining feature that differentiates Cosmos DB from other database solutions.

   Why the other options are wrong

   • BFalse is incorrect. The statement is true. Azure Cosmos DB is specifically architected to deliver single-digit millisecond latency for both read and write operations at the 99th percentile of requests. This latency guarantee is a core feature of the platform when configured with appropriate consistency levels such as eventual or session consistency.
7. Question 7Describe Considerations for Non-Relational Data

   A data engineer must move a 200 GB on-premises backup file into Azure Blob Storage as quickly and reliably as possible from a command line. Which tool is purpose-built for high-performance bulk uploads of blobs?

   • AAzCopyCorrect
   • BAzure Cosmos DB Data Explorer
   • CPower BI Desktop
   • DSQL Server Management Studio (SSMS)
   ✓ Correct answer: A

   AzCopy is a Microsoft command-line utility optimized for fast, resilient bulk transfer of blobs and files between local storage and Azure. It supports parallelism, resumable transfers, and large files, which makes it ideal for uploading a large backup file quickly and reliably.

   Why the other options are wrong

   • BCosmos DB Data Explorer manages documents in Cosmos DB, not blob uploads.
   • CPower BI Desktop is a data visualization and modeling tool, not a storage transfer utility.
   • DSSMS is used to administer SQL Server and Azure SQL databases, not to upload blobs to storage accounts.
8. Question 8Describe Considerations for Non-Relational Data

   Contoso wants to copy data written to a container in Azure Cosmos DB for NoSQL into an Azure Synapse Analytics environment for analytics, without affecting the performance of their transactional workload. Which Azure Cosmos DB capability is designed for this?

   • AAzure Synapse Link with the analytical storeCorrect
   • BMulti-region write (multi-master)
   • CAutoscale provisioned throughput
   • DSession consistency
   ✓ Correct answer: A

   Synapse Link automatically syncs data from the transactional (row-based) store into a separate column-based analytical store, which Azure Synapse Analytics can query. Because analytics run against the analytical store, the transactional workload's request units are not consumed, achieving hybrid transactional/analytical processing (HTAP) with no ETL.

   Why the other options are wrong

   • BMulti-region write lets multiple regions accept writes for low latency and availability; it does not provide an analytics-optimized store.
   • CAutoscale automatically adjusts provisioned RU/s to demand but is still the transactional store and does not isolate analytics.
   • DSession consistency is a read-consistency guarantee for a client session and has nothing to do with offloading analytics.

How Describe Considerations for Non-Relational Data is tested

This domain holds 137 of the 717 questions in the DP-900 bank, about 19%. The mix is 101 single-answer multiple choice, 16 multiple-response, 15 true/false, 2 yes/no scenario, 2 ordering and 1 hotspot, so it is worth practising the formats as well as the content.

Once you have a few attempts recorded, CertGrid scores every domain separately and points you at the weakest one, so you can drill Describe Considerations for Non-Relational Data on its own rather than re-running full-length mocks.

Other DP-900 exam domains

• Describe Core Data Concepts199 questions
• Identify Considerations for Relational Data177 questions
• Describe an Analytics Workload204 questions
• All DP-900 practice questions717 total
• Describe Considerations for Non-Relational Data study notesKey concepts
• Microsoft practice examsAll Microsoft

DP-900 Describe Considerations for Non-Relational Data FAQ