DP-420試験無料問題集「Microsoft Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB 認定」

You need to create a .NET console app to manage data in the Azure Cosmos DB SQL API account. As a part of the procedure, you need to create a database. Which of the following method can you use to create a database?

解説: (GoShiken メンバーにのみ表示されます)
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named db1. The subscription is linked to a Microsoft Entra tenant that contains a user named User1.
You need to delegate permissions to User1 to meet the following requirements:
- Ensure that User1 can manage db1.
- Prevent User1 from accessing connection strings.
- Prevent User1 from accessing the data stored in db1.
Which role should you assign to User1?

解説: (GoShiken メンバーにのみ表示されます)
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?

解説: (GoShiken メンバーにのみ表示されます)
The following is a sample of a document in orders.

The orders container uses customerId 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?

解説: (GoShiken メンバーにのみ表示されます)
Hotspot Question
You have an Azure Cosmos DB for NoSQL database named db1.
You run the following .NET 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.
正解:
Hotspot Question
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.

The container1 container has the following indexing policy.

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

Explanation:
Box 1: Yes
"path": "/*" is in includePaths.
Include the root path to selectively exclude paths that don't need to be indexed. This is the recommended approach as it lets Azure Cosmos DB proactively index any new property that may be added to your model.
Box 2: No
"path": "/firstName/?" is in excludePaths.
Box 3: Yes
"path": "/address/city/?" is in includePaths
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/index-policy
Drag and Drop Question
You have an app that stores data in an Azure Cosmos DB for NoSQL 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.
正解:

Explanation:
Step 1: Configure the MaxItemCount in QueryRequestOptions You can specify the maximum number of items returned by a query by setting the MaxItemCount. The MaxItemCount is specified per request and tells the query engine to return that number of items or fewer.
Box 2: Run the query and provide a continuation token
In the .NET SDK and Java SDK you can optionally use continuation tokens as a bookmark for your query's progress. Azure Cosmos DB query executions are stateless at the server side and can be resumed at any time using the continuation token.
If the query returns a continuation token, then there are additional query results.
Step 3: Append the results to a variable
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-pagination
You have an Azure Cosmos DB for NoSQL account that hosts a container named Container1.
You implement a change feed processor.
You discover that the processor is processing changes more slowly than the changes occur in Container1.
You need to resolve the issue.
What should you use?

解説: (GoShiken メンバーにのみ表示されます)
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?