exam questions

Exam DP-500 All Questions

View all questions & answers for the DP-500 exam

Exam DP-500 topic 1 question 55 discussion

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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this question, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.
The queries use OPENROWSET and infer the schema shown in the following table.

You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend defining a data source and view for the Parquet files. You recommend updating the query to use the view.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
cherious
Highly Voted 2 years, 6 months ago
Selected Answer: A
"views are generally faster and have more features such as OPENROWSET" "External tables require an explicit defined schema while views can use OPENROWSET to provide automatic schema inference allowing for more flexibility (but note that an explicitly defined schema can provide faster performance)" Source: https://www.jamesserra.com/archive/2020/11/external-tables-vs-t-sql-views-on-files-in-a-data-lake/
upvoted 8 times
...
Az301301X
Highly Voted 2 years, 6 months ago
Selected Answer: A
Yes. Views is my answer for auto schema.
upvoted 5 times
...
Alborz
Most Recent 1 year, 11 months ago
Selected Answer: A
When you define a data source and view for the Parquet files, you create metadata that specifies the schema of the data and its location. This eliminates the need for automatic schema inference during query execution, reducing I/O reads and improving performance.
upvoted 1 times
...
AN_78
2 years, 2 months ago
Selected Answer: A
Views are recommended for large datasets because they can have partition pruning. External table don't and are recommended for smaller datasets
upvoted 1 times
...
Chk88
2 years, 6 months ago
B correct
upvoted 1 times
...
nbagchi
2 years, 6 months ago
Selected Answer: B
Correct
upvoted 1 times
...
Az301301X
2 years, 6 months ago
this is the correct. "External tables" require an explicit defined schema while "views" can use OPENROWSET to provide "automatic schema inference" allowing for more flexibility.
upvoted 3 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
Loading ...