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 default consistency level of Consistent Prefix

a default consistency level of Strong

You plan to create an operational system that will store data in an Azure Cosmos OB 'or NoSQL account. You need to configure the account to meet the following requirements:• Support Spar* queries.• Support the analysis of data from the last six months.• Only pay for analytical compute when running queries.Which three actions should you perform? Each correct answer presents part of the solution. NOTE Each correct selection is worth one point.

Create a container and set the analytical property to six months.

Create an Azure Databanks notebook.

Enable Azure Synapse Link for the account

Create an Azure Synapse linked service.

Create a container and set the time to live to six months.

Create a container and set the analytical property to six months.

Create an Azure Synapse pipeline.

Create an Azure Databanks notebook.

Enable Azure Synapse Link for the account

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?

Change the indexing mode of container 1 to

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

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

You have an application that queries an Azure Cosmos 06 for NoSQL account.You discover that the following two queries run frequently You need to minimize the request units (RUs) consumed by reads and writes. What should you create?

a composite index for (name ASC, time stamp ASC)

a composite index for (name DESC, time stamp ASC)

a composite index for (name ASC, time stamp DESC)

a composite index for (name ASC time stamp ASC) and a composite index for (name, time stamp disc)

a composite index for (name ASC, time stamp ASC)

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.

Configure the same processor name for all the instances.

Configure a different instance name for each instance.

Configure the same lease container configuration for all the instances.

Configure the same processor name for all the instances.

Configure a different processor name for each instance.

Configure a different lease container configuration for each instance.

Configure the same instance name for all the instances. 13

Configure a different instance name for each instance.

Configure the same lease container configuration for all the instances.

You are building an application that will store data in an Azure Cosmos DB for NoSQL account. The account uses the session default consistency level. The account is used by five other applications.The account has a single read-write region and 10 additional read regions.Approximately 20 percent of the items stored in the account are updated hourly.Several users will access the new application from multiple devices.You need to ensure that the users see the same item values consistently when they browse from the different devices. The solution must not affect the other applications.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Provide a stored session token when performing read requests.

Associate a session token to the user account.

Use implicit session management when performing read requests.

Provide a stored session token when performing read requests.

Associate a session token to the user account.

Set the default consistency level to eventual.

Associate a session token to the device.

You have a container m an Azure Cosmos DB for NoSQL account. The container stores data about families. Data about parents, children, and pets are stored as separate documents.Each document contains the address of each family. Members of the same family share the same partition key named family IdYou need to update the address for each member of the same family that share the same address.The solution must meet the following requirements:• Be atomic consistent isolated, and durable (ACID).• Provide the lowest latency.What should you do?

Update the document of each family member by using a transactional batch operation.

Update the document of each family member separately by using a patch operation.

Update the document of each family member separately and set the consistency level to strong.

You have a container in an Azure Cosmos DB for NoSQL account that stores data about orders. The following is a sample of an order document. Documents are up to 2 KB.You plan to receive one million orders daily.Customers will frequently view then past order history.You are the evaluating whether to use orderDate as the partition key.What are two effects of using orderDate as the partition key? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

Queries will run cross-partition.

There will always be a hot partition.

You will exceed the maximum number of partition key values.

Queries will run cross-partition.

You will exceed the maximum storage per partition.

There will always be a hot partition.

You have a database named db1in an Azure Cosmos DB for NoSQL account named account 1.You need to write JSON data to db1 by using Azure Stream Analytics. The solution must minimize costs.Which should you do before you can use db1 as an output of Stream Analytics?

in account, add a private endpoint.

In db1, create containers that have a custom indexing policy and analytical store disabled.

In account, enable a dedicated gateway.

In db1, create containers that have an automatic indexing policy and analytical store enabled.

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 booksYou 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?

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

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

Microsoft DP-420 Practice Test 3 - Free Online Exam Questions 81-120

HOTSPOT

You have an Azure Cosmos DB account named account1 that has a default consistency level of session.

You have an app named App1.

You need to ensure that the read operations of App1 can request either bounded staleness or consistent prefix consistency.

What should you modify for each consistency level? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-420 Practice Test 3

Question

Microsoft DP-420 Practice Tests

Practice Tests