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?

Answer options:

A.Intersection()
B.GeoIntersection()
C.STIntersection()
D.IntersectionPoint()
E.None of these

Correct Answer: C 
STIntersection() method is used to return the point where two geometry instances intersect each other. 
Example: 

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.
Reference: 
To know more about geometry types, please visit the below-given link: 

https://docs.microsoft.com/en-us/sql/t-sql/spatial-geometry/spatial-types-geometry-transact-sql?view=sql-server-ver15