Free Microsoft DP-420 Practice Exam with Questions & Answers | Set: 3

Name: How to Pass DP-420 Exams
Brand: Examstrack
SKU: dp-420
Price: 34.5 USD
Availability: InStock

Questions 21

You are designing a data model for an Azure Cosmos DB for NoSQL account.

What are the partition limits for request units per second (RU/s) and storage? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-420 Question 21

Options:

Microsoft DP-420 Premium Access

Winston

06-Jun-2026

DP-420 was a breeze with examstrack.com's testing engine. Real exams were a cinch thanks to their competent IT experts.

Questions 22

You have a database in an Azure Cosmos DB for NoSQL account. The database contains a container named container1. The indexing mode container1 is set to none. You configure Azure Cognitive Search to extract data from container1 and make the data searchable. You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index. What should you do to resolve the issue?

Options:

Modify The index attributes in Cognitive Search to searchable.

Modify the index attributes in Cognitive Search to Retrievable.

Change the indexing mode of container 1 to consistent-

Modify the indexing policy of container 1 to exclude the / * path

Questions 23

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?

Options:

disableKeyBasedMetadataWriteAccess ,

disableLocalAuth

userAssignedldentatxe

allowedOrxgins

Questions 24

You are implementing an Azure Data Factory data flow that will use an Azure Cosmos DB (SQL API) sink to write a dataset. The data flow will use 2,000 Apache Spark partitions.

You need to ensure that the ingestion from each Spark partition is balanced to optimize throughput.

Which sink setting should you configure?

Options:

Throughput

Write throughput budget

Batch size

Collection action

Questions 25

You have a database named db1 in an Azure Cosmos DB for NoSQL account named account1. The db1 database has a manual throughput of 4,000 request units per second (RU/s).

You need to move db1 from manual throughput to autoscale throughput by using the Azure CLI. The solution must provide a minimum of 4,000 RU/s and a maximum of 40,000 RU/s.

How should you complete the CLI statements? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-420 Question 25

Options:

Questions 26

You have a development environment that uses multiple Azure subscriptions.

You plan to deploy a single Azure Cosmos DB account that will contain a single database in each subscription.

You need to automate the deployment by using an Azure Resource Manager (ARM) template. The solution must meet the following requirements:

• Minimize Azure Cosmos DB-related charges.

• Maximize the available request units per second (RU/s) without increasing costs.

How should you complete the template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

DP-420 Question 26

Options:

Questions 27

You have an Azure subscription.

You plan to create an Azure Cosmos DB for NoSQL database named DB1 that will store author and book data for authors that have each published up to ten books. Typical and frequent queries of the data will include:

• All books written by an individual author

• The synopsis of individual books

You need to recommend a data model for DB1. The solution must meet the following requirements:

• Support transactional updates of the author and book data.

• Minimize read operation costs.

What should you recommend?

Options:

Create a single container that stores author items and book items, and then items that represent the relationship between the authors and their books.

Create three containers, one that stores author items, a second that stores book items, and a third that stores items that represent the relationship between the authors and their books.

Create two containers, one that stores author items and another that stores book items. Embed a list of each author ' s books in the corresponding author item.

Create a single container that stores author items and book items. Embed a list of each author’s books in the

Questions 28

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.

DP-420 Question 28

For each of the following statements, select Yes if the statement is true, otherwise select No.

NOTE: Each correct selection is worth one point.

DP-420 Question 28

Options:

Questions 29

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?

Options:

cmd = " SELECT * FROM Persons p

WHERE p.accountnumber = ' accountnumber ' "

cmd = " SELECT * FROM Persons p

WHERE p.accountnumber = LIKE @accountnumber "

cmd = " SELECT * FROM Persons p

WHERE p.accountnumber = @accountnumber "

cmd = " SELECT * FROM Persons p

WHERE p.accountnumber = ' " + accountnumber + " ' "