PL-300 Practice Questions and
answers rated A+ 2025/2026
You are creating a Power BI report and need to pull data from a large dataset. Preferably, you want to
see the most up-to-date data in your reports. Which storage mode should you use?
1. Import
2. DirectQuery
3. Composite - correct answer ✔DirectQuery
You are working on a report in Power BI and thinking of naming your tables, columns and values
appropriately. Which of the following should you do?
1. Rename your columns in abbreviated form
2. Replace underscores with spaces in the column data
3. Use short abbreviated text - correct answer ✔Replace underscores with spaces in the column data
The fundamental difference between a calculated column and a measure is that a calculated column
creates a value for each row in the table.
1. True
2. False - correct answer ✔True
A column that has a lot of unique values in its range will have a high level of cardinality
1. True
, 2. False - correct answer ✔True
You're importing data from an Azure Analysis Services Cube in Power BI desktop. When the data
refreshes in the cube, you would like to see it immediately in the Power BI report. Which connection
type should you use?
1. Connect Live
2. Import
3. DirectQuery - correct answer ✔Connect Live
Which two Data profiling tools can you use to identify a Primary Key in a table?
1. Column Quality
2. Column Distribution
3. Column Profile
4. Column Check - correct answer ✔Column Distribution & Column Profile
Which Power Query tool can you use when you know the outcome of a column you want but don't
know which transformations to use?
1. Conditional column
2. Column from examples
3. Custom column
4. Index column - correct answer ✔Column from examples
Inactive relationships are represented by a dotted line.
answers rated A+ 2025/2026
You are creating a Power BI report and need to pull data from a large dataset. Preferably, you want to
see the most up-to-date data in your reports. Which storage mode should you use?
1. Import
2. DirectQuery
3. Composite - correct answer ✔DirectQuery
You are working on a report in Power BI and thinking of naming your tables, columns and values
appropriately. Which of the following should you do?
1. Rename your columns in abbreviated form
2. Replace underscores with spaces in the column data
3. Use short abbreviated text - correct answer ✔Replace underscores with spaces in the column data
The fundamental difference between a calculated column and a measure is that a calculated column
creates a value for each row in the table.
1. True
2. False - correct answer ✔True
A column that has a lot of unique values in its range will have a high level of cardinality
1. True
, 2. False - correct answer ✔True
You're importing data from an Azure Analysis Services Cube in Power BI desktop. When the data
refreshes in the cube, you would like to see it immediately in the Power BI report. Which connection
type should you use?
1. Connect Live
2. Import
3. DirectQuery - correct answer ✔Connect Live
Which two Data profiling tools can you use to identify a Primary Key in a table?
1. Column Quality
2. Column Distribution
3. Column Profile
4. Column Check - correct answer ✔Column Distribution & Column Profile
Which Power Query tool can you use when you know the outcome of a column you want but don't
know which transformations to use?
1. Conditional column
2. Column from examples
3. Custom column
4. Index column - correct answer ✔Column from examples
Inactive relationships are represented by a dotted line.
