Microsoft Certified Azure Enterprise Data Analyst Associate · Free Practice Question Easy
Question 10
What is the purpose of NATURALINNERJOIN function in Power Query Editor?
- A To merge two tables based on common column names
- B To create a relationship between two tables
- C To join physical tables that have a relationship between them
- D To apply filters to CALCULATE or CALCULATETABLE functions
Reveal correct answer
Correct answer: A
Explanation
The NATURALINNERJOIN function in Power Query Editor merges two tables based on common column names.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
