Question 360 of 388
Single answerYou use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.You need to combine the tables into a single query that contains the unique columns of each table.What should you select in Power Query Editor?
✓AMerge queriesB.Combine filesC.Append queries
BAdditional option
✓
Correct Answer: A
Merge queriesB.Combine filesC.Append queries
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.