You are building a Power BI report that uses data from an Azure SQL database named erp1.
You import the following tables.
 
You need to perform the following analyses:
✑ Orders sold over time that include a measure of the total order value
Orders by attributes of products sold
 
The solution must minimize update times when interacting with visuals in the report.
What should you do first?

A. From Power Query, merge the Order Line Items query and the Products query.

B. Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.

C. Calculate the count of orders per product by using a DAX function.

D. From Power Query, merge the Orders query and the Order Line Items query.








 

Suggested Answer: D

A merge queries operation joins two existing tables together based on matching values from one or multiple columns.
Join the Orders and the Order Line Items tables.
Reference:
https://docs.microsoft.com/en-us/power-query/merge-queries-overview

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.