Day 7 - Power BI Challenge

1. In Power Query Editor, which feature would you use to combine two tables vertically, stacking the rows of one table on top of the other?

• Join Queries
• Combine Files
• Group By
• Append Queries
• Merge Queries

2. Which join type in the "Merge Queries" operation includes all rows from the left table and only matching rows from the right table?

• Right Outer Join
• Left Outer Join
• Anti Join
• Inner Join
• Full Outer Join

3. When appending files from a folder in Power Query, which function is primarily used to combine the data from multiple files into a single table?

• Table.Join()
• Table.Append()
• Table.Combine()
• Table.Union()
• Table.Merge()

4. In Power BI Desktop, where can you adjust the privacy level settings for your data sources to control how data is combined?

• View Tab > Queries > Privacy Settings
• Transform Tab > Data Privacy
• File > Options and Settings > Options > Privacy
• Help Tab > Privacy Options
• Home Tab > Data Source Settings

5. Which of the following is TRUE when performing a merge operation in Power Query Editor?

• The tables must have the same number of columns.
• Merge operations cannot be undone.
• The join kind cannot be changed after the merge is created.
• You can only merge two tables at a time.
• The merge is case-insensitive by default.

6. When appending queries with differing column structures in Power Query, which of the following statements is TRUE?

• Columns are matched by their position in the table, not by their names.
• Power Query will throw an error if the columns do not match exactly.
• You must manually align the columns before appending.
• Only columns with matching names and data types are appended; others are ignored.
• All columns from both tables are included; missing values are filled with nulls.

7. Which M function in Power Query is commonly used to merge two tables based on a key column, allowing you to specify the join kind (e.g., Left Outer, Inner), resulting in a new column containing nested tables?”

• Table.Join()
• Table.Merge()
• Table.NestedJoin()
• Table.Combine()
• Table.ExpandTableColumn()

8. When appending files from a folder, which of the following steps ensures that only files with a specific extension (e.g., ".csv") are included in the append operation?

• Using the "Filter Rows" step to filter the [Name] column for ".csv" files.
• Renaming all non-".csv" files to have a ".csv" extension.
• Setting the data source privacy level to "Public."
• Manually selecting each ".csv" file from the folder.
• Using the "Remove Columns" step to delete unwanted files.

9. In Power Query, which of the following best describes the difference between "Merge Queries" and "Merge Queries as New"?

• "Merge Queries" creates a new query; "Merge Queries as New" appends data to an existing query.
• "Merge Queries" overwrites the original tables; "Merge Queries as New" does not.
• "Merge Queries" combines queries into the existing query; "Merge Queries as New" creates a new query for the result.
• "Merge Queries" merges tables in the data model; "Merge Queries as New" merges them in Power Query.
• There is no difference between the two options.

10. When merging two queries on multiple columns in Power Query, which of the following is a necessary step to ensure accurate matching?

• Concatenate the key columns into a single column before merging.
• Sort both tables by the key columns in ascending order.
• Ensure that the column names are identical in both tables.
• Disable data privacy settings for both queries.
• Select multiple columns as matching keys in the Merge dialog box.