DP-203 · Question #213
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…
The correct answer is D. Load the data by using PySpark. To load JSON files from an Azure Data Lake Storage Gen2 container into the tables in an Apache Spark pool in Azure Synapse Analytics while maintaining the source data types, you should use PySpark.
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
- AUse a Get Metadata activity in Azure Data Factory.
- BUse a Conditional Split transformation in an Azure Synapse data flow.
- CLoad the data by using the OPEHROwset Transact-SQL command in an Azure Synapse
- DLoad the data by using PySpark.
How the community answered
(30 responses)- A3% (1)
- B7% (2)
- C20% (6)
- D70% (21)
Explanation
To load JSON files from an Azure Data Lake Storage Gen2 container into the tables in an Apache Spark pool in Azure Synapse Analytics while maintaining the source data types, you should use PySpark.
Topics
Community Discussion
No community discussion yet for this question.