An analyst wants to combine Online Sales and Store Sales into one table by stacking rows and matching columns by name. Which Power Query operation should be used?
More Prepare the data Questions
55 questions
Full Microsoft Certified: Power BI Data Analyst Associate Practice Test
All topics covered
All Microsoft Certified: Power BI Data Analyst Associate Questions
Browse by topic
Related Questions
A report author needs visuals to query source data when users interact with the report instead of st...
A Power Query author wants a reusable value that can be changed once and referenced in multiple tran...
Two tables are appended, but one source lacks the Referrer column found in the other. What appears i...
In Power Query, which merge join kind returns all rows from the left table and only matching rows fr...
A developer needs to merge two tables by CountryID and StateID. What must be true when selecting mul...
Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy
Discussion
Be the first to share your understanding of this concept
Sign in to join the discussion