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

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.

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.

You have a container named container1 in an Azure Cosmos DB for NoSQL account named account1.
You configure container1 to use Always Encrypted by using an encryption policy as shown in the C# and the Java exhibits. (Click the C# tab to view the encryption policy in C#. Click the Java tab to see the encryption policy in Java.)


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

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

You need to create a database in an Azure Cosmos DB for NoSQL account. The database will contain three containers named coll1, coll2 and coll3. The coll1 container will have unpredictable read and write volumes. The col!2 and coll3 containers will have predictable read and write volumes. The expected maximum throughput for coll1 and coll2 is 50,000 request units per second (RU/s) each.
How should you provision the collection while minimizing costs?
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?
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts
You configure account! to send resource logs to Log Analytics.
You need to identify any containers in account1 that were deleted during the past 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.

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You run the following query.

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

You have an Azure Cosmos DB for NoSQL account.
The change feed is enabled on a container named invoice.
You create an Azure function that has a trigger on the change feed.
What is received by the Azure function?
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.

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?
You have an app that stores data in an Azure Cosmos DB Core (SQL) API account The app performs queries that return large result sets.
You need to return a complete result set to the app by using pagination. Each page of results must return 80 items.
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.

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?
You have an Azure-hosted solution named App1 that contains the following components:
• An Azure Cosmos DB for NoSQL account that has two containers named Orders and Reporting
• An Azure Functions app that contains the following functions:
o Function1: Uses an Azure Cosmos DS trigger that reacts the change feed from Orders and writes aggregated
sales data to Reporting
o function2: Reads the change feed from Orders to populate a search index
Both functions use the change feed in latest version mode.
In Appl. order cancelations trigger a hard delete of the order item from the Orders container. During peak periods, the same tern can be updated multiple times within a short interval.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB database that hosts a container named container1.
You need to ensure that the items stored in contained will NOT expire unless their TTL value is set explicitly. What should you do?
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.

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?
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you create a container that has the following configurations:
• Partition key: CompanylD
• Composite unique key: UserName and EmailAddress
To the container, you plan to add the data items shown in the following table.

How many conflicts will occur?
You have an Azure Cosmos DB for NoSQL account named account1.
You have an app named App1 that connects to account1 and uses strong consistency for all requests.
You implement the Azure Cosmos DB integrated cache for account1.
You need to ensure that App1 uses the integrated cache.
What should you do?
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?
You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.
What should you select?
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?
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?
You need to implement a solution to meet the product catalog requirements.
What should you do to implement the conflict resolution policy.
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.

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.