exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 2 question 60 discussion

Actual exam question from Microsoft's DP-203
Question #: 60
Topic #: 2
[All DP-203 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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1.
You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.
You plan to insert data from the files in container1 into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of
Table1.
You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.
Solution: You use a dedicated SQL pool to create an external table that has an additional DateTime column.
Does this meet the goal?

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

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
Canary_2021
Highly Voted 2 years, 10 months ago
Selected Answer: B
Answer should be B. An external table is based on a source flat file structure. It seems to make no sense to add additional date time columns to such a table.
upvoted 20 times
...
mghf61
Most Recent 8 months, 2 weeks ago
B is correct
upvoted 1 times
...
AlejandroU
11 months, 1 week ago
Answer B. The answer is incomplete because 2 additional steps were missing. After the 1st step which is creating the external table in the dedicated SQL pool with the additional DateTime column, the 2nd step is to load data using for example PolyBase to load data from the files in container1 into the external table of your dedicated SQL pool. 3rd step is to transform and insert once the data is in the dedicated SQL pool, and then insert the transformed data into your actual Table1, including the additional DateTime column.
upvoted 1 times
...
Deeksha1234
2 years, 2 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
youngbug
2 years, 2 months ago
From the words in the Solution part, it seems to use PolyBase to read external tables. PolyBase can't change the schemas of external tables(files). You can only transform the data after loading data in the staging directory. And then load the data into tables
upvoted 3 times
...
sdokmak
2 years, 5 months ago
Selected Answer: B
serverless works for data lake dedicated doesn't
upvoted 2 times
...
GDJ2022
2 years, 9 months ago
Its clearly mentioned "You plan to insert data from the files in container1 into Table1". External tables dont get the data inserted into themselves, but instead refer outside data.
upvoted 4 times
...
edba
2 years, 9 months ago
If using dedicated SQL pool, after creating an external table, need a further CTAS for adding derived columns.
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago