The latest leads4pass PL-300 Dumps contains 291 exam questions and answers for the Microsoft Power BI Data Analyst certification exam 2023. leads4pass PL-300 Dumps provides PDF and VCE lightweight learning tools for easy learning and increased learning progress.
Welcome 2023 Microsoft Power BI Data Analyst Exam candidates to download PL-300 Dumps: https://www.leads4pass.com/pl-300.html, to help you pass the exam easily.
PL-300 Dumps Exam Questions and Answers
Read some free Lead4Pas PL-300 Dumps 2023 exam questions and answers online:
| Number of exam questions | Exam name | Exam code | Last Updated |
| 15 | Microsoft Power BI Data Analyst | PL-300 | DA-100 dumps |
Question 1:
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?
A. Add a SQL statement.
B. Set Data Connectivity mode to DirectQuery.
C. Set the Command timeout in the minutes setting.
D. Set Data Connectivity mode to Import.
Correct Answer: B
With Power BI Desktop, when you connect to your data source, it\’s always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you\’re always viewing current data.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Question 2:
HOTSPOT
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Question 3:
You have a Power Bl report
You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:
1.
A card that shows the number of records
2.
A bar chart that shows total transaction amount by territory
3.
A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals What should you do?
A. Apply a row filter to the Dalai query in Power Query Editor.
B. Add a trend line to the scatter plot
C. Enable high-density sampling on the scatter plot
D. Add a count field of the transaction amount to the size bucket of the scatter plot
Correct Answer: B
Question 4:
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 m 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?
A. Create a column by example that starts with 2018-12-31.
B. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
C. Apply the parse function from the Date transformations options to the Logged column.
D. 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.
Correct Answer: C
Question 5:
You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
1.
First name
2.
Last name
3.
Email address
4.
State/Region
5.
Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Open the Advanced Editor.
B. Select Column quality.
C. Enable Column profiling based on the entire dataset.
D. Select Column distribution.
E. Select Column profile.
Correct Answer: CE
In Power query, the load preview by default is 1000 rows. By default, the column quality also only looks at the first 1000 rows. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set.
Question 6:
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?
A. dataset certifications
B. row-level security (RLS)
C. sensitivity labels
D. Microsoft Intune policies
Correct Answer: C
General availability of sensitivity labels in Power BI.
Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows. When data is exported from Power BI to Excel, PowerPoint, or PDF files, Power BI automatically applies a sensitivity label on the exported file and protects it according to the label\’s file encryption settings. This way your sensitive data remains protected no matter where it is.
Question 7:
You have an app workspace named Retail Analysis in the Power BI service. You need to manage the members that have access to the app workspace. What should you do?
A. From the Power BI Admin portal, click Usage metrics.
B. From the Office 365 Admin center, click Users.
C. From the Office 365 Admin center, click Groups.
D. From the Power BI Admin portal, click Tenant settings.
Correct Answer: C
References: https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365
Question 8:
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)
What occurred at 12:03:06 PM?
A. A user pressed F5
B. A new transaction was added to the data source.
C. A user added a comment to a tile.
D. The dashboard tile cache was refreshed.
Correct Answer: D
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
Question 9:
You have a large dataset that contains more than 1 million rows. The table has a DateTime column named Date.
You need to reduce the size of the data model.
What should you do?
A. Round the hour of the Date column to startOfHour.
B. Change the data type of the Date column to Text.
C. Trim the Date column.
D. Split the Date column into two columns, one that contains only the time and another that contains only the date.
Correct Answer: D
We have to separate the date and timetables. Also, we don’t need to put the time into the date table, because the time is repeated every day. Split your DateTime column into separate date and time columns in the fact table, so that you can join the date to the date table and the time to the time table. The time needs to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your timetable.
Reference: https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi
Question 10:
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer
presents part of the solution. NOTE:
Each correct selection is worth one point.
A. Add the same slicer to each page and configure Sync slicers.
B. Edit the interactions of the KPI visualization.
C. Configure a page-level filter.
D. Edit the interactions of the slicer that is on the same page as the KPI visualization.
E. Configure a report-level filter.
Correct Answer: AD
Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.
By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations from being affected by others.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
Question 11:
Your company has training videos that are published on Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?
A. video
B. custom streaming data
C. text box
D. web content
Correct Answer: D
Question 12:
You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?
A. decomposition tree
B. QandA
C. smart narrative
D. key influences
Correct Answer: D
Question 13:
HOTSPOT
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.
There are no reporting requirements on employee_id and employee_photo.
You need to optimize the data model.
What should you configure for employee_id and employee_photo? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: Hide Optimize data by hiding fields and sorting visualization data
Box 2: Delete The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations.
Reference: https://tessellationtech.io/optimizing-power-bi-reports/
Question 14:
You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.
You need to ensure that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?
A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.
B. Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.
C. Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.
D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.
Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#power-bi-connectivity-modes
Question 15:
You have a Power Bi report. The report contains a visual that snows gross sales by date The visual have anomaly detection enabled.
No anomalies ate detected
You need to increase the likelihood that anomaly detection will identify anomalies in the report.
What should you do?
A. Add a data field to the Secondary values field weft
B. Increase the Sensitivity setting.
C. Increase the Expected range transparency setting,
D. Add a data field to the Legend field well
Correct Answer: C
…
291 latest exam questions and answers are verified by Microsoft expert team, real and effective, provide bundled download, 2023 PL-300 dumps: https://www.leads4pass.com/pl-300.html, ensure 100% success in passing Microsoft Power BI Data Analyst Exam.