nerdexam
MicrosoftMicrosoft

DP-203 · Question #10

DP-203 Question #10: Real Exam Question with Answer & Explanation

Sign in or unlock DP-203 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.

Submitted by omar99· Mar 30, 2026

Question

You have an Azure Synapse workspace named MyWorkspace that contains an Apache Spark database named mytestdb. You run the following command in an Azure Synapse Analytics Spark pool in MyWorkspace. CREATE TABLE mytestdb.myParquetTable( EmployeeID int, EmployeeName string, EmployeeStartDate date) USING Parquet You then use Spark to insert a row into mytestdb.myParquetTable. The row contains the following data. One minute later, you execute the following query from a serverless SQL pool in MyWorkspace. SELECT EmployeeID FROM mytestdb.dbo.myParquetTable WHERE name = 'Alice'; What will be returned by the query?

Options

  • A24
  • Ban error
  • Ca null value

Unlock DP-203 to see the answer

You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full DP-203 PracticeBrowse All DP-203 Questions