Free Microsoft Power BI Data Analyst Exam PL-300 Exam Practice Test

You are reviewing a query that produces 10,000 rows in the Power Query Editor.You need to identify whether a column contains only unique values.Which two Data Preview options can you use? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

• Column profile
• Column distribution
• Show whitespace
• Column quality
• Monospace

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?

• Yes
• No

You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection.You need to ensure that users can use Q&A from the Power BI service for the dataset.What should you do?

• From the Power BI service, add an enterprise gateway to the dataset.
• From Power BI Desktop, add synonyms and suggested questions.
• From Power BI Desktop, add a Q&A visual to the report.
• From the Power Bi service, select Turn on Q& A for this dataset.

You have a Microsoft Power Bl dashboard.You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.What should you use?

• Feedback
• Subscribe
• Comments
• Mark as favorite

You have a Power Bl report that uses row-level security (RLS).You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.What should you do?

• Add the Azure network security team as members of the RLS role.
• Instruct the Azure network security team to create security groups. Configure RLS to use the groups.
• Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.
• Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.

In Power Bi Desktop, you are creating visualizations in a report based on an imported datasetYou need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying dataWhat should you do?

• From Power BI Desktop, configure the Data Load settings for the current file.
• From the Power BI service, configure the dataset permissions.
• From Power BI Desktop, configure the Report settings for the current file.
• From Power BI Desktop, modify the data source permissions.

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 percentile line by using the Salary measure and set the percentile to 50%.Does this meet the goal?

• Yes
• No

You need to create the dataset. Which dataset mode should you use?

• DirectQuery
• Import
• Live connection
• Composite

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?

• a SharePoint folder
• Power Bl dataflows
• an Excel workbook
• Power Bl dataset

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.What should you do?

• Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
• Change the data type of the Logged column to Date.
• Split the Logged column by using at as the delimiter.
• Apply a transformation to extract the first 11 characters of the Logged column.