Valid PL-300 Exam Q&A PDF PL-300 Dump is Ready (Updated 297 Questions)
Exam Questions and Answers for PL-300 Study Guide
Passing Score, Duration & Questions For Microsoft PL-300 Exam
The passing score: 700
Time Duration: 180 minutes
Languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Arabic (Saudi Arabia), Russian, Chinese (Traditional), Italian
Number of Questions: 40-60 questions
Microsoft PL-300: Microsoft Power BI Data Analyst is a certification exam that is designed to test and validate the skills of candidates in using Microsoft Power BI to create and manage business intelligence reports and dashboards. This exam is intended for data analysts who work with data from multiple sources and need to create reports and dashboards for business stakeholders. The exam also tests the candidate's ability to work with data models, data preparation, and data visualization.
NEW QUESTION # 20
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 is possible way to achieve this goal?
- A. Add a salary to the tooltips.
- B. Add salary to the drillthrough fields.
- C. Add a salary to the visual filters.
Answer:
Explanation:
A
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips
https://technovids.com/power-bi-filters/
NEW QUESTION # 21
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.
You need to prepare the data to support the following:
Visualizations that include all measures in the data over time
Year-over-year calculations for all the measures
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
1 - Use first row as header
2 - Unpivot all columns other than "Measure"
3 - Rename "Attribute" to "Year"
4 - Change data type of "Year" to date (Date > Year)
NEW QUESTION # 22
You have a Power Bi report for the procurement department. The report contains data from the following tables.
There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.
You need to minimize the size of the dataset without affecting the visuals. What should you do?
- A. Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month
- B. Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).
- C. Merge Suppliers and Uneltems.
- D. Remove the Lineitems[Description] column.
Answer: D
NEW QUESTION # 23
You have the dataset shown in the following exhibit.
You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?
- A. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
D18912E1457D5D1DDCBD40AB3BF70D5D - B. Add a Top N filter to the visual.
- C. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
- D. Configure the Sales Profit measure to use the RANKX function.
Answer: B
Explanation:
Explanation
Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.
Note:
* Select the Column you want to display the Top Sales Profit
* Then change the Filter Type of that Column to Top N
* Fill in Top / Bottom number field
* And lastly drag to the By Value filed your Sales Profit
Reference:
https://www.tutorialgateway.org/power-bi-top-10-filters/
NEW QUESTION # 24
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/dax/calculate-function-dax
NEW QUESTION # 25
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: Using a workspace membership
Scenario:
The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.
Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of dashboards, reports, and datasets in it.
Box 2: A mail-enabled security group
Scenario: Security Requirements
The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.
NEW QUESTION # 26
You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
1 - Select Use Header as First Row.
2 - Select Department and Product and Unpivot Other Columns
3 - Rename the Attribute column to Year and the Value column to Revenue.
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
NEW QUESTION # 27
HOTSPOT
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load.
The Combine Files dialog box is shown in the exhibit. (Click the Exhibit 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.
Answer:
Explanation:
NEW QUESTION # 28
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
- A. Transform the sales_amount column to replace negative values with 0.
- B. Select Column profile, and then select the sales_amount column.
- C. Select Column distribution.
- D. Select the sales_amount column and apply a number filter.
Answer: B
Explanation:
Topic 1, Litware, Inc.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
* Executives require a visual that shows sales by region.
* Regional managers require a visual to analyze weekly sales and returns.
* Sales managers must be able to see the sales data of their respective region only.
* The sales managers require a visual to analyze sales performance versus sales targets.
* The sale department requires reports that contain the number of sales transactions.
* Users must be able to see the month in reports as shown in the following example: Feb 2020.
* The customer service department requires a visual that can be filtered by both sales month and ship month independently.
NEW QUESTION # 29
You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?
- A. Change the Microsoft Power Bl license type of the sales manager.
- B. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
- C. Request that the sales manager be added to the correct Azure Active Directory group.
- D. Manage the permissions of the underlying dataset
Answer: C
NEW QUESTION # 30
You are profiling data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
Answer:
Explanation:
NEW QUESTION # 31
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.
Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.
NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Answer:
Explanation:
1 - From Power BI Desktop, select Get Data, and then select Folder.
2 - From Power Query Editor, expand the Attributes column.
3 - From Power Query Editor, combine the Content column.
NEW QUESTION # 32
You build a report about warehouse inventory data. The dataset has more than 10 million product records from
200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation
NEW QUESTION # 33
You are creating a Microsoft Power BI data model that has the tables shown in the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
NEW QUESTION # 34
You are profiling data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
Answer:
Explanation:
NEW QUESTION # 35
You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax
NEW QUESTION # 36
You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.
Which type of visual should you use?
- A. key influencers
- B. Q&A
- C. decomposition tree
- D. smart narrative
Answer: C
NEW QUESTION # 37
HOTSPOT
You have a power BI tenant that hosts the datasets shown in the following table.
You have the following requirements:
* The export of reports that contain Personally Identifiable Information (Pll) must be prevented.
* Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise select No. NOTE: Each correct selection is worth one point
Answer:
Explanation:
NEW QUESTION # 38
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax
NEW QUESTION # 39
You build a report about warehouse inventory dat
a. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
1 - Create a product hierarchy...
2 - Replace the use of ProductDescription....
3 - Transform the ProductDescription column...
4 - Add the product hierarchy as....
5 - Add a column named ProductName...
6 - Create a product hierarchy of ProductCategory,....
NEW QUESTION # 40
DRAG DROP
You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 41
You are creating a line chart in a Power Bl report as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Answer as selected
NEW QUESTION # 42
You plan to create a Power Bl dataset to analyze attendance at a school. Data will come from two separate views named View1 and View? in an Azure SQL database. View1 contains the columns shown in the following table.
View2 contains the columns shown in the following table.
The views can be related based on the Class ID column.
Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during two different periods, but the class will have a different class ID.
You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis:
The count of classes that occur by period
The count of students in attendance by period by day
The average number of students attending a class each month
In which table should you include the Teacher First Name and Period Number fields? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 43
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.
You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
NEW QUESTION # 44
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 45
......
Certification dumps - Microsoft Certified: Power BI Data Analyst Associate PL-300 guides - 100% valid: https://www.pass4suresvce.com/PL-300-pass4sure-vce-dumps.html
100% Pass Your PL-300 Microsoft Power BI Data Analyst at First Attempt with Pass4suresVCE: https://drive.google.com/open?id=1AOD-54j0bOccbp4wzWM3WPE_yncn5Bw1