DP-420 Practice Test

DP-420 Practice Test practice questions, page 11 of 11, with answer review and explanations.

Question 51

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 statements true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Question 52

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You need to write a SQL query that will return multiple items. The solution must meet the following requirements: • For each item returned, include the current Coordinated Universal Time (UTC) date and time, formatted as an ISO 8601 string. • Minimize development effort. What should you use?

  1. a user-defined function
  2. GetCurrentTimestamp()
  3. GetCurrentDateTime()
  4. DateTimePart()

Question 53

You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON You are writing a query that will retrieve the average age of each pet owned by each owner, if the pet is older than two years. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Question 54

You have an app named App1 that uses an Azure Cosmos DB for NoSQL database. App1 uses the spatial columns shown in the following table. You need to design an indexing strategy for App1. Which columns can be indexed by using spatial indexes?

  1. Col1 only
  2. Col1 and Col2 only
  3. Col1, Col2, and Col3 only
  4. Col1, Col2, and Col4 only