MicrosoftMicrosoft
DP-300 · Question #95
DP-300 Question #95: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.
Submitted by renata2k· Mar 6, 2026
Question
You have an Azure Synapse Analytics Apache Spark pool named Pool1. You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables in Pool1. The structure and data types vary by file. You need to load the files into the tables. The solution must maintain the source data types. What should you do?
Options
- ALoad the data by using PySpark.
- BLoad the data by using the OPENROWSET Transact-SQL command in an Azure Synapse
- CUse a Get Metadata activity in Azure Data Factory.
- DUse a Conditional Split transformation in an Azure Synapse data flow.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.