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

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

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

by azure2022 at Aug. 23, 2021, 7:57 a.m.

Comments

Submit Cancel

azure2022

Highly Voted 1 year, 4 months ago

dfs hadoop

upvoted 25 times

U_C

1 year, 3 months 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, 3 months 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, 4 months ago

Why "dfs"? For the reference in the answer seems that the first answer is "blob".

upvoted 2 times

...

Appajip

Highly Voted 10 months, 2 weeks 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 months, 1 week ago

is this for DP-300?

upvoted 1 times

...

CellCS

1 year 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

1 year, 1 month ago

dfs - gen2 datalakestorage - gen1 blob - blob storage

upvoted 2 times

...

sqljuanito

1 year, 1 month 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, 3 months 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, 3 months 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, 3 months 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, 4 months ago

'dfs' is required to access data files with a DLS Gen2 storage account

upvoted 3 times

...

Mladen_66

1 year, 4 months ago

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop

upvoted 1 times

...