DP-420 Dumps are Available for Instant Access [2023]

Practice with these DP-420 dumps Certification Sample Questions

Exam DP-420: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB

Candidates for this exam must have solid knowledge and experience developing apps for Azure and working with Azure Cosmos DB database technologies. They should be proficient at developing applications by using the Core (SQL) API and SDKs, writing efficient queries and creating appropriate index policies, provisioning and managing resources in Azure, and creating server-side objects with JavaScript. They should be able to interpret JSON, read C# or Java code, and use PowerShell.

The English language version of this exam will be updated on August 4, 2022. Please download the skills measured document below to see what’s changing. If a localized version of this exam is available, it will be updated approximately eight weeks after this date.

Passing score: 700. Learn more about exam scores.

Part of the requirements for: Microsoft Certified: Azure Cosmos DB Developer Specialty

Download exam skills outline

Get to know about the salary of the Microsoft DP-420 certified professional

The salary of the Microsoft DP-420 Certified professional depends on the type of the organization, company size, location, and the number of years of experience. It also depends on the job title of the Microsoft DP-420 certified professional. The average salary a Microsoft DP-420 certified professional can get, after passing the exam with the help of the DP-420 Dumps is as follows:

• In Sweden: 37,000 SEK
• In the United Kingdom: 56,000 GBP
• In India: 45,000 INR
• In Germany: 43,000 EUR
• In the United States: 85,000 USD

 

NEW QUESTION 20
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.

The orderId property is used as the partition key.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

 

NEW QUESTION 21
You have the following query.
SELECT * FROM c
WHERE c.sensor = "TEMP1"
AND c.value < 22
AND c.timestamp >= 1619146031231
You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query.
What should you recommend?

• A. a composite index for (sensor ASC, value ASC, timestamp ASC)
• B. a composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for (sensor DESC, value DESC, timestamp DESC)
• C. a composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC, sensor ASC)
• D. a composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)

Answer: D

Explanation:
If a query has a filter with two or more properties, adding a composite index will improve performance.
Consider the following query:
SELECT * FROM c WHERE c.name = "Tim" and c.age > 18
In the absence of a composite index on (name ASC, and age ASC), we will utilize a range index for this query. We can improve the efficiency of this query by creating a composite index for name and age.
Queries with multiple equality filters and a maximum of one range filter (such as >,<, <=, >=, !=) will utilize the composite index.

 

NEW QUESTION 22
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?

• A. cmd = "SELECT * FROM Persons p
  WHERE p.accountnumber = LIKE @accountnumber"
• B. cmd = "SELECT * FROM Persons p
  WHERE p.accountnumber = @accountnumber"
• C. cmd = "SELECT * FROM Persons p
  WHERE p.accountnumber = 'accountnumber'"
• D. cmd = "SELECT * FROM Persons p
  WHERE p.accountnumber = '" + accountnumber + "'"

Answer: B

Explanation:
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

 

NEW QUESTION 23
You have the indexing policy shown in the following exhibit.

Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

 

NEW QUESTION 24
You 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.

Answer:

Explanation:

 

NEW QUESTION 25
You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.
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?

• A. Create a new synthetic key that contains deviceId and deviceManufacturer.
• B. Create a new synthetic key that contains deviceId and sensor1Value.
• C. Create a new synthetic key that contains deviceId and a random number.
• D. Use timestamp as the partition key.

Answer: C

Explanation:
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.
Incorrect Answers:
A: You will also not like to partition the data on "DateTime", because this will create a hot partition. Imagine you have partitioned the data on time, then for a given minute, all the calls will hit one partition. If you need to retrieve the data for a customer, then it will be a fan-out query because data may be distributed on all the partitions.
B: Senser1Value has only two values.
C: All the devices could have the same manufacturer.

 

NEW QUESTION 26
You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.
What should you select?

• A. the temperature
• B. the humidity
• C. the timestamp
• D. the device ID

Answer: D

Explanation:
The partition key is what will determine how data is routed in the various partitions by Cosmos DB and needs to make sense in the context of your specific scenario. The IoT Device ID is generally the "natural" partition key for IoT applications.
Scenario: The iotdb database will contain two containers named con-iot1 and con-iot2.
Ensure that Azure Cosmos DB costs for IoT-related processing are predictable.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/solution-ideas/articles/iot-using-cosmos-db

 

NEW QUESTION 27
The 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?

• A. All items will be deleted after one year.
• B. Items stored in the collection will be retained always, regardless of the items time to live value.
• C. Items stored in the collection will expire only if the item has a time to live value.
• D. All items will be deleted after one hour.

Answer: C

Explanation:
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.

 

NEW QUESTION 28
You 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 cn1
A function named Fn2 that reads the change feed of cn2
A function named Fn3 that reads the change feed of cn3
You 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.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/change-feed-design-patterns
https://docs.microsoft.com/en-us/azure/cosmos-db/change-feed

 

NEW QUESTION 29
Note: 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?

• A. No
• B. Yes

Answer: B

Explanation:
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.

 

NEW QUESTION 30
You are creating a database in an Azure Cosmos DB Core (SQL) API account. The database will be used by an application that will provide users with the ability to share online posts. Users will also be able to submit comments on other users' posts.
You need to store the data shown in the following table.

The application has the following characteristics:
Users can submit an unlimited number of posts.
The average number of posts submitted by a user will be more than 1,000.
Posts can have an unlimited number of comments from different users.
The average number of comments per post will be 100, but many posts will exceed 1,000 comments.
Users will be limited to having a maximum of 20 interests.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

 

NEW QUESTION 31
You 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?

• A. Direct mode over HTTPS
• B. Direct mode over TCP
• C. Gateway mode (using HTTPS)

Answer: B

Explanation:
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-endpoints

 

NEW QUESTION 32
You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps.
You need to analyze the data stored in the account by using Apache Spark to create machine learning models. The solution must NOT affect the performance of the web apps.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source.
• B. Enable Azure Synapse Link for the account and Analytical store on the container.
• C. In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.oltp as the data source.
• D. Create a private endpoint connection to the account.
• E. In an Azure Synapse Analytics serverless SQL pool, create a view that uses OPENROWSET and the CosmosDB provider.

Answer: A,B

Explanation:
Reference:
https://github.com/microsoft/MCW-Cosmos-DB-Real-Time-Advanced-Analytics/blob/main/Hands-on%20lab/HOL%20step-by%20step%20-%20Cosmos%20DB%20real-time%20advanced%20analytics.md

 

NEW QUESTION 33
You 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.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-multi-master
https://docs.microsoft.com/en-us/azure/cosmos-db/optimize-cost-regions

 

NEW QUESTION 34
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?

• A. DocumentDB Account Contributor only
• B. CosmosDB Operator only
• C. DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor
• D. Cosmos DB Built-in Data Contributor only

Answer: B

Explanation:
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.

 

NEW QUESTION 35
The 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?

• A. Configure the report to query a new aggregate container. Populate the aggregates by using SQL queries that run daily.
• B. Configure the report to query orders by using a SQL query through a dedicated gateway.
• C. Configure the report to query a new aggregate container. Populate the aggregates by using the change feed.
• D. Configure the report to query orders by using a SQL query.

Answer: C

Explanation:
You can facilitate aggregate data by using Change Feed and Azure Functions, and then use it for reporting.

 

NEW QUESTION 36
You need to implement a trigger in Azure Cosmos DB Core (SQL) API that will run before an item is inserted into a container.
Which two actions should you perform to ensure that the trigger runs? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. For each create request, set the trigger name in RequestOptions.
• B. Register the trigger as a pre-trigger.
• C. Append pre to the name of the JavaScript function trigger.
• D. For each create request, set the access condition in RequestOptions.
• E. For each create request, set the consistency level to session in RequestOptions.

Answer: B

Explanation:
C: When triggers are registered, you can specify the operations that it can run with.
F: When executing, pre-triggers are passed in the RequestOptions object by specifying PreTriggerInclude and then passing the name of the trigger in a List object.

 

NEW QUESTION 37
Note: 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 a container named container1 in an Azure Cosmos DB Core (SQL) API account.
You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.
Solution: You create an Azure function that uses Azure Cosmos DB Core (SQL) API change feed as a trigger and Azure event hub as the output.
Does this meet the goal?

• A. No
• B. Yes

Answer: B

Explanation:
The Azure Cosmos DB change feed is a mechanism to get a continuous and incremental feed of records from an Azure Cosmos container as those records are being created or modified. Change feed support works by listening to container for any changes. It then outputs the sorted list of documents that were changed in the order in which they were modified.
The following diagram represents the data flow and components involved in the solution:

 

NEW QUESTION 38
Note: 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 a container named container1 in an Azure Cosmos DB Core (SQL) API account.
You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.
Solution: You create an Azure Synapse pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.
Does this meet the goal?

• A. No
• B. Yes

Answer: A

Explanation:
Instead create an Azure function that uses Azure Cosmos DB Core (SQL) API change feed as a trigger and Azure event hub as the output.
The Azure Cosmos DB change feed is a mechanism to get a continuous and incremental feed of records from an Azure Cosmos container as those records are being created or modified. Change feed support works by listening to container for any changes. It then outputs the sorted list of documents that were changed in the order in which they were modified.
The following diagram represents the data flow and components involved in the solution:

 

NEW QUESTION 39
......

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:

• 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.
• 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.
• Go to the official website of Microsoft. Click on the “Schedule Exam”, which will take you to the Exam Registration Page.

 

Get Instant Access REAL DP-420 DUMP Pass Your Exam Easily: https://www.dumptorrent.com/DP-420-braindumps-torrent.html

DP-420 Free Exam Questions with Quality Guaranteed: https://drive.google.com/open?id=1DpC1wS17YmRd7OlYJK7v8TaKYvKA-1WE