Practice Free PL-300 Exam Online Questions
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source.
The sales table has the following date foreign keys:
✑ Due Date
✑ Order Date
✑ Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date.
Does this meet the goal?
- A . Yes
- B . No
A
Explanation:
Creating two additional tables in Power Query can be a possible solution:
Remove any inactive relationships.
Consider renaming the role-playing dimension-type table to better describe its role. In the example, the Airport table is related to the ArrivalAirport column of the Flight table, so it’s renamed as Arrival Airport.
Create a copy of the role-playing table, providing it with a name that reflects its role. If it’s an Import table, we recommend defining a calculated table. If it’s a DirectQuery table, you can duplicate the Power Query query.
In the example, the Departure Airport table was created by using the following calculated table definition.
Topic 4, Misc. Questions
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?
- A . Yes
- B . No
DRAG DROP
You plan to use Power BI to create a quarterly profit report that meets the following requirements:
• Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
• Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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. NOTE: Each correct selection is worth one point.
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?
- A . Key influences
- B . Funnel chart
- C . Q&A
- D . Line and clustered column chart
A
Explanation:
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
You have a Power Bi report for the procurement department.
The report contains data from the following tables.
There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns.
The report contains the visuals shown in the following table.
You need to minimize the size of the dataset without affecting the visuals.
What should you do?
- A . Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month
- B . Merge Suppliers and Uneltems.
- C . Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).
- D . Remove the Lineitems[Description] column.
You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.
The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)
You need to modify the dashboard mobile layout to meet the following requirements:
• Only show single-value visuals.
• Minimize scrolling.
What should you do?
- A . Remove the card visual, increase the size of the map and bar chart visuals
- B . Decrease the size of the map and bar chart visuals Move all the card visuals to the top of the layout.
- C . Move the bar chart visuals to the top of the layout Remove the map visuals. Decrease the size of the card visuals.
- D . Decrease the size of the card visuals. Remove the map and bar chart visuals.
DRAG DROP
You publish a dataset that contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct
Vou plan to create a Power B1 report that will be connected to multiple data sources. One of the data sources contains law records. You need to ensure that other queries cannot access the tax record Information.
To what should you set Privacy Level for the data source?
- A . None
- B . Private
- C . Organizational
- D . Public
Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
- A . video
- B . custom streaming data
- C . text box
- D . web content
D
Explanation:
https://docs.microsoft.com/en-us/stream/portal-embed-video
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add-web-content
HOTSPOT
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State.
The distribution and quality data metrics for the data m State is shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
