Exam Certified Data Engineer Associate topic 1 question 110 discussion

Answer is (B. PIVOT) The PIVOT keyword is used to transform rows into columns, converting data from a long format (where each row represents a single measurement) to a wide format (where multiple measurements are represented as columns). For example, if you have a table of sales data with columns for Date, Product, and Sales, you can use PIVOT to create a table where each Product has its own column, and sales are aggregated by Date.