DP-900 · Question #41
DP-900 Question #41: Real Exam Question with Answer & Explanation
The correct answer is C: PolyBase. PolyBase enables your SQL Server instance to process Transact-SQL queries that read data from external data sources. SQL Server 2016 and higher can access external data in Hadoop and Azure Blob Storage. Starting in SQL Server 2019, you can now use PolyBase to access external data
Question
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?
Options
- AAzure Functions
- BMicrosoft SQL Server Integration Services (SSIS)
- CPolyBase
- DAzure Data Factory
Explanation
PolyBase enables your SQL Server instance to process Transact-SQL queries that read data from external data sources. SQL Server 2016 and higher can access external data in Hadoop and Azure Blob Storage. Starting in SQL Server 2019, you can now use PolyBase to access external data in SQL Server, Oracle, Teradata, and MongoDB. https://docs.microsoft.com/en-gb/learn/modules/explore-data-storage-processing-azure/3- explore-azure-synapse-analytics
Community Discussion
No community discussion yet for this question.