Practice Free DP-420 Exam Online Questions
HOTSPOT
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.
Explanation:
Box 1: Yes
Records with different OrderIDs will match.
Box 2: Yes
Records with different OrderIDs will match.
Box 3: No
Only records with one specific OrderId will match
You have a container m an Azure Cosmos DB for NoSQL account.
Data update volumes are unpredictable.
You need to process the change teed of the container by using a web app that has multiple instances. The change feed will be processed by using the change feed processor from the Azure Cosmos DB
SDK. The multiple instances must share the workload.
Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Configure the same processor name for all the instances.
- B . Configure a different processor name for each instance.
- C . Configure a different lease container configuration for each instance.
- D . Configure the same instance name for all the instances. 13
- E . Configure a different instance name for each instance.
- F . Configure the same lease container configuration for all the instances.
HOTSPOT
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.
You need to select the partition key for con-iot1 to meet the IoT telemetry requirements.
Which should you choose?
- A . timestamp
- B . humidity
- C . temperature
- D . device ID
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?
- A . disableKeyBasedMetadataWriteAccess ,
- B . disableLocalAuth
- C . userAssignedldentatxe
- D . allowedOrxgins
B
Explanation:
The disableLocalAuth property is a boolean flag that indicates whether local authentication methods such as primary/secondary keys are disabled for the Azure Cosmos DB account. Setting this property to true improves security by ensuring that Azure Cosmos DB accounts exclusively require Azure Active Directory identities for authentication1.
Your company develops an application named App1 that uses the Azure Cosmos DB SDK and the Eventual consistency level.
App1 queries an Azure Cosmos DB for NoSQL account named account!
You need to identify which consistency level to assign to App1 to meet the following requirements:
• Maximize the throughput of the queries generated by App1 without increasing the number of request units currently used by the queries.
• Provide the highest consistency guarantees.
Which consistency level should you identify?
- A . Strong
- B . Bounded Staleness
- C . Session
- D . Consistent Prefix
HOTSPOT
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.
You have an Azure Cosmos DB for NoSQL account.
The change feed is enabled on a container named invoice.
You create an Azure function that has a trigger on the change feed.
What is received by the Azure function?
- A . all the properties of the updated items
- B . only the partition key and the changed properties of the updated items
- C . all the properties of the original items and the updated items
- D . only the changed properties and the system-defined properties of the updated items
D
Explanation:
According to the Azure Cosmos DB documentation12, the change feed is a persistent record of changes to a container in the order they occur. The change feed outputs the sorted list of documents that were changed in the order in which they were modified.
The Azure function that has a trigger on the change feed receives all the properties of the updated items2. The change feed does not include the original items or only the changed properties. The change feed also includes some system-defined properties such as _ts (the last modified timestamp) and _lsn (the logical sequence number)3.
Therefore, the correct answer is:
You have an Azure Cosmos DB for NoSQL account. The account hosts a container that has the change feed enabled. You are building an app by using the Azure Cosmos DB SDK. The app will read items from the change feed by using a pull model. You need to ensure that multiple threads can read the change feed in parallel.
What should you include?
- A . the changeFeedStartFew value
- B . the Pagesize value
- C . the FeedRange value
- D . a stream-based iterator
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)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
B, D
Explanation:
ARRAY_CONTAINS returns a Boolean indicating whether the array contains the specified value. You can check for a partial or full match of an object by using a boolean expression within the command. Incorrect Answers:
A: Default sorting ordering is Ascending. Must use Descending order.
C: Order on Orders not on Type.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-array-contains