Questions & Answers PDF Page 1
Microsoft
PL-300 Exam
Microsoft Power BI Data Analyst
Thank you for Downloading PL-300 exam PDF Demo
You can also try our PL-300 practice exam software
Download Free Demo
https://www.certsfire.com/PL-300.html
https://www.certsfire.com
Questions & Answers PDF Page 2
Version: 13.0
Question: 1
You need to address the data concerns before creating the data model. What should you do in Power
Query Editor?
A. Select Column distribution.
B. Select the sales_amount column and apply a number filter.
C. Select Column profile, and then select the sales_amount column.
D. Transform the sales_amount column to replace negative values with 0.
Answer: C
Explanation:
Question: 2
You need to create a calculated column to display the month based on the reporting requirements.
Which DAX expression should you use?
A. FORMAT('Date'[date], "MMM YYYY")
B. FORMAT('Date' [date], "M YY")
C. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")
D. FORMAT('Date' [date_id], "MMM YYYY")
https://www.certsfire.com
Questions & Answers PDF Page 3
Answer: A
Explanation:
Question: 3
You need to create the required relationship for the executive's visual. What should you do before
you can create the relationship?
A. Change the data type of Sales[region_id] to Whole Number.
B. In the Sales table, add a measure for sum(sales_amount).
C. Change the data type of sales[sales_id] to Text.
D. Change the data type of sales [region_id] to Decimal Number.
Answer: A
Explanation:
Scenario: Executives require a visual that shows sales by region.
Need to change the sales_id column from Varchar to Whole Number (Integer).
Question: 4
What should you create to meet the reporting requirements of the sales department?
A. a measure that uses a formula of SUM (Sales [sales_id])
https://www.certsfire.com
Questions & Answers PDF Page 4
B. a calculated column that use a formula of COUNTA(sales [sales_id])
C. a measure that uses a formula of COUNTROWS (Sales)
D. a calculated column that uses a formula of SUM (Sales [sales_id])
Answer: C
Explanation:
The sale department requires reports that contain the number of sales transactions.
The COUNTROWS function counts the number of rows in the specified table, or in a table defined by
an expression.
Reference:
https://docs.microsoft.com/en-us/dax/countrows-function-dax
Question: 5
You need to create a relationship between the Weekly_Returns table and the Date table to meet the
reporting requirements of the regional managers. What should you do?
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.
B. Add the Weekly_Returns data to the Sales table by using related DAX functions.
C. Create a new table based on the Date table where date-id is unique, and then create a many-to-
many relationship to Weekly_Return.
https://www.certsfire.com
Questions & Answers PDF Page 5
Answer: A
Explanation:
Scenario: Region managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.
https://www.certsfire.com
Questions & Answers PDF Page 6
Thank You for trying PL-300 PDF Demo
`
To try our PL-300 practice exam software visit link below
https://www.certsfire.com/PL-300.html
Start Your PL-300 Preparation
Use Coupon “SAVE25” for extra 25% discount on the purchase of
Practice Test Software. Test your PL-300 preparation with actual
exam questions.
https://www.certsfire.com
