ExamGecko
Login
Home / Microsoft / DP-420 / List of questions
Ask Question

Microsoft DP-420 Practice Test - Questions Answers

Add to Whishlist

List of questions

Question 1

Report Export Collapse

You are troubleshooting the current issues caused by the application updates.

Which action can address the application updates issue without affecting the functionality of the application?

Enable time to live for the con-product container.
Enable time to live for the con-product container.
Set the default consistency level of account1 to strong.
Set the default consistency level of account1 to strong.
Set the default consistency level of account1 to bounded staleness.
Set the default consistency level of account1 to bounded staleness.
Add a custom indexing policy to the con-product container.
Add a custom indexing policy to the con-product container.
Suggested answer: C
Explanation:

Bounded staleness is frequently chosen by globally distributed applications that expect low write latencies but require total global order guarantee. Bounded staleness is great for applications featuring group collaboration and sharing, stock ticker, publish-subscribe/queueing etc.

Scenario: Application updates in con-product frequently cause HTTP status code 429 "Too manyrequests". You discover that the 429 status code relates to excessive request unit (RU) consumptionduring the updates.

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels

asked 02/10/2024
Nicholas Stoner
47 questions

Question 2

Report Export Collapse

You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.

What should you select?

the timestamp
the timestamp
the humidity
the humidity
the temperature
the temperature
the device ID
the device ID
Suggested 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

asked 02/10/2024
Sujit Singh
36 questions

Question 3

Report Export Collapse

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?

Direct mode over HTTPS
Direct mode over HTTPS
Gateway mode (using HTTPS)
Gateway mode (using HTTPS)
Direct mode over TCP
Direct mode over TCP
Suggested answer: C
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

asked 02/10/2024
Easwari Lakshminarayanan
50 questions

Question 4

Report Export Collapse

You configure multi-region writes for account1.

You need to ensure that App1 supports the new configuration for account1. The solution must meet the business requirements and the product catalog requirements.

What should you do?

Set the default consistency level of accountl to bounded staleness.
Set the default consistency level of accountl to bounded staleness.
Create a private endpoint connection.
Create a private endpoint connection.
Modify the connection policy of App1.
Modify the connection policy of App1.
Increase the number of request units per second (RU/s) allocated to the con-product and conproductVendor containers.
Increase the number of request units per second (RU/s) allocated to the con-product and conproductVendor containers.
Suggested answer: D
Explanation:

App1 queries the con-product and con-productVendor containers.

Note: Request unit is a performance currency abstracting the system resources such as CPU, IOPS, and memory that are required to perform the database operations supported by Azure Cosmos DB.

Scenario:

Develop an app named App1 that will run from all locations and query the data in account1.

Once multi-region writes are configured, maximize the performance of App1 queries against the data in account1.

Whenever there are multiple solutions for a requirement, select the solution that provides the best performance, as long as there are no additional costs associated.

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels

asked 02/10/2024
Gerrit Struik
59 questions

Question 5

Report Export Collapse

You need to provide a solution for the Azure Functions notifications following updates to conproduct.

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 a different leaseCollectionPrefix
Configure the trigger for each function to use the same leaseCollectionNair.e
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 a different leaseCollectionName
Configure the trigger for each function to use the same leaseCollectionPrefix
Configure the trigger for each function to use the same leaseCollectionPrefix
Suggested answer: A, C
Explanation:

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 conproduct container.

Reference:

https://docs.microsoft.com/en-us/azure/azure-functions/functions-bindings-cosmosdb-v2-trigger

asked 02/10/2024
Oliver Buss
32 questions

Question 6

Report Export Collapse

You need to implement a solution to meet the product catalog requirements.

What should you do to implement the conflict resolution policy.

Remove frequently changed field from the index policy of the con-product container.
Remove frequently changed field from the index policy of the con-product container.
Disable indexing on all fields in the index policy of the con-product container.
Disable indexing on all fields in the index policy of the con-product container.
Set the default consistency level for account1 to eventual.
Set the default consistency level for account1 to eventual.
Create a new container and migrate the product catalog data to the new container.
Create a new container and migrate the product catalog data to the new container.
Suggested answer: D
asked 02/10/2024
Andrew Vogel
47 questions

Question 7

Report Export Collapse

HOTSPOT

You need to recommend indexes for con-product and con-productVendor. The solution must meet the product catalog requirements and the business requirements.

Which type of index should you recommend for each container? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft DP-420 image Question 7 90131 10022024015919000
Correct answer: Microsoft DP-420 image answer Question 7 90131 10022024015919000
Explanation:
asked 02/10/2024
jose fajardo
38 questions

Question 8

Report Export Collapse

HOTSPOT

You need to select the capacity mode and scale configuration for account2 to support the planned changes and meet the business requirements. What should you select? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.


Microsoft DP-420 image Question 8 90132 10022024015919000
Correct answer: Microsoft DP-420 image answer Question 8 90132 10022024015919000
asked 02/10/2024
David Rossi
36 questions

Question 9

Report Export Collapse

You have an application named App1 that reads the data in an Azure Cosmos DB Core (SQL) API account. App1 runs the same read queries every minute. The default consistency level for the account is set to eventual.

You discover that every query consumes request units (RUs) instead of using the cache.

You verify the IntegratedCacheiteItemHitRate metric and the IntegratedCacheQueryHitRate metric.

Both metrics have values of 0.

You verify that the dedicated gateway cluster is provisioned and used in the connection string.

You need to ensure that App1 uses the Azure Cosmos DB integrated cache.

What should you configure?

the indexing policy of the Azure Cosmos DB container
the indexing policy of the Azure Cosmos DB container
the consistency level of the requests from App1
the consistency level of the requests from App1
the connectivity mode of the App1 CosmosClient
the connectivity mode of the App1 CosmosClient
the default consistency level of the Azure Cosmos DB account
the default consistency level of the Azure Cosmos DB account
Suggested answer: C
Explanation:

Because the integrated cache is specific to your Azure Cosmos DB account and requires significant CPU and memory, it requires a dedicated gateway node. Connect to Azure Cosmos DB using gateway mode.

Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/integrated-cache-faq

asked 02/10/2024
Wissam Aoun
45 questions

Question 10

Report Export Collapse

You 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.

Microsoft DP-420 image Question 2 90134 10022024015919000000

A collection that contains aggregated data already exists. The following is a sample document:

{

"name": "apple",

"type": ["fruit", "exotic"],

"orders": 10000

}W hich 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.

Suggested answer: B, D
Explanation:

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.

Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-array-contains

asked 02/10/2024
Guilherme Silva
34 questions
Total 139 questions
Go to page: of 14
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

HOTSPOT You have an Azure subscription. You need to deploy the following resources to an Azure Cosmos DB for NoSQL account: * A container * A user-defined function (UDF) The solution must minimize the possibility of the deployment failing. How should you complete the template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have an Azure Cosmos DB for NoSQL account. The account hosts a container that has the change feed enabled. You are building an app by using the Azure Cosmos DB SDK. The app will read items from the change feed by using a pull model. You need to ensure that multiple threads can read the change feed in parallel. What should you include?
DRAG DROP You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON You are writing a query that will retrieve the average age of each pet owned by each owner, il the pet is older than two years. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes 01 scroll to view content. NOTE: Each correct selection is worth one point.
You have an Azure Cosmos DB database that hosts a container named container1. You need to ensure that the items stored in contained will NOT expire unless their TTL value is set explicitly. What should you do?
HOTSPOT You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You create a container and assign the following indexing policy. You run the queries 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.
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Devices. Devices has a partition key named type. You are evaluating the resource utilization of the query. How will the query be executed?
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account! that hosts a container named Container 1. Container! has a provisioned throughput of 100 request units per second (RU/s) and uses a single physical partition. Vou are evaluating the available throughput for Container1. What is the maximum burst capacity that Container1 can accumulate?
You have an Azure Cosmos DB for NoSQL account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level. You configure account1 to use a dedicated gateway and integrated cache. You need to ensure that App1 can use the integrated cache. Which two actions should you perform for APP1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
HOTSPOT You need to recommend indexes for con-product and con-productVendor. The solution must meet the product catalog requirements and the business requirements. Which type of index should you recommend for each container? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You define and implement an encryption policy by using the following C# code. For each of the following statements, select Yes if the statement is true, otherwise select No. NOTE: Each correct selection is worth one point.