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
sqlmipg.blob.core.windows.netin 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.
Microsoft DP-203 Data Engineering on Microsoft Azure
www.certification-questions.comYou 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