{"id":85091,"date":"2022-10-07T05:24:34","date_gmt":"2022-10-07T10:54:34","guid":{"rendered":"https:\/\/www.whizlabs.com\/blog\/?p=85091"},"modified":"2022-11-18T02:17:55","modified_gmt":"2022-11-18T07:47:55","slug":"dp-420-exam-questions","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/dp-420-exam-questions\/","title":{"rendered":"Top free exam questions on DP-420 Designing and Implementing Cloud-Native Applications"},"content":{"rendered":"<p>Are you looking for DP-420 exam questions and answers to prepare for the\u00a0 Designing and Implementing Cloud-Native Applications Using <a href=\"https:\/\/www.whizlabs.com\/microsoft-azure-certification-dp-420\/\" target=\"_blank\" rel=\"noopener\">Microsoft Azure Cosmos DB certification<\/a> exam?<\/p>\n<p>Here are our\u00a0<strong>newly updated 25+ <\/strong><strong>Free DP-420 exam questions<\/strong> which are very similar to the DP-420 practice test as well as the real exam.<\/p>\n<h3>Who this exam is intended for?<\/h3>\n<p>This DP-420 Microsoft azure cosmos DB exam is intended for software professionals those who want to show their skills and knowledge in designing and implementing solutions that use Azure Cosmos DB. The candidates who take this exam should have experience working with Azure Cosmos DB, including experience with the Azure portal, Azure Resource Manager, Cosmos DB SQL API, and Cosmos DB SDK.<\/p>\n<h3>Domains Covered in DP-420 exam questions<\/h3>\n<p>This DP-420 exam questions covers four domains as follows:<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Domain<\/strong><\/td>\n<td><strong>Weightage<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Implementing and designing the data models<\/td>\n<td>35-40%<\/td>\n<\/tr>\n<tr>\n<td>Implementing and designing the data distribution<\/td>\n<td>5-10%<\/td>\n<\/tr>\n<tr>\n<td>Integrating an Azure Cosmos DB Solution<\/td>\n<td>5-10%<\/td>\n<\/tr>\n<tr>\n<td>Optimizing an Azure Cosmos DB Solution<\/td>\n<td>15-20%<\/td>\n<\/tr>\n<tr>\n<td>Maintaining an Azure Cosmos DB Solution<\/td>\n<td>25-30%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>The DP-420 practice exam covers a range of topics, including how to provision and configure Cosmos DB databases, how to manage and monitor them, and how to troubleshoot common issues.<\/p>\n<h3>What skills will you gain by obtaining DP-420 Designing and Implementing Cloud-Native Applications certification exam?<\/h3>\n<p>This DP-420 exam is designed to help you learn the skills needed to design, build, and deploy cloud-native applications into an Azure Cosmos DB database. By taking this exam, you will gain the skills needed to:<\/p>\n<ul>\n<li>Creation of indexing policies,<\/li>\n<li>Manage and provisioned resources, and<\/li>\n<li>Performing common operations with the SDK.<\/li>\n<li>Design and deploy a cloud-native application<\/li>\n<li>Monitor and troubleshoot a cloud-native application<\/li>\n<li>Microservices architecture<\/li>\n<li>Continuous delivery and integration<\/li>\n<\/ul>\n<p><em>Let\u2019s start Learning!<\/em><\/p>\n<h4 style=\"text-align: center;\"><span style=\"color: #ff9900;\">Free DP- 420 <\/span><span style=\"color: #ff9900;\">Exam Questions on <\/span><span style=\"color: #ff9900;\">Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB<\/span><\/h4>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Design and implement a non-relational data model for Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 1.<\/strong> You are working on an app that will save the device metrics produced every minute by various IoT devices. You decide to collect the data for two entities; the devices and the device metrics produced by each device. You were about to create two containers for these identified entities but suddenly your data engineer suggests placing both entities in a single container, not in two different containers. What would you do?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Create a document with the deviceid property and other device data, and add a property called \u2018type\u2019 having the value \u2018device\u2019. Also, create another document for each metrics data collected using devicemetricsid property.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Create a document with the deviceid property and other device data. After that embed each metrics collection into the document with the devicemetricsid property and all the metrics data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Create a document with the deviceid property and other device data, and add a property called\u00a0\u201d<\/span><span style=\"font-weight: 400;\">type\u201d<\/span><span style=\"font-weight: 400;\">\u00a0with the value\u00a0\u2019<\/span><span style=\"font-weight: 400;\">device<\/span><span style=\"font-weight: 400;\">&#8216;. Create another document for each metrics data using the devicemetricsid and deviceid properties and add a property called\u00a0\u201d<\/span><span style=\"font-weight: 400;\">type\u201d<\/span><span style=\"font-weight: 400;\"> with the value\u00a0<\/span><span style=\"font-weight: 400;\">devicemetrics.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">None of these.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation<\/b><span style=\"font-weight: 400;\">: If you create two different types of documents including the property \u2018deviceid\u2019 for both entities, it will ease referencing both entities inside the container.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> Creating two types of documents but not including the deviceid for the device metrics document would make it impossible to reference the device actually referenced by the collected metrics.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. Embedding each metric data collected every minute would create high amounts of requests.<\/span><\/p>\n<p><b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> If you create two different types of documents including the property \u2018deviceid\u2019 for both entities, it will ease referencing both entities inside the container.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Option C is correct.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about storing multiple entities in a single cosmos DB collection, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/anthonychu.ca\/post\/cosmos-db-mongoose-discriminators\/\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/anthonychu.ca\/post\/cosmos-db-mongoose-discriminators\/<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Design and implement a non-relational data model for Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 2.<\/strong> The below diagram illustrates the configuration settings for a container in an Azure Cosmos DB Core (SQL) API account.<\/p>\n<p>Which of the following statements rightly describes the container\u2019s configuration?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">All the items will be deleted after 1 hour.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">All the items will be deleted after 1 month.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Items will be expired only if they have a time to live value.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Items stored in containers will get retained always, regardless of the time to live value of the items.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b> <span style=\"font-weight: 400;\">Time to live can be set on a container or an item within the container. The following figure illustrates the properties:<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. The deletion of the items depends upon the time to live value set on the item.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> The deletion of the items depends upon the time to live value set on the item.<\/span><\/p>\n<p><b>Option C is correct.<\/b> <span style=\"font-weight: 400;\">Items will be expired only if it has a time to live value.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. Items will get expired if it has a time to live value.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about Time to Live in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/time-to-live\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/time-to-live<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Design a data partitioning strategy for Azure Cosmos DB Core API<\/b><\/p>\n<p>Question 3. In a shared throughput database, the containers share the throughput (Request Units per Second) allocated to that database. In a manually provisioned throughput, it is possible to have up to \u2026\u2026\u2026\u2026 containers with a minimum \u2026\u2026\u2026\u2026\u2026. Request Units per second on the database.<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">15 and 400<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">25 and 400<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">15 and 4000<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">25 and 4000<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:<\/b> <span style=\"font-weight: 400;\">With manually provisioned throughput, there can be up to 25 (twenty-five) containers with a minimum of 400 Request Units per second on the database. On the other hand, with autoscale provisioned throughput, there can be up to twenty-five containers with an autoscale maximum of 4000 Request Units\/s (scaling b\/w 400 &#8211; 4000 Request Units per second).<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> You can have up to 25 containers, not only 15.<\/span><\/p>\n<p><b>Option B is correct<\/b><span style=\"font-weight: 400;\">. 25 containers with a minimum of 400 RU\/s is the right answer.<\/span><\/p>\n<p><b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> You can have up to 25 containers with a minimum of 400 RU\/s.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> You can have up to 25 containers a minimum of 400 RU\/s.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about provisioned throughput in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/set-throughput?WT.mc_id=ravikirans\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/set-throughput<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Plan and implement sizing and scaling for a database created with Azure Cosmos DB<\/b><\/p>\n<p><strong>Question 4.<\/strong> Storage1 is an Azure Cosmos DB Core (SQL) API account based on provisioned throughput capacity mode.<\/p>\n<p>The following table shows the databases contained by this account:<\/p>\n<p>And the below table demonstrates the containers contained by the databases:<\/p>\n<p>Here are two statements for the given scenario:<\/p>\n<p>Statement 1: You can add a new container that uses database throughput to db2.<\/p>\n<p>Statement 2: The maximum throughput that can be consumed by cn11 is 400 RU\/s.<\/p>\n<p>Which of the above statements are correct?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Only statement 1<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Only statement 2<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Both statement 1 and statement 2<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">None of the statement\u00a0<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> For db2, the maximum request units per second are 8000 and there are 8 containers in DB as can be seen from the above diagram; from cn11 to cn18. Therefore, the maximum throughput that can be consumed by each container is 1000 RU\/s. Moreover, as the throughput is 1000 RU\/s, the new container can be added easily.\u00a0<\/span><\/p>\n<p><b>Option A is correct.<\/b><span style=\"font-weight: 400;\"> A new container can be added to db2 that will use the database throughput.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. The maximum throughput that can be consumed by cn11 is not 400 RU\/s.<\/span><\/p>\n<p><b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> Statement 2 is incorrect.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Statement 1 is correct.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about Azure Cosmos DB pricing, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/cosmos-db\/\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/cosmos-db\/<\/span><\/a><\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Implement client connectivity options in the Azure Cosmos DB SDK<\/b><\/p>\n<p><strong>Question 5.<\/strong> While working in .NET SDK v3, you need to enable multi-region writes in your app that uses Azure Cosmos DB. WestUS2 is the region where your application would be deployed and Cosmos DB is replicated.<\/p>\n<p>Which of the following attributes would you set to WestUS2 to achieve the goal?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ApplicationRegion<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SetCurrentLocation<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">setPreferredLocations<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">connection_policy.PreferredLocations<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">In .NET SDK v3, <\/span><span style=\"font-weight: 400;\">if you want to enable multi-region writes in your application, set\u00a0<\/span><span style=\"font-weight: 400;\">ApplicationRegion<\/span><span style=\"font-weight: 400;\">\u00a0to the region where the application is being deployed and Cosmos DB is replicated:<\/span><\/p>\n<p><b>Option A is correct.<\/b><span style=\"font-weight: 400;\"> ApplicationRegion is the correct answer.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\">\u00a0 SetCurrentLocation is used in .NET SDK v2.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">.\u00a0 setPreferredLocations is used in Async Java V2 SDK.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Connection_policy.PreferredLocations is used in Python SDK.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about multi-region writes in your applications, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/bs-latn-ba\/azure\/cosmos-db\/sql\/how-to-multi-master\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/bs-latn-ba\/azure\/cosmos-db\/sql\/how-to-multi-master<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Implement client connectivity options in the Azure Cosmos DB SDK<\/b><\/p>\n<p><strong>Question 6.<\/strong> While chairing a team session, you are telling the team members about the Azure Cosmos DB Emulator. Which of the following statement is not true about Azure Cosmos DB Emulator?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Azure Cosmos DB Emulator offers an emulated environment that would run on the local developer workstation.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The emulator does support only a single fixed account and a familiar primary key. You can even regenerate the key while utilizing the Azure Cosmos DB Emulator.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The emulator doesn\u2019t offer\u00a0multi-region replication.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The emulator doesn\u2019t offer various Azure Cosmos DB consistency levels\u00a0as offered by the cloud service.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> The following diagram <\/span><span style=\"font-weight: 400;\">states the differences in functionality between the emulator and an Azure Cosmos account in the cloud:<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\">\u00a0 <\/span><span style=\"font-weight: 400;\">Azure Cosmos DB Emulator really offers an emulated environment that would run on the local developer workstation.<\/span><\/p>\n<p><b>Option B is correct.<\/b><span style=\"font-weight: 400;\"> The emulator does support only a single fixed account and a familiar primary key but you can\u2019t regenerate the key while utilizing the Azure Cosmos DB Emulator.<\/span><\/p>\n<p><b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> The statement \u201c<\/span><span style=\"font-weight: 400;\">The emulator doesn\u2019t offer\u00a0multi-region replication\u201d is true.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\">\u00a0 The statement \u201cThe emulator doesn\u2019t offer various Azure Cosmos DB consistency levels\u00a0as offered by the cloud service\u201d is also true.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about Installing and using the Azure Cosmos DB Emulator for local development and testing, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/local-emulator?WT.mc_id=ravikirans&amp;tabs=ssl-netstd21\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/local-emulator<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Implement data access by using the Azure Cosmos DB SQL language<\/b><\/p>\n<p><strong>Question 7.<\/strong> You are having an index policy as shown in the following diagram:<\/p>\n<p>You need to create an SQL query with an ORDER BY statement. Which of the following ORDER BY statements will execute successfully while creating the query?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ORDER BY c.age ASC, c.name ASC<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ORDER BY c.age DESC, c.name DESC<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ORDER BY c.name ASC, c.age DESC<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ORDER BY c.name DESC, c.age ASC<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ORDER BY c.name DESC, c.age DESC<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: E<\/b><\/p>\n<p><b>Explanation<\/b><span style=\"font-weight: 400;\">: SQL <\/span><span style=\"font-weight: 400;\">Queries having an ORDER BY clause with two or more properties needs a composite index. While using a composite index for such queries, here are a few considerations that need to be taken care of:\u00a0<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\"> Composite index won\u2019t support the query if the composite index paths don\u2019t match the sequence of the properties in the ORDER BY clause.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> The order of composite index paths (descending or ascending) should also match the order in the ORDER BY clause.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> The composite index also supports an ORDER BY clause with the opposite order on all paths.<\/span><\/li>\n<\/ul>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> As per the above consideration, the given statement won\u2019t run successfully.\u00a0<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. Due to the non-matching of the sequence of properties, the given statement won&#8217;t run successfully.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. The order needs to be the same.\u00a0<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. The order needs to be the same.<\/span><\/p>\n<p><b>Option E is correct.<\/b><span style=\"font-weight: 400;\"> The given statement meets all the above considerations and therefore will run successfully.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about index policy, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/index-policy\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/index-policy<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Implement server-side programming in Azure Cosmos DB Core API by using JavaScript<\/b><\/p>\n<p><strong>Question 8.<\/strong> Your development team has written a validation logic in JavaScript to ensure that the items are in the said format before committing them to a container.<\/p>\n<p>One of your friends suggests using post-trigger as a server-side programming construct for this task.<\/p>\n<p>Will the suggested solution meet the goal?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Yes<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">No<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> A post-trigger will run its logic too late after the item has already been committed to the container. Therefore, using the post-trigger won\u2019t work. Instead, a pre-trigger should be used as a pre-trigger will run its logic prior to the item being committed to the container. Any validation logic can be executed at this point.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about triggers in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/how-to-write-stored-procedures-triggers-udfs?tabs=javascript#triggers\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/how-to-write-stored-procedures-triggers-udfs<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Distribution<\/b><\/p>\n<p><b>Subdomain: Design and implement a replication strategy for Azure Cosmos DB<\/b><\/p>\n<p><strong>Question 9.<\/strong> \u00a0You need to configure the consistency levels on a per-request basis. Which of the following C# class would you use in the .NET SDK for Azure Cosmos DB SQL API?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">CosmosClientOptions<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">CosmosConfigOptions<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ItemRequestOptions<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Container<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation<\/b><span style=\"font-weight: 400;\">: <\/span><span style=\"font-weight: 400;\">The\u00a0<\/span><b>ItemRequestOptions\u00a0<\/b><span style=\"font-weight: 400;\">class contains various session token and consistency level configuration properties on a per-request basis.<\/span><\/p>\n<p><b>Option A is incorrect. <\/b><span style=\"font-weight: 400;\">CosmosClientOptions class configures the overall client used in the SDK in several operations.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. <\/span><span style=\"font-weight: 400;\">CosmosConfigOptions isn\u2019t a valid class.<\/span><\/p>\n<p><b>Option C is correct<\/b><b>. <\/b><span style=\"font-weight: 400;\">The\u00a0<\/span><span style=\"font-weight: 400;\">ItemRequestOptions<\/span><span style=\"font-weight: 400;\">\u00a0class includes several properties to configure per-request options.<\/span><\/p>\n<p><b>Option D is incorrect. <\/b><span style=\"font-weight: 400;\">The Container class has methods for performing operations on a container but does not provide any way to configure per-request options.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: To know more about how to configure consistency models, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/microsoftlearning.github.io\/dp-420-cosmos-db-dev\/instructions\/21-sdk-consistency-model.html\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/microsoftlearning.github.io\/dp-420-cosmos-db-dev\/instructions\/21-sdk-consistency-model.html<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Integrate an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Enable Azure Cosmos DB analytical workloads<\/b><\/p>\n<p><strong>Question 10.<\/strong> Which of the following function in Spark SQL separates the array\u2019s elements into multiple rows with positions and utilizes the column names \u2018pos\u2019 for position and \u2018col\u2019 for elements of the array?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">explode()<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">posexplode()<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">preexplode()<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Separate()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> posexplode() is a function in Spark SQL that separates <\/span><span style=\"font-weight: 400;\">the array\u2019s elements into multiple rows with positions and utilizes the column names pos for position and col for elements of the array.<\/span><\/p>\n<p><b>Option A is incorrect. <\/b><span style=\"font-weight: 400;\">explode() function separates the array\u2019s elements into many rows and utilizes the default column name array\u2019s elements.<\/span><\/p>\n<p><b>Option B is correct<\/b><span style=\"font-weight: 400;\">. <\/span><span style=\"font-weight: 400;\">posexplode() is a function in Spark SQL that separates <\/span><span style=\"font-weight: 400;\">the array\u2019s elements into multiple rows with positions and utilizes the column names pos for position and col for elements of the array.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. Preexplode() is not the right function.<\/span><\/p>\n<p><b>Option D is incorrect. <\/b><span style=\"font-weight: 400;\">Separate() is not a right function.\u00a0<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: To know more about performing complex queries with JSON data, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/query-azure-cosmos-db-with-apache-spark-for-azure-synapse-analytics\/5-perform-complex-queries\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/query-azure-cosmos-db-with-apache-spark-for-azure-synapse-analytics\/5-perform-complex-queries<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Optimize an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Optimize query performance in Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 11.<\/strong> An Azure Cosmos DB Core (SQL) API account has a container that stores telemetry data from IoT devices. The container utilizes telemetryId as the partition key and has a throughput of 1000 RU\/s (request units per second). Data is submitted by approx 5000 IoT devices by using the same telemetryId value every 5 minutes.<\/p>\n<p>You have an app that does analytics on the data and reads telemetry data frequently for a single IoT device to have the trend analysis.<\/p>\n<p>The below figure demonstrates the sample of a document in the container:<\/p>\n<p>What would you do for reducing the number of RUs consumed by the analytics app?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enhance the offerThroughput value for the container.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Decrease the offerThroughput value for the container.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Move the data to a new container that utilizes a partition key of date.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Move the data to a new container that contains a partition key of deviceId.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation:<\/b> <span style=\"font-weight: 400;\">The partition key determines how data is routed in the different partitions by Cosmos DB and should make sense in the context of the specified scenario. For IoT applications, DeviceId is the typical &#8220;natural&#8221; partition key.<\/span><\/p>\n<p><b>Option A is incorrect. <\/b><span style=\"font-weight: 400;\">Increasing the offerThroughput value is not the right answer.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. Decreasing the offerThroughput value won\u2019t meet the goal.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">.\u00a0 DeviceId is the typical &#8220;natural&#8221; partition key for IoT applications.<\/span><\/p>\n<p><b>Option D is correct<\/b><span style=\"font-weight: 400;\">. Moving the data to a new container that contains a partition key of deviceId will result in reducing the number of RUs consumed by the analytics app.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: To know more about Azure Cosmos DB in IoT workloads, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/architecture\/solution-ideas\/articles\/iot-using-cosmos-db\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/architecture\/solution-ideas\/articles\/iot-using-cosmos-db<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Optimize an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Optimize query performance in Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 12.<\/strong> One of the team members has recently joined the team and wants to manually adjust the time for which the items will remain in the cache.\u00a0 He asks you for help about which property from the ItemRequestOptions\u00a0class should he configure. What would you suggest?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ConsistencyLevel<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SessionToken<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">MaxIntegratedCacheStaleness<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">None of these<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b> <b>\u00a0<\/b><span style=\"font-weight: 400;\">MaxIntegratedCacheStaleness\u00a0indicates the maximum acceptable staleness for the cached queries and point reads, irrespective of the selected consistency. This property is set to configure a\u00a0<\/span><span style=\"font-weight: 400;\">TimeSpan<\/span><span style=\"font-weight: 400;\">\u00a0that will be used to limit how long items will remain in the cache.\u00a0<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> Setting the consistency level correctly is a part of enabling the integrated cache, but it doesn\u2019t affect the time items remain in the cache.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Getting the session token won\u2019t affect the time items remain in the cache.<\/span><\/p>\n<p><b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> MaxIntegratedCacheStaleness property is set to configure a TimeSpan that will be used to limit how long items will remain in the cache.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. MaxIntegratedCacheStaleness property is the right property to set for the said purpose.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know about MaxIntegratedCacheStaleness in detail, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/integrated-cache\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/integrated-cache<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Optimize an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Design and implement change feeds for an Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 13.<\/strong> You are having an Azure Cosmos DB Core (SQL) API account that has three containers as demonstrated in the below table.<\/p>\n<p>Fn1, Fn2, and Fn3 are three Azure functions that read the change feed from cn1, cn2, and cn3 respectively.<\/p>\n<p>Now, you perform the below three actions:<\/p>\n<ul>\n<li>Delete item item1 from container cn1.<\/li>\n<li>Update item item2 from container cn2.<\/li>\n<li>For item item3 in container cn3, update the item TTL ( time to live to) 3,600 seconds.<\/li>\n<\/ul>\n<p>Consider three statements for the given scenario:<\/p>\n<p>Statement 1: Fn1 will receive an item1 from the change feed.<\/p>\n<p>Statement 2: Fn2 can check the _etag of an item2 to view whether the item is an insert or update.<\/p>\n<p>Statement 3: Fn3 will receive item3 from the change feed.<\/p>\n<p>Which of the above statements are true?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Only statement 1<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Only statement 2<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Only statement 3<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Only statement 1 and statement 2<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Only statement 2 and statement 3<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">All of the statements<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> The change feed doesn\u2019t capture the deletes. If an item is deleted from the container, it also gets removed from the change feed. The easiest method to handle this is to add a soft marker upon the items that are being deleted. You can even add a property known as &#8220;deleted&#8221; and assign it the value &#8220;true&#8221; while deleting. This document update will be shown up in the change feed. A TTL can be set on this item to make it automatically delete later.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. Statement 1 is incorrect as the change feed doesn&#8217;t capture deletes.\u00a0<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. Statement 2 is also incorrect as <\/span><span style=\"font-weight: 400;\">the _etag format is internal and you shouldn\u2019t be dependable upon it as it can change anytime.<\/span><\/p>\n<p><b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> Statement 3 is the only statement that is correct as the Change feed listens an Azure Cosmos container for any modifications or changes.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. Both statements 1 and 2 are incorrect.<\/span><\/p>\n<p><b>Option E is incorrect.<\/b><span style=\"font-weight: 400;\"> Only statement 3 is correct.<\/span><\/p>\n<p><b>Option F is incorrect<\/b><span style=\"font-weight: 400;\">. Only statement 3 is correct.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about change feed in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/change-feed\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/change-feed<\/span><\/a><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/change-feed-design-patterns\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/change-feed-design-patterns<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Optimize an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Design and implement change feeds for an Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 14.<\/strong> Which of the following method of the<span style=\"font-weight: 400;\">\u00a0<\/span>ChangeFeedProcessor<span style=\"font-weight: 400;\">\u00a0<\/span>class is invoked to start consuming changes from the change feed?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">StartAsync<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">GetChangeFeedProcessorBuilder&lt;&gt;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Build<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">None of these<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><span style=\"font-weight: 400;\">: StartAsync is a method in the\u00a0<\/span><i><span style=\"font-weight: 400;\">ChangeFeedProcessor<\/span><\/i><i><span style=\"font-weight: 400;\">\u00a0<\/span><\/i><span style=\"font-weight: 400;\">class and is invoked to start consuming changes from the change feed.<\/span><\/p>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\">. StartAsync is a method in the<\/span><i><span style=\"font-weight: 400;\">\u00a0<\/span><\/i><i><span style=\"font-weight: 400;\">ChangeFeedProcessor<\/span><\/i><span style=\"font-weight: 400;\">\u00a0class and is invoked to start consuming changes from the change feed.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. The given is a method of\u00a0<\/span><i><span style=\"font-weight: 400;\">Container<\/span><\/i><span style=\"font-weight: 400;\">\u00a0class that creates the builder to eventually build a change feed processor.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. The build method is invoked at the end of creating a change feed processor (or estimator) and isn&#8217;t a method of the <\/span><i><span style=\"font-weight: 400;\">ChangeFeedProcessor<\/span><\/i><i><span style=\"font-weight: 400;\">\u00a0<\/span><\/i><span style=\"font-weight: 400;\">class.<\/span><\/p>\n<p><b>Option D is incorrect. <\/b><span style=\"font-weight: 400;\">StartAsync is the correct answer.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: To know more about the change feed processor in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/change-feed-processor\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/change-feed-processor<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Optimize an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Define and implement an indexing strategy for an Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 15.<\/strong> While defining a custom index policy, which of the following path expression can be used to define an included path that will include all possible properties from the root of any JSON document?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\/[]<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\/?<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\/*<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\/()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> The property path can be defined with the below-given additions:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">a path that leads to a scalar value (number or string) ends with\u00a0\/?<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The elements from an array are addressed together through the\u00a0\/[]\u00a0notation (instead of\u00a0\/1\u00a0, \/0\u00a0 etc.)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Wildcard \/* can be utilized to match any elements below the referenced node.<\/span><\/li>\n<\/ul>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. The array operator is exclusively used to address multiple elements together.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> The scalar operator is used strictly for the number or string values at the current node.<\/span><\/p>\n<p><b>Option C is correct<\/b><span style=\"font-weight: 400;\">. The wildcard operator is used to match any elements below the referenced node.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. \/() is not the valid option.\u00a0<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about property paths, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/index-policy\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/index-policy<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Maintain an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Monitor and troubleshoot an Azure Cosmos DB solution<\/b><\/p>\n<p><strong>Question 16.<\/strong> In the Azure portal, which of the following tab inside the Insights pane demonstrates the percentage (%) of successful requests over the total requests per hour?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Storage<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Requests<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">System<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Availability<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">The availability tab demonstrates the % of successful requests out of the total requests per hour. Azure Cosmos DB SLAs define the success rate.<\/span><\/p>\n<p><b>Option A is incorrect. <\/b><span style=\"font-weight: 400;\">The storage tab demonstrates<\/span> <span style=\"font-weight: 400;\">the size of data and index usage over the specific time period.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. The requests tab demonstrates the total number of requests processed by operation type, by status code, and the count of failed requests.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. It demonstrates the number of metadata requests served by the primary partition.\u00a0<\/span><\/p>\n<p><b>Option D is correct.<\/b> <span style=\"font-weight: 400;\">The availability tab demonstrates the % of successful requests out of the total requests per hour.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about how to monitor and debug with insights in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/hi-in\/azure\/cosmos-db\/use-metrics\" target=\"_blank\" rel=\"nofollow noopener\"><b>https:\/\/docs.microsoft.com\/hi-in\/azure\/cosmos-db\/use-metrics<\/b><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Maintain an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Implement backup and restore for an Azure Cosmos DB solution<\/b><\/p>\n<p><strong>Question 17.<\/strong> There is a database in an Azure Cosmos DB Core (SQL) API account which is backed up every two hours.<\/p>\n<p>You have been asked to implement a solution that will support point-in-time restore. Which of the following thing would you perform first?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Configuring the backup and restore settings for the account<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enabling the continuous backup for the account<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Configuring the Point In Time Restore settings for the account<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Creating a new account having a periodic backup policy<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> While creating a new Azure Cosmos DB account, go to the Backup policy tab and select continuous mode to enable the point-in-time restore feature for the new account. With this restore functionality, data is restored to a new account, currently, it doesn&#8217;t allow restoring the data to an existing account.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. First, you need to enable continuous backup for the account.<\/span><\/p>\n<p><b>Option B is correct. <\/b><span style=\"font-weight: 400;\">Enabling the continuous backup for the account is the first thing you need to perform to meet the goal.\u00a0<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. To enable the Point In Time Restore settings for the account, you need to first go to the Backup policy tab and select continuous mode.\u00a0<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. You need to create a new account with the continuous backup policy.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the point in time restore, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/provision-account-continuous-backup\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/provision-account-continuous-backup<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Maintain an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Implement security for an Azure Cosmos DB solution<\/b><\/p>\n<p><strong>Question 18.<\/strong> Your Azure Cosmos DB Core (SQL) API account contains a database. You need to create an Azure function that would access the database for retrieving the records based upon a variable known as the account number.<\/p>\n<p>You need to ensure that the provided solution protects against SQL injection attacks.<\/p>\n<p>How would you write the command statement in the Azure function?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cmd= \u201cSELECT * FROM Employees e where e.accountnumber= \u2018accountnumber\u2019\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0cmd= \u201cSELECT * FROM Employees e where e.accountnumber= @accountnumber\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cmd= \u201cSELECT * FROM Employees e where e.accountnumber= LIKE @accountnumber\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cmd= \u201cSELECT * FROM Employees e where e.accountnumber= \u2018 \u201c +accountnumber+\u201d \u2019 \u201d<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Azure Cosmos DB supports writing queries with parameters with @ notation. Parameterized SQL offers robust handling and escaping of user input, and avoids accidental exposure of data through SQL injection.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> The given query doesn&#8217;t protect from SQL injection attacks.<\/span><\/p>\n<p><b>Option B is correct<\/b><span style=\"font-weight: 400;\">. Parameterized SQL protects against SQL injection attacks.<\/span><\/p>\n<p><b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> The given query won&#8217;t protect from SQL injection attacks.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Parameterized SQL queries with @ notation protect against SQL injection.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about parameterized queries in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/sql-query-parameterized-queries\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/sql-query-parameterized-queries<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Maintain an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Implement data movement for an Azure Cosmos DB solution<\/b><\/p>\n<p><strong>Question 19.<\/strong> The Azure Cosmos DB (SQL API) connector supports various authentication types like Key authentication, Service principal authentication, System-assigned managed identity authentication and User-assigned managed identity authentication.<\/p>\n<p>Consider the following statements regarding these types:<\/p>\n<p>Statement 1: The service principal authentication is currently supported in the data flow.<\/p>\n<p>Statement 2: The system-assigned managed identity authentication is currently supported in the data flow.<\/p>\n<p>Statement 3: The user-assigned managed identity authentication isn\u2019t currently supported in the data flow.<\/p>\n<p>Which of the above statements are true?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Statement 1 only<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Statement 2 only<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Statement 3 only<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Statement 1 and statement 2 only<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Statement 2 and statement 3 only<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">All the three statements<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> Currently, all the three authentication types i.e service principal authentication, system-assigned managed identity authentication, and user-assigned managed identity authentication are not supported in the data flow.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> Statement 1 is incorrect.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. Statement 2 is not true.<\/span><\/p>\n<p><b>Option C is correct<\/b><span style=\"font-weight: 400;\">. Out of the given statements, only statement 3 is true.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. Both statements 1 and 2 are not true.<\/span><\/p>\n<p><b>Option E is incorrect<\/b><span style=\"font-weight: 400;\">. Only statement 3 is correct. Statement 2 is not true.<\/span><\/p>\n<p><b>Option F is incorrect.<\/b><span style=\"font-weight: 400;\"> Only statement 3 is true.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about Copy and transforming data in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/connector-azure-cosmos-db\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/connector-azure-cosmos-db<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Maintain an Azure Cosmos DB Solution<\/b><\/p>\n<p><b>Subdomain: Implement a DevOps process for an Azure Cosmos DB solution<\/b><\/p>\n<p><strong>Question 20.<\/strong> You want to disable all indexing for a container in Azure Cosmos Database. Which of the following property of the indexing policy would help you in meeting the goal?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">excludedPaths<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">includedPath<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">automatic\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">indexingMode<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> None and consistent are two indexing modes supported by Azure Cosmos DB. If you set the indexingMode\u00a0property to\u00a0none, it disables all indexing.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. The\u00a0excludedPaths\u00a0property specifies the paths that will be excluded from the index. It says nothing about the running of the indexer.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. The\u00a0includedPaths\u00a0property specifies the paths that will be included in the index. It says nothing about the running of the indexer.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. If you disable the\u00a0automatic\u00a0indexing by assigning it a value as false, it won\u2019t disable all indexing for the container.<\/span><\/p>\n<p><b>Option D is correct.<\/b><span style=\"font-weight: 400;\"> Setting the indexing mode\u00a0property to\u00a0none\u00a0disables all indexing.<\/span><\/p>\n<p><b>References:<\/b><span style=\"font-weight: 400;\"> To know more about various properties in Indexing in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/azurecosmosdb.github.io\/labs\/dotnet\/labs\/04-indexing_in_cosmosdb.html?WT.mc_id=ravikirans\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/azurecosmosdb.github.io\/labs\/dotnet\/labs\/04-indexing_in_cosmosdb.html<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Design and implement a non-relational data model for Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 21.<\/strong> There is a database in an Azure Cosmos DB Core (SQL) API account. You have been asked to create a container that will store employee data for 2500 small businesses. Every business is supposed to have up to 30 employees and every employee will have an email_Address value.<\/p>\n<p>You will have to ensure the uniqueness of the email_Address value for every employee within the same company.<\/p>\n<p>Which of the following fields would you set as the partition key and the unique key respectively?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Company_ID and Email_Address<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Email_Address and Company_ID<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Employee_ID and Email_Address<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Email_Address and Employee_ID<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> After a container is created with a unique key condition, as per the unique key constraint, it will prevent creating any such new item or updating an existing value or item that will result in duplicity inside a logical partition. When you combine the partition key with the unique key, it guarantees that the item will be unique within the container\u2019s scope.<\/span><\/p>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\">. For an Azure Cosmos container with Company_ID as the partition key and Email_address as the unique key constraint, when the email address of a user is configured using a unique key, every item will have a unique email_address within the specific Company_ID. You can&#8217;t create two items with the same email addresses using the same Company_ID.<\/span><\/p>\n<p><b>Option B is incorrect. <\/b><span style=\"font-weight: 400;\">Company_ID must be the partition key whereas Email_Address must be the unique key.<\/span><\/p>\n<p><b>Option C is incorrect. <\/b><span style=\"font-weight: 400;\">Employee_ID and Email_Address are not the given option.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. Email_Address and Employee_ID are not the right answers.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: To know more about unique keys and partition keys, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/unique-keys\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/unique-keys<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Design and implement a non-relational data model for Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 22.<\/strong> Your development team already has an existing Azure Cosmos DB account, database, and container. One of the senior executives asks you to configure Azure Cosmos DB for another team with unique and different needs for regional replication and default consistency levels.<\/p>\n<p>Which of the following new sources would you create?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Database<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Container<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Account<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">There is no need to create a new source<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b> <span style=\"font-weight: 400;\">The replication settings and default consistency level configured on a cosmos account apply to all Cosmos databases and containers under that account. <\/span><span style=\"font-weight: 400;\">As per the scenario, another team has unique needs <\/span><span style=\"font-weight: 400;\">for regional replication and default consistency levels. <\/span><span style=\"font-weight: 400;\">To support the different behavior for replication and default consistency levels, there is a need to create a new account.\u00a0<\/span><\/p>\n<p><b>Option A is incorrect. <\/b><span style=\"font-weight: 400;\">If you create a new container, the global replication settings and default consistency level will remain the same between both teams.<\/span><\/p>\n<p><b>Option B is incorrect. <\/b><span style=\"font-weight: 400;\">If you create a new database, the global replication settings and default consistency level will remain the same between both teams.<\/span><\/p>\n<p><b>Option C is correct<\/b><span style=\"font-weight: 400;\">. To support different behavior for replication and default consistency levels, you must create a new account.<\/span><\/p>\n<p><b>Option D is incorrect. <\/b><span style=\"font-weight: 400;\">You will have to create a new account.<\/span><\/p>\n<p><b>Reference:\u00a0 <\/b><span style=\"font-weight: 400;\">To know more about Consistency levels in Azure Cosmos DB, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/consistency-levels\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/consistency-levels<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Design a data partitioning strategy for Azure Cosmos DB Core API<\/b><\/p>\n<p><strong>Question 23.<\/strong> You need to design an Azure Cosmos DB SQL API solution for storing the data from various IoT (Internet of Things) devices. The Writes from these devices will occur each second.<\/p>\n<p>Below is a data sample<span style=\"font-weight: 400;\">.<\/span><\/p>\n<p>You are required to choose a partition key which will meet all the below-mentioned writes requirements:<\/p>\n<ul>\n<li aria-level=\"1\">Avoids hot partitions<\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\">Avoids capacity limits<\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\">Decreases the partition skew<\/li>\n<\/ul>\n<p>What would you prefer?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Creating a new synthetic key containing deviceId and a random number<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Creating a new synthetic key containing deviceId and a devicemanufacturer<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Creating a new synthetic key containing deviceId and sensor1value<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use timestamp as the partition key<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> More evenly workload distribution is all about appending a random number to the value of partition key. When items are distributed in this style, it allows performing write operations in parallel across partitions.<\/span><\/p>\n<p><b>Option A is correct.<\/b><span style=\"font-weight: 400;\"> Creating a new synthetic key containing deviceId and a random number is the right answer.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> All the devices might have the same manufacturer. Therefore, creating a new synthetic key that contains deviceId and a devicemanufacturer is not the right answer.<\/span><\/p>\n<p><b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> \u00a0Senser1Value has only two values.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> You won\u2019t like partitioning the data on timestamp, as it will result in creating hot partitions. Suppose, the data is partitioned on time, in this case, for a specific minute, all write calls might hit only 1 partition. If you want to get the data for a client, it will result in a fan-out query as data might be distributed across all partitions.\u00a0<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about synthetic partition keys, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/synthetic-partition-keys\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql\/synthetic-partition-keys<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Plan and implement sizing and scaling for a database created with Azure Cosmos DB<\/b><\/p>\n<p><strong>Question 24.<\/strong> The web development team of the company successfully estimates the throughput needs of your app within a 5% margin of error, with no significant variances over time. While running the app in production, the team reckons that your workload would be extraordinarily stable.<\/p>\n<p>With both these inputs, which of the following throughput options would you consider?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Serverless<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Standard<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Autoscale<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Hybrid<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: <\/b><span style=\"font-weight: 400;\">B<\/span><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">Standard throughput is well-suited for workloads with steady traffic. It needs a static number of RUs to be assigned ahead of time. Whereas the Autoscale throughput suits better for unpredictable traffic.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. Serverless is a better option for workloads with widely varying traffic and low average-to-peak traffic ratios.<\/span><\/p>\n<p><b>Option B is correct.<\/b><span style=\"font-weight: 400;\"> Standard throughput suits best for workloads with steady traffic as expected in the given scenario.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. Autoscale throughput suits best for unpredictable traffic.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. Hybrid is not a valid throughput option.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about standard throughput, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/how-to-choose-offer\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/how-to-choose-offer<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Domain: Design and Implement Data Models<\/b><\/p>\n<p><b>Subdomain: Implement client connectivity options in the Azure Cosmos DB SDK<\/b><\/p>\n<p><strong>Question 25.<\/strong> Gateway mode using the dedicated gateway is one of the ways to connect to an Azure Cosmos DB Account. Which statement is not true regarding this connecting mode?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A dedicated gateway cluster can\u2019t be provisioned in Core (SQL) API accounts.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A dedicated gateway cluster can have up to 5 nodes.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">You can&#8217;t change the size of the dedicated gateway nodes once it is created.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dedicated gateway nodes are independent of each other.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><span style=\"font-weight: 400;\">: You can provision a dedicated gateway cluster in Core (SQL) API accounts. A dedicated gateway cluster can accommodate up to 5 nodes and nodes can be added or removed at any time. Even the same connection string is shared by all dedicated gateway nodes in your account.<\/span><\/p>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\">. The given statement is not true. A dedicated gateway cluster can be provisioned in Core (SQL) API accounts.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> The given statement is true. <\/span><span style=\"font-weight: 400;\">A dedicated gateway cluster can have up to 5 nodes.<\/span><\/p>\n<p><b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> It is not possible to change the <\/span><span style=\"font-weight: 400;\">size of the dedicated gateway nodes once it is created.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Dedicated gateway nodes are independent of each other.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about Azure Cosmos DB dedicated gateway, please visit the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/dedicated-gateway#connect-to-azure-cosmos-db-using-direct-mode\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/dedicated-gateway#connect-to-azure-cosmos-db-using-direct-mode<\/span><\/a><\/p>\n<h3>Summary<\/h3>\n<p>We hope the above list of DP-420 exam questions are helpful for you. DP-420 is an advanced-level certificate exam by Microsoft Azure in which a working professional interested to upskill their cloud native knowledge using Azure cosmos DB can attempt this exam.<\/p>\n<p>We strongly ensure that we have covered all the objectives of the DP-420 exam questions, so that you can pass the exam at ease in your first attempt. Hence, keep on practicing until you are confident to take the real exams. You can also try Azure\u00a0<a tabindex=\"-1\" title=\"https:\/\/www.whizlabs.com\/labs\/library\" href=\"https:\/\/www.whizlabs.com\/labs\/library\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"Link hands-on-labs\">hands-on-labs<\/a>\u00a0&amp;\u00a0<a tabindex=\"-1\" title=\"https:\/\/www.whizlabs.com\/labs\/sandbox\" href=\"https:\/\/www.whizlabs.com\/labs\/sandbox\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"Link cloud sandbox\">cloud sandbox<\/a>\u00a0where you can experience the real time working experiments.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you looking for DP-420 exam questions and answers to prepare for the\u00a0 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB certification exam? Here are our\u00a0newly updated 25+ Free DP-420 exam questions which are very similar to the DP-420 practice test as well as the real exam. Who this exam is intended for? This DP-420 Microsoft azure cosmos DB exam is intended for software professionals those who want to show their skills and knowledge in designing and implementing solutions that use Azure Cosmos DB. The candidates who take this exam should have experience working with Azure Cosmos DB, [&hellip;]<\/p>\n","protected":false},"author":223,"featured_media":85123,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[15],"tags":[],"class_list":["post-85091","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-azure"],"uagb_featured_image_src":{"full":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions.webp",1280,720,false],"thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions-150x150.webp",150,150,true],"medium":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions-300x169.webp",300,169,true],"medium_large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions-768x432.webp",768,432,true],"large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions-1024x576.webp",1024,576,true],"1536x1536":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions.webp",1280,720,false],"2048x2048":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions.webp",1280,720,false],"profile_24":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions.webp",24,14,false],"profile_48":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions.webp",48,27,false],"profile_96":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions.webp",96,54,false],"profile_150":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions.webp",150,84,false],"profile_300":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions.webp",300,169,false],"tptn_thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions-250x250.webp",250,250,true],"web-stories-poster-portrait":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions-640x720.webp",640,720,true],"web-stories-publisher-logo":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions-96x96.webp",96,96,true],"web-stories-thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/10\/DP-420-free-Questions-150x84.webp",150,84,true]},"uagb_author_info":{"display_name":"Dharmendra Digari","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/dharmendrawhizlabs-com\/"},"uagb_comment_info":1,"uagb_excerpt":"Are you looking for DP-420 exam questions and answers to prepare for the\u00a0 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB certification exam? Here are our\u00a0newly updated 25+ Free DP-420 exam questions which are very similar to the DP-420 practice test as well as the real exam. Who this exam is intended for?&hellip;","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/85091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/223"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=85091"}],"version-history":[{"count":11,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/85091\/revisions"}],"predecessor-version":[{"id":85838,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/85091\/revisions\/85838"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media\/85123"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=85091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=85091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=85091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}