Microsoft Azure Data Engineer Associate - DP-203

Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.


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

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';

What will the query return?

Quiz related visual


Comments

Loading comments...