Deal of the Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-203 Topic 4 Question 19 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 19
Topic #: 4
[All DP-203 Questions]

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 dat


One minute later, you execute the following query from a serverless SQL pool in MyWorkspace.


FROM mytestdb.dbo.myParquetTable

WHERE name = 'Alice';

What will be returned by the query?

Show Suggested Answer Hide Answer
Suggested Answer: A

Once a database has been created by a Spark job, you can create tables in it with Spark that use Parquet as the storage format. Table names will be converted to lower case and need to be queried using the lower case name. These tables will immediately become available for querying by any of the Azure Synapse workspace Spark pools. They can also be used from any of the Spark jobs subject to permissions.

Note: For external tables, since they are synchronized to serverless SQL pool asynchronously, there will be a delay until they appear.


Currently there are no comments in this discussion, be the first to comment!

Save Cancel