LeetQuiz Logo
About•Privacy Policy•contact@leetquiz.com
RedditX
© 2025 LeetQuiz All rights reserved.
Microsoft Azure Data Engineer Associate - DP-203

Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.


Comments

Loading comments...

You have an Azure Synapse workspace named MyWorkspace containing an Apache Spark database named mytestdb. You execute the following command in a Spark pool within MyWorkspace:

CREATE TABLE mytestdb.myParquetTable(
    EmployeeID int,
    EmployeeName string,
    EmployeeStartDate date)
USING Parquet
CREATE TABLE mytestdb.myParquetTable(
    EmployeeID int,
    EmployeeName string,
    EmployeeStartDate date)
USING Parquet

You then insert a row into mytestdb.myParquetTable using Spark. The row contains the following data:

  • EmployeeID: 1
  • EmployeeName: 'Alice'
  • EmployeeStartDate: '2021-01-01'

One minute later, you run this query from a serverless SQL pool in MyWorkspace:

SELECT EmployeeID
FROM mytestdb.dbo.myParquetTable
WHERE EmployeeName = 'Alice';
SELECT EmployeeID
FROM mytestdb.dbo.myParquetTable
WHERE EmployeeName = 'Alice';

What will the query return?

Exam-Like
Quiz related visual


Powered ByGPT-5