Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 1

© examsnet.com

Question : 26 of 39

Marks: +1, -0

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.

CREATE EXTERNAL DATA SOURCE source 1 WITH ( LOCATION = 'https://account1._______-.core.window.net',) ______
blob
dfs
table
______
PUSHDOWN = ON
TYPE = BLOB_STORAGE
TYPE = HADOOP

Go to Question:

Prev Question

Next Question