Microsoft Power BI Data Analyst (PL-300) Practice Test 19

Startups and large platforms both hire analysts who can make a metric undeniable. In a small company, the analyst may own the path from export to executive view. In a large one, the analyst is judged on trust, speed, and adoption. Data scientists in both settings use Power BI when a model result must survive a meeting with sales or finance. The PL-300 certification is specific, renewable, and easy for a recruiter to verify. This Free Microsoft Power BI Data Analyst Associate Certification (PL-300) Practice Test 19 helps you separate “I use the tool” from “I can pass the standard.” Product companies such as Netflix, Uber, and Spotify employ data analysts who share insight this way. 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-19

Name

Phone

Q1. You have a Power BI report. The report contains a visual that shows gross sales by date. The visual has anomaly detection enabled. No anomalies are detected. You need to increase the likelihood that anomaly detection will identify anomalies in the report. What should you do?

Select 1 option(s):

A. Increase the Expected range transparency setting.

B. Add a data field to the Legend field well.

C. Increase the Sensitivity setting.

D. Add a data field to the Secondary values field well.

Q2. 8. How can you create a custom visual in Power BI?

Select 1 option(s):

By importing a custom visual from the marketplace

By using the Power BI Developer Tools to create a custom visual

By using the built-in visualizations and customizing them

By creating a new report page and adding visuals to it

Q3. What is the best way to monitor the performance of your assets?

Select 1 option(s):

Use Azure Monitor

Use Azure Log Analytics

Use Azure Application Insights

Use Azure Network Watcher

Q4. 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: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q5. You are designing a data model for a financial institution. Which entity should you use to store information about customer accounts?

Select 1 option(s):

A. Account

B. Contact

C. Opportunity

D. Activity

Q6. You want to create a data source that can be used by Power BI. Which type of data source should you use?

Select 1 option(s):

SQL Server

Common Data Service

SharePoint

OneDrive

Q7. How can you ensure that your assets are highly available and scalable?

Select 1 option(s):

Use Azure Availability Zones

Use Azure Virtual Machine Scale Sets

Use Azure Load Balancer

Use Azure Traffic Manager

Q8. You have two Power BI reports named ReportA and ReportB that each uses a distinct color palette.You are creating a Power BI dashboard that will include two visuals from each report.You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.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. Upload a snapshot.

B. For the browser, set the color preference to dark mode.

C. When pinning visuals to the dashboard, select Use destination theme.

D. Select the dark dashboard theme.

E. Turn on tile flow.

Q9. 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 report-level filter that filters based on the order date.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q10. You want to show the correlation between two variables in a dataset. Which chart type would be best to use?

Select 1 option(s):

A. Scatter chart

B. Bar chart

C. Line chart

D. Pie chart

Q11. What is the difference between a slicer and a filter in Power BI?

Select 1 option(s):

A slicer is a visual control that allows users to filter data, while a filter is a data manipulation tool that allows users to filter data

A slicer is a data manipulation tool that allows users to filter data, while a filter is a visual control that allows users to filter data

A slicer and a filter are the same thing

A slicer and a filter are not available in Power BI

Q12. 5. What is the purpose of the Power BI Q&A feature?

Select 1 option(s):

To allow users to ask natural language questions and receive visual answers

To provide a way to export data to Excel

To create custom visuals for reports and dashboards

To schedule data refreshes for reports and dashboards

Q13. How can you create a custom theme in Power BI?

Select 2 option(s):

Use the Power BI Desktop

Use the Power BI Service

Use the Power BI Mobile App

Use the Power BI Developer Tools

Q14. How can you create a custom data connector in Power BI?

Select 1 option(s):

Use the Power Query SDK

Use the Power BI API

Use the Power BI Embedded SDK

Use the Power BI Mobile app

Q15. How can you ensure that your assets are backed up and recoverable in case of a disaster?

Select 1 option(s):

Use Azure Backup

Use Azure Site Recovery

Use Azure Disaster Recovery

Use Azure Storage Account Replication

Q16. How can you create a custom visual in Power BI?

Select 1 option(s):

Use the Power BI Developer Tools

Use the Power BI Service

Use the Power BI Mobile App

Use the Power BI Desktop

Q17. What is the purpose of data normalization?

Select 1 option(s):

To scale data to a common range

To remove outliers from the data

To replace missing data with estimated values

To transform data into a different format

Q18. You want to create a data source that can be used by multiple Power Apps. Which type of data source should you use?

Select 1 option(s):

SQL Server

Common Data Service

SharePoint

OneDrive

Q19. You are designing a data model for a healthcare organization. Which entity should you use to store information about patient diagnoses?

Select 1 option(s):

A. Appointment

B. Encounter

C. Diagnosis Code

D. Procedure

Q20. You are creating a data model for a retail company. Which entity should you use to store information about customer orders?

Select 1 option(s):

A. Order

B. Product

C. Customer

D. Salesperson

Q21. You are designing a data model for a customer relationship management system. Which entity should you use to store information about customer interactions?

Select 1 option(s):

A. Account

B. Contact

C. Opportunity

D. Activity

Q22. You have a Power BI tenant.You have reports that use financial datasets and are exported as PDF files.You need to ensure that the reports are encrypted.What should you implement?

Select 1 option(s):

A. Microsoft Intune policies

B. row-level security (RLS)

C. sensitivity labels

D. dataset certifications

Q23. What is the best way to manage data sources in Power BI?

Select 1 option(s):

A. Use a single data source for all reports

B. Use a separate data source for each report

C. Use a data gateway to connect to on-premises data sources

D. Use a cloud-based data source for all reports

Q24. You have a dataset that is used infrequently and refreshes every hour.You receive a notification that the refresh was disabled due to inactivity.Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

Select 2 option(s):

A. Enable query caching for the dataset.

B. Import the dataset to Microsoft Excel.

C. From the Power BI service, open a dashboard that uses the dataset.

D. From the Power BI service, open a report that uses the dataset.

E. From PowerShell, run the get-powerbireport cmdlet.

Q25. You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI dataset. You need to ensure that the dataset can be refreshed in powerbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Select 1 option(s):

A. Excel Workbook

B. Text/CSV

C. Folder

D. SharePoint folder

E. Web

Q26. You want 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 unstructured data?

Select 1 option(s):

SQL Server

Common Data Service

SharePoint

OneDrive

Q27. How can you handle duplicate data in a dataset?

Select 1 option(s):

Remove the duplicate data

Keep the first occurrence of the data

Keep the last occurrence of the data

Keep all occurrences of the data

Q28. What is the most effective way to manage your assets‘ configuration and updates?

Select 1 option(s):

Use Azure Automation

Use Azure Configuration Management

Use Azure Policy

Use Azure Update Management

Q29. You need to import data from a CSV file into Power Apps. Which connector should you use?

Select 1 option(s):

SharePoint

OneDrive

Excel

CSV

Q30. You want to show the distribution of customer ages in a survey. Which chart type would be best to use?

Select 1 option(s):

A. Histogram

B. Line chart

C. Pie chart

D. Scatter chart

Q31. You are creating a data model for a transportation company. Which entity should you use to store information about vehicles?

Select 1 option(s):

A. Vehicle

B. Driver

C. Route

D. Shipment

Q32. You are creating a data model for a marketing agency. Which entity should you use to store information about campaigns?

Select 1 option(s):

A. Campaign

B. Lead

C. Opportunity

D. Contact

Q33. You have a Power BI workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.A user wants to create a report by using the data in DS1 and publish the report to another workspace.You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.What should you do?

Select 1 option(s):

A. Add the user as a Viewer of Workspace1.

B. Grant the Build permission for DS1 to the user.

C. Share RPT1 with the user.

D. Add the user as a member of Workspace1.

Q34. 2. How can you filter data in Power BI?

Select 1 option(s):

Using slicers

Using drill-through filters

Using cross-filtering

Using calculated columns

Q35. How can you create a calculated table in Power BI?

Select 1 option(s):

Use the DAX formula language

Use the M formula language

Use the SQL formula language

Use the Python formula language

Q36. You want to show the comparison of sales performance between different product categories. 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

Q37. 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 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 a numerical amount representing US dollars.You need to create a reference line to show which employees are above the median salary.Solution: You create an average line by using the Salary measure.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q38. What is the purpose of a dataset in Power BI?

Select 1 option(s):

To store data

To create reports

To share data

To manage data sources

Q39. How can you manage workspaces in Power BI?

Select 4 option(s):

Create a new workspace

Delete a workspace

Rename a workspace

Share a workspace

Unattempted

Q40. What is the purpose of a data type in Power BI?

Select 1 option(s):

To define the format and behavior of a column

To define the format and behavior of a measure

To define the format and behavior of a visualization

To define the format and behavior of a report

Q41. You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date andOrders and between City and Orders.The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.City[State Province] = “Kentucky“Role2 contains the following filter.Date[Calendar Year] = 2020 -If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

Select 1 option(s):

A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.

B. The user will receive an error and will not be able to see the data in the report.

C. The user will only see data for which the State Province value is Kentucky.

D. The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.

Q42. You have a report that contains four pages. Each page contains slicers for the same four fields.Users report that when they select values in a slicer on one page, the selections are not persisted on other pages.You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

Select 2 option(s):

A. Create a bookmark for each slicer value.

B. Replace the slicers with report-level filters.

C. Sync the slicers across the pages.

D. Replace the slicers with page-level filters.

E. Replace the slicers with visual-level filters.

Q43. You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

Select 1 option(s):

A. Add a SQL statement.

B. Set the Command timeout in minutes setting.

C. Set Data Connectivity mode to Import.

D. Set Data Connectivity mode to DirectQuery.

Q44. What is the best way to organize datasets in Power BI?

Select 1 option(s):

A. Use folders to group related datasets

B. Use tags to categorize datasets

C. Use a naming convention to identify datasets

D. Use a separate workspace for each dataset

Q45. You have a line chart that shows the number of employees in a department over time.You need to see the total salary costs of the employees when you hover over a data point.What should you do?

Select 1 option(s):

A. Add salary to the drillthrough fields.

B. Add salary to the visual filters.

C. Add salary to the tooltips.

Q46. What is the purpose of the Power BI Q&A feature?

Select 1 option(s):

To allow users to ask natural language questions and get answers in the form of visualizations

To allow users to create custom visuals

To allow users to share reports with others

To allow users to create dashboards

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

Select 1 option(s):

Use the DAX formula language

Use the M formula language

Use the SQL formula language

Use the Python formula language

Q48. How can you create a drill-through report in Power BI?

Select 1 option(s):

Use the Drillthrough feature in the Power BI Desktop

Use the Drillthrough feature in the Power BI Service

Use the Drillthrough feature in the Power BI Mobile App

Use the Drillthrough feature in Excel

Q49. In a sales report, which chart type would be best to show the total sales for each product category?

Select 1 option(s):

A. Pie chart

B. Bar chart

C. Line chart

D. Scatter chart

Q50. You want to show the trend of website traffic over time. Which chart type would be best to use?

Select 1 option(s):

A. Line chart

B. Bar chart

C. Scatter chart

D. Pie chart