Power BI: PL-300 practice questions with 100% correct solutions

1-236 of 236




what is PATHLENGTH function?




PATHLENGTH in Power BI measures the depth of hierarchical structures, showing the
breadth and complexity of things like product ranges or organizational charts.

HierarchyDepth = PATHLENGTH([EmployeePath])

,Question 3
True or False: The DAX CALENDAR function automatically detects the data range of your dataset
and creates a calculated date column.


True
False




- False
The DAX CALENDARAUTO function automatically detects the date range from your
dataset, while CALENDAR needs you to provide a date range.




What is Column profile?




it provides a more in depth look into the statistics within the columns for the first 1,000
rows of data, this column provides several different values, including the count of rows,
which is important when verifying whether you imported your data successfully.

,What are the 3 main Table Relationship?




- One To One
- Many To One
- Many to Many




What is a star schema?




a single fact table is typically related to one or more dimension tables




What can you do with FILTERS

, returns the values that are directly applied as filters to column name.

FILTERS (<columnName>)




USERELATIONSHIP (use relationship function ) Filter Arguments Onlyno row-level security
allowed first define relationship Column Argument REQUIREDNest up to 10




Filter Arguments Only
no row-level security allowed
first define relationship
Column Argument REQUIRED
Nest up to 10




What is the primary function of Power BI Workspace Apps?


To bundle related Power BI dashboards and reports into a single collection for easier sharing.
To add new features in Power BI desktop app.