Power BI Interface & Data Connectivity Quiz

You are starting Module 1. What is the correct first step in Power BI Desktop to connect to the AdventureWorks_2022.xlsx file?

Click Transform Data immediately after selecting the file.

Correct Incorrect Correct answer

Go to Home > Get Data, select the source type (e.g., Excel Workbook), and choose the file.

Correct Incorrect Correct answer

Open the Power Query Editor first, then click New Source.

Correct Incorrect Correct answer

Drag the Excel file directly onto the Power BI canvas.

Correct Incorrect Correct answer

After selecting the required tables (FactSales, DimCustomer, etc.) in the Navigator Pane, what is the correct action to take to begin the cleaning and transformation process as required by the ETL workflow?

Click Load to bring the data directly into the Power BI model.

Correct Incorrect Correct answer

Click Cancel to go back to the main window.

Correct Incorrect Correct answer

Click Transform Data to open the Power Query Editor for cleaning.

Correct Incorrect Correct answer

Click Refresh to preview the data again.

Correct Incorrect Correct answer

You have imported the FactSales and DimCustomer tables. According to the study guide notes, what is a crucial first step for clarity and organization within the Power Query Editor?

Leave the default names (e.g., "Sheet1", "FactSales").

Correct Incorrect Correct answer

Rename them clearly in the Queries pane (e.g., "Sales_Fact", "Customer_Dim").

Correct Incorrect Correct answer

Rename the columns within each query.

Correct Incorrect Correct answer

Rename the source Excel file itself.

Correct Incorrect Correct answer

You import several source tables (e.g., SalesOrderHeader, SalesOrderDetail) that you plan to merge into a final Sales_Fact table. What should you do with the “Enable Load” setting for the original source queries?

Disable Enable Load for intermediate queries used only for merging.

Correct Incorrect Correct answer

Keep Enable Load checked for all queries to ensure data is available.

Correct Incorrect Correct answer

Delete the intermediate queries after merging.

Correct Incorrect Correct answer

Check Include in Report Refresh for all queries.

Correct Incorrect Correct answer

You suspect the imported FactSales table has identical duplicate rows. What is the standard Power Query command to remove these?

Go to Transform > Remove Rows > Remove Duplicates.

Correct Incorrect Correct answer

Go to Home > Remove Rows > Remove Duplicates.

Correct Incorrect Correct answer

Write an M function Table.Distinct().

Correct Incorrect Correct answer

Filter the table to show only unique rows.

Correct Incorrect Correct answer

The ProductName column in DimProduct has inconsistent spacing (leading/trailing spaces) and potentially hidden non-printable characters. Which two transformations should you apply?

Transform > Replace Values

Correct Incorrect Correct answer

Transform > Format > Trim and Transform > Format > Clean.

Correct Incorrect Correct answer

Add Column > Custom Column with Text.Trim()

Correct Incorrect Correct answer

Home > Change Type > Text

Correct Incorrect Correct answer

The BirthDate column in DimCustomer imported as Text. How do you convert it to the correct Date data type?

Use Transform > Replace Values.

Correct Incorrect Correct answer

Right-click the column header > Change Type > Date.

Correct Incorrect Correct answer

Use Add Column > Date > Parse.

Correct Incorrect Correct answer

Format the column in the Power BI Report View.

Correct Incorrect Correct answer

In the DimCustomer query, the Region column contains “N.America” but the standard should be “North America”. What is the correct transformation to fix this?

Use Transform > Replace Values, find "N.America", replace with "North America".

Correct Incorrect Correct answer

Use Transform > Filter Rows to exclude "N.America".

Correct Incorrect Correct answer

Use Add Column > Conditional Column to create a new region column.

Correct Incorrect Correct answer

Rename the column header from Region to SalesRegion.

Correct Incorrect Correct answer

You need to add ProductName and Category from DimProduct to your FactSales table by matching on ProductKey. Which Power Query operation performs this join?

Home > Append Queries

Correct Incorrect Correct answer

Home > Merge Queries (or Merge Queries as New)

Correct Incorrect Correct answer

Transform > Transpose

Correct Incorrect Correct answer

Add Column > Custom Column

Correct Incorrect Correct answer

When merging FactSales (left table) with DimProduct (right table) on ProductKey, you want to keep all sales records, even if a ProductKey in the sales data doesn’t exist in the DimProduct table. Which Join Kind should you select?

Inner Join (only matching rows)

Correct Incorrect Correct answer

Full Outer Join (all rows from both)

Correct Incorrect Correct answer

Right Outer Join (all rows from Product, matching Sales)

Correct Incorrect Correct answer

Left Outer Join (all rows from Sales, matching Product)

Correct Incorrect Correct answer

After performing a Merge Query, a new column containing Table values appears. How do you select and bring in the specific columns (e.g., ProductName, Category) from the merged table?

Right-click the merged column header and choose Expand.

Correct Incorrect Correct answer

Use Transform > Unpivot Columns.

Correct Incorrect Correct answer

Use Add Column > Duplicate Column.

Correct Incorrect Correct answer

Click the filter icon on the merged column header.

Correct Incorrect Correct answer

You have separate queries for Sales_USA, Sales_Canada, and Sales_Europe, all with identical column structures. You need to combine them into one single All_Sales table. What operation should you use?

Use Home > Merge Queries.

Correct Incorrect Correct answer

Use Home > Append Queries.

Correct Incorrect Correct answer

Use Add Column > Custom Column with Table.Combine().

Correct Incorrect Correct answer

Use Transform > Group By.

Correct Incorrect Correct answer

You need to add a new Profit column calculated as [SalesAmount] – [CostAmount] for each row. Which Power Query feature allows you to define this custom calculation?

Transform > Custom Column

Correct Incorrect Correct answer

Add Column > Custom Column

Correct Incorrect Correct answer

Add Column > Conditional Column

Correct Incorrect Correct answer

Transform > Format > Add Prefix

Correct Incorrect Correct answer

You want to add a Performance column that categorizes sales based on Profit: “High” if Profit > 1000, “Medium” if Profit > 0, and “Low” otherwise. Which UI-driven feature helps you build this multi-step if-then-else logic easily?

Add Column > Custom Column

Correct Incorrect Correct answer

Add Column > Index Column

Correct Incorrect Correct answer

Add Column > Conditional Column

Correct Incorrect Correct answer

Transform > Replace Values

Correct Incorrect Correct answer

You have a Date column and need to create a new column containing only the Year. What is the standard UI-based method in Power Query?

Select the Date column > Transform > Date > Year > Year.

Correct Incorrect Correct answer

Select the Date column > Add Column > Date > Year > Year.

Correct Incorrect Correct answer

Add a Custom Column with formula Date.Year([DateColumn]).

Correct Incorrect Correct answer

Use Transform > Split Column > By Delimiter.

Correct Incorrect Correct answer

Before loading your data, you want to quickly check for errors, empty values, and the distribution of values within key columns like CustomerID and TotalSales. Which Power Query features help with this?

The Model View in Power BI Desktop.

Correct Incorrect Correct answer

The Data View in Power BI Desktop.

Correct Incorrect Correct answer

The Column quality, Column distribution, and Column profile features in the Power Query Editor View tab.

Correct Incorrect Correct answer

The Performance Analyzer pane in Power BI Desktop.

Correct Incorrect Correct answer

According to the “Checklist Before Load,” which of the following is a critical validation step within Power Query before clicking “Close & Apply”?

All charts on the report canvas are formatted correctly.

Correct Incorrect Correct answer

All necessary joins (merges) have been performed and key relationships verified.

Correct Incorrect Correct answer

All DAX measures have been written and tested.

Correct Incorrect Correct answer

The Power BI file has been published to the Service.

Correct Incorrect Correct answer

You have completed all cleaning, merging, and transformation steps in the Power Query Editor. What is the final action to load the data into the Power BI Data Model and return to the main Power BI Desktop window?

File > Save As

Correct Incorrect Correct answer

Home > Close & Apply

Correct Incorrect Correct answer

View > Advanced Editor

Correct Incorrect Correct answer

Data Source Settings

Correct Incorrect Correct answer

You are required to maintain an ETL_Process_Log. What essential information should this log contain for auditability and reproducibility?

Only the names of the source files used.

Correct Incorrect Correct answer

Source file paths, transformations applied, merge/append logic, and validation outcomes.

Correct Incorrect Correct answer

Only the M code generated by Power Query.

Correct Incorrect Correct answer

Only a list of the final columns loaded into the model.

Correct Incorrect Correct answer

What is the main objective and deliverable of the Module 1 Mini Project?

Create DAX measures for Total Sales and Profit.

Correct Incorrect Correct answer

Build a cleaned, integrated dataset using Power Query, ready for data modeling.

Correct Incorrect Correct answer

Design the final dashboard layout in Power BI.

Correct Incorrect Correct answer

Publish the report to the Power BI Service.

Correct Incorrect Correct answer

Power BI Interface & Data Connectivity Quiz

DataPro 23 October 2025

Exam Summary

Information

Results

Results

Categories

1. Question

Hint

2. Question

Hint

3. Question

Hint

4. Question

Hint

5. Question

Hint

6. Question

Hint

7. Question

Hint

8. Question

Hint

9. Question

Hint

10. Question

Hint

11. Question

Hint

12. Question

Hint

13. Question

Hint

14. Question

Hint

15. Question

Hint

16. Question

Hint

17. Question

Hint

18. Question

Hint

19. Question

Hint

20. Question

Hint