Exam DP-203 topic 1 question 84 discussion

Actual exam question from Microsoft's DP-203

Question #: 84
Topic #: 1

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. Parquet
B. ORC
C. JSON
D. HIVE

Show Suggested Answer

Suggested Answer: A 🗳️

by makkelijkzat at May 5, 2023, 6:10 p.m.

Comments

Submit Cancel

kam1122

Highly Voted 1 year, 8 months ago

always pick parquet first

upvoted 5 times

...

EmnCours

Most Recent 8 months, 2 weeks ago

Selected Answer: A

upvoted 1 times

...

kkk5566

1 year, 11 months ago

Selected Answer: A

is correct

upvoted 1 times

...

Deeksha1234

1 year, 12 months ago

Selected Answer: A

parquet. CSV , delta also possible but not an option here.

upvoted 2 times

...

akhil5432

2 years ago

Selected Answer: A

parquet

upvoted 1 times

...

Ankit_Az

2 years, 2 months ago

Selected Answer: A

Correct

upvoted 1 times

...

rocky48

2 years, 3 months ago

Selected Answer: A

Parquet is the correct answer

upvoted 1 times

...

aemilka

2 years, 3 months ago

Selected Answer: A

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop Supported formats for serverless pool: Delimited/CSV, Parquet, Delta Lake So Parquet is the correct answer

upvoted 2 times

...