
Ultimate access to all questions.
You have an Azure Synapse Analytics Apache Spark pool named Pool1. You need to load JSON files from an Azure Data Lake Storage Gen2 container into tables in Pool1. The files have varying structures and data types. You must preserve the source data types during the load process.
What should you do?
A
Use a Conditional Split transformation in an Azure Synapse data flow.
B
Use a Get Metadata activity in Azure Data Factory.
C
Load the data by using the OPENROWSET Transact-SQL command in an Azure Synapse Analytics serverless SQL pool.
D
Load the data by using PySpark.