DumpsFiles
 Request Exam  Contact
  • Home
  • PRACTICE EXAMS
    Oracle
    Fortinet
    Juniper
    Microsoft
    Cisco
    Citrix
    CompTIA
    VMware
    ISC
    SAP
    EMC
    PMI
    HP
    Salesforce
    Other
  • View All Exams
  • New Dumps Files
  • Upload
  • Oracle
    Oracle
  • Fortinet
    Fortinet
  • Juniper
    Juniper
  • Microsoft
    Microsoft
  • Cisco
    Cisco
  • Citrix
    Citrix
  • CompTIA
    CompTIA
  • VMware
    VMware
  • ISC
    ISC
  • SAP
    SAP
  • EMC
    EMC
  • PMI
    PMI
  • HP
    HP
  • Salesforce
    Salesforce
  1. Home
  2. Microsoft
  3. Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
  4. Microsoft.DP-420.v2024-06-19.q119
  5. Question 28

Join the discussion

Question 28/119

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.

Correct Answer: 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.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-array-contains

Add Comments

Your email address will not be published. Required fields are marked *

insert code
Type the characters from the picture.
Rating:
Other Question (119q)
Q1. You have an Azure Cosmos DB Core (SQL) API account that is configured for multi-region wri...
Q2. You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The fo...
Q3. You have a multi-region Azure Cosmos DB account named account1 that has a default consiste...
Q4. Note: This question is part of a series of questions that present the same scenario. Each ...
Q5. You have an Azure Cosmos DB Core (SQL) API account used by an application named App1. You ...
Q6. The following is a sample of a document in orders. (Exhibit) The orders container uses cus...
Q7. You plan to store order data in Azure Cosmos DB for NoSQL account. The data contains infor...
Q8. You have an Azure Cosmos DB for NoSQL account that frequently receives the same three quer...
Q9. You have a database in an Azure Cosmos DB for NoSQL account. The database contains a conta...
Q10. You have a container in an Azure Cosmos DB for NoSQL account. The database that has a manu...
Q11. You have a container in an Azure Cosmos DB for NoSQL account. The database that has a manu...
Q12. You have a container in an Azure Cosmos DB Core (SQL) API account. You need to use the Azu...
Q13. You have a container in an Azure Cosmos DB for NoSQL account. The database that has a manu...
Q14. You need to create a data store for a directory of small and medium-sized businesses (SMBs...
Q15. You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Upsert...
Q16. You have an Azure Cosmos DB container named container1. You need to insert an item into co...
Q17. You plan to use a multi-region Azure Cosmos DB for NoSQL account to store data for a new a...
Q18. You provision Azure resources by using the following Azure Resource Manager (ARM) template...
Q19. You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Upsert...
Q20. You have the following Azure Resource Manager (ARM) template. (Exhibit) You plan to deploy...
Q21. You have an Azure Cosmos DB Core (SQL) API account named account1 that has the disableKeyB...
Q22. You have a container in an Azure Cosmos DB Core (SQL) API account. You need to use the Azu...
Q23. You plan to store order data in Azure Cosmos DB for NoSQL account. The data contains infor...
Q24. You have a database in an Azure Cosmos DB for NoSQL account that is configured for multi-r...
Q25. You have an Azure Cosmos DB for NoSQL container named Contacts that is configured as shown...
Q26. You have a database in an Azure Cosmos DB for NoSQL account that is configured for multi-r...
Q27. You have a database in an Azure Cosmos DB Core (SQL) API account. You need to create an Az...
Q28. You are developing an application that will use an Azure Cosmos DB Core (SQL) API account ...
Q29. You are developing an application that will use an Azure Cosmos DB Core (SQL) API account ...
Q30. You have a multi-region Azure Cosmos DB account named account1 that has a default consiste...
Q31. You need to provide a solution for the Azure Functions notifications following updates to ...
Q32. You provision Azure resources by using the following Azure Resource Manager (ARM) template...
Q33. You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core...
Q34. You have an Azure Cosmos DB for NoSQL account named account that has the disablekeyBasedle...
Q35. You are developing an application that will connect to an Azure Cosmos DB for NoSQL accoun...
Q36. You have a database named db1 in an Azure Cosmos DB for NoSQL account named account1. The ...
Q37. You have an Azure Cosmos DB Core (SQL) API account. You configure the diagnostic settings ...
Q38. You configure multi-region writes for account1. You need to ensure that App1 supports the ...
Q39. You have a container that stores data about families. The following is a sample document. ...
Q40. The settings for a container in an Azure Cosmos DB Core (SQL) API account are configured a...
Q41. You have the following query. SELECT * FROM WHERE c.sensor = "TEMP1" AND c.value < 22 A...
Q42. You have the following Azure Resource Manager (ARM) template. (Exhibit) You plan to deploy...
Q43. You need to recommend indexes for con-product and con-productVendor. The solution must mee...
Q44. You have an app that stores data in an Azure Cosmos DB Core (SQL) API account The app perf...
Q45. You plan to create an Azure Cosmos DB account that will use the NoSQL API. You need to cre...
Q46. You have an Azure Cosmos DB for NoSQL account. The change feed is enabled on a container n...
Q47. You plan to deploy two Azure Cosmos DB Core (SQL) API accounts that will each contain a si...
Q48. You configure multi-region writes for account1. You need to ensure that App1 supports the ...
Q49. You have an Azure Cosmos DB Core (SQL) API account named account1. You have the Azure virt...
Q50. You have a global ecommerce application that stores data in an Azure Cosmos OB for NoSQL a...
Q51. You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Euro...
Q52. You have an Azure Cosmos DB Core (SQL) API account named account1. In account1, you run th...
Q53. You have a container that stores data about families. The following is a sample document. ...
Q54. You have the indexing policy shown in the following exhibit. (Exhibit) Use the drop-down m...
Q55. You have a container named contained in an Azure Cosmos DB for NoSQL account. The followin...
Q56. You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Euro...
Q57. You have an Azure Cosmos DB for NoSQL account named account that has the disablekeyBasedle...
Q58. You have an Azure Cosmos DB Core (SQL) API account used by an application named App1. You ...
Q59. You need to select the partition key for con-iot1. The solution must meet the IoT telemetr...
Q60. You are developing an application that will connect to an Azure Cosmos DB for NoSQL accoun...
Q61. You have an Azure Cosmos DB Core (SQL) API account named account1. In account1, you run th...
Q62. You plan to store order data in Azure Cosmos DB for NoSQL account. The data contains infor...
Q63. You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. ...
Q64. You have an Azure Cosmos DB for NoSQL account that contains a container named container1. ...
Q65. You have an Azure Cosmos DB Core (SQL) API account that is configured for multi-region wri...
Q66. You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Euro...
Q67. You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for deve...
Q68. You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps. You need t...
Q69. You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The co...
Q70. You have three containers in an Azure Cosmos DB Core (SQL) API account as shown in the fol...
Q71. You have a container named container1 in an Azure Cosmos DB for NoSQL account named accoun...
Q72. You have a database named telemetry in an Azure Cosmos DB Core (SQL) API account that stor...
Q73. You have an Azure Cosmos DB for NoSQL container. The container contains items that have th...
Q74. You have an Azure Cosmos DB container named container1. You need to insert an item into co...
Q75. You have a container in an Azure Cosmos DB Core (SQL) API account. The container stores te...
Q76. You have an Azure Cosmos DB Core (SQL) API account named account1. You have the Azure virt...
Q77. You have a database named db1 in an Azure Cosmos DB for NoSQL account named account1. The ...
Q78. You have an Apache Spark pool in Azure Synapse Analytics that runs the following Python co...
Q79. You have an Azure Cosmos DB Core (SQL) API account named account1. You have the Azure virt...
Q80. You have a database in an Azure Cosmos DB Core (SQL) API account. You plan to create a con...
Q81. You plan to use a multi-region Azure Cosmos DB for NoSQL account to store data for a new a...
Q82. You need to implement a trigger in Azure Cosmos DB Core (SQL) API that will run before an ...
Q83. You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Euro...
Q84. You have an Azure Cosmos DB for NoSQL account named account1 that supports an application ...
Q85. You have a multi-region Azure Cosmos DB account named account1 that has a default consiste...
Q86. You have an Apache Spark pool in Azure Synapse Analytics that runs the following Python co...
Q87. Note: This question is part of a series of questions that present the same scenario. Each ...
Q88. Note: This question is part of a series of questions that present the same scenario. Each ...
Q89. You have an Azure Cosmos DB for NoSQL account named account that has the disablekeyBasedle...
Q90. You have the Azure Cosmos DB for NoSQL containers shown in the following table. (Exhibit) ...
Q91. You need to identify which connectivity mode to use when implementing App2. The solution m...
Q92. You are creating a database in an Azure Cosmos DB Core (SQL) API account. The database wil...
Q93. You have a container in an Azure Cosmos DB for NoSQL account that stores data about orders...
Q94. Your company develops an application named App1 that uses the Azure Cosmos DB SDK and the ...
Q95. You have an Azure Cosmos DB Core (SQL) API account named account1 that has the disableKeyB...
Q96. You have an Azure Cosmos DB container named container! that has a provisioned throughput a...
Q97. You need to select the capacity mode and scale configuration for account2 to support the p...
Q98. You have a multi-region Azure Cosmos DB account named account1 that has a default consiste...
Q99. You have a container that stores data about families. The following is a sample document. ...
Q100. You are developing an application that will connect to an Azure Cosmos DB for NoSQL accoun...
Q101. You have a container named container1 in an Azure Cosmos DB for NoSQL account named accoun...
Q102. You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. ...
Q103. You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. ...
Q104. You have an Azure Cosmos DB Core (SQL) API account named storage1 that uses provisioned th...
Q105. You are designing a data model for an Azure Cosmos DB for NoSQL account. What are the part...
Q106. You are troubleshooting the current issues caused by the application updates. Which action...
Q107. You need to identify which connectivity mode to use when implementing App2. The solution m...
Q108. You have an Azure Cosmos DB Core (SQL) API account named account1. You have the Azure virt...
Q109. You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Euro...
Q110. You have an Azure Cosmos DB Core (SQL) API account named account1. In account1, you run th...
Q111. You need to create a database in an Azure Cosmos DB for NoSQL account. The database will c...
Q112. You have a container named container1 in an Azure Cosmos DB for NoSQL account named accoun...
Q113. You have a database named db1in an Azure Cosmos DB for NoSQL account named account 1. You ...
Q114. You have an Azure Cosmos DB Core (SQL) API account that is configured for multi-region wri...
Q115. You have a container in an Azure Cosmos DB for NoSQL account that stores data about orders...
Q116. You have a container m an Azure Cosmos DB for NoSQL account. The container stores data abo...
Q117. You have a database in an Azure Cosmos DB Core (SQL) API account. You need to create an Az...
Q118. Note: This question is part of a series of questions that present the same scenario. Each ...
Q119. You need to create a data store for a directory of small and medium-sized businesses (SMBs...
[×]

Download PDF File

Enter your email address to download Microsoft.DP-420.v2024-06-19.q119.pdf

Email:

DumpsFiles

Our website provides the Largest and the most Latest vendors Certification Exam materials around the world.

Using dumps we provide to Pass the Exam, we has the Valid Dumps with passing guranteed just which you need.

  • DMCA
  • About
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
©2026 DumpsFiles

www.dumpsfiles.com materials do not contain actual questions and answers from Cisco's certification exams.