Pl-300 Microsoft Practice Questions and
Answers Already Passed
Which type of relationship in Power BI allows you to filter data from one table to another?
- One-to-One
- Many-to-Many
- Complex
- Single-Column
✔✔A "One-to-Many" relationship.
What is a "Measure" in Power BI?
- A column of raw data
- A relationship between two tables
- A visual format for presenting data
- A direct filter applied to data
✔✔A calculation based on data in your model, usually aggregated.
What does the "What-If" parameter in Power BI allow users to do?
- Filter data dynamically
1
,- Create custom visualizations
- Sort data based on user input
- Merge data sources
✔✔It lets users simulate different scenarios by changing input values.
In Power BI, how can you display geographical data on a map?
- By applying a data transformation
- By using a bar chart
- By creating a table
- By importing a map image
✔✔By using the "Map" or "Filled Map" visual.
How does Power BI help with data security?
- By blocking all external data sources
- By allowing only local data connections
- By limiting data refresh to specific hours
- By storing data in encrypted formats
✔✔By allowing row-level security and user-based permissions.
2
,What is the "Publish to Web" feature in Power BI?
- It uploads reports to a cloud server
- It exports reports to Excel
- It sends reports via email
- It shares reports within an organization
✔✔It allows users to share reports publicly on the internet.
How does Power BI handle large datasets efficiently?
- By ignoring excess data
- By filtering out large datasets automatically
- By limiting data views to a set number of rows
- By using Excel as a data intermediary
✔✔By using techniques like data compression and in-memory storage.
How can you create a custom visual in Power BI?
- By modifying a standard chart
- By writing a DAX formula
3
, - By using only pre-built charts
- By changing data types in the model
✔✔By importing a visual from the marketplace or creating one using Power BI SDK.
What does the "Sync Slicers" feature in Power BI allow you to do?
- It hides slicers on all pages
- It disables slicers for specific users
- It copies slicer settings to new reports
- It applies slicers to just one page
✔✔It synchronizes slicers across multiple pages in a report.
Which visualization type in Power BI would you use to show the percentage contribution of
different categories to a total?
- Column Chart
- Line Chart
- Tree Map
- Scatter Plot
✔✔Pie Chart.
4
Answers Already Passed
Which type of relationship in Power BI allows you to filter data from one table to another?
- One-to-One
- Many-to-Many
- Complex
- Single-Column
✔✔A "One-to-Many" relationship.
What is a "Measure" in Power BI?
- A column of raw data
- A relationship between two tables
- A visual format for presenting data
- A direct filter applied to data
✔✔A calculation based on data in your model, usually aggregated.
What does the "What-If" parameter in Power BI allow users to do?
- Filter data dynamically
1
,- Create custom visualizations
- Sort data based on user input
- Merge data sources
✔✔It lets users simulate different scenarios by changing input values.
In Power BI, how can you display geographical data on a map?
- By applying a data transformation
- By using a bar chart
- By creating a table
- By importing a map image
✔✔By using the "Map" or "Filled Map" visual.
How does Power BI help with data security?
- By blocking all external data sources
- By allowing only local data connections
- By limiting data refresh to specific hours
- By storing data in encrypted formats
✔✔By allowing row-level security and user-based permissions.
2
,What is the "Publish to Web" feature in Power BI?
- It uploads reports to a cloud server
- It exports reports to Excel
- It sends reports via email
- It shares reports within an organization
✔✔It allows users to share reports publicly on the internet.
How does Power BI handle large datasets efficiently?
- By ignoring excess data
- By filtering out large datasets automatically
- By limiting data views to a set number of rows
- By using Excel as a data intermediary
✔✔By using techniques like data compression and in-memory storage.
How can you create a custom visual in Power BI?
- By modifying a standard chart
- By writing a DAX formula
3
, - By using only pre-built charts
- By changing data types in the model
✔✔By importing a visual from the marketplace or creating one using Power BI SDK.
What does the "Sync Slicers" feature in Power BI allow you to do?
- It hides slicers on all pages
- It disables slicers for specific users
- It copies slicer settings to new reports
- It applies slicers to just one page
✔✔It synchronizes slicers across multiple pages in a report.
Which visualization type in Power BI would you use to show the percentage contribution of
different categories to a total?
- Column Chart
- Line Chart
- Tree Map
- Scatter Plot
✔✔Pie Chart.
4
