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?
A.
Azure Functions
B.
Microsoft SQL Server Integration Services (SSIS)
Polybase is the correct answerd,
https://docs.microsoft.com/en-gb/learn/modules/explore-data-storage-processing-azure/3-explore-azure-synapse-analytics
"Use SQL pools in Synapse Analytics for the following scenarios:
Complex reporting. You can use the full power of Transact-SQL to run complex SQL statements that summarize and aggregate data.
Data ingestion. PolyBase enables you to retrieve data from many external sources and convert it into a tabular format. You can reformat this data and save it as tables and materialized views in Azure Synapse."
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.
C looks good to me - PolyBase is a technology that accesses external data stored in Azure Blob storage or Azure Data Lake Store via the T-SQL language. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/load-data-overview
This section is not available anymore. Please use the main Exam Page.DP-900 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
faust0
Highly Voted 3 years, 11 months agosarndr04
Highly Voted 3 years, 11 months agoAGTraining
Most Recent 7 months, 4 weeks agoJayBee65
2 years, 10 months agoTob1as
3 years, 2 months agoBolarin
3 years, 6 months ago