[Dec 05, 2024] Today Updated DP-420 Exam Dumps Actual Questions
DP-420 exam dumps with real Microsoft questions and answers
Microsoft DP-420 certification exam is designed for individuals who want to demonstrate their expertise in designing and implementing cloud-native applications using Microsoft Azure Cosmos DB. Azure Cosmos DB is a globally distributed, multi-model database service that is designed to enable developers to build highly scalable and available applications.
NEW QUESTION # 68
You have a multi-region Azure Cosmos DB account named account1 that has a default consistency level of strong.
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 the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 69
You have the Azure Cosmos DB for NoSQL containers shown in the following table.
You have the items shown in the following table.
When will each item expire? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
NEW QUESTION # 70
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. Items stored in the collection will be retained always, regardless of the items time to live value.
- B. All items will be deleted after one year.
- 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:
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.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/time-to-live
NEW QUESTION # 71
Your company develops an application named App1 that uses the Azure Cosmos DB SDK and the Eventual consistency level.
App1 queries an Azure Cosmos DB for NoSQL account named account!
You need to identify which consistency level to assign to App1 to meet the following requirements:
* Maximize the throughput of the queries generated by App1 without increasing the number of request units currently used by the queries.
* Provide the highest consistency guarantees.
Which consistency level should you identify?
- A. Bounded Staleness
- B. Consistent Prefix
- C. Session
- D. Strong
Answer: D
NEW QUESTION # 72
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 = '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 = LIKE @accountnumber"
Answer: C
Explanation:
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
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-parameterized-queries
NEW QUESTION # 73
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 # 74
You have an Azure Cosmos DB for NoSQL 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.
Answer:
Explanation:
NEW QUESTION # 75
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. For each create request, set the access condition in RequestOptions.
- C. For each create request, set the consistency level to session in RequestOptions.
- D. Append pre to the name of the JavaScript function trigger.
- E. Register the trigger as a pre-trigger.
Answer: A,E
Explanation:
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.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-use-stored-procedures-triggers-udfs
NEW QUESTION # 76
You 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.
Answer:
Explanation:
Explanation
NEW QUESTION # 77
You plan to create an Azure Cosmos DB account that will use the NoSQL API.
You need to create a grouping strategy for items that will be stored in the account. The solution must ensure that write and read operations on the items can be performed within the same transact!
What should you use to group the items?
- A. databases
- B. containers
- C. logical partitions
- D. physical partitions
Answer: C
NEW QUESTION # 78
You have operational data in an Azure Cosmos OB for NoSQL database.
Database users report that the performance of the database degrades significantly when a business analytics team runs large Apache Spark-based queries against the database.
You need 10 reduce the impact that running the Spark-based queries has on the database users.
What should you implement?
- A. a default consistency level of Strong
- B. the Spark connector
- C. Azure Synapse Link
- D. a default consistency level of Consistent Prefix
Answer: C
NEW QUESTION # 79
You have the Azure Cosmos DB for NoSQL containers shown in the following table.
You have the items shown in the following table.
When will each item expire? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
NEW QUESTION # 80
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1 and a Log Analytics workspace named Workspace1. Workspace 1 stores the logs of account1.
You need to identify which operations used the most request units per second (RU/s) during the last 24 hours.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point
Answer:
Explanation:
Explanation:
NEW QUESTION # 81
You have an Azure Cosmos DB for NoSQL account.
You plan 10 create a container named container1. The container1 container will store items that include two properties named nm and age The most commonly executed queries will query container1 for a specific name. The following is a sample of the query.
You need to define an opt-in Indexing policy for container1. The solution must meet the following requirements:
* Minimize the number of request units consumed by the queries.
* Ensure that the _etag property is excluded from indexing.
How should you define the indexing poky? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection Is worth one point.
Answer:
Explanation:
Explanation
NEW QUESTION # 82
You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a and a read region in East US.
You run the following PowerShell command.
What is the effect of running the command?
- A. The account will be unavailable to writes during the change.
- B. A manual failover will occur.
- C. The provisioned throughput for account1 will increase.
- D. The account will be configured for multi-region writes.
Answer: A
Explanation:
Explanation
You can use the Set-AzCosmosDBAccountRegion cmdlet to update the regions that an Azure Cosmos DB account uses. You can use this cmdlet to add a region or change the region failover order. The cmdlet requires a resource group name, an Azure Cosmos DB account name, and a list of regions in desired failover order1.
For your scenario, based on the PowerShell command, you are using the Set-AzCosmosDBAccountRegion cmdlet to update the regions for an Azure Cosmos DB account named account1 that is configured for automatic failover. The command specifies two regions: West US and East US. The effect of running the command is that the account will be configured for multi-region writes.
Multi-region writes is a feature of Azure Cosmos DB that allows you to write data to any region in your account and have it automatically replicated to all other regions. This feature provides high availability and low latency for write operations across multiple regions. To enable multi-region writes, you need to specify at least two regions in your account and set them as write regions2. In your command, you are setting both West US and East US as write regions by using the -IsZoneRedundant parameter with a value of $true for both regions.
NEW QUESTION # 83
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:
Explanation:
Box 1: Yes
Records with different OrderIDs will match.
Box 2: Yes
Records with different OrderIDs will match.
Box 3: No
Only records with one specific OrderId will match
NEW QUESTION # 84
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 the change feed.
- 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 SQL queries that run daily.
- D. Configure the report to query orders by using a SQL query.
Answer: A
Explanation:
You can facilitate aggregate data by using Change Feed and Azure Functions, and then use it for reporting.
NEW QUESTION # 85
You have an Azure Cosmos DB account named account1.
You have several apps that connect to account1 by using the account's secondary key.
You then configure the apps to authenticate by using service principals.
You need to ensure that account1 will only allow apps to connect by using an Azure AD identity.
Which account property should you modify?
- A. allowedOrxgins
- B. disableKeyBasedMetadataWriteAccess ,
- C. userAssignedldentatxe
- D. disableLocalAuth
Answer: D
Explanation:
The disableLocalAuth property is a boolean flag that indicates whether local authentication methods such as primary/secondary keys are disabled for the Azure Cosmos DB account. Setting this property to true improves security by ensuring that Azure Cosmos DB accounts exclusively require Azure Active Directory identities for authentication1.
NEW QUESTION # 86
......
The DP-420 exam is an intermediate-level test and requires candidates to have a strong understanding of the Azure platform, including Azure Cosmos DB, and related cloud technologies. DP-420 exam assesses the candidate's ability to develop, design, and implement cloud-native applications that utilize Cosmos DB's features and functionality. DP-420 exam also tests the candidate's knowledge of Cosmos DB's APIs, data modeling, partitioning, security, and performance tuning.
Exam Sure Pass Microsoft Certification with DP-420 exam questions: https://passleader.briandumpsprep.com/DP-420-prep-exam-braindumps.html
