Microsoft Power BI Certification (PL-300) Practice Test 18

Providers and pharmacy retailers measure access as carefully as revenue: appointment lag, script volume, and site productivity. Power BI is where data analysts assemble those measures for regional operators. Data scientists explain staffing or demand models in language a clinic director can challenge. Exam PL-300 gives you the Power BI Data Analyst Associate title Microsoft publishes for this work. Benefits include a resume keyword that matches analyst requisitions and evidence that you follow a vendor-defined bar. This Free Microsoft Power BI Data Analyst Associate Certification (PL-300) Practice Test 18 keeps preparation cost at zero while you learn the exam’s shape. Employers such as Kaiser Permanente, HCA Healthcare, and Walgreens hire analysts who maintain these views. U.S. base pay varies by city and industry: junior data analysts often earn $58,000–$75,000, mid-level analysts commonly earn $78,000–$108,000, and senior data analysts frequently reach $112,000–$145,000. Synergisticit JOPP helps jobseekers get certified, prepared, and hired at top tech companies through our Job Placement programs—Java DevOps Full Stack JOPP and Data Science JOPP.

If you want to learn how to get hired as a Power BI Data Analyst, Data Scientist, Data Engineer, AI or ML engineer, Java developer, or software engineer, contact Synergisticit for expert upskilling and marketing connections to companies. Visit Synergisticit Contact Us and Synergisticit JOPP.

Welcome to your Microsoft Power BI - Test-18

Name

Phone

Q1. What is the best way to handle missing data in a dataset?

Select 1 option(s):

Remove the missing data

Replace the missing data with the mean value

Replace the missing data with the median value

Replace the missing data with the mode value

Q2. 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: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table. Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q3. You are designing a data model for a real estate company. Which entity should you use to store information about properties?

Select 1 option(s):

A. Property

B. Agent

C. Listing

D. Offer

Q4. What is the purpose of the Power BI Mobile App?

Select 1 option(s):

To allow users to view and interact with Power BI reports on mobile devices

To allow users to create custom visuals

To allow users to share reports with others

To allow users to create dashboards

Q5. How can you identify outliers in a dataset?

Select 1 option(s):

Use box plots

Use scatter plots

Use histograms

Use bar charts

Q6. 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 five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports. Solution: You create an Azure Active Directory group that contains all the users. You share each selected report and the one dashboard to the group. Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q7. How can you create a dataflow in Power BI?

Select 2 option(s):

Connect to a data source

Import data from a file

Use Power Query to transform data

Delete a dataflow

Q8. You create a report by using Microsoft Power BI Desktop.The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company‘s internal network.You plan to publish the report to the Power BI Service.What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

Select 1 option(s):

A. an OData feed

B. an On-premises data gateway

C. a subscription

D. a scheduled refresh of the dataset

Q9. How can you ensure data privacy and security during analysis?

Select 1 option(s):

Use encryption and access controls

Use data profiling tools

Use data visualization tools

Use data transformation tools

Q10. How can you create a relationship between two tables in Power BI?

Select 2 option(s):

Use the Manage Relationships dialog box

Use the Query Editor

Use the Data Model view

Use the Visualizations pane

Q11. What is the best way to handle large datasets for analysis?

Select 1 option(s):

Use distributed computing systems

Use data profiling tools

Use data visualization tools

Use data transformation tools

Q12. You have a report that includes a card visualization.You need to apply the following conditional formatting to the card while minimizing design effort:✑ For values that are greater than or equal to 100, the font of the data label must be dark red.✑ For values that are less than 100, the font of the data label must be dark gray.Which type of format should you use?

Select 1 option(s):

A. Color scale

B. Rules

C. Field value

Q13. You need to create a data source that can be used by Power Apps. Which type of data source should you use if you need to store large amounts of data?

Select 1 option(s):

SQL Server

Common Data Service

SharePoint

OneDrive

Q14. You want to show the comparison of sales performance between different sales representatives. Which chart type would be best to use?

Select 1 option(s):

A. Bar chart

B. Line chart

C. Scatter chart

D. Dual-axis chart

Q15. What is the purpose of a data source in Power BI?

Select 1 option(s):

To define the location and format of data

To define the location and format of a report

To define the location and format of a visualization

To define the location and format of a dashboard

Q16. 10. How can you share a Power BI report with external users?

Select 1 option(s):

By publishing the report to the Power BI service and sharing it with external users

By exporting the report to PDF and emailing it to external users

By creating a new workspace and inviting external users to it

By using the Power BI Gateway to share on-premises data with external users

Q17. You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis. What should you do?

Select 1 option(s):

A. Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library.

B. Get data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.

C. Get data from a SharePoint folder, enter the site URL, and then select Combine & Load.

D. Get data from a SharePoint list, enter the site URL, and then select Combine & Load.

Q18. You have a table that contains sales data and approximately 1,000 rows.You need to identify outliers in the table.Which type of visualization should you use?

Select 1 option(s):

A. area chart

B. scatter plot

C. pie chart

D. donut chart

Q19. How can you share a workspace with external users in Power BI?

Select 1 option(s):

A. Add external users to the workspace

B. Share a dashboard with external users

C. Share a report with external users

D. Use a guest account to share the workspace

Q20. How can you ensure data accuracy before analysis?

Select 1 option(s):

Use data profiling tools

Use data visualization tools

Use data transformation tools

Use data modeling tools

Q21. You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions.Each sales region has an HR manager.You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.How should you provision access to the reports for the HR managers?

Select 1 option(s):

A. Publish the reports in an app and grant the HR managers access permission.

B. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.

C. Publish the reports to a different workspace other than the one hosting the datasets.

D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Q22. What is the purpose of the Power BI Report Server?

Select 1 option(s):

To allow users to host and view Power BI reports on-premises

To allow users to create custom visuals

To allow users to share reports with others

To allow users to create dashboards

Q23. You have five sales regions. Each region is assigned a single salesperson.You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.Salespeople must see only the data from their region.You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.A salesperson reports that she believes she should see more data.You need to verify what data the salesperson currently sees.What should you do?

Select 1 option(s):

A. Use the Test as role option to view data as the salesperson‘s user account.

B. Use the Test as role option to view data as the Sales role.

C. Instruct the salesperson to open the report in Microsoft Power BI Desktop.

D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Q29. 9. What is the purpose of the Power BI Gateway?

Select 1 option(s):

To allow on-premises data to be accessed by Power BI

To provide a way to share reports and dashboards with external users

To schedule data refreshes for reports and dashboards

To create custom visuals for reports and dashboards

Q25. 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 five reports and two dashboards in a workspace.You need to grant all organizational users read access to one dashboard and three reports.Solution: You publish an app to the entire organization.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q26. You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.The report is a single page that contains 15 AppSource visuals and 10 default visuals.Users say that the report is slow to load the visuals when they access and interact with the report.You need to recommend a solution to improve the performance of the report.What should you recommend?

Select 1 option(s):

A. Change any DAX measures to use iterator functions.

B. Enable visual interactions.

C. Replace the default visuals with AppSource visuals.

D. Split the visuals onto multiple pages.

Q27. You are designing a data model for a non-profit organization. Which entity should you use to store information about donations?

Select 1 option(s):

A. Donation

B. Donor

C. Fundraiser

D. Volunteer

Q28. In Power BI Desktop, you are creating visualizations in a report based on an imported dataset.You need to allow Power BI users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data.What should you do?

Select 1 option(s):

A. From the Power BI service, configure the dataset permissions.

B. From Power BI Desktop, configure the Data Load settings for the current file.

C. From Power BI Desktop, modify the data source permissions.

D. From Power BI Desktop, configure the Report settings for the current file.

Q29. 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 BI. 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?

Select 1 option(s):

A. Yes

B. No

Q30. How can you create a calculated column in Power BI?

Select 1 option(s):

Use the Power BI Desktop

Use the Power BI Service

Use the Power BI Mobile App

Use Excel

Q31. What is the difference between a shared dataset and a published dataset in Power BI?

Select 1 option(s):

A. Shared datasets can be edited by multiple users, published datasets cannot

B. Published datasets can be refreshed, shared datasets cannot

C. Shared datasets can be used in multiple reports, published datasets cannot

D. Published datasets can be shared with external users, shared datasets cannot

Q32. You have a PBIX file that imports several tables from an Azure SQL database.The data will be migrated to another Azure SQL database.You need to change the connections in the PBIX file. The solution must minimize administrative effort.What should you do?

Select 1 option(s):

A. From Power Query Editor, create new queries.

B. From Power Query Editor, modify the source of each query.

C. Create a PBIT file, open the file, and change the data sources when prompted.

D. Modify the Data source settings.

Q33. You need to create a visualization that compares revenue and cost over time.Which type of visualization should you use?

Select 1 option(s):

A. waterfall chart

B. stacked area chart

C. line chart

D. donut chart

Q34. You have a Power BI workspace that contains several reports.You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.What should you do?

Select 1 option(s):

A. Create a row-level security (RLS) role and add the user to the role.

B. Share the reports with the user.

C. Grant the Read permission for the datasets to the user.

D. Add the user as a member of the workspace.

E. Add the user as a Viewer of the workspace.

Q35. 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 DateYou 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 andDelivery Date.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q36. You are creating a Power BI report by using Power BI Desktop.You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.Which type of visual should you use?

Select 1 option(s):

A. Q&A

B. smart narrative

C. key influencers

D. decomposition tree

Q37. You need to create a data source that can be used offline. Which type of data source should you use?

Select 1 option(s):

SQL Server

Common Data Service

SharePoint

OneDrive

Q38. How can you automate the deployment and maintenance of your assets?

Select 1 option(s):

Use Azure DevOps

Use GitHub Actions

Use Jenkins

Use Travis CI

Q39. You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:✑ A line chart that shows the number of defective products manufactured by day✑ A KPI visual that shows the current daily percentage of defective products manufacturedYou need to be notified when the daily percentage of defective products manufactured exceeds 3%.What should you create?

Select 1 option(s):

A. a subscription

B. an alert

C. a smart narrative visual

D. a Q&A visual

Q40. You want to create a data source that can be accessed by external users. Which type of data source should you use?

Select 1 option(s):

SQL Server

Common Data Service

SharePoint

OneDrive

Q41. 3. What is the difference between a measure and a calculated column in Power BI?

Select 1 option(s):

A measure is an aggregation of data, while a calculated column is a new column created from existing data

A calculated column is an aggregation of data, while a measure is a new column created from existing data

A measure is a calculation based on a single column, while a calculated column is a calculation based on multiple columns

A calculated column is a calculation based on a single column, while a measure is a calculation based on multiple columns

Q42. A user creates a Power BI report named ReportA that uses a custom theme.You create a dashboard named DashboardA.You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Select 2 option(s):

A. Publish ReportA to Power BI.

B. From ReportA save the current theme.

C. Publish ReportA to the Microsoft Power BI Community theme gallery.

D. From DashboardA, create a custom theme.

E. From DashboardA, upload a JSON theme.

Q43. You want to create a custom connector to access data from a third-party API. Which tool should you use?

Select 1 option(s):

Power BI

Power Automate

Power Apps

Power Query

Q44. 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 five reports and two dashboards in a workspace.You need to grant all organizational users read access to one dashboard and three reports.Solution: You enable included in app for all assets.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q45. What is the purpose of a dataflow in Power BI?

Select 1 option(s):

To transform and clean data

To create visualizations

To share data with other users

To manage data sources

Q46. 7. What is the difference between a calculated column and a calculated table in Power BI?

Select 1 option(s):

A calculated column creates a new column in an existing table, while a calculated table creates a new table

A calculated table creates a new column in an existing table, while a calculated column creates a new table

A calculated column is a calculation based on a single column, while a calculated table is a calculation based on multiple columns

A calculated table is a calculation based on a single column, while a calculated column is a calculation based on multiple columns

Q47. You want to compare the sales performance of two different regions. Which chart type would be best to use?

Select 1 option(s):

A. Stacked bar chart

B. Line chart

C. Scatter chart

D. Dual-axis chart

Q48. 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 BI. 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: From Power Query Editor, you import the table and then add a filter step to the query.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q49. You are creating a data model for a manufacturing company. Which entity should you use to store information about raw materials?

Select 1 option(s):

A. Product

B. Vendor

C. Purchase Order

D. Inventory

Q50. You are creating a report in Power BI Desktop.You load a data extract that includes a free text field named coll.You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.What should you do?

Select 1 option(s):

A. In the report, add a DAX calculated column that calculates the length of col1

B. In the report, add a DAX function that calculates the average length of col1

C. From Power Query Editor, add a column that calculates the length of col1

D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

Microsoft Power BI Certification (PL-300) Practice Test 18

Q1. What is the best way to handle missing data in a dataset?

Q3. You are designing a data model for a real estate company. Which entity should you use to store information about properties?

Q4. What is the purpose of the Power BI Mobile App?

Q5. How can you identify outliers in a dataset?

Q7. How can you create a dataflow in Power BI?

Q9. How can you ensure data privacy and security during analysis?

Q10. How can you create a relationship between two tables in Power BI?

Q11. What is the best way to handle large datasets for analysis?

Q13. You need to create a data source that can be used by Power Apps. Which type of data source should you use if you need to store large amounts of data?

Q14. You want to show the comparison of sales performance between different sales representatives. Which chart type would be best to use?

Q15. What is the purpose of a data source in Power BI?

Q16. 10. How can you share a Power BI report with external users?

Q18. You have a table that contains sales data and approximately 1,000 rows.You need to identify outliers in the table.Which type of visualization should you use?

Q19. How can you share a workspace with external users in Power BI?

Q20. How can you ensure data accuracy before analysis?

Q22. What is the purpose of the Power BI Report Server?

Q29. 9. What is the purpose of the Power BI Gateway?

Q27. You are designing a data model for a non-profit organization. Which entity should you use to store information about donations?

Q28. In Power BI Desktop, you are creating visualizations in a report based on an imported dataset.You need to allow Power BI users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data.What should you do?

Q30. How can you create a calculated column in Power BI?

Q31. What is the difference between a shared dataset and a published dataset in Power BI?

Q32. You have a PBIX file that imports several tables from an Azure SQL database.The data will be migrated to another Azure SQL database.You need to change the connections in the PBIX file. The solution must minimize administrative effort.What should you do?

Q33. You need to create a visualization that compares revenue and cost over time.Which type of visualization should you use?

Q34. You have a Power BI workspace that contains several reports.You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.What should you do?

Q36. You are creating a Power BI report by using Power BI Desktop.You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.Which type of visual should you use?

Q37. You need to create a data source that can be used offline. Which type of data source should you use?

Q38. How can you automate the deployment and maintenance of your assets?

Q40. You want to create a data source that can be accessed by external users. Which type of data source should you use?

Q41. 3. What is the difference between a measure and a calculated column in Power BI?

Q43. You want to create a custom connector to access data from a third-party API. Which tool should you use?

Q45. What is the purpose of a dataflow in Power BI?

Q46. 7. What is the difference between a calculated column and a calculated table in Power BI?

Q47. You want to compare the sales performance of two different regions. Which chart type would be best to use?

Q49. You are creating a data model for a manufacturing company. Which entity should you use to store information about raw materials?

Q50. You are creating a report in Power BI Desktop.You load a data extract that includes a free text field named coll.You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.What should you do?

Company

Some Useful Links

Our Services

Oh yeah, we're on social media too!