Power BI Series_ Use Power Query to Transform Your Data

Passed with 70% 1. What is the advantage of selecting the "Load To" Option? a. It gives you the ability to select which data to import. b. It gives you the ability to sort the data. c. It gives you the ability to select where you want to place data and whether you want to add the data to the data model. d. It gives you the ability to export the data to another source. 2. Which of the following is a feature of Power Query? a. Change column headings so the new name appears in the File list of a PivotTable. b. Change the raw data. c. Build relationships between tables. d. Uses Visual Basic to create steps for import. 3. What is the advantage of selecting the "Only Create Connection" option when importing data? a. Data is added to the data model so you can change the data as needed. b. Data is added to the data model and cannot be changed in Excel. c. Data is added to a table in a workbook. d. It makes it much easier to clean the data by just changing it is Excel, allowing you to bypass making changes in the source data. 4. How do you access the Power Query interface? a. Select Data - Power Query. b. Open the Queries & Connection panel, then right click on a query and select edit. c. Select File - Open - Power Query. d. Select Data - Get Data - Power Query. 5. What is one way to document your work within Power Query? a. Create a document with your steps in Word. b. Let Power Query automatically document. c. Rename the steps to be more descriptive. d. There is no need to document because it is a waste of time. 6. Why would you want to rename the queries or column headings? a. It allows you to document your work in Power Query. b. It allows you to provide names that confuse users. c. So that you can make them longer names because it is easier to have long field names in Excel. d. It makes the names easier to read in Excel. 7. Upon import, you notice the column headings are number instead of the field name but Row 1 had the correct names, what should you do? a. Remove Row 1 and it will make it the column names. b. Start the query over because you did something wrong. c. Select the Use First Row as Headers option. d. Double-click on each column name and rename the column. 8. If you want to change data in a column to something more meaningful like "Internet" instead of "I", what feature do you want to use? a. Replace Values.