Microsoft Discussions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Go to Exam

Exam DP-203 topic 1 question 26 discussion

Actual exam question from Microsoft's DP-203

Question #: 26
Topic #: 1

[All DP-203 Questions]

You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1.
You plan to create a database named DB1 in Pool1.
You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool.
Which format should you use for the tables in DB1?

A. CSV
B. ORC
C. JSON
D. Parquet

Show Suggested Answer

Suggested Answer: D 🗳️

by alexleonvalencia at Dec. 9, 2021, 11:22 p.m.

Comments

Submit Cancel

KevinSames

Highly Voted 3 years, 8 months ago

Both A and D are correct "For each Spark external table based on Parquet or CSV and located in Azure Storage, an external table is created in a serverless SQL pool database. As such, you can shut down your Spark pools and still query Spark external tables from serverless SQL pool."

upvoted 24 times

...

ZIMARAKI

Highly Voted 2 years, 9 months ago

Selected Answer: D

"For each Spark external table based on Parquet or CSV and located in Azure Storage, an external table is created in a serverless SQL pool database. As such, you can shut down your Spark pools and still query Spark external tables from serverless SQL pool." So A and D. Parquet are faster so D

upvoted 5 times

Jiviify

2 years, 9 months ago

But they never asked about faster, so why it cant be A

upvoted 3 times

shakes103

2 years, 6 months ago

In this business, time is money.

upvoted 19 times

...

...

...

EmnCours

Most Recent 8 months, 3 weeks ago

Selected Answer: D

Correct Answer: D

upvoted 1 times

...

sergio_eduardo

1 year, 2 months ago

Selected Answer: D

Both A and D, but for priority i decide D

upvoted 1 times

...

kkk5566

1 year, 11 months ago

Selected Answer: D

Prefer to D

upvoted 2 times

...

ExamWiner

2 years, 2 months ago

Selected Answer: D

Tipos de archivo adecuados para consultas analíticas - Si tiene cargas de trabajo basadas en Hive o Presto, vaya con ORC. - Si tiene cargas de trabajo basadas en Spark o Drill, vaya con Parquet.

upvoted 3 times

...

Deeksha1234

3 years ago

Selected Answer: D

both A and D; D - Parquet is faster

upvoted 2 times

...

jainparag1

3 years, 1 month ago

Option D as the explanation suggests. Parquet is always faster than CSV being columnar data store.

upvoted 3 times

...

Dicer

3 years, 1 month ago

both A and D are okay, but Paraquet is faster than CSV, so answer is D.

upvoted 2 times

...

Rrk07

3 years, 2 months ago

Both A & D are correct , as the explanation also suggest same.

upvoted 2 times

...

RehanRajput

3 years, 2 months ago

Both A and D

upvoted 2 times

RehanRajput

3 years, 2 months ago

https://docs.microsoft.com/en-us/azure/synapse-analytics/metadata/database

upvoted 1 times

...

...

MatiCiri

3 years, 3 months ago

Selected Answer: D

Looks correct to me

upvoted 2 times

...

AhmedDaffaie

3 years, 5 months ago

JSON is also supported by Serverless SQL Pool but it is kinda complicated. Why is it not selected?

upvoted 2 times

...

Ajitk27

3 years, 5 months ago

Selected Answer: D

Looks correct to me

upvoted 2 times

...

VijayMore

3 years, 5 months ago

Selected Answer: D

Correct

upvoted 1 times

...

PallaviPatel

3 years, 6 months ago

Selected Answer: D

Both A and D are correct. as CSV and Parquet are correct answers.

upvoted 1 times

...

Mahesh_mm

3 years, 7 months ago

Parquet and CSV are correct

upvoted 4 times

...

Load full discussion...