Microsoft Power BI Data Analyst - PL-300 FREE EXAM DUMPS QUESTIONS & ANSWERS
You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization.
The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data.
You need to ensure that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?
The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data.
You need to ensure that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?
Correct Answer: D
Vote an answer
Hotspot Question
You have a dataset named Pens that contains the following columns:
- Item
- Unit Price
- Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a dataset named Pens that contains the following columns:
- Item
- Unit Price
- Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: A scatter plot...
A scatter chart always has two value axes to show: one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. Power BI may distribute these data points evenly or unevenly across the horizontal axis. It depends on the data the chart represents.
Box 2: Automatically find clusters
Scatter charts are a great choice to show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter
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: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?
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: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Hotspot Question
You have a Power BI tenant that contains a workspace. The workspace contains a dataset named datasetA.
You need to build a pivot table report in Microsoft Excel. The report must use datasetA as the data source. The solution must meet the following requirements:
- Ensure that the report can be refreshed to get the latest available
data from the Power BI service.
- Ensure that all the visible data in datasetA is available for use in
Excel.
What should you do to connect Excel to datasetA, and which element in datasetA will be incompatible with the Excel connection? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Power BI tenant that contains a workspace. The workspace contains a dataset named datasetA.
You need to build a pivot table report in Microsoft Excel. The report must use datasetA as the data source. The solution must meet the following requirements:
- Ensure that the report can be refreshed to get the latest available
data from the Power BI service.
- Ensure that all the visible data in datasetA is available for use in
Excel.
What should you do to connect Excel to datasetA, and which element in datasetA will be incompatible with the Excel connection? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
You plan to generate a line chart to visualize and compare the last six months of sales data for two departments.
You need to increase the accessibility of the visual.
What should you do?
You need to increase the accessibility of the visual.
What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Hotspot Question
You have a power BI tenant that hosts the datasets shown in the following table.
You have the following requirements:
- The export of reports that contain Personally Identifiable
Information (Pll) must be prevented.
- Data used for financial decisions must be reviewed and approved
before use.
For each of the following statements, select Yes if the statement is true. Otherwise select No.
NOTE: Each correct selection is worth one point
You have a power BI tenant that hosts the datasets shown in the following table.
You have the following requirements:
- The export of reports that contain Personally Identifiable
Information (Pll) must be prevented.
- Data used for financial decisions must be reviewed and approved
before use.
For each of the following statements, select Yes if the statement is true. Otherwise select No.
NOTE: Each correct selection is worth one point
Correct Answer:
Explanation:
https://docs.microsoft.com/en-us/power-bi/enterprise/service-security-sensitivity-label-overview
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 data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You implicitly convert the values into the required type.
Does this meet the goal?
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 data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You implicitly convert the values into the required type.
Does this meet the goal?
Correct Answer: A
Vote an answer
Hotspot Question
You are using Microsoft Power BI Desktop to profile data in Power Query Editor.
Table data is displayed as 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.
You are using Microsoft Power BI Desktop to profile data in Power Query Editor.
Table data is displayed as 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.
Correct Answer:
