Skip to main content
ITPrepCerts
Login
Exams Free Samples About Contact
Login Create an account

PL-300 Microsoft Power BI Data Analyst

  • Microsoft
  • 4 free sample questions

About this exam

PL-300 is the Microsoft exam Microsoft Power BI Data Analyst. Paid practice material for this exam is not available yet, but you can try its free sample questions.

Exam code
PL-300
Vendor
Microsoft
Practice questions
Not available yet
Free sample questions
4
Question bank last updated
Not available yet

Try 2 sample questions

Taken from the free sample set for PL-300.

Question 1

You need to create a relationship between the Weekly_Returnstable and the Date table to meet the reporting requirements of the regional managers. What should you do? 

  1. Option A:
    In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
  2. Option B:
     Add the Weekly_Returns data to the Salestable by using related DAX functions.
  3. Option C:
    Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to Weekly_Return. 
Show answer and explanation

Correct answer: A

Scenario: Region managersrequire a visual to analyze weekly sales and returns. 

Question 2

Whatshould you create to meet the reporting requirements of the sales department? 

  1. Option A:
    a measure that uses a formula of SUM (Sales [sales_id])
  2. Option B:
    a calculated column that use a formula of COUNTA(sales [sales_id])
  3. Option C:
    a measure that uses a formula of COUNTROWS (Sales)
  4. Option D:
    a calculated column that uses a formula of SUM (Sales [sales_id])
Show answer and explanation

Correct answer: C

The sale department requires reports that contain the number ofsalestransactions. The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression. 
See all 4 free sample questions