Microsoft Power BI Data Analyst (PL-300) Free Questions - Part 10
Question No : 136) Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?
A. Yes
B. No
Question No : 137) You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?
A. Key influences
B. Funnel chart
C. Q&A
D. Line and clustered column chart
Question No : 138) You are developing a sales report that will have multiple pages. Each page will answer a different business question.
You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.
What should you include on the menu page?
A. Create a text box for each business question and insert a link.
B. Create a button for each business question and set the action type to Bookmark.
C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.
Question No : 139) You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question No : 140) You have a report that includes a card visualization.
You need to apply the following conditional formatting to the card while minimizing design
effort.
For values that are greater than or equal to 100, the font of the data label must be dark red.
For values that are less than 100, the font of the data label must be dark gray.
Which type of format should you use?
A. Color scale
B. Rules
C. Field value
Question No : 141) Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.
The tables have the following relationships:
Sales[DueDate] and Date[Date]
Sales[ShipDate] and Date[Date]
Sales[OrderDate] and Date[Date]
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.
Does this meet the goal?
A. Yes
B. No
Question No : 142) You have a sales system that contains the tables shown in the following table.
The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?
A. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
SAMEPERIODLASTYEAR('Date'[DateID])
B. (SUM(‘Sales’[sales_amount]) - CALCULATE(SUM(‘Sales’[sales_amount]),
SAMEPERIODLASTYEAR(‘Date’[DateID])))
/ CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))
C. CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))
D. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))
Question No : 143) You build a report to analyze customer transactions from a database that contains the tables shown in the following table.
You import the tables.
Which relationship should you use to link the tables?
A. one-to-many from Customer to Transaction
B. one-to-one between Customer and Transaction
C. one-to-many from Transaction to Customer
D. many-to-many between Customer and Transaction
Question No : 144) You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?
A. Share the dashboard to the user.
B. Create a subscription.
C. Create a data alert.
D. Tag the user in a comment.
Question No : 145) You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?
A. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
B. From Power Bi Desktop, use the Auto date/time option when creating the reports.
C. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.
D. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column
Question No : 146) You are building a Power BI report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort. Which type of visualization should you use?
A. decomposition tree
B. funnel chart
C. Q&A
D. key influencers
Question No : 147) You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?
A. Change any DAX measures to use iterator functions.
B. Replace the default visuals with AppSource visuals.
C. Change the imported dataset to DirectQuery.
D. Remove unused columns from tables in the data model.
Question No : 148) In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?
A. Create an active relationship between the tables and select Assume referential integrity.
B. Create an inactive relationship between the tables and select Assume referential integrity.
C. Create an inactive relationship between the tables and select Apply security filter in both directions.
D. Create an active relationship between the tables and select Apply security filter in both directions.
Question No : 149) Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create an average line by using the Salary measure.
Does this meet the goal?
A. Yes
B. No
Question No : 150) Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
Access a published Power BI app
Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
PL-300 Answers