nerdexam
MicrosoftMicrosoft

DP-420 · Question #174

DP-420 Question #174: Real Exam Question with Answer & Explanation

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 spa

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?

Options

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

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 PracticeBrowse All DP-420 Questions