DP-203 Certification Practice Question #158

Question

You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. The file contains two attributes named FirstName and LastName.
You need to copy the data from the JSON file to an Azure Synapse Analytics table by using Azure Databricks. A new column must be created that concatenates the FirstName and LastName values.
You create the following components:
✑ A destination table in Azure Synapse
✑ An Azure Blob storage container
✑ A service principal
In which order should you perform the actions? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Accepted Answer

The logical pipeline is to access the source storage, load the JSON into Spark, create the concatenated column in the DataFrame, and then write to Synapse. Microsoft Learn?s Databricks-to-Synapse pattern uses a temporary Blob storage folder for the Synapse connector during the write operation, so that staging configuration belongs immediately before writing the final results to the destination table.

More DP-203 practice questions