PL-300 Free Practice Test

- (Topic 4)
You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month.
You pin the Sales by month visual to Dashboard1.
In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard', What should you do?

1. A. Refresh the dataset used by Report1 and Dashboard1.
2. B. Select Refresh visuals for Dashboard1.
3. C. Edit the details for the dashboard tile Of Dashboar1.
4. D. Pin the Sales by month bar chart to Dashboard1.

Correct Answer: A

HOTSPOT - (Topic 4)
You have a query named All Sales that imports sales data into a Power BI model.
You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:
• Use All Sales as the source for three other queries named Sales Fact Product Dimension, and Customer Dimension.
• Minimize maintenance effort.
What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 4)
You have a Power BI data model that contains a table named Employees. The table has the following columns:
• Employee Name
• Email Address
• Start Date
• Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
• Users must see only their own employee data
• The DAX expression must work in both Power 81 Desktop and the Power BI service.
Which expression should you use?

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: B

- (Topic 4)
What should you do to address the existing environment data concerns?

1. A. a calculated column that uses the following formula: ABS(Sales[sales_amount])
2. B. a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])
3. C. a measure that uses the following formula: SUM(Sales[sales_amount])
4. D. a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

Correct Answer: B

DRAG DROP - (Topic 4)
You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.
You add a sheer named Country to each page of the report.
You need to configure the report to meet the following requirements:
• When a user selects a country on the first page, the report must filter the other pages.
• The second and third pages must display only the filtered results.
Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.Ther
NOTE Each correct selection is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A