Power Up Your Study Prep: Black Friday 75% Discount! Use coupon code below to save! - Ends in 0d 00h 00m 00s - Coupon code: big75certs

Free and Premium Microsoft DP-420 Dumps Questions Answers

Page: 1 / 8
Total 204 questions

Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Questions and Answers

Question 1

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

Options:

A.

Configure the trigger for each function to use a different leaseCollectionPrefix

B.

Configure the trigger for each function to use the same leaseCollectionNair.e

C.

Configure the trigger for each function to use a different leaseCollectionName

D.

Configure the trigger for each function to use the same leaseCollectionPrefix

Buy Now
Question 2

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.

Options:

Question 3

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

What should you select?

Options:

A.

the timestamp

B.

the humidity

C.

the temperature

D.

the device ID

Question 4

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 area. NOTE: Each correct selection is worth one point.

Options:

Question 5

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?

Options:

A.

Enable time to live for the con-product container.

B.

Set the default consistency level of account1 to strong.

C.

Set the default consistency level of account1 to bounded staleness.

D.

Add a custom indexing policy to the con-product container.

Question 6

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?

Options:

A.

Set the default consistency level of accountl to bounded staleness.

B.

Create a private endpoint connection.

C.

Modify the connection policy of App1.

D.

Increase the number of request units per second (RU/s) allocated to the con-product and con-productVendor containers.

Question 7

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

What should you do to implement the conflict resolution policy.

Options:

A.

Remove frequently changed field from the index policy of the con-product container.

B.

Disable indexing on all fields in the index policy of the con-product container.

C.

Set the default consistency level for account1 to eventual.

D.

Create a new container and migrate the product catalog data to the new container.

Question 8

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?

Options:

A.

Direct mode over HTTPS

B.

Gateway mode (using HTTPS)

C.

Direct mode over TCP

Question 9

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.

Options:

Question 10

You have an Azure Cosmos DB for NoSQL account that contains a container named container1.

You plan to use container1 as a key-value store that will perform point reads on the item ID and partition key.

You need to define an indexing policy for container! The solution must meet the following requirements:

• Provide the ability to set DefauitTimeToLive for container1.

• Minimize implementation time.

• Minimize costs.

How should you complete the JSON definition of the indexing policy? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 11

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1.

Backups for account1 have the following configurations:

• Interval: 2 hours

• Retention period: 4 days

You need to estimate the charges associated with the retention of the backups. How many copies of the backups will incur additional charges?

Options:

A.

8

B.

12

C.

46

D.

48

Question 12

You have an Azure Cosmos DB for NoSQL database that hosts the containers shown in the following table.

You need to ensure that when a product name changes in the Products container, the product name changes in all orders that have NOT been shipped.

What should you implement?

Options:

A.

a change feed

B.

a post-trigger

C.

a pre-trigger

D.

a stored procedure

Question 13

You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.

You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.

Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

A.

Wrap Key

B.

Get

C.

List

D.

Update

E.

Sign

F.

Verify

G.

Unwrap Key

Question 14

You have a container in an Azure Cosmos DB Core (SQL) API account. The container stores telemetry data from IoT devices. The container uses telemetryId as the partition key and has a throughput of 1,000 request units per second (RU/s). Approximately 5,000 IoT devices submit data every five minutes by using the same telemetryId value.

You have an application that performs analytics on the data and frequently reads telemetry data for a single IoT device to perform trend analysis.

The following is a sample of a document in the container.

You need to reduce the amount of request units (RUs) consumed by the analytics application.

What should you do?

Options:

A.

Decrease the offerThroughput value for the container.

B.

Increase the offerThroughput value for the container.

C.

Move the data to a new container that has a partition key of deviceId.

D.

Move the data to a new container that uses a partition key of date.

Question 15

You have an Azure Cosmos DB account named accounts

You need to access account1 from an on-premises environment by using a Site-to-Site VPN. What should you use?

Options:

A.

a private endpoint

B.

Azure Synapse Link

C.

a dedicated gateway

Question 16

You need to create a data store for a directory of small and medium-sized businesses (SMBs). The data store must meet the following requirements:

* Store companies and the users employed by them. Each company will have less than 1,000 users.

* Some users have data that is greater than 2 KB.

* Associate each user to only one company.

* Provide the ability to browse by company.

* Provide the ability to browse the users by company.

* Whenever a company or user profile is selected, show a details page for the company and all the related users.

* Be optimized for reading data.

Which design should you implement to optimize the data store for reading data?

Options:

A.

In a directory container, create a document for each company and a document for each user. Use company ID as the partition key.

B.

In a company container, create a document for each company. Embed the users into company documents. Use the company ID as the partition key.

C.

Create a user container that uses the user ID as the partition key and a company container that container that uses the company ID as the partition key. Add the company ID to each user documents.

D.

In a user container, create a document for each user. Embed the company into each user document. Use the user ID as the partition key.

Question 17

You have an Azure subscription that contains a resource group named RG1. RG1 contains an Azure Cosmos DB for NoSQL account named account1.

You plan to audit changes to the control plane of account1.

You need to ensure that audit events include the details of the security principal that performs each control plane change.

How should you complete the az command? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 18

Vou have an Azure Cosmos DB for NoSQL account that hosts a container named Container1. Contained has analytical store enabled, analytical TTL is set to 7 flays.

An application performs frequent updates to Container 1 and uses TTL to remove expired items.

Vou plan to build an incremental export from Container! to a downstream sink by using change data capture (CDC) in the analytical store and running the export from Azure Data Factory mapping data flows-

You need to configure CDC to meet the following requirement!

• The first run must include only changes from the last three days.

• The RUs required to perform the first run must be minimized.

• Subsequent runs must capture inserts updates, deletes, and TTL operations.

• The process must NOT rely on custom checkpoints based on the _is property,

Which CDC start option should you configure for the source?

Options:

A.

Start from the beginning, and set analytical TTL to 3 days so that the first CDC read contains only the last three days.

B.

Start from a specific timestamp set to now. and configure the pipeline to backfill the previous three days by querying the analytical store with a _is fitter

C.

Start from a specific timestamp set to three days ago.

D.

Start from the beginning, and set the dataflow to write rows only where the CDC operation time is within the last three days.

Question 19

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:

A.

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

B.

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.

C.

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.

D.

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

Question 20

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?

Options:

A.

Yes

B.

No

Question 21

You have a container in an Azure Cosmos DB Core (SQL) API account.

You need to use the Azure Cosmos DB SDK to replace a document by using optimistic concurrency.

What should you include in the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 22

You have the following query.

SELECT * FROM с

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?

Options:

A.

a composite index for (sensor ASC, value ASC) and a composite index for (sensor 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, timestamp ASC)

Question 23

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?

Options:

A.

CosmosDB Operator only

B.

DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor

C.

DocumentDB Account Contributor only

D.

Cosmos DB Built-in Data Contributor only

Question 24

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1. You plan to configure the Apache Kafka service as a data source for account1. What should you use to store the Kafka configuration?

Options:

A.

KRaft metadata quorum

B.

Azure Key Vault

C.

Apache Gremlin

D.

Apache Tomcat

Question 25

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

Options:

A.

" connector.class " : " com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector "

B.

" key.converter " : " org.apache.kafka.connect.json.JsonConverter "

C.

" key.converter " : " io.confluent.connect.avro.AvroConverter "

D.

" connect.cosmos.containers.topicmap " : " iot#telemetry "

E.

" connect.cosmos.containers.topicmap " : " iot "

F.

" connector.class " : " com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector "

Question 26

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:

A.

cmd = " SELECT * FROM Persons pWHERE p.accountnumber = ' accountnumber ' "

B.

cmd = " SELECT * FROM Persons pWHERE p.accountnumber = LIKE @accountnumber "

C.

cmd = " SELECT * FROM Persons pWHERE p.accountnumber = @accountnumber "

D.

cmd = " SELECT * FROM Persons pWHERE p.accountnumber = ' " + accountnumber + " ' "

Question 27

You have an Azure subscription.

You plan to implement an Azure Cosmos DB for NoSQL single-region write account named account1 that will replicate across two Azure regions.

You need to set the default consistency level for account1. The solution must meet the following requirements:

• Writes must be performed to a local majority in a single region.

• Reads must be performed from a local minority in a single region.

Which consistency level should you select?

Options:

A.

Session

B.

Consistent Prefix

C.

Strong

D.

Bounded Stateness

Question 28

You have a database in an Azure Cosmos DB Core (SQL) API account. The database is backed up every two hours.

You need to implement a solution that supports point-in-time restore.

What should you do first?

Options:

A.

Enable Continuous Backup for the account.

B.

Configure the Backup & Restore settings for the account.

C.

Create a new account that has a periodic backup policy.

D.

Configure the Point in Time Restore settings for the account.

Question 29

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.

Options:

Question 30

You have a container m an Azure Cosmos DB for NoSQL account.

Data update volumes are unpredictable.

You need to process the change teed of the container by using a web app that has multiple instances. The change feed will be processed by using the change feed processor from the Azure Cosmos DB SDK. The multiple instances must share the workload.

Which three actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

A.

Configure the same processor name for all the instances.

B.

Configure a different processor name for each instance.

C.

Configure a different lease container configuration for each instance.

D.

Configure the same instance name for all the instances. 13

E.

Configure a different instance name for each instance.

F.

Configure the same lease container configuration for all the instances.

Question 31

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.

Options:

Page: 1 / 8
Total 204 questions