Microsoft PL-300 Questions Set-1

Let’s prepare for the Microsoft Certified: Power BI Data Analyst Associate Certification with our comprehensive set of Microsoft PL-300 questions. Test your knowledge with our practice set and boost your chances of passing with real exam-like scenarios and expert solutions.

Note: All the questions and answers are my experience, research, and self-study.

1.) You must create the relationship between the product and revenue results first. The solution must mine the time it takes to execute DAX queries.

What should you set as the relationship cardinality?

A. One to many
B. One to one
C. Many to many
D. Many to one

2.) Which DAX expression should you use to get the ending balances in the balance sheet reports?

A. FIRSTNONBLANK (‘Date’ [Date] SUM (BalanceSheet[BalanceAnount] ) )
B. CALCULATE ( SUM (BalanceSheet[BalanceAmount] ), DATESQTD (‘Date’ [Date]) )
C. CALCULATE ( SUM (BalanceSheet [BalanceAmount] ), LASTDATE ( “Date’ (Date] ) )
D. CALCULATE ( MAX (BalanceSheet[BalanceAmount] ), LASTDATE (‘Date’ [Date] ) )

3.) You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.

What should you do?

A. Configure a scheduled refresh by using an on-premises data gateway.
B. Configure a scheduled refresh without using an on-premises data gateway.
C. From Power BI Desktop, download the PBIX file and refresh the data.
D. From each report in powerbi.com, select Refresh visuals.

4.) Once the profit and loss semantic model is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

arrange them

A. From Power BI Desktop, create four roles.
B. From Power BI Desktop, add a Table Filter DAX Expression to the roles.
C. From powerbi.com, add role members to the roles.
D. From Power BI Desktop, publish the dataset to powerbi.com.
E. From powerbi.com, assign the analysts the Contributor role to the workspace.

5.) You need to grant access to the business unit analysts.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE Each correct selection is worth one point.

A. Permissions required in powerbi.com:__________________________
B. Permissions for the profit and loss semantic model: _______________

6.) How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE Each correct selection is worth one point.

A. Grant access by:__________________________
B. Grant access to:__________________________

7.) You need to create a date table in Power Bl that must contain 10 full calendar years, including the current year How should you complete the DAX expression? To answer, drag the appropriate values to the correct locations. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE Each correct selection is worth one point.

8.)You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network.
You are notified that the Excel data source was moved to a new location.
You need to update the PBIX file to use the new location.
What are three ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. From the Semantic model settings of the Power Bl service, configure the data source credentials.
B. From the Data source settings in Power BI Desktop, configure the file path.
C. From Advanced Editor in Power Query Editor, configure the file path in the M code.
D. From Power Query Editor, use the formula bar to configure the file path for the applied step.
E. From Current File in Power BI Desktop, configure the Data Load settings.

9.) You have a Power BI report that contains five bookmarks. You need to add an object to the report from which users can navigate between three specific bookmarks.

How should you complete the task? To answer, drag the appropriate actions to the correct steps. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Answer Area:

First step:_________
Second Step:_______
Third Step:_______

10.) You have a Power Bl report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns.
You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.

What should you do?

A. Change the icons to use a different shape for each color.
B. Remove the icons and use red, yellow, and green background colors instead.
C. Add alt text that lists the values in the table.
D. Move the conditional formatting icons to a tooltip report.

FAQs

microsoft pl-300 microsoft pl-300 microsoft pl-300 pl-300 pl-300 microsoft pl-300 exam

Must Read:

• Cyber Security: Secure – Cybersecurity Awareness Curriculum MCQ–22264 Set1
• Generative AI for Software Engineer MCQs
• Azure Fundamentals Question And Answers