DP-420 Exam Dumps: Ways DP-420 Exam Dumps Improved My Microsoft Certification Jo

1. https://www.microsoftdumps.us/DP-420-exam-questions Microsoft DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB QUESTION & ANSWERS https://www.microsoftdumps.us/DP-420-exam-questions

2. https://www.microsoftdumps.us/DP-420-exam-questions Topics Number of Questions 95 21 33 38 52 4 2 3 43 291 Topic 1 : Design and implement data models Topic 2 : Design and implement data distribution Topic 3 : Integrate an Azure Cosmos DB solution Topic 4 : Optimize an Azure Cosmos DB solution Topic 5 : Maintain an Azure Cosmos DB solution Topic 6 : Testlet 1 Topic 7 : Testlet 2 Topic 8 : Testlet 3 Mix Questions : Total Title : Design and implement data models QUESTION: 1 Topic 1 Design and implement data models https://www.microsoftdumps.us/DP-420-exam-questions

3. https://www.microsoftdumps.us/DP-420-exam-questions You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will occur every second. Data will be retained indefinitely. The following is a sample of the data. You need to select a partition key that meets the following requirements for writes: •Minimizes the partition skew •Avoids capacity limits •Avoids hot partitions What should you do? Option A : Use timestamp as the partition key. Option B : Create a new synthetic key that contains deviceId and sensor1Value. Option C : Create a new synthetic key that contains deviceId and deviceManufacturer. Option D : Create a new synthetic key that contains deviceId and a random number. Correct Answer: B Explanation/Reference: Use a partition key with a random suffix. Distribute the workload more evenly is to append a random number at the end of the partition key value. When you distribute items in this way, you can perform parallel write operations across partitions. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/synthetic-partition-keys https://www.microsoftdumps.us/DP-420-exam-questions

4. https://www.microsoftdumps.us/DP-420-exam-questions QUESTION: 2 Topic 1 Design and implement data models You provision Azure resources by using the following Azure Resource Manager (ARM) template. https://www.microsoftdumps.us/DP-420-exam-questions

5. https://www.microsoftdumps.us/DP-420-exam-questions For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each https://www.microsoftdumps.us/DP-420-exam-questions

6. https://www.microsoftdumps.us/DP-420-exam-questions correct selection is worth one point. Option A : The alert will be triggered when an Azure Cosmos DB key is used Option B : Two alert actions will be performed when the alert is triggered Option C : The alert will be triggered when an item that has a new partition key value is created Correct Answer: C Explanation/Reference: Box 1: No An alert is triggered when the DB key is regenerated, not when it is used. Note: The az cosmosdb keys regenerate command regenerates an access key for a Azure Cosmos DB database account. Box 2: No Only an SMS action will be taken. Emailreceivers is empty so no email action is taken. Box 3: Yes Yes, an alert is triggered when the DB key is regenerated. Reference: https://docs.microsoft.com/en-us/cli/azure/cosmosdb/keys QUESTION: 3 Topic 1 Design and implement data models 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. You will have to ensure the uniqueness of the email_Address value for every employee within the same company. Which of the following fields would you set as the partition key and the unique key respectively? Option A : Company_ID and Email_Addressright Option B : Email_Address and Company_ID Option C : Employee_ID and Email_Address Option D : Email_Address and Employee_ID Correct Answer: A https://www.microsoftdumps.us/DP-420-exam-questions

7. https://www.microsoftdumps.us/DP-420-exam-questions Explanation/Reference: 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’s scope. Option A is correct. 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't create two items with the same email addresses using the same Company_ID. Option B is incorrect. Company_ID must be the partition key whereas Email_Address must be the unique key. Option C is incorrect. Employee_ID and Email_Address are not the given option. Option D is incorrect. Email_Address and Employee_ID are not the right answers. Reference: To know more about unique keys and partition keys, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/unique-keys QUESTION: 4 Topic 1 Design and implement data models One of your friends has written a user-defined function named ’addTax’. He needs to write a SQL query to return a flat array of scalar Rate values with the calculated tax value. Which of the following is the valid SQL query to use for this purpose? Option A : SELECT VALUE addTax(i.rate) FROM items i Option B : SELECT VALUE udf.addTax(i.rate) FROM items iright Option C : SELECT VALUE i.rate.addTax() FROM item i Option D : SELECT VALUE addTax.rate FROM item i Correct Answer: B https://www.microsoftdumps.us/DP-420-exam-questions

8. https://www.microsoftdumps.us/DP-420-exam-questions Explanation/Reference: The udf.addTax() syntax is the right syntax to use user-defined function in the SQL query. Option A is incorrect. The given is not the right syntax to use a user-defined function in SQL. Option B is correct. The udf.addTax() syntax is the right syntax to use user-defined function in the SQL query. Option C is incorrect. The given syntax is not valid. Option D is incorrect. The given syntax is not right to use a user-defined function in a SQL query. Reference: To know more about how to work with user-defined functions, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-use-stored-procedures-triggers-udfs#u dfs QUESTION: 5 Topic 1 Design and implement data models https://www.microsoftdumps.us/DP-420-exam-questions

9. https://www.microsoftdumps.us/DP-420-exam-questions You have an Azure Cosmos DB database. You plan to create a new container named container1 that will store product data and product category data and will primarily support read requests. You need to configure a partition key for container1. The solution must meet the following requirements: Minimize the size of the partition. Minimize maintenance effort. Which two characteristics should you prioritize? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. Option A : unique Option B : high cardinality Option C : low cardinality Option D : static Correct Answer: B,D Explanation/Reference: B: For all containers, your partition key should: *Have a high cardinality. In other words, the property should have a wide range of possible values. *Etc. D: Be a property that has a value, which doesn't change. If a property is your partition key, you can't update that property's value. Reference: https://learn.microsoft.com/en-us/azure/cosmos-db/partitioning-overview https://www.microsoftdumps.us/DP-420-exam-questions

10. https://www.microsoftdumps.us/DP-420-exam-questions QUESTION: 6 Topic 1 Design and implement data models You have an Azure Cosmos DB for NoSQL account named account1. You need to create a container named Container1 in account1 by using the Azure Cosmos DB .NET SDK. The solution must ensure that the items in Container1 never expire. What should you set? Option A : TimeToLivePropertyPath to null Option B : TimeToLivePropertyPath to 0 Option C : DefaultTimeToLive to null Option D : DefaultTimeToLive to –1 Correct Answer: C Explanation/Reference: Time to live for containers and items The time to live value is set in seconds, and it is interpreted as a delta from the time that an item was last modified. You can set time to live on a container or an item within the container: Time to Live on a container (set using DefaultTimeToLive): If missing (or set to null), items are not expired automatically. If present and the value is set to "-1", it is equal to infinity, and items don’t expire by default. If present and the value is set to some non-zero number "n" – items will expire "n" seconds after their last modified time. Reference: https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/time-to-live QUESTION: 7 Topic 1 Design and implement data models https://www.microsoftdumps.us/DP-420-exam-questions

11. https://www.microsoftdumps.us/DP-420-exam-questions You run the below query against a container in the Azure Cosmos DB Core (SQL) API account. SELECT IS_NUMBER (“4567”) AS P, IS_NUMBER (4567) AS Q, IS_NUMBER ({prop:4567}) AS R What will be the output? Option A : [{“P”: false, “Q”: false, “R”: false}] Option B : [{“P”: false, “Q”: true, “R”: false}]right Option C : [{“P”: true, “Q”: false, “R”: false}] Option D : [{“P”: true, “Q”: true, “R”: false}] Correct Answer: B Explanation/Reference: IS-NUMBER returns a Boolean value that indicates if the type of the mentioned expression is a number. Option A is incorrect. As 4567 is a number, the output value for Q will be true, not false. Option B is correct. IS-NUMBER returns a Boolean value that indicates if the type of the mentioned expression is a number. Therefore, the value for Q will be true and the rest values will be false. Option C is incorrect. It is Q that will have a true value and all other values will be false. Option D is incorrect. As "4567" is a string, not a number, the value for P will be false. Reference: To know more about the IS_NUMBER function, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-is-number https://www.microsoftdumps.us/DP-420-exam-questions

12. https://www.microsoftdumps.us/DP-420-exam-questions QUESTION: 8 Topic 1 Design and implement data models Azure SQL Database allows configuring MAXDOP for every database and elastic pool. How the query executes also depends a lot on the MAXDOP value. What will happen if the MAXDOP is equal to Zero? Option A : SQL Server database engine won’t execute queries in parallel mode Option B : The database engines can use a maximum of 10 parallel threads Option C : The database engine can utilize any number of parallel threads with the upper cap constrained by the total number of logical processorsright Option D : MAXDOP can’t be 0 Correct Answer: C Explanation/Reference: With MAXDOP=0, the database engine can utilize any number of parallel threads with the upper cap constrained by the total number of logical processors. Option A is incorrect. SQL Server database engine won’t execute queries in parallel mode if MAXDOP =1. Option B is incorrect. With MAXDOP value greater than 1, the database engines can utilize the parallel threads stated by the MAXDOP. For an instance, MAXDOP 5 permits a maximum of 5 parallel threads. Option C is correct. With MAXDOP=0, the database engine can utilize any number of parallel threads with the upper cap constrained by the total number of logical processors. Option D is incorrect. MAXDOP can be zero. Reference: To know more about MAXDOP in Azure SQL Database, please visit the below-given link: https://docs.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallel ism QUESTION: 9 Topic 1 Design and implement data models Azure Cosmos DB offers the ability to automatically delete the items from a container after a specific time https://www.microsoftdumps.us/DP-420-exam-questions

13. https://www.microsoftdumps.us/DP-420-exam-questions period. Which property of a container do you need to specify the automatically purge items after a certain number of seconds? Option A : _ttl Option B : Expiration Option C : DefaultTimeToLiveright Option D : Default_ttl Correct Answer: C Explanation/Reference: Time to live can be set on a container or an item within the container. The following figure illustrates the properties: Option A is incorrect. _ttl property is used to configure the time-to-live feature for specific items. Option B is incorrect. Expiration is not a valid property to set the time-to-live feature for a container. Option C is correct. DefaultTimeToLive of a container is specified to enable the time-to-live feature for items in the container. Option D is incorrect. Default_ttl is not a valid property. Reference: To know more about Time to Live in Azure Cosmos DB, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/time-to-live QUESTION: 10 Topic 1 Design and implement data models https://www.microsoftdumps.us/DP-420-exam-questions

14. https://www.microsoftdumps.us/DP-420-exam-questions You have an Azure Cosmos DB account named account1 that has a default consistency level of session. You have an app named App1. You need to ensure that the read operations of App1 can request either bounded staleness or consistent prefix consistency. What should you modify for each consistency level? To answer, select the appropriate options in the answer area. Answer : Explanation/Reference: Box 1 = The request level options Azure Cosmos DB offers five well-defined consistency levels: strong, bounded staleness, session, consistent prefix and eventual. You can configure the default consistency level on your Azure Cosmos DB account at any time2. The default consistency level applies to all databases and containers under that account1. You can also override the default consistency level for a specific request by using the request options2. Box 2 = The request level options To modify the consistency level of a read operation in Azure Cosmos DB, you can use request-level options to override the account's default consistency setting. Therefore, to ensure that the read operations of App1 can request either consistent prefix or session consistency, you need to modify the request-level options for each operation. Reference: - https://docs.microsoft.com/en- us/azure/cosmos-db/consistency-levels https://www.microsoftdumps.us/DP-420-exam-questions

15. https://www.microsoftdumps.us/DP-420-exam-questions Title : Design and implement data distribution QUESTION: 11 Topic 2 Design and implement data distribution https://www.microsoftdumps.us/DP-420-exam-questions

16. https://www.microsoftdumps.us/DP-420-exam-questions You have a multi-region Azure Cosmos DB account named account1 that has a default consistency level ofstrong.You have an app named App1 that is configured to request a consistency level of session.How will the read and write operations of App1 be handled? To answer, select the appropriate options in theanswer area.NOTE: Each correct selection is worth one point Answer : Explanation/Reference: Box 1 = Write and replicate data to every region synchronously This is because the write concern is mapped to the default consistency level configured on your Azure Cosmos DB account2, which is strong in this case. Strong consistency ensures that every write operation is synchronously committed to every region associated with your Azure Cosmos DB account1. The request level consistency level of session only applies to the read operations of App11. Box 2: That has the lowest estimated latency to the client This is because the read operations of App1 will use the session consistency level that is specified in the request options. Session consistency is a client-centric consistency model that guarantees monotonic reads, monotonic writes, and read-your-own-writes within a session. A session is scoped to a client connection or a stored procedure execution. Session consistency allows clients to read from any region that has the lowest latency to the client. https://www.microsoftdumps.us/DP-420-exam-questions

17. https://www.microsoftdumps.us/DP-420-exam-questions Title : Integrate an Azure Cosmos DB solution QUESTION: 12 Topic 3 Integrate an Azure Cosmos DB solution You plan to create an Azure Cosmos DB for NoSQL database named db1 that will contain two containers. One of the containers will contain blog posts, and the other will contain users. Each item in the blog post container will include: •A single blog post •The top 10 comments associated to the blog post •The names of the users who created the blog post and the associated comments You need to automatically update the usernames in the blog post container whenever a username in the user container changes. What should you implement for the user container? Option A : a stored procedure Option B : a change feed processor Option C : a post-trigger Option D : a user-defined function (UDF) Correct Answer: B QUESTION: 13 Topic 3 Integrate an Azure Cosmos DB solution You plan to create an Azure Cosmos DB database named db1 that will contain two containers. One of the containers will contain blog posts, and the other will contain users. Each item in the blog post container will include: • A single blog post• All the comments associated to the blog post• The names of the users who created the blog post and added the commentsYou need to design a solution to update usernames in the user container without causing data integrity issues. The solution must minimize administrative and development effort.What should you include in the solution? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. https://www.microsoftdumps.us/DP-420-exam-questions

18. https://www.microsoftdumps.us/DP-420-exam-questions Answer : Title : Optimize an Azure Cosmos DB solution QUESTION: 14 Topic 4 Optimize an Azure Cosmos DB solution https://www.microsoftdumps.us/DP-420-exam-questions

19. https://www.microsoftdumps.us/DP-420-exam-questions An output binding has been configured for Azure Cosmos DB SQL API named items. You want to add multiple items to a container with the help of this binding. Which of the following function method parameters would you use to meet the goal? Option A : out IEnumerable items Option B : out Product items Option C : IAsyncCollector itemsright Option D : In items Correct Answer: C Explanation/Reference: The IAsyncCollector class has the AddAsync method that can be used to add items to a container. Option A is incorrect. The IEnumerable class doesn’t have the methods required to add items to a container. Option B is incorrect. An out parameter with a type will only add a single item to the container. Option C is correct. The IAsyncCollector class contains the AddAsync method to add items to a container. Option D is incorrect. In items is not the valid parameter. Reference: To know more about how to write docs using IAsyncCollector, please visit the below-given link: https://docs.microsoft.com/en-us/azure/azure-functions/functions-bindings-cosmosdb-v2-output?tabs=i n- process%2Cfunctionsv2&pivots=programming-language-csharp QUESTION: 15 Topic 4 Optimize an Azure Cosmos DB solution https://www.microsoftdumps.us/DP-420-exam-questions

20. https://www.microsoftdumps.us/DP-420-exam-questions Which of the following method of the ChangeFeedProcessor class is invoked to start consuming changes from the change feed? Option A : StartAsyncright Option B : GetChangeFeedProcessorBuilder<> Option C : Build Option D : None of these Correct Answer: A Explanation/Reference: StartAsync is a method in the ChangeFeedProcessor class and is invoked to start consuming changes from the change feed. Option A is correct. StartAsync is a method in the ChangeFeedProcessor class and is invoked to start consuming changes from the change feed. Option B is incorrect. The given is a method of Container class that creates the builder to eventually build a change feed processor. Option C is incorrect. The build method is invoked at the end of creating a change feed processor (or estimator) and isn't a method of the ChangeFeedProcessor class. Option D is incorrect. StartAsync is the correct answer. Reference: To know more about the change feed processor in Azure Cosmos DB, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/change-feed-processor QUESTION: 16 Topic 4 Optimize an Azure Cosmos DB solution https://www.microsoftdumps.us/DP-420-exam-questions

21. https://www.microsoftdumps.us/DP-420-exam-questions You are having an index policy as demonstrated in the following diagram: https://www.microsoftdumps.us/DP-420-exam-questions

22. https://www.microsoftdumps.us/DP-420-exam-questions You are creating an item. When will the index get updated? Option A : At a scheduled interval Option B : After the item appears in the change feed Option C : At the same time as the item creationright Option D : The index won’t be updated at all Correct Answer: C Explanation/Reference: The index will get updated at the same time as item creation. As can be seen from the given figure, the indexing mode is consistent and in the consistent mode, the index gets updated synchronously as you update, delete or create items. Option A is incorrect. In the consistent indexing mode, the index gets updated at the same time as you create the item. Option B is incorrect. In the consistent indexing mode, the index gets updated at the same time as you create the item. https://www.microsoftdumps.us/DP-420-exam-questions

23. https://www.microsoftdumps.us/DP-420-exam-questions Option C is correct. the index will get updated at the same time as the item creation. Option D is incorrect. In the consistent mode, the index gets updated synchronously as you update, delete or create items. Reference: To know more about Indexing policies in Azure Cosmos DB, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/index-policy QUESTION: 17 Topic 4 Optimize an Azure Cosmos DB solution https://www.microsoftdumps.us/DP-420-exam-questions

24. https://www.microsoftdumps.us/DP-420-exam-questions You have an Azure Cosmos DB Core (SQL) API account that frequently receives the same three queries. You need to configure indexing to minimize RUs consumed by the queries. Which type of index should you use for each query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: Answer : https://www.microsoftdumps.us/DP-420-exam-questions

25. https://www.microsoftdumps.us/DP-420-exam-questions Explanation/Reference: Box 1: Range - Range index is based on an ordered tree-like structure. The range index type is used for: Equality queries: SELECT * FROM container c WHERE c.property = 'value' SELECT * FROM c WHERE c.property IN ("value1", "value2", "value3") Box 2: Composite - Composite indexes increase the efficiency when you are performing operations on multiple fields. The composite index type is used for: Queries with a filter on two or more properties where at least one property is an equality filter SELECT * FROM container c WHERE c.property1 = 'value' AND c.property2 > 'value' Box 3: Composite - Incorrect: https://www.microsoftdumps.us/DP-420-exam-questions

26. https://www.microsoftdumps.us/DP-420-exam-questions Spatial indices enable efficient queries on geospatial objects such as - points, lines, polygons, and multipolygon. These queries use ST_DISTANCE, ST_WITHIN, ST_INTERSECTS keywords. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/index-overview Title : Maintain an Azure Cosmos DB solution QUESTION: 18 Topic 5 Maintain an Azure Cosmos DB solution You have an Azure Cosmos DB for NoSQL account that has multiple write regions. You need to receive an alert when requests that target the database exceed the available request units per second (RU/s). Which Azure Monitor signal should you use? Option A : Document Quota Option B : Region Removed Option C : Total Request Units Option D : Document Count Correct Answer: C QUESTION: 19 Topic 5 Maintain an Azure Cosmos DB solution https://www.microsoftdumps.us/DP-420-exam-questions

27. https://www.microsoftdumps.us/DP-420-exam-questions There is a database in an Azure Cosmos DB Core (SQL) API account which is backed up every two hours. You have been asked to implement a solution that will support point-in-time restore. Which of the following thing would you perform first? Option A : Configuring the backup and restore settings for the account Option B : Enabling the continuous backup for the accountright Option C : Configuring the Point In Time Restore settings for the account Option D : Creating a new account having a periodic backup policy Correct Answer: B Explanation/Reference: 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't allow restoring the data to an existing account. Option A is incorrect. First, you need to enable continuous backup for the account. Option B is correct. Enabling the continuous backup for the account is the first thing you need to perform to meet the goal. Option C is incorrect. 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. Option D is incorrect. You need to create a new account with the continuous backup policy. Reference: To know more about the point in time restore, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/provision-account-continuous-back up https://www.microsoftdumps.us/DP-420-exam-questions

28. https://www.microsoftdumps.us/DP-420-exam-questions QUESTION: 20 Topic 5 Maintain an Azure Cosmos DB solution One of your friends needs to troubleshoot the skew storage. Which of the following SQL API Log Analytics tables would you suggest using? Option A : DataPlaneRequests Option B : QueryRuntimeStatistics Option C : PartitionKeyRUConsumption Option D : n PartitionKeyStatisticsright Option E : ControlPlaneRequests Correct Answer: D Explanation/Reference: PartitionKeyStatistics is the analytics table that logs the logical partition key statistics in estimated KB. This table helps in troubleshooting skew storage. Option A is incorrect. DataPlaneRequests table logs back-end requests for the operations that execute update, create, retrieve or delete data. Option B is incorrect. It logs query operations against the SQL API account. Option C is incorrect. This table helps in troubleshooting the hot partitions. Option D is correct. PartitionKeyStatistics helps in troubleshooting skew storage. Option E is incorrect. It logs Azure Cosmos DB account control data, for example deleting or adding regions in the replication settings. Reference: To know more about how to monitor Azure Cosmos DB data by using diagnostic settings in Azure, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/cosmosdb-monitor-resource-logs https://www.microsoftdumps.us/DP-420-exam-questions

29. https://www.microsoftdumps.us/DP-420-exam-questions QUESTION: 21 Topic 5 Maintain an Azure Cosmos DB solution You are having an Azure Cosmos DB account titled ‘accountI’. Azure subnets and virtual networks (VNets ) are present as demonstrated below. The vnet1 & vnet2 are connected through a virtual n/w peer. https://www.microsoftdumps.us/DP-420-exam-questions

30. https://www.microsoftdumps.us/DP-420-exam-questions The virtual network and Firewall settings for ‘accountI’ have been configured as demonstrated in the following diagram. Out of Virtual Machines - VM1, VM2, and VM3, which virtual machines(s) can access the ‘accountI’? Option A : Only VM1right Option B : Only VM2 Option C : Only VM3 Option D : Both VM1 and VM3 Option E : Both VM2 and VM3 Option F : All; VM1, VM2, and VM3 Correct Answer: A Explanation/Reference: Only VNet and its subnets included in the Azure Cosmos account are having access. Peered virtual networks of them can't access the Cosmos account until these subnets inside the peered vnets are included in the account. Option A is correct. VM1 is on vnet1.subnet1 which has the Endpoint Status enabled. Option B is incorrect. Only VNet and its subnets included in the Azure Cosmos account are having access. VM2 can't access the accountI. https://www.microsoftdumps.us/DP-420-exam-questions

31. https://www.microsoftdumps.us/DP-420-exam-questions Option C is incorrect. VM3 can’t access the accountI. Option D is incorrect. Only VM1 can access the accountI. VM3 can't. Option E is incorrect. Only VM1 can access the accountI. VM2 and VM3 can't access the account. Option F is incorrect. Only VM1 can access the accountI. Reference: To know more about how to configure access to Azure Cosmos DB from VNet, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-configure-vnet-service-endpoint QUESTION: 22 Topic 5 Maintain an Azure Cosmos DB solution https://www.microsoftdumps.us/DP-420-exam-questions

32. https://www.microsoftdumps.us/DP-420-exam-questions You configure a backup for an Azure Cosmos DB for NoSQL account as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the https://www.microsoftdumps.us/DP-420-exam-questions

33. https://www.microsoftdumps.us/DP-420-exam-questions information presented in the graphic. NOTE: Each correct selection is worth one point. Answer : Explanation/Reference: Box 1 = The current backup policy provides protection for: 2 Hours Azure Cosmos DB automatically takes backups of your data at regular intervals. The backup interval and the retention period can be configured from the Azure portal. You can also choose between two backup modes: periodic backup mode and continuous backup mode. Periodic backup mode is the default mode for all existing accounts and it takes a full backup of your database every 4 hours by default. Continuous backup mode is a new mode that allows you to restore to any point of time within either 7 or 30 days1. For your scenario, based on the exhibit, you have configured a backup for an Azure Cosmos DB for NoSQL account using the periodic backup mode with a backup interval of 1 hour and a retention period of 2 hours. This means that Azure Cosmos DB will take a full backup of your database every hour and keep only the latest two backups. Therefore, the current backup policy provides protection for 2 hours. Box 2: In case of emergency, you must (answer choice) to restore the backup = create a support ticket Azure Cosmos DB automatically takes backups of your data at regular intervals. You can configure the backup interval and the retention period from the Azure portal. You can also choose between two backup modes: periodic backup mode and continuous backup mode. Periodic backup mode https://www.microsoftdumps.us/DP-420-exam-questions

34. https://www.microsoftdumps.us/DP-420-exam-questions is the default mode for all existing accounts and it takes a full backup of your database every 4 hours by default. Continuous backup mode is a new mode that allows you to restore to any point of time within either 7 or 30 days1. For your scenario, based on the exhibit, you have configured a backup for an Azure Cosmos DB for NoSQL account using the periodic backup mode with a backup interval of 1 hour and a retention period of 2 hours. This means that Azure Cosmos DB will take a full backup of your database every hour and keep only the latest two backups. In case of emergency, you must create a support ticket to restore the backup. This is the answer to your question. To restore data from a periodic backup, you need to create a support request with Azure Cosmos DB team and provide the following information: The name of your Azure Cosmos DB account The name of the database or container that you want to restore The date and time (in UTC) that you want to restore from The name of the target Azure Cosmos DB account where you want to restore the data The name of the target resource group where you want to restore the data The Azure Cosmos DB team will then initiate the restore process and notify you when it is completed2. QUESTION: 23 Topic 5 Maintain an Azure Cosmos DB solution You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. You need to provide a user named User1 with the ability to insert items into container1 by using role-based access control (RBAC). The solution must use the principle of least privilege. Which roles should you assign to User1? Option A : CosmosDB Operator only Option B : DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor Option C : DocumentDB Account Contributor only Option D : Cosmos DB Built-in Data Contributor only Correct Answer: D Explanation/Reference: Cosmos DB Operator: Can provision Azure Cosmos accounts, databases, and containers. Cannot access any data or use Data Explorer. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/role-based-access-control QUESTION: 24 Topic 5 Maintain an Azure Cosmos DB solution https://www.microsoftdumps.us/DP-420-exam-questions

35. https://www.microsoftdumps.us/DP-420-exam-questions You need to implement an Azure Data Factory data flow that will utilize an Azure Cosmos DB (SQL API) sink to write a dataset. The data flow will utilize 2000 Apache Spark partitions. You need to make sure that the ingestion from every Spark partition is balanced to optimize throughput. Which of the following sink setting would you configure? Option A : Collection action Option B : Batch sizeright Option C : Throughput Option D : Write throughput budget Correct Answer: B https://www.microsoftdumps.us/DP-420-exam-questions

36. https://www.microsoftdumps.us/DP-420-exam-questions Explanation/Reference: Batch size is an integer value that indicates the number of objects being written to the Cosmos DB collection in every batch. Generally, starting with the default batch size is enough. For further tuning of this value, you need to note that Cosmos DB limits the size of a single request to 2MB. Request size is calculated with the following formula: "Request Size = Single Document Size * Batch Size". If you get the error that states "Request size is too large", decrease the batch size value. As the batch size increases, the service can achieve better throughput, while making sure you allocate enough Request Units per second to empower your workload. Option A is incorrect. This setting decides whether to recreate the destination collection before writing. Option B is correct. Batch size is the right setting to configure. Option C is incorrect. Set an optional value for the number of Request Units per second you would like to apply to your CosmosDB collection for every execution of this data flow. The Minimum value is 400. Option D is incorrect. Write throughput budget is an integer value that indicates the Request Units per second you want to allocate for this Data Flow write operation out of the total throughput assigned to the collection. Reference: To know more about how to copy and transform data in Azure Cosmos DB (SQL API) by using Azure Data Factory, please visit the below-given link: https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-cosmos-db QUESTION: 25 Topic 5 Maintain an Azure Cosmos DB solution You have a database in an Azure Cosmos DB Core (SQL) API account. You need to create an Azure function that will access the database to retrieve records based on a variable named accountnumber. The solution must protect against SQL injection attacks. How should you define the command statement in the function? Option A : cmd = "SELECT * FROM Persons p WHERE p.accountnumber = 'accountnumber'" Option B : cmd = "SELECT * FROM Persons p WHERE p.accountnumber = LIKE @accountnumber" Option C : cmd = "SELECT * FROM Persons p WHERE p.accountnumber = @accountnumber" Option D : cmd = "SELECT * FROM Persons p WHERE p.accountnumber = '" + accountnumber + "'" Correct Answer: C https://www.microsoftdumps.us/DP-420-exam-questions

37. https://www.microsoftdumps.us/DP-420-exam-questions Explanation/Reference: Azure Cosmos DB supports queries with parameters expressed by the familiar @ notation. Parameterized SQL provides robust handling and escaping of user input, and prevents accidental exposure of data through SQL injection. For example, you can write a query that takes lastName and address.state as parameters, and execute it for various values of lastName and address.state based on user input. SELECT * FROM Families f WHERE f.lastName = @lastName AND f.address.state = @addressState Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-parameterized-queries QUESTION: 26 Topic 5 Maintain an Azure Cosmos DB solution For an Azure Synapse Link-enabled account, is the analytical store data involved in the backups & restores? Option A : Yes Option B : Noright Correct Answer: B Explanation/Reference: For an Azure Synapse Link-enabled account, analytical store data is not involved in the backups & restores. With enabled Synapse Link, Azure Cosmos DB continuously keeps on taking automatic backups of transactional store data at a scheduled interval. On the other hand, it doesn’t support automatic backup and restoration of the data present in the analytical store. Reference: To know more about Online backup and on-demand data restore in Azure Cosmos DB, please visit the below-given link: https://docs.microsoft.com/en-us/azure/cosmos-db/online-backup-and-restore QUESTION: 27 Topic 5 Maintain an Azure Cosmos DB solution https://www.microsoftdumps.us/DP-420-exam-questions

38. https://www.microsoftdumps.us/DP-420-exam-questions 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? Option A : excludedPaths Option B : includedPath Option C : automatic Option D : indexingModeright Correct Answer: D Explanation/Reference: None and consistent are two indexing modes supported by Azure Cosmos DB. If you set the indexingMode property to none, it disables all indexing. Option A is incorrect. The excludedPaths property specifies the paths that will be excluded from the index. It says nothing about the running of the indexer. Option B is incorrect. The includedPaths property specifies the paths that will be included in the index. It says nothing about the running of the indexer. Option C is incorrect. If you disable the automatic indexing by assigning it a value as false, it won’t disable all indexing for the container. Option D is correct. Setting the indexing mode property to none disables all indexing. Reference: To know more about various properties in Indexing in Azure Cosmos DB, please visit the below-given link: https://azurecosmosdb.github.io/labs/dotnet/labs/04-indexing_in_cosmosdb.html QUESTION: 28 You plan to create an Azure Cosmos DB for NoSQL account that will use customer-managed keys stored in Azure Key Vault. https://www.microsoftdumps.us/DP-420-exam-questions

39. https://www.microsoftdumps.us/DP-420-exam-questions https://www.microsoftdumps.us/DP-420-exam-questions

40. https://www.microsoftdumps.us/DP-420-exam-questions You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys. Which three permissions should you enable in the access policy? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. Option A : Wrap Key Option B : Get Option C : List Option D : Update Option E : Sign Option F : Verify Option G : Unwrap Key Correct Answer: A,B,G Explanation/Reference: To Configure customer-managed keys for your Azure Cosmos account with Azure Key Vault: Add an access policy to your Azure Key Vault instance: 1.From the Azure portal, go to the Azure Key Vault instance that you plan to use to host your encryption keys. Select Access Policies from the left menu: 2.Select + Add Access Policy. 3.Under the Key permissions drop-down menu, select Get, Unwrap Key, and Wrap Key permissions: https://www.microsoftdumps.us/DP-420-exam-questions

41. https://www.microsoftdumps.us/DP-420-exam-questions Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-setup-cmk QUESTION: 29 You have a container named container! in an Azure Cosmos DB for NoSQL account. You need to provide a user named User1 with the ability to insert items into container1 by using role-based access The solution must use the principle of least privilege. Which roles should you assign to User1? Option A : Cosmos DB Built-in Data Contributor only Option B : Cosmos DB Operator only Option C : DocumentDB Account Contribute only Option D : DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor Correct Answer: A Explanation/Reference: The Cosmos DB Built-in Data Contributor role provides the necessary permissions to insert items into a container in an Azure Cosmos DB for NoSQL account. This role grants the minimum required privileges for the described task, adhering to the principle of least privilege. https://www.microsoftdumps.us/DP-420-exam-questions