PL-300 Demo Exam | Skill Course

Question 1

Where is the option to test RLS located?

Desktop view Service → Dataset → Security Power Query Themes

Question 2

The DAX function _______ counts the number of rows in a table.

SUM DISTINCTCOUNT COUNTAX COUNTROWS

Question 3

What is the main role of dimension tables?

Store metrics Store descriptive attributes Store logs Store calculated values

Question 4

Power Query “Keep Top Rows” step does what?

Keeps all rows Keeps N top rows Removes top rows Randomly keeps rows

Question 5

What is M-code in Power Query used for?

Data modeling Report rendering Data transformations Visual interactions

Question 6

What does DAX SUMX do?

Iterate table rows Sum columns only Filter table Return text

Question 7

When is a live connection used?

Connecting to SQL Connecting to Cube/Analysis Services Excel import DirectQuery only

Question 8

What will “Keep Rows → Keep Top 100” do?

Filter top values Random rows Trim column Remove duplicates

Question 9

Which table types can be used in Power Query for merge?

Reference Duplicate Fact Dimension

Question 10

Where should measures be stored in a fact table model?

Dimension table Fact table Separate Measures table Any table