Latest Exam Prep

NEW QUESTION 132
Hotspot Question
You have an Azure Cosmos DB for NoSQL database named DB1 that hosts a container named Container1. The partition key for Container1 is /city.
You are developing a cloud-native app named App1 that will store customer information in DB1.
App1 will perform transactional batch operations to update the items in Container1.
You need to configure App1 to meet the following requirements:
– Ensure that batch operations are rolled back if an item’s ETag value
has changed since the value was last read.
– Ensure that all operations in the batch apply to a single partition
key value.
How should you complete the C# code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

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

You need to store the account key of account1 in KV1.
What should you use?

NEW QUESTION 134
Hotspot Question
You have an Azure Cosmos DB for NoSQL account that has a single write region in West Europe.
You run the following Azure CLI script.

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

NEW QUESTION 135
You plan to implement an Azure Cosmos DB container that will store telemetry data from 1,000 IoT devices. The data will be updated once every minute. An app will read the data once daily and generate aggregated reports that summarize the state of each device.
You need to configure a partition key for the container. The solution must meet the following requirements:
– Minimize the possibility of reaching the partition limits.
– Spread read and write operations evenly across the partitions.
– Minimize how long it takes to locate a specific set of telemetry
values.
To what should you set the partition key?

NEW QUESTION 136
You plan to implement con-iot1 and con-iot2.
You need to configure the default Time to Live setting for each container. The solution must meet the loT telemetry requirements.
What should you configure? To answer, select the appropriate options in the answer NOTE: Each correct selection is worth one point.

NEW QUESTION 137
You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON

You are writing a query that will retrieve the average age of each pet owned by each owner, il the pet is older than two years.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes 01 scroll to view content.
NOTE: Each correct selection is worth one point.

NEW QUESTION 138
You have an Azure Cosmos DB for NoSQL account.
You configure the diagnostic settings to send all log information to a Log Analytics workspace.
You need to identify when the provisioned request units per second (RU/s) for resources within the account were modified.
You write the following query.
AzureDiagnostics
| where Category == “ControlPlaneRequests”
What should you include in the query?

NEW QUESTION 139
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.

NEW QUESTION 140
You have a database in an Azure Cosmos DB Core (SQL) API account.
You plan to create a container that will store employee data for 5,000 small businesses. Each business will have up to 25 employees. Each employee item will have an emailAddress value.
You need to ensure that the emailAddress value for each employee within the same company is unique.
To what should you set the partition key and the unique key? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NEW QUESTION 141
You plan to implement con-iot1 and con-iot2.
You need to configure the default Time to Live setting for each container. The solution must meet the loT telemetry requirements.
What should you configure? To answer, select the appropriate options in the answer NOTE: Each correct selection is worth one point.

NEW QUESTION 142
You are developing an application that will use an Azure Cosmos DB Core (SQL) API account as a data source.
You need to create a report that displays the top five most ordered fruits as shown in the following table.

A collection that contains aggregated data already exists. The following is a sample document:
{
“name”: “apple”,
“type”: [“fruit”, “exotic”],
“orders”: 10000
}
Which two queries can you use to retrieve data for the report? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A)

B)

C)

D)

NEW QUESTION 143
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.

NEW QUESTION 144
You have an Azure Cosmos DB for NoSQL container named Container1 that contains 20,000 items. The items have 1,000 unique partition key values. Each item is 50 KB.
You need to evaluate the cost of running cross-partition queries by using Container1.
What should you do first?

NEW QUESTION 145
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.

NEW QUESTION 146
Case Study 1 – Litware, inc
Overview
Litware, Inc. is a United States-based grocery retailer. Litware has a main office and a primary datacenter in Seattle. The company has 50 retail stores across the United States and an emerging online presence. Each store connects directly to the internet. Existing environment.
Cloud and Data Service Environments. Litware has an Azure subscription that contains the resources shown in the following table.

Each container in productdb is configured for manual throughput. The con-product container stores the company’s product catalog data. Each document in con-product includes a con- productvendor value. Most queries targeting the data in con-product are in the following format.
SELECT * FROM con-product p WHERE p.con-productVendor – ‘name’
Most queries targeting the data in the con-productVendor container are in the following format SELECT * FROM con-productVendor pv ORDER BY pv.creditRating, pv.yearFounded Existing environment.
Current Problems.
Litware identifies the following issues:
– Updates to product categories in the con-productVendor container do not propagate automatically to documents in the con-product container.
– Application updates in con-product frequently cause HTTP status code 429 “Too many requests”.
– You discover that the 429 status code relates to excessive request unit (RU) consumption during the updates.
Requirements.
Planned Changes
Litware plans to implement a new Azure Cosmos DB for NoSQL account named account2 that will contain a database named iotdb. The iotdb database will contain two containers named con- iot1 and con-iot2.
Litware plans to make the following changes:
– Store the telemetry data in account2.
– Configure account1 to support multiple read-write regions.
– Implement referential integrity for the con-product container.
– Use Azure Functions to send notifications about product updates to different recipients.
– Develop an app named App1 that will run from all locations and query the data in account1.
– Develop an app named App2 that will run from the retail stores and query the data in account2.
– App2 must be limited to a single DNS endpoint when accessing account2.
Requirements.
Business Requirements
Litware identifies the following business requirements:
– Whenever there are multiple solutions for a requirement, select the solution that provides the best performance, as long as there are no additional costs associated.
– Ensure that Azure Cosmos DB costs for IoT-related processing are predictable.
– Minimize the number of firewall changes in the retail stores.
Requirements.
Product Catalog Requirements
Litware identifies the following requirements for the product catalog:
– Implement a custom conflict resolution policy for the product catalog data.
– Minimize the frequency of errors during updates of the con-product container.
– Once multi-region writes are configured, maximize the performance of App1 queries against the data in account1.
– Trigger the execution of two Azure functions following every update to any document in the con- product container.
You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.
What should you select?

NEW QUESTION 147
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account.
The following is a sample of a document in container1.
{
“studentId”: “631282”,
“firstName”: “James”,
“lastName”: “Smith”,
“enrollmentYear”: 1990,
“isActivelyEnrolled”: true,
“address”: {
“street”: “”,
“city”: “”,
“stateProvince”: “”,
“postal”: “”,
}
}
The container1 container has the following indexing policy.
{
“indexingMode”: “consistent”,
“includePaths”: [
{
“path”: “/*”
},
{
“path”: “/address/city/?”
}
],
“excludePaths”: [
{
“path”: “/address/*”
},
{
“path”: “/firstName/?”
}
]
}
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

NEW QUESTION 148
You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.
SELECT
IS_NUMBER(“1234”) AS A,
IS_NUMBER(1234) AS B,
IS_NUMBER({prop: 1234}) AS C
What is the output of the query?

NEW QUESTION 149
You have an Azure subscription.
You need to deploy the following resources to an Azure Cosmos DB for NoSQL account:
* A container
* A user-defined function (UDF)
The solution must minimize the possibility of the deployment failing.
How should you complete the template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NEW QUESTION 150
You have an Azure Cosmos DB Core (SQL) API account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception.
The runtime exception prevents conflicts from being resolved.
You need to use an Azure function to resolve the conflicts.
What should you use?

NEW QUESTION 151
You are developing an application that will use an Azure Cosmos DB Core (SQL) API account as a data source.
You need to create a report that displays the top five most ordered fruits as shown in the following table.

A collection that contains aggregated data already exists. The following is a sample document:
{
“name”: “apple”,
“type”: [“fruit”, “exotic”],
“orders”: 10000
}
Which two queries can you use to retrieve data for the report? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

NEW QUESTION 152
You plan to create a container named Container1 in an Azure Cosmos DB for NoSQL account Container! will store items that contain user sign-in session data from multiple organizations. Each user is assigned to a single organization.
Contained will include the following properties:
* Userld
* Sessionld
* SessionStart
* Organizationld
The following are common queries served by Container1.
SELECT SessionID,SessionStart,UserID FROM c WHERE Organizationld = 6 AND Userld = 50143 SELECT SessionID,SessionStart,UserID FROM c WHERE Organizationld – 6 You need to recommend a partitioning scheme for Container! that meets the following requirements:
You need to recommend a partitioning scheme for Container! that meets the following requirements:
* Maximizes performance
* Minimizes the cost of read queries
* Minimizes the possibility of reaching the partition size limits
Which type of partition key and which partition key properties should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NEW QUESTION 153
You have a database in an Azure Cosmos DB for NoSQL account that is configured for multi-region writes.
You need to use the Azure Cosmos DB SDK to implement the conflict resolution policy for a container. The solution must ensure that any conflict sent to the conflict feed.
Solution: You set ConfilictResolutionMode to Custom. You Set ResolutionProcedures to a custom stored procedure. You configure the custom stored procedure to use the isTomstone parameter to resolve conflict.
Does this meet the goal?

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

In CosmosDB1, you plan to create a container named Container1 that will store sensitive data.
You need to ensure that Container1 uses Always Encrypted for Azure Cosmos DB.
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.

NEW QUESTION 155
Hotspot Question
You have an Azure Cosmos DB for NoSQL account used by an application named App1.
You open the Insights pane for the account and see the following chart.

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

NEW QUESTION 156
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.

The orderId property is used as the partition key.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.