Exam PL-300 Microsoft Power BI Data Analyst

Question 1

You launch Power Query Editor and open a query. The percentage of empty values in each column must be rapidly determined. Which Data Preview selection is best?

Column quality Show whitespace Column profile Column distribution

Correct Answer:

Column quality

Question 2

You have a custom connector that gives you the following information for each email sent in the last year: ID, From, To, Subject, Body, and Has Attachments. There are returned more than 10 million records. Based on whom employees send emails to, you create a report that analyzes the internal networks of those employees. You must keep the recipients of the report from viewing the examined emails. The model size must be reduced in the solution. What ought you to do?

From Model view, set the Subject and Body columns to Hidden. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent. Remove the Subject and Body columns during the import. None of the Above

Correct Answer:

Remove the Subject and Body columns during the import.

Question 3

You have one of the three Azure SQL databases listed below: - Test - Production - Development You have a dataset that draws its data from the development database. You must set up the dataset so that you can quickly switch between the powerbi.com development, test, and production database servers as the data source. Which one is the best?

Create a parameter and update the queries to use the parameter. Create a query for each database server and hide the development tables. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function. Create a JSON file that contains the database server names. Import the JSON file to the dataset.

Correct Answer:

Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

Question 4

You have a CSV file with user complaints in it. The file has a column called Logged in it. Each complaint's log entry includes the date and time that it happened. The information in Logged is formatted as follows: 2018-12-31 08:59. You must be able to use an internal date hierarchy and the logged date to assess the complaints. What ought you to do?

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number. Change the data type of the Logged column to Date. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

Correct Answer:

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

Question 5

You have a sales transaction database stored in Azure SQL. The database is regularly updated. To find phony transactions, you must create reports from the data. After an update, the data must be accessible within five minutes. How should the data connection be set up?

Set Data Connectivity mode to Import. Add a SQL statement. Set Data Connectivity mode to DirectQuery. Set the Command timeout in minutes setting.

Correct Answer:

Set Data Connectivity mode to DirectQuery.

Question 1

Exam overview

About this Exam

Prepare with the Exam PL-300 Microsoft Power BI Data Analyst practice quiz. This question bank includes 31 questions covering data, sales, database, power, and column. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

Exam PL-300 Microsoft Power BI Data Analyst

This practice set contains 31 questions from the matching question bank and focuses on data, sales, database, power, and column. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.

No fixed duration is currently configured for this quiz.

Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.

Yes. You can retake the practice test again as you continue studying during your available access period.

After your access is confirmed, you can continue into the complete practice exam from this quiz flow.

Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.

Keep studying

Correct Answer:

Correct Answer:

Correct Answer:

Correct Answer:

Correct Answer:

About this Exam

Additional Information

Exam PL-300 Microsoft Power BI Data Analyst

Frequently Asked Questions

Related Questions

2nd Class Power Engineering (2A1) Practice Exam

2nd Class Power Engineering 2A3 Practice Exam

2nd Class Power Engineering (2B1) Practice Exam

2nd Class Power Engineering 2B2 Practice Exam

2nd Class Power Engineering 2B3 Practice Exam

2nd Class Power Engineering 2A2 Practice Exam Guide