Question 103 of 240 from exam DP-203: Data Engineering on Microsoft Azure

Question 103 of 240 from exam DP-203: Data Engineering on Microsoft Azure

Prev Question Next Question

Question

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.

CREATE TABLE aimtestdb.aimParquetTable( EmployeeID int, EmployeeName string, EmployeeStartDate date)

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

1. SELECT EmployeeID - 2. FROM aimtes{db.dbo.aimParquetTable 3. WHERE name = ‘Steve Warner;

What will the query return?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E.

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:

SELECT EmployeeID - FROM aimtestdb.dbo.aimParquetTable WHERE employeename = ‘Steve Warner;

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:

Prev Question Next Question