A global e-commerce platform stores orders and customer profiles in a single container. Orders are queried by customer ID, but also by order ID for order-tracking pages. Customer profiles are queried by customer ID. The platform has a hot partition problem on a few high-volume customers. Which partition key design best balances the need for point reads and distribution?

Use a fixed partition key of 'tenant' for all documents.

Use a synthetic partition key that combines customer ID and a hash suffix for orders, while keeping customer profiles partitioned by customer ID.

Use customer ID as the partition key for all documents.

Use order ID as the partition key for all documents.

What is the primary purpose of denormalizing data across multiple documents in Azure Cosmos DB?

To enforce referential integrity between related documents.

To reduce storage costs by eliminating duplicate data.

To avoid the need for joins and improve read performance.

To ensure that all documents have the same schema.

Microsoft Certified:Azure Cosmos DB Developer Specialty

Domain 1Objective 1

Design and Implement a Non-Relational Data Model for Azure Cosmos DB for NoSQL DP-420 Practice Questions (Page 6)

Part of the Design and implement data models domain, which makes up ~45% of our current practice bank. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~18–29 in this domain), expect 3–4 from this objective — we provide 27 practice questions to prepare you well beyond it. (estimate)

27questions here

6free pages

10concepts

Questions 26–27

26expert · hard
A global e-commerce platform stores orders and customer profiles in a single container. Orders are queried by customer ID, but also by order ID for order-tracking pages. Customer profiles are queried by customer ID. The platform has a hot partition problem on a few high-volume customers. Which partition key design best balances the need for point reads and distribution?
Select an answer first
27foundation · easy
What is the primary purpose of denormalizing data across multiple documents in Azure Cosmos DB?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DP-420

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-420” is a trademark of its owner, used for identification only.

Design and Implement a Non-Relational Data Model for Azure Cosmos DB for NoSQL DP-420 Practice Questions (Page 6)

Questions 26–27

What is the primary purpose of denormalizing data across multiple documents in Azure Cosmos DB?

Keep studying — Design and implement data models