{"id":16504,"date":"2026-09-19T07:53:24","date_gmt":"2026-09-19T07:53:24","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=16504"},"modified":"2026-09-19T07:53:24","modified_gmt":"2026-09-19T07:53:24","slug":"microsoft-dp-420-practice-test-questions-and-exam-dumps-part5-q81-100","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/microsoft-dp-420-practice-test-questions-and-exam-dumps-part5-q81-100\/","title":{"rendered":"Microsoft DP-420 Practice Test Questions and Exam Dumps Part5 Q81-100"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><b>View Full <\/b><a href=\"https:\/\/www.examlabs.com\/dp-420-exam-dumps\"><b>Microsoft DP-420 Exam Dumps<\/b><\/a><b> and Practice Test Dumps.<\/b><\/p>\n<p><b><br \/>\n<\/b><b>Q1. You are designing a Cosmos DB workload where one set of queries is optimized by customer ID and another independent set is optimized by product ID. No single partition key satisfies both access patterns. What should you consider?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Use one constant partition key for all items.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Use separate containers or duplicated data models optimized for the different access patterns.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Disable partitioning.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Use TTL to switch partition keys automatically.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2. Use separate containers or duplicated data models optimized for the different access patterns.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Azure Cosmos DB supports one partition-key definition per container, so a single container cannot independently optimize unrelated access patterns that require fundamentally different partition keys. When two important workloads require different distribution and routing strategies, separate containers or denormalized projections can be appropriate. Change feed processing can help keep duplicated projections synchronized. A constant partition key creates severe scalability limits, TTL controls expiration rather than partitioning, and scalable Cosmos DB containers depend on partitioning. The correct design should be driven by access patterns, transaction boundaries, storage growth, and throughput distribution.<\/span><\/p>\n<p><b>Q2. You are creating a small development Cosmos DB account and want to minimize cost. Your Azure subscription has not previously used the Cosmos DB free tier. What should you evaluate during account creation?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Continuous backup only.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Multi-region writes.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Strong consistency.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Free tier eligibility.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4. Free tier eligibility.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Azure Cosmos DB free tier can provide a limited amount of throughput and storage at no charge for an eligible account, making it useful for development, learning, and smaller workloads. Eligibility and limits should be confirmed when the account is created because the option is subject to Azure subscription and account rules. Multi-region writes, strong consistency, and backup choices solve architectural requirements but do not by themselves minimize basic development costs. DP-420 candidates should understand how workload size, throughput mode, storage, global distribution, and available pricing options influence Cosmos DB cost planning.<\/span><\/p>\n<p><b>Q3. You are using the Cosmos DB SDK in an application that performs thousands of concurrent independent operations. You want to increase client-side parallelism without creating a new Cosmos client for every operation. What should you do?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Reuse the client and configure appropriate SDK parallelism or concurrency options.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Create one client for every document.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Disable all asynchronous operations.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Route every operation through a stored procedure.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1. Reuse the client and configure appropriate SDK parallelism or concurrency options.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Cosmos DB SDK clients are designed to be reused, and high-throughput applications should generally use asynchronous operations and suitable concurrency settings rather than repeatedly creating clients. Proper client-side threading and parallelism can improve throughput while preserving efficient connection reuse. Creating many clients increases resource consumption and can cause connection-management problems. Stored procedures are limited to transactional logic within a logical partition and are not a general replacement for scalable client concurrency. Applications should also consider bulk support, connection mode, partition distribution, and available RU\/s when tuning parallel execution.<\/span><\/p>\n<p><b>Q4. Documents in one container have different optional properties. You need a SQL query that returns items only when the <\/b><b>promotionCode<\/b><b> property exists. Which query capability is most appropriate?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Spatial querying.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Transactional Batch.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> A type or existence-checking function such as <\/span><span style=\"font-weight: 400;\">IS_DEFINED<\/span><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Continuous backup.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3. A type or existence-checking function such as <\/b><b>IS_DEFINED<\/b><b>.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Azure Cosmos DB for NoSQL supports flexible JSON schemas, so properties can be present in some documents and missing from others. A function such as <\/span><span style=\"font-weight: 400;\">IS_DEFINED<\/span><span style=\"font-weight: 400;\"> can test whether a property exists before additional logic is applied. This is useful for queries over variable-schema data and helps prevent assumptions that every item contains the same fields. Spatial functions operate on geographic data, Transactional Batch performs atomic operations within a logical partition, and continuous backup supports recovery. DP-420 candidates should be comfortable querying heterogeneous JSON documents using type-checking and existence functions.<\/span><\/p>\n<p><b>Q5. You need a query that returns the total number of orders and the average order amount for a selected customer. Which Cosmos DB SQL capability should you use?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Aggregate functions such as <\/span><span style=\"font-weight: 400;\">COUNT<\/span><span style=\"font-weight: 400;\"> and <\/span><span style=\"font-weight: 400;\">AVG<\/span><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> TTL.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Change feed leases.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Manual failover.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1. Aggregate functions such as <\/b><b>COUNT<\/b><b> and <\/b><b>AVG<\/b><b>.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Cosmos DB for NoSQL SQL supports aggregate functions such as COUNT, SUM, AVG, MIN, and MAX. These functions allow server-side aggregation of matching documents and can reduce the need to retrieve every item and calculate totals in application code. The query should ideally include the customer partition key when possible so execution can be routed efficiently. TTL controls expiration, change feed leases coordinate processors, and failover changes regional roles. Aggregation queries can still consume significant request units, so developers should inspect query cost and indexes when operating over large datasets.<\/span><\/p>\n<p><b>Q6. You operate a write-heavy Cosmos DB container. Most document properties are never used in filters, sorting, or projections that require indexing. Which indexing strategy should you evaluate?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Index every possible property with multiple composite indexes.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Add a unique key to every field.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Use strong consistency to reduce index writes.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Exclude unnecessary paths from the indexing policy.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4. Exclude unnecessary paths from the indexing policy.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Every indexed property adds index-maintenance work when documents are written or updated. In a write-heavy workload, excluding properties that are never queried can reduce indexing overhead and request-unit consumption. The indexing policy should still include paths required by important filters, ordering, or search patterns. Creating unnecessary composite indexes increases maintenance cost, while unique keys serve data-integrity requirements rather than general query optimization. Consistency level does not eliminate index maintenance. A well-designed write-heavy indexing policy balances efficient reads against the cost of maintaining indexes during frequent writes.<\/span><\/p>\n<p><b>Q7. A query scans many documents even though it returns only a small number of results. You want to determine whether the indexing policy could be improved. What should you review?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Only the account&#8217;s Azure region.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Query metrics and index utilization information.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> The backup retention period.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Only the document TTL.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2. Query metrics and index utilization information.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Query metrics provide insight into execution behavior and request-unit consumption, helping identify queries that inspect substantially more data than they return. Index-related diagnostics can indicate whether the indexing policy supports the query efficiently or whether a different policy or composite index could help. Region selection, TTL, and backup retention do not explain poor query selectivity or index usage. Query tuning should combine metrics, partition routing, predicate design, and indexing analysis. A query that is logically correct can still be expensive if it fans out across partitions or cannot use the index effectively.<\/span><\/p>\n<p><b>Q8. A multi-region Cosmos DB application experiences increased read latency from one Azure region. You need to determine whether replication behavior may be contributing. What should you monitor?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Only the number of unique keys.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Only item TTL values.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Replication and regional latency metrics.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Only composite-index definitions.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3. Replication and regional latency metrics.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> In globally distributed Cosmos DB accounts, latency can be influenced by regional connectivity, replication behavior, consistency settings, and application routing. Monitoring regional and replication-related metrics can help determine whether a particular region is experiencing delays or whether consistency requirements are affecting request behavior. Unique keys, TTL, and composite-index definitions do not explain regional replication latency. Troubleshooting should also consider preferred regions, SDK diagnostics, server-side latency, network latency, and failover configuration to distinguish database processing delays from client or network issues.<\/span><\/p>\n<p><b>Q9. Your organization does not require second-by-second point-in-time recovery but needs automatic backups at configured intervals. Which backup mode should you consider?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Change feed only.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Integrated cache.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Analytical store.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Periodic backup.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4. Periodic backup.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Periodic backup creates backups according to a defined schedule and retention configuration. It can be appropriate when recovery requirements do not demand fine-grained point-in-time restoration. Continuous backup is the option used when point-in-time restore within the supported retention window is required. Change feed is an event-processing mechanism, integrated cache improves read performance, and analytical store supports analytical workloads. Backup strategy should be selected based on recovery-point objectives, recovery-time expectations, operational requirements, and the impact of accidental deletion or corruption on the business.<\/span><\/p>\n<p><b>Q10. You are configuring periodic backup for a Cosmos DB account. Which two settings are directly relevant to how often backups are taken and how long they are retained?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Backup interval and retention period.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Partition key and unique key.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Session token and continuation token.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Conflict policy and TTL.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1. Backup interval and retention period.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Periodic backup configuration includes settings that determine how frequently backups are created and how long those backups are retained. These values influence the available recovery points and should align with organizational recovery requirements. Partition keys govern data distribution, while unique keys enforce constraints. Session and continuation tokens relate to consistency and query pagination. Conflict policies and TTL address multi-region writes and item expiration. Backup configuration should be treated as part of the application&#8217;s resilience plan and validated through documented restore procedures rather than assumed to work only when an incident occurs.<\/span><\/p>\n<p><b>Q11. You are using continuous backup and need to restore a database after an application defect corrupted data. What should you identify before initiating the restore?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> The item&#8217;s integrated-cache age.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> An appropriate restore point before the corruption occurred.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> The client&#8217;s session token.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> The current composite-index count.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2. An appropriate restore point before the corruption occurred.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Point-in-time restore requires selecting a restore point that predates the unwanted changes while minimizing loss of valid subsequent data. Operators should identify when corruption began and select an appropriate time within the supported continuous-backup retention window. Session tokens, integrated-cache age, and index counts do not determine recovery state. Recovery procedures should document how to locate valid restore points, restore databases or containers, validate restored data, and redirect applications when necessary. Choosing the wrong restore point can reintroduce corrupted data or unnecessarily lose later valid changes.<\/span><\/p>\n<p><b>Q12. A Fabric Warehouse contains historical analytical data replicated from Cosmos DB. You need to query the warehouse as it existed at an earlier point in time for investigation. Which capability should you use?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> TTL.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Manual regional failover.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Point reads.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Time travel in Microsoft Fabric Warehouse.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4. Time travel in Microsoft Fabric Warehouse.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Time travel in Fabric Warehouse allows supported analytical queries to access historical states of warehouse data, which can be valuable for auditing, investigation, and comparison. This is distinct from Cosmos DB operational point-in-time restore because time travel is an analytical warehouse capability rather than a transactional recovery operation. TTL deletes data automatically, manual failover changes regional write roles, and point reads retrieve current known items from Cosmos DB. DP-420 now includes analytical integration topics such as Fabric Mirroring and time-travel scenarios in Microsoft Fabric.<\/span><\/p>\n<p><b>Q13. A Spark job reads records from Cosmos DB, performs enrichment, and must write the transformed documents back to the transactional store. Which integration should you use?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Only Azure Monitor.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> A backup restore job.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Azure Cosmos DB Spark connector with write support.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> A sensitivity label.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3. Azure Cosmos DB Spark connector with write support.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> The Azure Cosmos DB Spark connector supports Spark-based interaction with the transactional store, including supported read and write operations. This makes it appropriate for distributed transformation jobs that must persist enriched or derived documents back to Cosmos DB. Azure Monitor is used for observability, backup restores recover data, and sensitivity labels are unrelated to transactional writes. When writing through Spark, the workload should still consider partition-key values, throughput, write concurrency, item sizes, and the potential impact on operational workloads.<\/span><\/p>\n<p><b>Q14. You need to delete one known item as efficiently as possible. You know its <\/b><b>id<\/b><b> and partition key value. Which operation should you use?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> A cross-partition SQL query followed by deletion.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> A point delete operation using the item ID and partition key.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> A change feed processor.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> A stored procedure that scans every partition.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2. A point delete operation using the item ID and partition key.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> When both an item&#8217;s ID and partition key are known, an SDK point delete can target the exact item directly. This avoids an unnecessary query and reduces request-unit cost and latency. Cross-partition scanning is inefficient for a known item, while the change feed is intended for processing changes rather than initiating deletion. A stored procedure is constrained to a logical partition and would still be excessive for deleting one known item. Efficient Cosmos DB application design uses point operations whenever item identity and routing information are available.<\/span><\/p>\n<p><b>Q15. A container has a default TTL of one hour. One document must remain for 24 hours instead. What should you do?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Set an item-level TTL value that overrides the container default.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Disable all indexing for the document.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Change the account consistency level.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Create another Azure region.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1. Set an item-level TTL value that overrides the container default.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> When TTL is enabled on the container, individual items can specify their own TTL value to override the default expiration interval. This is useful when most items share a common lifecycle but certain records must remain longer or expire sooner. Indexing, consistency, and regional distribution do not control an individual document&#8217;s expiration time. Item-level TTL allows lifecycle behavior to remain data-driven without requiring custom cleanup jobs or separate containers solely for different expiration periods.<\/span><\/p>\n<p><b>Q16. Your application writes documents with several properties that have very high cardinality, but only two are used in queries. You want to optimize a custom indexing policy for write performance. What should you do?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Add all high-cardinality paths to multiple composite indexes.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Disable the partition key.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Include the required query paths and exclude unused paths where appropriate.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Use strong consistency.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3. Include the required query paths and exclude unused paths where appropriate.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> A custom indexing policy can reduce write overhead by indexing only the properties needed for query patterns while excluding paths that are not queried. High-cardinality properties that are unnecessarily indexed can increase index maintenance cost during writes. However, removing an index from a path required by queries can make those queries unsupported or more expensive, so policies must be workload-driven. Partition keys and consistency settings address different architectural concerns. Index optimization should consider read frequency, write frequency, query predicates, ordering, and request-unit metrics.<\/span><\/p>\n<p><b>Q17. A production account experiences a rise in HTTP 5xx responses. Which Azure Monitor information should you review first?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Status-code and failure metrics together with server-side latency.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Only the number of stored procedures.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Only item TTL values.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Only the unique-key policy.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1. Status-code and failure metrics together with server-side latency.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> HTTP 5xx responses indicate server-side or service-related failures and should be investigated using failure metrics, status-code trends, server-side latency, resource logs, and SDK diagnostics. Reviewing these signals together can help determine whether failures are regional, transient, workload-specific, or associated with service processing. TTL values and unique-key policies do not explain general 5xx failures, and the number of stored procedures alone provides little diagnostic value. Production troubleshooting should correlate application logs with Cosmos DB metrics and diagnostics to establish both scope and likely cause.<\/span><\/p>\n<p><b>Q18. One logical partition receives most writes even though the overall container has sufficient RU\/s. What operational condition are you experiencing?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Backup saturation.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Session-token overflow.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Index-free querying.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> A hot partition.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4. A hot partition.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> A hot partition occurs when request-unit consumption is concentrated on a small subset of partition-key values or physical partitions. The account may have sufficient total throughput, yet requests targeting the overloaded partition can still be throttled. This typically indicates skewed access patterns or an unsuitable partition-key strategy. Monitoring per-partition throughput helps reveal the imbalance. Backup, session tokens, and indexing terminology do not describe this condition. Hot partitions are important because Cosmos DB scalability depends not only on total RU\/s but also on effective workload distribution.<\/span><\/p>\n<p><b>Q19. You want an automated notification when server-side latency exceeds an acceptable threshold. Which Azure capability should you configure?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Unique key policy.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Azure Monitor alert.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Transactional Batch.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> TTL.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2. Azure Monitor alert.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Azure Monitor alerts can evaluate Cosmos DB metrics such as server-side latency and trigger notifications or automated actions when configured conditions are met. Alert rules can use action groups to send email, invoke webhooks, trigger automation, or integrate with incident-management systems. Unique keys enforce data integrity, Transactional Batch provides atomic operations, and TTL controls expiration. Proactive alerts are essential for production monitoring because they allow operators to respond before sustained latency significantly affects end-user experience.<\/span><\/p>\n<p><b>Q20. Your security team needs to investigate potentially unauthorized Cosmos DB operations over the previous week. Where should operational logs be sent for centralized querying?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Integrated cache.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> Analytical store only.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> TTL history.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\"> A Log Analytics workspace through Azure Monitor diagnostic settings.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4. A Log Analytics workspace through Azure Monitor diagnostic settings.<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Azure Monitor diagnostic settings can route Cosmos DB resource logs to a Log Analytics workspace for centralized investigation using Kusto Query Language. This supports security analysis, troubleshooting, auditing, and correlation with logs from other Azure resources. Integrated cache is a performance feature, analytical store supports analytics over application data, and TTL does not maintain a general security audit history. Centralized logging is particularly useful when investigating suspicious access patterns or failures across multiple resources and time periods.<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; View Full Microsoft DP-420 Exam Dumps and Practice Test Dumps. Q1. You are designing a Cosmos DB workload where one set of queries is optimized by customer ID and another independent set is optimized by product ID. No single partition key satisfies both access patterns. What should you consider? Use one constant partition key [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16504"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=16504"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16504\/revisions"}],"predecessor-version":[{"id":16576,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16504\/revisions\/16576"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=16504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=16504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=16504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}