exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 8 discussion

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

HOTSPOT -
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1.
You plan to access the files in Account1 by using an external table.
You need to create a data source in Pool1 that you can reference when you create the external table.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: dfs -
For Azure Data Lake Store Gen 2 used the following syntax:
http[s] <storage_account>.dfs.core.windows.net/<container>/subfolders
Incorrect:
Not blob: blob is used for Azure Blob Storage. Syntax:
http[s] <storage_account>.blob.core.windows.net/<container>/subfolders

Box 2: TYPE = HADOOP -
Syntax for CREATE EXTERNAL DATA SOURCE.
External data sources with TYPE=HADOOP are available only in dedicated SQL pools.
CREATE EXTERNAL DATA SOURCE <data_source_name>

WITH -
( LOCATION = '<prefix>://<path>'
[, CREDENTIAL = <database scoped credential> ]
, TYPE = HADOOP
)
[;]
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables

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
azure2022
Highly Voted 1 year, 2 months ago
dfs hadoop
upvoted 25 times
U_C
1 year ago
-- Please note the abfss endpoint when your account has secure transfer enabled ( LOCATION = 'abfss://[email protected]' , CREDENTIAL = ADLS_credential , TYPE = HADOOP ) ;
upvoted 2 times
...
U_C
1 year ago
You are right: CREATE EXTERNAL DATA SOURCE YellowTaxi WITH ( LOCATION = 'https://azureopendatastorage.blob.core.windows.net/nyctlc/yellow/', TYPE = HADOOP)
upvoted 2 times
...
Dawn7
1 year, 2 months ago
Why "dfs"? For the reference in the answer seems that the first answer is "blob".
upvoted 2 times
...
...
Appajip
Highly Voted 8 months ago
datalake gen2 is dfs. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop#create-external-data-source
upvoted 5 times
...
sincerebb
Most Recent 3 weeks, 5 days ago
is this for DP-300?
upvoted 1 times
...
CellCS
10 months, 1 week ago
datalake gen2 is dfs. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop#create-external-data-source
upvoted 5 times
...
ramelas
10 months, 3 weeks ago
dfs - gen2 datalakestorage - gen1 blob - blob storage
upvoted 2 times
...
sqljuanito
10 months, 3 weeks ago
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop Azure Data Lake Storage Gen2 ===> dfs TYPE = HADOOP
upvoted 2 times
...
U_C
1 year ago
-- Creates a Hadoop external data source in dedicated SQL pool CREATE EXTERNAL DATA SOURCE AzureDataLakeStore WITH ( LOCATION = 'abfss://[email protected]' , CREDENTIAL = ADLS_credential , TYPE = HADOOP ) -- Creates an external data source for Azure Data Lake Gen2 CREATE EXTERNAL DATA SOURCE YellowTaxi WITH ( LOCATION = 'https://azureopendatastorage.blob.core.windows.net/nyctlc/yellow/', TYPE = HADOOP ) The question asks to create a data source in Pool1. So the answer is dfs & HADOOP.
upvoted 1 times
...
panjie_s
1 year ago
dfs and hadoop. Azure Data Lake Store Gen 2 http[s] <storage_account>.dfs.core.windows.net/<container>/subfolders
upvoted 1 times
...
matongax
1 year, 1 month ago
Azure Data Lake Store Gen 2 =dfs https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop#:~:text=Azure%20Data%20Lake%20Store%20Gen%202
upvoted 2 times
...
lorenzopp
1 year, 2 months ago
'dfs' is required to access data files with a DLS Gen2 storage account
upvoted 3 times
...
Mladen_66
1 year, 2 months ago
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago