Exam Certified Data Engineer Associate topic 1 question 57 discussion

The PIVOT operation is used to rotate data from rows to columns, which effectively converts a table from a long format (where each row represents a single observation or measurement) to a wide format (where each row represents a single entity with multiple observations or measurements as columns).

B is correct

Answer is B

https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-pivot.html “Pivot” transforms the rows of the table_reference by rotating unique values of a specified column list into separate columns. SYNTAX : table_reference PIVOT ( { aggregate_expression [ [ AS ] agg_column_alias ] } [, ...] FOR column_list IN ( expression_list ) ) column_list { column_name | ( column_name [, ...] ) } expression_list { expression [ AS ] [ column_alias ] | { ( expression [, ...] ) [ AS ] [ column_alias] } [, ...] ) }

PIVOT is correct.

PIVOT is correct.