Azure SQL Database: Intersecting Geometry Instances - DP-203 Exam Answer

Intersecting Geometry Instances

Question

You have an Azure SQL database.

You have created two geometry instances and now you are interested in returning the point where these two geometry instances intersect? Which of the following methods will you use to achieve the goal?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E.

Correct Answer: C

STIntersection() method is used to return the point where two geometry instances intersect each other.

Example:

sa

DECLARE @geoml geometry;
DECLARE @geom2 geometry;
DECLARE @result geometry;

SELECT @geoml = GeomCol1 FROM SpatialTable WHERE id = 1;
SELECT @geom2 = GeomCol1 FROM SpatialTable WHERE id = 2
SELECT @result = @geoml.STIntersection(@geom2) ;

SELECT @result.STAsText();

Option A is incorrect.

Intersection is not the right function to return the point where two geometry instances intersect.

Option B is incorrect.

There is no function like GeoIntersection().

Option C is correct.

STIntersection() method is used to return the point where two geometry instances intersect each other.

Option D is incorrect.IntersectionPoint() is not a valid function in Azure.

Option E is incorrect.

STIntersection()is the right choice.

To know more about geometry types, please visit the below-given link:

To return the point where two geometry instances intersect in an Azure SQL database, you should use the STIntersection() method. This method returns a new geometry instance that represents the spatial intersection of two input geometry instances.

Here is a more detailed explanation of the options provided:

A. Intersection(): This method is not a valid method for geometry instances in Azure SQL database.

B. GeoIntersection(): This is not a valid method for geometry instances in Azure SQL database.

C. STIntersection(): This method returns a new geometry instance that represents the spatial intersection of two input geometry instances. If the input geometry instances do not intersect, the method returns an empty geometry instance.

D. IntersectionPoint(): This method is not a valid method for geometry instances in Azure SQL database.

E. None of these: This option is not correct, as the correct method for returning the point where two geometry instances intersect is STIntersection().

Therefore, the correct answer is option C, STIntersection().