Practice Free PL-300 Exam Online Questions
You are configuring a Power BI report for accessibility as shown in the following table.
You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.
Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . First-level elements colors
- B . Theme colors
- C . Divergent colors
- D . Sentiment colors
You are configuring a Power BI report for accessibility as shown in the following table.
You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.
Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . First-level elements colors
- B . Theme colors
- C . Divergent colors
- D . Sentiment colors
HOTSPOT
You hove a folder that contains 50 JSON files.
You need to use Power 81 Desktop to make the metadata of the files available as a single semantic model. The solution must NOT store the data of the JSON files.
Which type of data source should you use. and which transformation should you perform? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset.
What should you do?
- A . From Power Bl Desktop, change the Row-Level Security settings.
- B . From Power Bl Desktop, import a table that contains the HR team members
- C . From powerbi.com.add users to the HR role for the dataset.
- D . From powerbi.com, share the dataset to the HR team members.
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
- A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
- B . an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
- C . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
- D . a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
- E . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
A
Explanation:
Scenario: The customer service department requires a visual that can be filtered by both sales month
and ship month independently.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
You have a Power Bi data model that imports data from a Microsoft Excel spreadsheet. You use Power Query to load a query that contains both renamed and custom columns. Later you attempt to reload the query and receive the following error message
Expression.Error; The column ‘Category’ of the table wasn’t found.
What are two possible causes of the error? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A . The column was removed from the source ‘lie.
- B . The data type of the column was changed
- C . The file is no longer in the specified location
- D . The column »vas renamed in the source tile.
You have a Power Bl workspace that contains a dataset. a report, and a dashboard.
The following groups have access:
• External users can access the dashboard.
• Managers can access the dashboard and a manager-specific report.
• Employees can access the dashboard and a row-level security (RLS) constrained report.
You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.
What should you use?
- A . subscriptions
- B . comments
- C . alerts
- D . chat in Microsoft Teams
HOTSPOT
You have a semantic model in import mode that contains the model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
DRAG DROP
You are modifying a Power Bi model by using Power Bl Desktop.
You have a table named Sales that contains the following fields.
You have a table named Transaction Size that contains the following data.
You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.
How should you complete the code? To answer, drag the appropriate values to the correct targets.
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.
Explanation:
FILTER | AND | CALCULATE
You have a Power BI report that contains one page. The page contains two line charts and one bar chart.
You need to ensure that users can perform the following tasks for all three visuals:
✑ Switch the measures used in the visuals.
✑ Change the visualization type.
✑ Add a legend.
The solution must minimize development effort.
What should you do?
- A . Enable personalization for each Visual.
- B . Create a bookmark for each acceptable combination of visualization type, measure, and legend in the bar chart
- C . Edit the interactions between the three visuals.
- D . Enable personalization for the report