Download Microsoft.PL-300.VCEplus.2022-06-08.28q.tqb
| Vendor: | Microsoft |
| Exam Code: | PL-300 |
| Exam Name: | Microsoft Power BI Data Analyst |
| Date: | Jun 08, 2022 |
| File Size: | 5 MB |
| Downloads: | 2 |
Demo Questions
Question 1
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
- Select Column distribution.
- Select the sales_amount column and apply a number filter.
- Select Column profile, and then select the sales_amount column.
- Transform the sales_amount column to replace negative values with 0.
Correct 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?
- FORMAT('Date'[date], "MMM YYYY")
- FORMAT('Date' [date], "M YY")
- FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")
- FORMAT('Date' [date_id], "MMM YYYY")
Correct 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?
- Change the data type of Sales[region_id] to Whole Number.
- In the Sales table, add a measure for sum(sales_amount).
- Change the data type of sales[sales_id] to Text.
- Change the data type of sales [region_id] to Decimal Number.
Correct 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). Scenario: Executives require a visual that shows sales by region.
Need to change the sales_id column from Varchar to Whole Number (Integer).
