Example: barber

Querying External Data In Azure Blob Data Lake Storage

Found 2 free book(s)
Querying external data in Azure Blob/Data Lake Storage

Querying external data in Azure Blob/Data Lake Storage

sqlmipg.blob.core.windows.net

in Parquet and CSV format, stored in Azure Data Lake Storage v2 or Azure Blob Storage, and to combine it in queries with locally stored relational data. In terms of the syntax, the feature resembles SQL Server’s PolyBase capabilities, currently limited to read-only access to files.

  Data, Storage, Lake, External, Azure, Querying, Querying external data in azure blob data lake storage, Blob, In azure data lake storage, Azure blob storage

Microsoft DP-203 Data Engineering on Microsoft Azure

Microsoft DP-203 Data Engineering on Microsoft Azure

www.certification-questions.com

You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit. You create an external table named ExtTable that has LOCATION='/topfolder/' . When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned? Options: A. File2.csv and File3.csv only

  Data, Storage, Lake, External, Azure, In azure data lake storage

Similar queries