This page was exported from Latest Exam Prep [ http://certify.vceprep.com ] Export date:Sat Dec 14 11:25:46 2024 / +0000 GMT ___________________________________________________ Title: DP-420 Dumps PDF 2023 Strategy Your Preparation Efficiently [Q24-Q43] --------------------------------------------------- DP-420 Dumps PDF 2023 Strategy Your Preparation Efficiently Latest Verified & Correct Microsoft DP-420 Questions Skills measured Design and implement data models (35–40%)Design and implement data distribution (5–10%)Optimize an Azure Cosmos DB solution (15–20%) Here is the registration process of the Microsoft DP-420 Certification Exam The registration process for the Microsoft DP-420 Certification Exam is very simple and straightforward. You just need to follow the steps given in the DP-420 Dumps. These steps are also given below to get registered for the DP-420 Certification Exam: Finally, click on the “Register Now” button. You will get a confirmation mail from Microsoft with a link to take the DP-420 Certification Exam. Take the DP-420 Certification Exam at the specified date and time, with the Pearson Vue.Fill in the required details like name, email, and password. After that, enter the required information like your country, your exam center, and your exam date.Go to the official website of Microsoft. Click on the “Schedule Exam”, which will take you to the Exam Registration Page.   QUESTION 24You have a database in an Azure Cosmos DB Core (SQL) API account.You plan to create a container that will store employee data for 5,000 small businesses. Each business will have up to 25 employees. Each employee item will have an emailAddress value.You need to ensure that the emailAddress value for each employee within the same company is unique.To what should you set the partition key and the unique key? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. QUESTION 25Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput.You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.Solution: You configure the function to have an Azure CosmosDB trigger.Does this meet the goal?  Yes  No Instead configure an Azure Monitor alert to trigger the function.You can set up alerts from the Azure Cosmos DB pane or the Azure Monitor service in the Azure portal.QUESTION 26You configure Azure Cognitive Search to index a container in an Azure Cosmos DB Core (SQL) API account as shown in the following exhibit.Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.NOTE: Each correct selection is worth one point. QUESTION 27You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format.Which three configuration items should you include in the solution? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.  “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector”  “key.converter”: “org.apache.kafka.connect.json.JsonConverter”  “key.converter”: “io.confluent.connect.avro.AvroConverter”  “connect.cosmos.containers.topicmap”: “iot#telemetry”  “connect.cosmos.containers.topicmap”: “iot”  “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector” C: Avro is binary format, while JSON is text.F: Kafka Connect for Azure Cosmos DB is a connector to read from and write data to Azure Cosmos DB. The Azure Cosmos DB sink connector allows you to export data from Apache Kafka topics to an Azure Cosmos DB database. The connector polls data from Kafka to write to containers in the database based on the topics subscription.D: Create the Azure Cosmos DB sink connector in Kafka Connect. The following JSON body defines config for the sink connector.Extract:“connector.class”: “com.azure.cosmos.kafka.connect.sink.CosmosDBSinkConnector”,“key.converter”: “org.apache.kafka.connect.json.AvroConverter”“connect.cosmos.containers.topicmap”: “hotels#kafka”Incorrect Answers:B: JSON is plain text.Note, full example:{“name”: “cosmosdb-sink-connector”,“config”: {“connector.class”: “com.azure.cosmos.kafka.connect.sink.CosmosDBSinkConnector”,“tasks.max”: “1”,“topics”: [“hotels”],“value.converter”: “org.apache.kafka.connect.json.AvroConverter”,“value.converter.schemas.enable”: “false”,“key.converter”: “org.apache.kafka.connect.json.AvroConverter”,“key.converter.schemas.enable”: “false”,“connect.cosmos.connection.endpoint”: “Error! Hyperlink reference not valid.”,“connect.cosmos.master.key”: “<cosmosdbprimarykey>”,“connect.cosmos.databasename”: “kafkaconnect”,“connect.cosmos.containers.topicmap”: “hotels#kafka”}}Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/sql/kafka-connector-sinkhttps://www.confluent.io/blog/kafka-connect-deep-dive-converters-serialization-explained/QUESTION 28You have an Azure Cosmos DB Core (SQL) API account named account1.In account1, you run the following query in a container that contains 100GB of data.SELECT *FROM cWHERE LOWER(c.categoryid) = “hockey”You view the following metrics while performing the query.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. QUESTION 29Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput.You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.Solution: You configure an Azure Monitor alert to trigger the function.Does this meet the goal?  Yes  No You can set up alerts from the Azure Cosmos DB pane or the Azure Monitor service in the Azure portal.Note: Alerts are used to set up recurring tests to monitor the availability and responsiveness of your Azure Cosmos DB resources. Alerts can send you a notification in the form of an email, or execute an Azure Function when one of your metrics reaches the threshold or if a specific event is logged in the activity log.QUESTION 30You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.The database is modified once per day in a batch process.You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.How should you configure the backup settings? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. QUESTION 31You have an Azure Cosmos DB Core (SQL) API account.You run the following query against a container in the account.SELECTIS_NUMBER(“1234”) AS A,IS_NUMBER(1234) AS B,IS_NUMBER({prop: 1234}) AS CWhat is the output of the query?  [{“A”: false, “B”: true, “C”: false}]  [{“A”: true, “B”: false, “C”: true}]  [{“A”: true, “B”: true, “C”: false}]  [{“A”: true, “B”: true, “C”: true}] IS_NUMBER returns a Boolean value indicating if the type of the specified expression is a number.“1234” is a string, not a number.QUESTION 32You have an Azure Cosmos DB Core (SQL) API account that is configured for multi-region writes. The account contains a database that has two containers named container1 and container2.The following is a sample of a document in container1:{“customerId”: 1234,“firstName”: “John”,“lastName”: “Smith”,“policyYear”: 2021}The following is a sample of a document in container2:{“gpsId”: 1234,“latitude”: 38.8951,“longitude”: -77.0364}You need to configure conflict resolution to meet the following requirements:For container1 you must resolve conflicts by using the highest value for policyYear.For container2 you must resolve conflicts by accepting the distance closest to latitude: 40.730610 and longitude: -73.935242.Administrative effort must be minimized to implement the solution.What should you configure for each container? To answer, drag the appropriate configurations to the correct containers. Each configuration may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/conflict-resolution-policieshttps://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-conflictsQUESTION 33You have three containers in an Azure Cosmos DB Core (SQL) API account as shown in the following table.You have the following Azure functions:A function named Fn1 that reads the change feed of cn1A function named Fn2 that reads the change feed of cn2A function named Fn3 that reads the change feed of cn3You perform the following actions:Delete an item named item1 from cn1.Update an item named item2 in cn2.For an item named item3 in cn3, update the item time to live to 3,600 seconds.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/sql/change-feed-design-patternshttps://docs.microsoft.com/en-us/azure/cosmos-db/change-feedQUESTION 34You need to identify which connectivity mode to use when implementing App2. The solution must support the planned changes and meet the business requirements.Which connectivity mode should you identify?  Direct mode over HTTPS  Gateway mode (using HTTPS)  Direct mode over TCP Scenario: Develop an app named App2 that will run from the retail stores and query the data in account2. App2 must be limited to a single DNS endpoint when accessing account2.By using Azure Private Link, you can connect to an Azure Cosmos account via a private endpoint. The private endpoint is a set of private IP addresses in a subnet within your virtual network.When you’re using Private Link with an Azure Cosmos account through a direct mode connection, you can use only the TCP protocol. The HTTP protocol is not currently supported.Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-configure-private-endpointsQUESTION 35You 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?  CosmosDB Operator only  DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor  DocumentDB Account Contributor only  Cosmos DB Built-in Data Contributor only Cosmos DB Operator: Can provision Azure Cosmos accounts, databases, and containers. Cannot access any data or use Data Explorer.Incorrect Answers:B: DocumentDB Account Contributor can manage Azure Cosmos DB accounts. Azure Cosmos DB is formerly known as DocumentDB.C: DocumentDB Account Contributor: Can manage Azure Cosmos DB accounts.QUESTION 36You 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?  cmd = “SELECT * FROM Persons pWHERE p.accountnumber = ‘accountnumber'”  cmd = “SELECT * FROM Persons pWHERE p.accountnumber = LIKE @accountnumber”  cmd = “SELECT * FROM Persons pWHERE p.accountnumber = @accountnumber”  cmd = “SELECT * FROM Persons pWHERE p.accountnumber = ‘” + accountnumber + “‘” 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 fWHERE f.lastName = @lastName AND f.address.state = @addressStateQUESTION 37You have an Azure Cosmos DB Core (SQL) API account named storage1 that uses provisioned throughput capacity mode.The storage1 account contains the databases shown in the following table.The databases contain the containers shown in the following table.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/plan-manage-costshttps://azure.microsoft.com/en-us/pricing/details/cosmos-db/QUESTION 38You need to provide a solution for the Azure Functions notifications following updates to con-product. The solution must meet the business requirements and the product catalog requirements.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.  Configure the trigger for each function to use a different leaseCollectionPrefix  Configure the trigger for each function to use the same leaseCollectionNair.e  Configure the trigger for each function to use a different leaseCollectionName  Configure the trigger for each function to use the same leaseCollectionPrefix leaseCollectionPrefix: when set, the value is added as a prefix to the leases created in the Lease collection for this Function. Using a prefix allows two separate Azure Functions to share the same Lease collection by using different prefixes.Scenario: Use Azure Functions to send notifications about product updates to different recipients.Trigger the execution of two Azure functions following every update to any document in the con-product container.Reference:https://docs.microsoft.com/en-us/azure/azure-functions/functions-bindings-cosmosdb-v2-triggerQUESTION 39You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Europe.You run the following Azure CLI script.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-multi-masterhttps://docs.microsoft.com/en-us/azure/cosmos-db/optimize-cost-regionsQUESTION 40The settings for a container in an Azure Cosmos DB Core (SQL) API account are configured as shown in the following exhibit.Which statement describes the configuration of the container?  All items will be deleted after one year.  Items stored in the collection will be retained always, regardless of the items time to live value.  Items stored in the collection will expire only if the item has a time to live value.  All items will be deleted after one hour. When DefaultTimeToLive is -1 then your Time to Live setting is On (No default) Time to Live on a container, if present and the value is set to “-1”, it is equal to infinity, and items don’t expire by default.Time to Live on an item:This Property is applicable only if DefaultTimeToLive is present and it is not set to null for the parent container.If present, it overrides the DefaultTimeToLive value of the parent container.QUESTION 41The following is a sample of a document in orders.The orders container uses customerId as the partition key.You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements:Ensure that the report can run as quickly as possible.Minimize the consumption of request units (RUs).What should you do?  Configure the report to query orders by using a SQL query.  Configure the report to query a new aggregate container. Populate the aggregates by using the change feed.  Configure the report to query orders by using a SQL query through a dedicated gateway.  Configure the report to query a new aggregate container. Populate the aggregates by using SQL queries that run daily. You can facilitate aggregate data by using Change Feed and Azure Functions, and then use it for reporting.QUESTION 42You are developing an application that will use an Azure Cosmos DB Core (SQL) API account as a data source.You need to create a report that displays the top five most ordered fruits as shown in the following table.A collection that contains aggregated data already exists. The following is a sample document:{“name”: “apple”,“type”: [“fruit”, “exotic”],“orders”: 10000}Which two queries can you use to retrieve data for the report? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.A)B)C)D)  Option A  Option B  Option C  Option D ARRAY_CONTAINS returns a Boolean indicating whether the array contains the specified value. You can check for a partial or full match of an object by using a boolean expression within the command.Incorrect Answers:A: Default sorting ordering is Ascending. Must use Descending order.C: Order on Orders not on Type.QUESTION 43You have a container named container1 in an Azure Cosmos DB Core (SQL) API account.The following is a sample of a document in container1.{“studentId”: “631282”,“firstName”: “James”,“lastName”: “Smith”,“enrollmentYear”: 1990,“isActivelyEnrolled”: true,“address”: {“street”: “”,“city”: “”,“stateProvince”: “”,“postal”: “”,}}The container1 container has the following indexing policy.{“indexingMode”: “consistent”,“includePaths”: [{“path”: “/*”},{“path”: “/address/city/?”}],“excludePaths”: [{“path”: “/address/*”},{“path”: “/firstName/?”}]}For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.  Loading … DP-420 PDF Dumps Are Helpful To produce Your Dreams Correct QA's: https://www.vceprep.com/DP-420-latest-vce-prep.html --------------------------------------------------- Images: https://certify.vceprep.com/wp-content/plugins/watu/loading.gif https://certify.vceprep.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2023-03-05 16:43:15 Post date GMT: 2023-03-05 16:43:15 Post modified date: 2023-03-05 16:43:15 Post modified date GMT: 2023-03-05 16:43:15