Microsoft
70-778 · Question #31
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…
The correct answer is D. Append Queries. See the full explanation below for the reasoning.
Question
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 database Both tables have the same columns. You need to combine the data from SMB_Customers and Enterprise_Customers. Which command should you use?
Options
- ACombine Files
- BMerge Columns
- CMerge Queries
- DAppend Queries
How the community answered
(39 responses)- A5% (2)
- B3% (1)
- C10% (4)
- D82% (32)
Community Discussion
No community discussion yet for this question.