QUESTION 47
You have a global ecommerce application that stores data in an Azure Cosmos DB for NoSQL account. The account is configured for multi-region writes.
You need to create a stored procedure for a custom conflict resolution policy for a new container.
In the event of a conflict caused by a deletion, the deletion must always take priority.
Which parameter should you check in the stored procedure function?

QUESTION 48
Drag and Drop Question
You have an Azure Synapse Analytics workspace named workspace1 that contains a serverless SQL pool.
You have an Azure Table Storage account that stores operational data.
You need to replace the Table storage account with Azure Cosmos DB for NoSQL. The solution must meet the following requirements:
– Support queries from the serverless SQL pool.
– Only pay for analytical compute when running queries.
– Ensure that analytical processes do NOT affect operational processes.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

QUESTION 49
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.

QUESTION 50
You have an Azure Cosmos DB for NoSQL container named Container1 that stores 500 GB of data.
You plan to run cross-partition queries that target Container1. The queries will include the partition key values specified in the db filters.
You need to minimize the cost of the queries.
What should you do?

QUESTION 51
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.

QUESTION 52
You have an Azure Cosmos DB for NoSQL container named Contacts that is configured as shown in the following exhibit.

Contacts contains the items shown in the following table.

To Contacts, you plan to insert the items 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.

QUESTION 53
Hotspot Question
You have an Azure Cosmos DB for NoSQL account that hosts a container named Customers.
You need to add customers to Customers by using the Azure Cosmos DB Spark Connector.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 54
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 are a. NOTE: Each correct selection Is worth one point.

QUESTION 55
Hotspot Question
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.

QUESTION 56
You have an Azure Synapse Analytics workspace named workspace1 that contains a server less SQL pool.
You have an Azure Table Storage account that stores operational data.
You need to replace the Table storage account with Azure Cosmos DB for NoSQL The solution must meet the following requirements:
* Support Queries from the server less SQL pool.
* Only pay for analytical compute when running queries.
* Ensure that analytical processes do
NOTE: affect operational processes.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

QUESTION 57
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 their 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.

QUESTION 58
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.

QUESTION 59
You have an Azure subscription that contains the resources shown in the following table.

You need to configure the sink connector for KafkaConnect1 to deliver messages from Topic1 to Container1.
How should you configure the value converter for the sink connector? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 60
Drag and Drop Question
You have an Azure subscription that contains the resources shown in the following table.

You need to create a container in db1 that has the following attributes:
– Name: Container1
– Encryption: Client-side encryption with Always Encrypted
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

QUESTION 61
You have an Azure Cosmos DB for NoSQL account that has multiple write regions.
You need to receive an alert when requests that target the database exceed the available request units per second (RU/s).
Which Azure Monitor signal should you use?

QUESTION 62
Hotspot Question
You have an Azure Cosmos DB for NoSQL account that hosts a container named Container1.
You are developing an Azure Function named Function1.
You need to ensure that Function1 will be triggered when an item is created or updated in Container1.
How should you complete the function? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 63
Hotspot Question
You have an Apache Spark pool in Azure Synapse Analytics that runs the following Python code in a notebook.

For each of the following statements. select Yes if the statement is true. Otherwise. select No.
NOTE: Each correct selection is worth one point.

QUESTION 64
You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices.
Writes from the devices will be occur every second.
The following is a sample of the data.

You need to select a partition key that meets the following requirements for writes:
– Minimizes the partition skew
– Avoids capacity limits
– Avoids hot partitions
What should you do?

QUESTION 65
You configure a backup for an Azure Cosmos DB for NoSQL account as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

QUESTION 66
You have a container named container1 in an Azure Cosmos DB for NoSQL account named account1 that is set to the session default consistency level. The average size of an item in container1 is 20 KB.
You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute.
You need to minimize the consumption of the request units (RUs) associated to the reads by App1. What should you do?

QUESTION 67
You have an Azure Cosmos DB for NoSQL database named db1.
You run the following 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.

QUESTION 68
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 to copy data to another Azure Cosmos DB Core (SQL) API container.
Does this meet the goal?