Explanation
The SQL keyword PIVOT can be used to convert a table from a long format to a wide format. A long format table has one column for each variable and one row for each observation. A wide format table has one column for each variable and value combination and one row for each observation. PIVOT allows you to specify the column that contains the values to be pivoted, the column that contains the categories to be pivoted, and the aggregation function to be applied to the values. For example, the following query converts a long format table of sales data into a wide format table with columns for each product and sum of sales:
SELECT *
FROM sales
PIVOT (
SUM(sales_amount) FOR product IN ('A', 'B', 'C')
)
References: The information can be referenced from Databricks documentation on SQL: PIVOT.
https://files.training.databricks.com/assessments/practice-exams/PracticeExam-DataEngineerAssociate.pdf
https://community.databricks.com/t5/data-engineering/practice-exams-for-databricks-certified-data-engineer/td-p