PL-300 Practice Test

Answer choices

1. A. Apply conditional formatting to highlight all low-severity claims
2. B. Use a tooltip to display additional information about each claim
3. C. Add a new column that calculates the total number of claims per adjuster
4. D. Create a slicer to filter the data by claim severity level and date range

Wrong-answer review

• A. Apply conditional formatting to highlight all low-severity claims: Conditional formatting highlights values but does not let users choose severity and date ranges interactively.
• B. Use a tooltip to display additional information about each claim: Tooltips add hover details, but they do not provide the requested page-level filtering controls.
• C. Add a new column that calculates the total number of claims per adjuster: A calculated column adds data to the model; it does not give users interactive severity and date filtering.

Answer choices

1. A. Apply the 'Change Type' transformation to convert all date columns to a consistent format
2. B. Use the 'Replace Values' transformation to manually correct each erroneous entry
3. C. Ignore the errors and proceed with loading data, assuming minor discrepancies won't impact analysis
4. D. Delete all rows containing dates to avoid any potential issues

Answer choices

1. A. Use SUMX to iterate over a table
2. B. Create a new measure using AVERAGE
3. C. Use FILTER to remove unwanted rows from the dataset
4. D. Apply CALCULATE to override or add filters as needed

Answer choices

1. A. Disable cross-filtering between visuals
2. B. Enable cross-highlighting between visuals
3. C. Configure the visual interactions to filter only when selecting
4. D. Set the interaction between visuals to 'None'

Answer choices

1. A. Choose Import mode for static datasets with high-performance requirements
2. B. Select DirectQuery to always have up-to-date data at the cost of query speed
3. C. Use Direct Lake for a balance of performance and real-time data access
4. D. Implement a hybrid approach using both Direct Lake and Import modes

Answer choices

1. A. Set all relationships as one-to-many with bidirectional filtering
2. B. Use only many-to-one relationships to simplify data modeling
3. C. Avoid setting any specific filter directions to maintain flexibility
4. D. Define relationships based on business logic and set appropriate filter directions

Answer choices

1. A. Prompt Copilot to suggest visuals based on the selected semantic model
2. B. Manually create each visual without using Copilot's suggestions
3. C. Import data directly into Power BI Desktop and skip the semantic model
4. D. Use a pre-existing report template instead of generating a new page

Answer choices

1. A. Configure data loading settings in Power Query Editor to selectively load only necessary queries into the model
2. B. Enable all queries to load into the model for comprehensive analysis
3. C. Disable query loading in Power Query Editor by using the 'Close & Apply' button without selecting any options
4. D. Use a single query to combine all datasets and then load it into the model

Answer choices

1. A. Remove all columns related to booking channels
2. B. Filter out low-occupancy data points before modeling
3. C. Delete any columns that are not directly used in visualizations or calculations
4. D. Retain all historical data for comprehensive analysis

Answer choices

1. A. Create a narrative visual with Copilot to summarize key findings
2. B. Use conditional formatting to highlight critical data points
3. C. Apply slicers to filter specific delivery routes for analysis
4. D. Implement drillthrough functionality to explore underlying data