Questions

1. What are the crucial components of the Query Editor interface discussed in the chapter?
   1. Power Query help
   2. Navigation compass
   3. Power Query ribbon
   4. Settings
2. What is query folding, and how does it optimize query execution in Power BI?
   1. Folding multiple tables
   2. Duplicate queries in Power Query
   3. Translating high-level transformations into low-level SQL statements
   4. Executing queries slowly for precision
3. Which technique allows the creation of new data based on existing columns?
   1. Filtering
   2. Sorting
   3. Adding columns
   4. Removing duplicates
4. What determines how records are matched between tables in merging queries?
   1. Query folding
   2. Join types
   3. Preview settings
   4. Ribbon functions
5. What is Power Query used for in the data preparation process?
   1. Creating calculated columns
   2. Defining complex business logic
   3. Loading, cleaning, and shaping data
   4. Folding queries