Advanced Insight Mechanics (AIM) has hired you as an expert consultant.You have called a meeting with the IT Team where you are discussing Azure Synapse. AIM has a Synapse workspace titled aimWorkspace that has an Apache Spark DB titled aimtestdb. 
The senior developer of the team runs the below given query in Spark pool in aimWorkspace. 

EmployeeName

EmployeeID

EmployeeStartDate

Steve Warner

1234

2019-03-21

After 5 minutes, the senior developer executes the below-given statement through a serverless SQL pool into aimWorkspace. 

What will the query return?

Answer options:

A.Null
B.Steve Warner
C.1234
D.2019-03-21
E.An error

Correct Answer: E 
The given query will return an error as the query mentions a column ‘name’ in the WHERE clause. There is no such column in the actual table. 
The actual query should be written as: 

Option A is incorrect. The query uses the column that actually does not exist in the table. So, it will return an error.
Option B is incorrect. The query won’t return Steve Warner.
Option C is incorrect. The query won’t return 1234.
Option D is incorrect. The query won’t return 2019-03-2021.
Option E is correct. The query uses the column that actually does not exist in the table. So, it will return an error.
Reference:
To know more about Azure Synapse Analytics shared metadata tables, please visit the below-given link: 

https://docs.microsoft.com/en-us/azure/synapse-analytics/metadata/table