Free certification test prep

NO.46 You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Upserts of items in container1 occur every three seconds.
You have an Azure Functions app named function1 that is supposed to run whenever items are inserted or replaced in container1.
You discover that function1 runs, but not on every upsert.
You need to ensure that function1 processes each upsert within one second of the upsert.
Which property should you change in the Function.json file of function1?

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

NO.48 You have an Azure Cosmos DB Core (SQL) API 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.

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

NO.50 Drag and Drop Question
You have an Azure Cosmos DB for NoSQL account that is configured for multi-region writes. The account contains a database that has two containers named container1 and container2. The following is a sample of a document in container1:
{
“customerId”: 1234,
“firstName”: “John”,
“lastName”: “Smith”,
“policyYear”: 2021
}
The following is a sample of a document in container2:
{
“gpsId”: 1234,
“latitude”: 38.8951,
“longitude”: -77.0364
}
You need to configure conflict resolution to meet the following requirements:
– For container1 you must resolve conflicts by using the highest value
for policyYear.
– For container2 you must resolve conflicts by accepting the distance
closest to latitude: 40.730610 and longitude: -73.935242.
– Administrative effort must be minimized to implement the solution.
What should you configure for each container? To answer, drag the appropriate configurations to the correct containers. Each configuration may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

NO.51 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:

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.

NO.52 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.

NO.53 The following is a sample of a document in orders.

The orders container uses customer as the partition key.
You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements:
Ensure that the report can run as quickly as possible.
Minimize the consumption of request units (RUs).
What should you do?

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

NO.55 You have a database named db1 in an Azure Cosmos DB for NoSQL
You are designing an application that will use dbl.
In db1, you are creating a new container named coll1 that will store in coll1.
The following is a sample of a document that will be stored in coll1.

The application will have the following characteristics:
* New orders will be created frequently by different customers.
* Customers will often view their past order history.
You need to select the partition key value for coll1 to support the application. The solution must minimize costs.
To what should you set the partition key?

NO.56 You plan to create an Azure Cosmos DB for NoSQL account that will have a single write region and three read regions.
You need to set the consistency level for the account. The solution must meet the following requirements:
– In the write region, writes must replicate synchronously across at
least three replicas.
– In the read regions, reads must see writes in order for transactional batches.
– Throughput for reads and writes must be maximized.
Which consistency level should you select?

NO.57 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 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 conflicts are sent to the conflicts feed.
Solution: You set ConflictResolutionMode to Custom and you use the default settings for the policy.
Does this meet the goal?

NO.58 Drag and Drop Question
You have an Azure subscription that contains an Azure AI Search service named search1 and an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1 in consistent indexing mode.
You need to ensure that the data in Container1 is searchable by using search1.
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.

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

NO.60 Hotspot Question
You have an Azure Cosmos DB for NoSQL container named Container1 that has a default indexing policy. Container1 has two properties named age and name. The _etag property is NOT indexed.
You run the following query.
SELECT c.name, c.age FROM c WHERE c.name = “Tim” ORDER BY c.age ASC
You need to add an index to Container1 and optimize the query syntax. The solution must minimize the number of RU/s utilized by the query and maximize query performance.
Which index should you add, and which query should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NO.61 You have a container that stores data about families. The following is a sample document.

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

NO.62 You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1.
In account1, you plan to create a container that will store the data items shown in the following table.

Each customer item will have customer sales by month values embedded.
The most executed query will return data for a matrix that aggregates the monthly sales of each business category. The matrix will use customer business categories as columns and months as rows.
You need to configure the partition key for the container. The solution must minimize the request units (RUs) required to run the query.
Which property should you use for the partition key?

NO.63 You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a and a read region in East US.
You run the following PowerShell command.

What is the effect of running the command?

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