PL-300 Demo Exam | Skill Course

Question 1

To combine multiple tables by rows, use _______ in Power Query.

Append Queries Merge Queries Union Join Tables

Question 2

Scenario: Display total revenue ignoring all filters.

ALL ALLSELECTED CALCULATE FILTER

Question 3

Scenario: Combine multiple columns into one full name column.

Merge Columns Split Column Replace Values Pivot Columns

Question 4

Which DAX functions are time intelligence?

DATESYTD TOTALYTD RANKX SAMEPERIODLASTYEAR

Question 5

When do we create a custom column in Power Query?

When adding a new visual When setting model relationships When row-wise calculation is needed When sharing dashboards

Question 6

Where is a Line chart best used?

Trend over time Ranking Pie distribution Geospatial mapping

Question 7

For what is DAX DISTINCTCOUNT used?

Rows Unique values All values Filtered values only

Question 8

You need to create the dataset. Which dataset mode should you use?

DirectQuery Import Live connection Composite

Question 9

In Power Query, what controls the order of “Applied Steps”?

Model size Data refresh speed Transformation sequence Visual updates

Question 10

What is a drawback of a Snowflake schema?

Best performance More complexity Small models Faster visuals