Microsoft Exam DP-500 Topic 7 Question 42 Discussion

Actual exam question for Microsoft's DP-500 exam

Question #: 42
Topic #: 7

You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool named Pool1.

You plan to deploy a data lake that will record the history of transactions executed against Pool1.

You need to recommend which type of file to use to store the history. The solution must ensure that the history is written in the scope of the related transaction.

Which file type should you recommend?

AJSON

BAvro

CDelta

DParquet

Show Suggested Answer

Suggested Answer: C

by Zona at Jun 03, 2024, 10:58 PM

Limited Time Offer

25%

Off

Get Premium DP-500 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Launa

4 months ago

Delta is the clear winner in my opinion. Transactional integrity is crucial for this kind of data lake implementation.

upvoted 0 times

Hyman

4 months ago

I think Parquet could also be a good option for storing the history of transactions.

upvoted 0 times

...

Kattie

4 months ago

I agree, Delta is the best choice for ensuring transactional integrity.

upvoted 0 times

...

My

5 months ago

Hah, imagine trying to use JSON to store a transaction history. That would be like trying to put out a fire with gasoline!

upvoted 0 times

Shanda

4 months ago

JSON would definitely not be suitable for storing transaction history. Parquet or Avro could also be good options.

upvoted 0 times

...

Jackie

4 months ago

Agreed, Delta files would ensure that the history is written in the scope of the related transaction.

upvoted 0 times

...

Madelyn

4 months ago

I would recommend using Delta files to store the transaction history.

upvoted 0 times

...

Tandra

5 months ago

I'm not sure about the other options, but Delta definitely sounds like the most relevant pick here. Gotta love that transactional guarantee!

upvoted 0 times

Sean

4 months ago

Definitely, Delta ensures that the history is written in the scope of the related transaction.

upvoted 0 times

...

Freeman

4 months ago

Agreed, Delta is the best choice for storing transaction history.

upvoted 0 times

...

Launa

5 months ago

I think Delta is the way to go for transactional guarantee.

upvoted 0 times

...

Avery

5 months ago

Parquet would be a solid choice too. It's a highly efficient and widely-used file format for big data applications.

upvoted 0 times

Reita

4 months ago

Parquet would be a solid choice too. It's a highly efficient and widely-used file format for big data applications.

upvoted 0 times

...

Latia

4 months ago

I agree, Delta files ensure that the history is written in the scope of the related transaction.

upvoted 0 times

...

Renea

5 months ago

I think we should recommend using Delta files to store the history.

upvoted 0 times

...

Darnell

5 months ago

I agree with you, Delta files provide ACID transactions and ensure data consistency.

upvoted 0 times

...

Bettina

5 months ago

Delta is the way to go! It ensures the history is written within the transaction scope, which is key for this use case.

upvoted 0 times

Aleisha

4 months ago

Agreed, Delta is the best choice for this scenario.

upvoted 0 times

...

Maile

4 months ago

C) Delta

upvoted 0 times

...

Ashanti

4 months ago

D) Parquet

upvoted 0 times

...

Dwight

4 months ago

C) Delta

upvoted 0 times

...

Lorean

4 months ago

B) Avro

upvoted 0 times

...

Salena

4 months ago

A) JSON

upvoted 0 times

...

Thersa

4 months ago

Delta is the way to go! It ensures the history is written within the transaction scope, which is key for this use case.

upvoted 0 times

...

Helene

4 months ago

D) Parquet

upvoted 0 times

...

Iraida

4 months ago

C) Delta

upvoted 0 times

...

Kimberely

4 months ago

I agree, Delta is the best option for this scenario.

upvoted 0 times

...

Kimberely

5 months ago

C) Delta

upvoted 0 times

...

Eugene

5 months ago

B) Avro

upvoted 0 times

...

Marica

5 months ago

A) JSON

upvoted 0 times

...

Glendora

5 months ago

I think we should recommend using Delta files for storing the history.

upvoted 0 times

...