Chapter 6 – Cleaning Data with Query Editor

1. C – Power Query ribbon – The crucial components of the Query Editor interface include the Power Query ribbon, navigation pane, preview pane, and settings pane. However, the correct answer in the multiple-choice format is Preview Binoculars.
2. C – Translating high-level transformations into low-level SQL statements – Query folding is the process of translating high-level transformations into low-level SQL statements, optimizing query execution.
3. C – Adding columns – The technique that allows the creation of new data based on existing columns is adding calculated columns.
4. B – Join types – The factor that determines how records are matched between tables in merging queries is join types.
5. C – Loading, cleaning, and shaping data – Power Query is used for loading, cleaning, and shaping data.