Microsoft Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB - DP-420 Exam Practice Test
Hotspot Question
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 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.
Correct Answer:
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?
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?
Correct Answer: D
Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).
Hotspot Question
You have the following Azure Resource Manager (ARM) template.
You plan to deploy the template in incremental mode.
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 the following Azure Resource Manager (ARM) template.
You plan to deploy the template in incremental mode.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: No
An account is not a resource in this context.
Note: In incremental mode, Resource Manager leaves unchanged resources that exist in the resource group but aren't specified in the template. Resources in the template are added to the resource group.
The Microsoft.DocumentDB databaseAccounts/sqlDatabases/containers resource type can be deployed to: Resource groups.
Box 2: Yes
A container is a resource.
Box 3: No
Note that you can't change the partition key of a container. If you do need to change it, you need to migrate the container data to a new container with the correct key.
Reference:
https://docs.microsoft.com/en-us/azure/templates/microsoft.documentdb/databaseaccounts/sqldatabases/containers
https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/deployment-modes#incremental-mode
You plan to deploy an Azure Cosmos DB for NoSQL account that will contain orders and the order lines of each order.
You need to recommend an account design that will maximize performance and minimize the cost of reading a single order and its order lines.
What should you recommend?
You need to recommend an account design that will maximize performance and minimize the cost of reading a single order and its order lines.
What should you recommend?
Correct Answer: C
Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).
Hotspot Question
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.
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.
Correct Answer:
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/azure/cosmos-db/plan-manage-costs
https://azure.microsoft.com/en-us/pricing/details/cosmos-db/
Hotspot Question
You have an Azure Cosmos DB for NoSQL database that hosts a container named Container1.
Container1 stores order details, including the following properties:
- OrderNumber (a number)
- OrderDate (a date)
You need to write a query that returns the following for each order:
- OrderNumber
- PeriodDate (as the first day of the calendar year based on orderDate) 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 Cosmos DB for NoSQL database that hosts a container named Container1.
Container1 stores order details, including the following properties:
- OrderNumber (a number)
- OrderDate (a date)
You need to write a query that returns the following for each order:
- OrderNumber
- PeriodDate (as the first day of the calendar year based on orderDate) How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point
Correct Answer:
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that uses a default consistency level of Consistent Prefix.
You execute a SELECT query and specify the Consistent Prefix consistency level.
You need to execute a second SELECT query during the same session and specify a lower consistency level.
Which consistency level can be used for the second SELECT query?
You execute a SELECT query and specify the Consistent Prefix consistency level.
You need to execute a second SELECT query during the same session and specify a lower consistency level.
Which consistency level can be used for the second SELECT query?
Correct Answer: D
Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).
Hotspot Question
You have two Azure Cosmos for NoSQL containers named Container1 and Container2.
You plan to process the change feed for each container by using the following:
- Container1: Pull model
- Container2: Change feed processor
You need to track the current processing point for each change feed.
What should you use for each container? To answer, select the appropriate options in the answer area.
You have two Azure Cosmos for NoSQL containers named Container1 and Container2.
You plan to process the change feed for each container by using the following:
- Container1: Pull model
- Container2: Change feed processor
You need to track the current processing point for each change feed.
What should you use for each container? To answer, select the appropriate options in the answer area.
Correct Answer:
You have an Azure Cosmos DB database named database1 that contains a container named container1. The container1 container stores product data and has the following indexing policy.
Which path will be indexed?
Which path will be indexed?
Correct Answer: C
Hotspot Question
You have an Azure subscription that contains a resource group named RG1. RG1 contains an Azure Cosmos DB for NoSQL account named account1.
You plan to audit changes to the control plane of account1.
You need to ensure that audit events include the details of the security principal that performs each control plane change.
How should you complete the az command? 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 a resource group named RG1. RG1 contains an Azure Cosmos DB for NoSQL account named account1.
You plan to audit changes to the control plane of account1.
You need to ensure that audit events include the details of the security principal that performs each control plane change.
How should you complete the az command? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
