ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 1 question 55 discussion

Actual exam question from Microsoft's DP-203
Question #: 55
Topic #: 1
[All DP-203 Questions]

You have an Azure subscription that contains an Azure Blob Storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool named
Pool1.
You need to store data in storage1. The data will be read by Pool1. The solution must meet the following requirements:
Enable Pool1 to skip columns and rows that are unnecessary in a query.

✑ Automatically create column statistics.
✑ Minimize the size of files.
Which type of file should you use?

  • A. JSON
  • B. Parquet
  • C. Avro
  • D. CSV
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by shachar_ash at May 11, 2022, 3:41 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
namtn6
Highly Voted 2 years, 10 months ago
If the answer has Parquet. Of course, you should choose that answer. :D
upvoted 29 times
...
ClassMistress
Highly Voted 2 years, 12 months ago
Selected Answer: B
Automatic creation of statistics is turned on for Parquet files. For CSV files, you need to create statistics manually until automatic creation of CSV files statistics is supported.
upvoted 15 times
sdokmak
2 years, 11 months ago
Good point, also better cost
upvoted 3 times
...
...
GigachadPrime
Most Recent 4 months, 3 weeks ago
Selected Answer: B
If it has Parquet, odds are very good.
upvoted 1 times
...
EmnCours
5 months, 2 weeks ago
Selected Answer: B
Selected Answer: B
upvoted 1 times
...
dgerok
1 year, 1 month ago
Selected Answer: B
PARQUET
upvoted 2 times
...
phydev
1 year, 6 months ago
Parquet is always the answer ;-)
upvoted 5 times
...
kkk5566
1 year, 8 months ago
Selected Answer: B
is correct
upvoted 1 times
...
akhil5432
1 year, 9 months ago
Selected Answer: B
Parquet
upvoted 1 times
...
ajhak
1 year, 12 months ago
Selected Answer: B
When in doubt, select Parquet.
upvoted 8 times
...
greenlever
2 years, 7 months ago
Selected Answer: B
When reading from Parquet files, you can specify only the columns you want to read and skip the rest.
upvoted 5 times
...
Rahuar
2 years, 8 months ago
CORRECT
upvoted 2 times
...
monibun
2 years, 8 months ago
Question is bit contradictory: it mentions reading blob storage data in dedicated sql , which could be done by External Tables, however, dedicated sql pool do NOT support automatic stats for external tables (as mentioned on "automatic stats creation for dedicated sql pool" section- https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-statistics
upvoted 3 times
Ranjan6214
1 year, 4 months ago
@monibun : great point. I agree with you . I am not sure if anyone wants to advise on your point .
upvoted 1 times
...
...
Deeksha1234
2 years, 9 months ago
Parquet
upvoted 2 times
...
shachar_ash
3 years ago
Correct
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago