Analyzing and Visualizing Data with Microsoft Power BI — Question 116

You have the following two queries in Power BI Desktop:
✑ A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
✑ A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle Server database
Both tables have the same columns.
You need to combine the data from SMB_Customers and Enterprise_Customers.
Which command should you use?

Answer options

• A. Combine Files
• B. Merge Queries
• C. Merge Columns
• D. Append Queries

Correct answer: D

Explanation

The correct answer is D, Append Queries, because this command is specifically designed to stack data from multiple tables with similar structures. Merge Queries, on the other hand, combines data based on matching columns, which is not suitable in this case since you want to combine all rows from both tables.