exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 2 question 61 discussion

Actual exam question from Microsoft's DP-203
Question #: 61
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 an Azure Synapse Analytics serverless 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
rainbowyu
Highly Voted 2 years, 10 months ago
You can't use serverless pool to create table in dedicate pool
upvoted 22 times
...
Knoushore1
Highly Voted 2 years, 1 month ago
Selected Answer: B
Table1 is in dedicated sql pool
upvoted 7 times
...
jppdks
Most Recent 8 months, 2 weeks ago
Selected Answer: B
The solution does not meet the goal. While an Azure Synapse Analytics serverless SQL pool can be used to create an external table, this alone will not ensure that the DateTime is stored as an additional column in Table1 when the source data files are loaded to container1. The DateTime would need to be included in the data files themselves or added during the transformation process before loading the data into Table1. Therefore, the proposed solution is incorrect.
upvoted 2 times
...
mghf61
9 months, 4 weeks ago
Answer is Yes,
upvoted 1 times
...
Azure_2023
10 months ago
Selected Answer: B
No. Because of the serverless pool.
upvoted 1 times
...
kkk5566
1 year, 3 months ago
Selected Answer: B
should be no
upvoted 2 times
kkk5566
1 year, 2 months ago
correct to yes
upvoted 2 times
...
...
[Removed]
1 year, 3 months ago
Selected Answer: B
You can't use serverless pool to create table in dedicate pool
upvoted 1 times
...
AliakseiM
1 year, 3 months ago
Selected Answer: B
B since Table1 is in dedicated pool
upvoted 2 times
...
g2000
1 year, 4 months ago
Selected Answer: A
You can use external tables to read external data using dedicated SQL pool or serverless SQL pool. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop
upvoted 2 times
...
OldSchool
2 years ago
Selected Answer: A
Q:"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." Park for a while Table1 and dedicated SQL pool, that is where the transformation will happen AFTER loading from container1 to Table1. Here is about loading data to ADLSG2 continer1 and adding a column which can be done with serverless SQL as an external table.
upvoted 3 times
...
berend1
2 years, 1 month ago
if table 1 would be serverless, yes, now no
upvoted 1 times
...
emna2022
2 years, 2 months ago
The job is to insert data from the files in container1 into Table1 (in the dedicated sql pool) and transform the data after that and we need to add a new additional column. External table are just references to the data, only metadata is really stored in the sql pool. Hence anything including external table will be not a solution. If you follow the different proposed solutions from previous questions, the most efficient solution is to use derived column transformation.
upvoted 4 times
...
Deeksha1234
2 years, 4 months ago
Selected Answer: A
yes, with serverless pool we can add a new column while creating an external table
upvoted 1 times
...
youngbug
2 years, 4 months ago
The aim of the solution is to load data from Data Lake's files to dedicated SQL pool's tables. There are three ways: DF's Copy Activity, PolyBase and Bulk insert. It's not serverless SQL pool's business...
upvoted 1 times
...
StudentFromAus
2 years, 5 months ago
The answer should be yes as we can create an additional column using CETAS in a serverless SQL pool though it is not a complete solution but a step closer to the required result.
upvoted 1 times
...
sdokmak
2 years, 6 months ago
Serverless pool works for data lake Dedicated doesn't
upvoted 2 times
...
nefarious_smalls
2 years, 6 months ago
Apparently when dealing with dedicated sql pools you can only create an external table by importing the data from source using ctas. However, when using serverless using cetas will actually export a new file to your data source as well as create an external table. With that being said I think the answer is A.
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 ...