You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse.
What should you use to query the files?
Click on the arrows to vote for the correct answer
A. B. C. D.C
https://docs.databricks.com/data/data-sources/azure/synapse-analytics.htmlThe correct answer is C. PolyBase.
Azure Synapse Analytics (formerly known as Azure SQL Data Warehouse) is an analytics service that allows you to analyze large amounts of data. Azure Data Lake Storage Gen 2 is a storage solution that provides a scalable and secure way to store large amounts of data in Azure.
PolyBase is a feature in Azure Synapse Analytics that allows you to query data in external data sources, including Azure Data Lake Storage Gen 2. With PolyBase, you can use T-SQL statements to query files stored in Azure Data Lake Storage Gen 2 as if they were tables in your database. PolyBase provides a way to access the data in your data lake without having to move it into a database.
Azure Functions is a serverless compute service that allows you to run code on demand in response to events. It is not designed for querying files in Azure Data Lake Storage Gen 2.
Microsoft SQL Server Integration Services (SSIS) is a platform for building data integration and transformation solutions. While it can be used to move data between different data sources, it is not specifically designed for querying files in Azure Data Lake Storage Gen 2.
Azure Data Factory is a cloud-based data integration service that allows you to create and schedule data-driven workflows. While it can be used to move data between different data sources, it is not specifically designed for querying files in Azure Data Lake Storage Gen 2.
Therefore, the best option to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse is to use PolyBase.