Free Preparation Discussions
MENU
Microsoft PL-300 Exam
- Topic 1: Create reference lines by using the Analytics pane/ Identify and create appropriate keys for joins
- Topic 2: Resolve inconsistencies, unexpected or null values, and data quality issues/ Select a shared dataset or create a local dataset
- Topic 3: Apply user-friendly naming conventions to columns and queries/ Design and implement role-playing dimensions
- Topic 4: Define a relationship's cardinality and cross-filter direction/ Publish, import, or update assets in a workspace
- Topic 5: Evaluate and transform column data types/ Identify and connect to a data source
- Topic 6: Apply sensitivity labels to workspace content/ Design a data model that uses a star schema
- Topic 7: Identify poorly performing measures, relationships, and visuals/ Replace implicit measures with explicit measures
- Topic 8: Reduce cardinality levels to improve performance/ Create model calculations by using DAX
- Topic 9: Configure row-level security group membership/ Choose an appropriate visualization type
- Topic 10: choose an appropriate visualization type/ Get data from different data sources
- Topic 11: Group and layer visuals by using the selection pane/ Implement row-level security roles
- Topic 12: Choose when to use a paginated report/ Configure table and column properties
- Topic 13: Edit and configure interactions between visuals/ Drilldown into data using interactive visuals
- Topic 14: Choose between continuous and categorical axes/ Format and configure visualizations
- Topic 15: Add a Quick Insights result to a dashboard/ Configure subscriptions and data alerts
Free Microsoft PL-300 Exam Actual Questions
The questions for PL-300 were last updated On Dec. 05, 2023
You have a Power B1 report. The report contains a line chart that displays sales data for several regions.
You need to add an element to the report that will enable users to filter the sales data to include only a selected region.
Which two elements achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You have a Power Bl model that contains two tables named Population and Date.
The Population table contains two columns named Population Amount and Date Key.
DateKey contains date values that represent the first day of a year and are used to create a many-to
The Power Bl model contains two measures that have the following definitions.
Total Population = Sum ('Population'[Population Amount])
2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023)
You create a table visual that displays Date[Year] and [2023 Population].
What will the table visual show?
You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
Delete the City column. You don't need this column for your Country dimension, as it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis.
Remove duplicates from the Country column. You want to have a list of unique countries in your dimension table, so you need to remove any duplicate values from this column.
You have a Rawer Bl report That imports a dace table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
* Due Date
* Order Date
* Delivery Date
You need to support the analysis of sales over time based on all three dates at the same time.
Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.
Does this meet the goal?
You have a Power B1 report named ReportA.
You have a Power B1 tenant that allows users to export data.
You need to ensure that consumers of ReportA cannot effort any data from visuals.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE Each correct selection is worth one point.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Submit Cancel