Microsoft DP-420認定資格 は主要材料 & DP-420認定資格: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DBPass4Testは頼りが強い上にサービスもよくて、もしDP-420試験に失敗したら全額で返金いたしてまた一年の無料なアップデートいたします。 Microsoft Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB 認定 DP-420 試験問題 (Q100-Q105):質問 # 100
You have a container named contained in an Azure Cosmos DB for NoSQL account.
The following is a sample of a document in container1.
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:
質問 # 101
You have the indexing policy shown in the following exhibit.
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. 正解：
解説：
質問 # 102
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?
A. Configure the report to query a new aggregate container. Populate the aggregates by using the change feed.
B. Configure the report to query orders by using a SQL query.
C. Configure the report to query a new aggregate container. Populate the aggregates by using SQL queries that run daily.
D. Configure the report to query orders by using a SQL query through a dedicated gateway.
正解：A
解説：
You can facilitate aggregate data by using Change Feed and Azure Functions, and then use it for reporting.
質問 # 103
You have an Azure Cosmos DB Core (SQL) API account named storage1 that uses provisioned throughput capacity mode.
The storage1 account contains the databases shown in the following table.
The databases contain the containers 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. 正解：
解説：
Explanation:
Box 1: No
Four containers with 1000 RU/s each.
Box 2: No
Max 8000 RU/s for db2. 8 containers, so 1000 RU/s for each container.
Box 3: Yes
Max 8000 RU/s for db2. 8 containers, so 1000 RU/s for each container. Can very well add an additional container.
Reference: https://docs.microsoft.com/en-us ... b/plan-manage-costs https://azure.microsoft.com/en-us/pricing/details/cosmos-db/
質問 # 104
You have an Azure Cosmos DB for NoSQL account that frequently receives the same three queries.
You need to configure indexing to minimize RUs consumed by the queries.
Which type of index should you use for each query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point. 正解：
解説：
Explanation:
Box 1 = Range Azure Cosmos DB supports three types of indexes: range, spatial and composite. For the query you provided, which is an equality query on a single property, the best type of index to use is range. Range index is based on an ordered tree-like structure and it is used for equality queries, range queries and checking for the presence of a property1. Range index also supports any string or number2.
Box 2 = Composite
Azure Cosmos DB supports three types of indexes: range, spatial and composite. For the query you provided, which is an order by query on two properties, the best type of index to use is composite. Composite index is used for optimizing order by queries on multiple properties1. Composite index allows you to specify a list of property paths and sort orders that are used for ordering items2.
Box 3 = spatial
Azure Cosmos DB supports three types of indexes: range, spatial and composite. For the query you provided, which is a spatial query on a point property, the best type of index to use is spatial. Spatial index is used for querying items based on their location or proximity to a given point1. Spatial index supports point, polygon and linestring data types2.
