PL-300 Exam Dumps - Microsoft Power BI Data Analyst
You 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?
You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?
You need to minimize the size of the semantic model. The solution must meet the report requirements.
What should you do?
You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?
You need to create a relationship in the data model for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?