
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?
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?
Exam-Like

Comments
Loading comments...