nerdexam
Microsoft

DP-420 · Question #174

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…

The correct answer is B. Col1 and Col2 only. In Azure Cosmos DB for NoSQL, only the Point and LineString data types support spatial indexing. This allows for efficient querying of geospatial data, such as locations (points) and paths (lines). Other data types like Curve, MultiPolygon, and MultiCurve are not supported by…

Optimize an Azure Cosmos DB solution

Question

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?

Exhibit

DP-420 question #174 exhibit

Options

  • ACol1 only
  • BCol1 and Col2 only
  • CCol1, Col2, and Col3 only
  • DCol1, Col2, and Col4 only

How the community answered

(42 responses)
  • B
    95% (40)
  • C
    2% (1)
  • D
    2% (1)

Explanation

In Azure Cosmos DB for NoSQL, only the Point and LineString data types support spatial indexing. This allows for efficient querying of geospatial data, such as locations (points) and paths (lines). Other data types like Curve, MultiPolygon, and MultiCurve are not supported by spatial indexes in Cosmos DB.

Topics

#Azure Cosmos DB#Indexing#Spatial Index

Community Discussion

No community discussion yet for this question.

Full DP-420 Practice