Free Power BI Data Analyst (PL-300) Certification Questions and Answers

The Power BI Data Analyst Associate (PL-300) is a certification exam that is offered by Microsoft. It usually validates the skills and knowledge of a data analyst who uses Power BI for the purpose of analyzing data and creating reports. It validates the following skills;

• Power BI Data Analyst (PL-300) Certification Objectives
  • Preparing data for analysis
  • Modeling of data
  • Visualizing and analyzing data
  • Deploying and maintaining assets
• Power BI Data Analyst (PL-300) Certification Exam Details
• Power BI Data Analyst (PL-300) Certification Practice Test Questions
  

Power BI Data Analyst (PL-300) Certification Objectives

Preparing data for analysis

This includes multiple tasks like importing data from sources, cleaning the data, and then transforming it.

Modeling of data

This includes tasks like creating relationships between data tables and defining calculated columns and measures. It also includes creating complex calculations using DAX.

Visualizing and analyzing data

This mainly includes tasks like creating charts, tables, and KPIs.

Deploying and maintaining assets

This includes multiple tasks like publishing reports to the Power BI service, configuring security settings, and managing data refresh schedules.

Power BI Data Analyst (PL-300) Certification Exam Details

Exam details

• The duration of the exam is 120 minutes.
• It contains 40 to 50 questions in the form of multiple choices.
• The passing score is 700.

Eligibility

• If you want to be eligible to take the exam then you need to have;
• A basic understanding of data analysis concepts.
• You must have experience in using Power BI.
• You should be able to read and understand English.

We can conclude by saying The Power BI Data Analyst Associate (PL-300) is a highly valuable certification and is suitable for data analysts who wish to depict their skills and knowledge to potential employers.

Power BI Data Analyst (PL-300) Certification Practice Test Questions

Beginner level:

Q1. Which of the following is NOT a data source that can be imported into Power BI?

• A Excel workbook
• B SQL Server database
• C CSV file
• D Google Analytics

Correct Answer: D

Check out the Solution:

Google Analytics is not a data source that can be imported into Power BI directly. However, you can use the Google Analytics connector to import data from Google Analytics into Power BI.

Q2. Which of the following is NOT a type of measure in Power BI?

• Calculated measure
• Derived measure
• Dimension
• KPI

Correct Answer: C

Check out the Solution:

Dimensions are used to categorize data, while measures are used to calculate values. KPIs are a type of measure that is used to track performance.

Q3. Which of the following is NOT a type of visual in Power BI?

• Bar chart
• Pie chart
• Table
• Q&A

Correct Answer: D

Check out the Solution:

Q&A is not a visual in Power BI. It is a feature that allows you to ask questions about your data and get answers in the form of visuals.

Q4. Which of the following is NOT a way to filter data in Power BI?

• Using a filter pane
• Using a slicer
• Using a calculated column
• Using a DAX expression

Correct Answer: C

Check out the Solution:

Calculated columns are used to calculate values, not to filter data.

Q5. Which of the following is NOT a way to publish a report in Power BI?

• Publishing to the Power BI service
• Publishing to a SharePoint library
• Publishing to a file
• Publishing to an email

We’ve compiled a list of the best courses on Sharepoint Online to help you advance your skills.

Correct Answer: D

Check out the Solution:

You can’t publish a report directly to an email. You can, however, export a report to a file and then attach the file to an email.

Q6. You have a Power BI dataset that contains a column called OrderDate. You want to create a calculated column that calculates the number of days since the order was placed. Which of the following DAX expressions would you use?

• COUNT(OrderDate)
• DATEDIFF(‘day’, OrderDate, TODAY())
• DATEPART(‘day’, OrderDate)
• TODAY() – OrderDate

Correct Answer: B

Check out the Solution:

The DATEDIFF() function calculates the difference between two dates. In this case, we are calculating the difference between the OrderDate column and the current date.

Q7. You have a Power BI report that contains a table of sales data. You want to create a visual that shows the sales by product category. Which of the following visuals would you use?

• Bar chart
• Pie chart
• Table
• Treemap

Correct Answer: D

Check out the Solution:

A treemap is a good visual for showing hierarchical data, such as product categories. The treemap will show the sales for each product category, with the larger categories being shown in a larger size.

Q8. You have a Power BI report that contains a measure called Total Sales. You want to create a calculated column that calculates the percentage of total sales that each product category represents. Which of the following DAX expressions would you use?

• [Total Sales] / [Product Category]
• [Product Category] / [Total Sales]
• SUM([Total Sales]) / SUM([Product Category])
• [Total Sales] / SUM([Total Sales])

Correct Answer: B

Check out the Solution:

The DAX expression [Product Category] / [Total Sales] will calculate the percentage of total sales that each product category represents.

Q9. You have a Power BI report that contains a table of sales data. You want to create a visual that shows the sales by month. Which of the following visuals would you use?

• Bar chart
• Pie chart
• Table
• Line chart

Correct Answer: D

Check out the Solution:

A line chart is a good visual for showing trends over time, such as sales by month. The line chart will show the sales for each month, with the months being connected by a line.

Q10. You have a Power BI report that contains a table of sales data. You want to create a visual that shows the sales by country. Which of the following visuals would you use?

• Bar chart
• Pie chart
• Table
• Map

Correct Answer: D

Check out the Solutions:

A map is a good visual for showing geographic data, such as sales by country. The map will show the sales for each country, with the countries being represented by different colors.

Intermediate level:

Q1. You have a Power BI dataset that contains a column called OrderDate. You want to create a calculated column that calculates the number of days since the order was placed, but only if the order was placed within the last 30 days. Which of the following DAX expressions would you use?

• IF(DATEDIFF(‘day’, OrderDate, TODAY()) <= 30, DATEDIFF(‘day’, OrderDate, TODAY()), 0)
• IF(DATEDIFF(‘day’, OrderDate, TODAY()) < 30, DATEDIFF(‘day’, OrderDate, TODAY()), -1)
• IF(DATEDIFF(‘day’, OrderDate, TODAY()) > 30, DATEDIFF(‘day’, OrderDate, TODAY()), 0)
• IF(DATEDIFF(‘day’, OrderDate, TODAY()) <= 30, 1, 0)

Correct Answer: A

Check out the Solution:

The IF() function allows us to create an expression that returns one value if a condition is met, and another value if the condition is not met. In this case, we are using the IF() function to create a calculated column that returns the number of days since the order was placed, but only if the order was placed within the last 30 days.

Q2. You have a Power BI report that contains a table of sales data. You want to create a visual that shows the sales by product category, but only if the product category has more than 100 sales. Which of the following visuals would you use?

• Bar chart
• Pie chart
• Table
• Filter

Correct Answer: D

Check out the Solution:

A filter is a good way to show only the data that meets a certain criteria. In this case, we can use a filter to show only the product categories that have more than 100 sales.

Q3. You have a Power BI report that contains a measure called Total Sales. You want to create a calculated column that calculates the percentage of total sales that each product category represents, but only if the product category has more than 100 sales. Which of the following DAX expressions would you use?

• IF(SUM([Product Category]) > 100, [Product Category] / [Total Sales], 0)
• IF(SUM([Product Category]) <= 100, [Product Category] / [Total Sales], 0)
• IF(SUM([Product Category]) > 100, 1, 0)
• IF(SUM([Product Category]) <= 100, 1, 0)

Correct Answer: A

Check out the Solution:

The IF() function allows us to create an expression that returns one value if a condition is met, and another value if the condition is not met. In this case, we are using the IF() function to create a calculated column that calculates the percentage of total sales that each product category represents, but only if the product category has more than 100 sales.

Q4. You have a Power BI report that contains a table of sales data. You want to create a visual that shows the sales by month, but only if the sales for the month are greater than $10,000. Which of the following visuals would you use?

• Bar chart
• Pie chart
• Table
• Filter

Correct Answer: D

Check out the Solution:

A filter is a good way to show only the data that meets a certain criteria. In this case, we can use a filter to show only the months that have sales greater than $10,000.

Q5. You have a Power BI report that contains a table of sales data. You want to create a visual that shows the sales by country, but only if the country has more than 100,000 customers. Which of the following visuals would you use?

• Bar chart
• Pie chart
• Table
• Map

Correct Answer: D

Check out the Solution:

A map is a good way to show geographic data, such as sales by country.

Advance Level:

Q1. You have a Power BI report that contains a table of sales data. You want to create a calculated column that calculates the average sales per month, but only if the month is within the first quarter of the year. Which of the following DAX expressions would you use?

IF(MONTH(OrderDate) > 3, 0, AVERAGE([Sales]))

IF(MONTH(OrderDate) <= 3, AVERAGE([Sales]), 0)

IF(MONTH(OrderDate) > 3, AVERAGE([Sales]), 1)

IF(MONTH(OrderDate) <= 3, 1, 0)

Correct Answer: B

Check out the Solution:

The IF() function allows us to create an expression that returns one value if a condition is met, and another value if the condition is not met. In this case, we are using the IF() function to create a calculated column that calculates the average sales per month, but only if the month is within the first quarter of the year.

Q2. You have a Power BI report that contains a table of sales data. You want to create a visual that shows the sales by product category, but only if the product category has more than 100 sales and the sales are greater than $10,000. Which of the following visuals would you use?

• Bar chart
• Pie chart
• Table
• Filter

Correct Answer: D

Check out the Solution:

A filter is a good way to show only the data that meets a certain criteria. In this case, we can use a filter to show only the product categories that have more than 100 sales and the sales are greater than $10,000.

Q3. You have a Power BI report that contains a measure called Total Sales. You want to create a calculated column that calculates the percentage of total sales that each product category represents, but only if the product category has more than 100 sales and the sales are greater than $10,000. Which of the following DAX expressions would you use?

• IF(SUM([Product Category]) > 100 && SUM([Sales]) > 10000, [Product Category] / [Total Sales], 0)
• IF(SUM([Product Category]) <= 100 || SUM([Sales]) <= 10000, [Product Category] / [Total Sales], 0)
• IF(SUM([Product Category]) > 100 && SUM([Sales]) > 10000, 1, 0)
• IF(SUM([Product Category]) <= 100 || SUM([Sales]) <= 10000, 1, 0)

Correct Answer: B

Check out the Solution:

The IF() function allows us to create an expression that returns one value if a condition is met, and another value if the condition is not met. In this case, we are using the IF() function to create a calculated column that calculates the percentage of total sales that each product category represents, but only if the product category has more than 100 sales and the sales are greater than $10,000.

Q4. You have a Power BI report that contains a table of sales data. You want to create a visual that shows the sales by month, but only if the sales for the month are greater than $10,000 and the month is within the first quarter of the year. Which of the following visuals would you use?

• Bar chart
• Pie chart
• Table
• Filter

Correct Answer: D

Check out the Solution:

A filter is a good way to show only the data that meets a certain criteria. In this case, we can use a filter to show only the months that have sales greater than $10,000 and the months are within the first quarter of the year.

Q5. You have a Power BI report that contains a table of sales data. You want to create a visual that shows the sales by country, but only if the country has more than 100,000 customers and the sales for the country are greater than $100,000. Which of the following visuals would you use?

Bar chart

Pie chart

Table

Filter

Correct Answer: D

Check out the Soultion:

A filter is a good way to show only the data that meets a certain criteria. In this case, we can use a filter to show only the countries that have more than 100,000 customers and the sales for the country are greater than $100,000.

---

Some Best Power BI Data Analyst (PL-300) Training Courses with Certificates: