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 102 discussion

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

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

You execute the following query.



Where will the rows returned by the query be stored?

  • A. in a file in a data lake
  • B. in a relational database
  • C. in a global temporary table
  • D. in a session temporary table
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by jongert at Jan. 6, 2024, 9:01 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
jongert
Highly Voted 1 year, 4 months ago
Correct: Serverless SQL pools can query, import, and store data from Azure Blob Storage, Azure Data Lake Storage Gen1 and Gen2. Serverless does not support TYPE=Hadoop. https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&tabs=dedicated#overview-azure-synapse-analytics
upvoted 5 times
...
mavdplas
Most Recent 5 months, 3 weeks ago
Selected Answer: A
Answer A
upvoted 1 times
...
KarlGardnerDataEngineering
1 year ago
How do we know this is ADLS (data lake) storage? Can't it be plain blob storage as well?
upvoted 1 times
...
swathi_rs
1 year ago
Selected Answer: A
Correct
upvoted 1 times
...
MohamedBI12
1 year, 2 months ago
Selected Answer: A
their is no Tables with servless pool
upvoted 2 times
Bakhtiyor
1 year, 1 month ago
You are right. We can't create the table in serverless SQL pool.
upvoted 1 times
...
...
mav2000
1 year, 3 months ago
Correct "DATA_SOURCE = external_data_source_name Specifies the name of the external data source that contains the location of the external data. This location is in Azure Data Lake" https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&tabs=dedicated#overview-azure-synapse-analytics
upvoted 4 times
...
vernillen
1 year, 3 months ago
Selected Answer: A
A is the correct one
upvoted 1 times
...
jsav1
1 year, 4 months ago
Selected Answer: A
correct
upvoted 1 times
...
moize
1 year, 4 months ago
Bonne réponse : A. Lien est : https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&tabs=dedicated#overview-azure-synapse-analytics
upvoted 1 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