PL-300 Free Practice Test

- (Exam Topic 4)
You attempt to connect Purer 81 Desktop to a Cassandra database.
From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that will connect to the database.
Which of connector should you choose?

1. A. Microsoft SQL Server database
2. B. ODBC
3. C. OData
4. D. OLE DB

Correct Answer: B

- (Exam Topic 4)
For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing data. The solution must minimize development effort. Which type ol data source should you use?

1. A. a SharePoint folder
2. B. Power Bl dataflows
3. C. an Excel workbook
4. D. Power Bl dataset

Correct Answer: D
case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.

- (Exam Topic 4)
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary. Solution: You create a median line by using the Salary measure.
Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: B
The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference:
https://dash-intel.com/powerbi/statistical_functions_median.php

- (Exam Topic 4)
You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

1. A. Key influences
2. B. Funnel chart
3. C. Q&A
4. D. Line and clustered column chart

Correct Answer: A
The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes
your data, ranks the factors that matter, and displays them as key influencers. The key influencers visual is a great choice if you want to:
See which factors affect the metric being analyzed.
Contrast the relative importance of these factors. For example, do short-term contracts have more impact on churn than long-term contracts?
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

- (Exam Topic 4)
You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do?

1. A. Sync the slicers on Page1 and Page3
2. B. On each page, modify the interactions of the slicer.
3. C. Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.

Correct Answer: B