2023 Realistic PL-300 Dumps Questions To Gain Brilliant Result
Start your PL-300 Exam Questions Preparation with Updated 337 Questions
NEW QUESTION # 47
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],6.40) - B. Add a measure to the visual that uses the following DAX expression.
Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40) - C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- D. Create a horizontal line that has a fixed value of 24,000.
Answer: C
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart
Add percentile lines to monitor daily revenue
NEW QUESTION # 48
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.
From Power Query Editor, you profile the data shown in the following exhibit.
The IOT ID columns are unique to each row in query.
You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.
Solution: You change the IOT DateTime column to the Date data type.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
NEW QUESTION # 49
You have the Power Bl model shown in the following exhibit.
There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only.
What should you do?
- A. Create a slicer that filters Departments based on DepartmentID.
- B. Create a DepartmentID parameter to filter the Departments table.
- C. Create a row-level security (RLS) role for each department, and then define the membership of the role.
- D. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.
Answer: C
NEW QUESTION # 50
You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
- A. Remove duplicates from the City column.
- B. |Remove duplicates from the table.
- C. Remove duplicates from the Country column.
- D. Delete the Country column.
- E. Delete the City column.
Answer: C,E
Explanation:
Explanation
To create a dimension table for Country from your source data, you need to perform these two actions34:
Delete the City column. You don't need this column for your Country dimension, as it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis.
Remove duplicates from the Country column. You want to have a list of unique countries in your dimension table, so you need to remove any duplicate values from this column.
NEW QUESTION # 51
You have a Power BI imported dataset that contains the data model 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:
NEW QUESTION # 52
You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? 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/visuals/power-bi-visualization-scatter
NEW QUESTION # 53
You need to create a measure that will return the percentage of late orders.
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:
See the answer as below in explanation.
Explanation
Answer as below
Graphical user interface Description automatically generated
NEW QUESTION # 54
You have a Power Bl report.
You have the following tables.
You have the following DAX measure.
Answer:
Explanation:
NEW QUESTION # 55
You have a Microsoft Power Bl 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 custom 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?
- A. Remove unused columns from tables in the data model.
- B. Change any DAX measures to use iterator functions.
- C. Replace the default visuals with AppSource visuals.
- D. Increase the number of times that the dataset is refreshed
Answer: D
NEW QUESTION # 56
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 # 57
You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 58
You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is 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:
NEW QUESTION # 59
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.
From Power Query Editor, you profile the data shown in the following exhibit.
The IOT ID columns are unique to each row in query.
You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.
Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
Does this meet the goal?
- A. Yes
- B. No
Answer: B
NEW QUESTION # 60
You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is 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:
Explanation
NEW QUESTION # 61
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 employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
Explanation
Table Description automatically generated
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/
NEW QUESTION # 62
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the 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.
- A. Replace the slicers with report-level filters.
- B. Replace the slicers with visual-level filters.
- C. Create a bookmark for each slicer value.
- D. Sync the slicers across the pages.
- E. Replace the slicers with page-level filters.
Answer: A,D
Explanation:
Explanation
Add a report-level filter to filter an entire report.
The visuals on the active page, and on all pages in the report, change to reflect the new filter.
You can sync a slicer and use it on any or all pages in a report.
1. On the Power BI Desktop View menu, select Sync slicers.
The Sync slicers pane appears between the Filters and Visualizations panes.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
NEW QUESTION # 63
You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is 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:
NEW QUESTION # 64
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.
Answer:
Explanation:
NEW QUESTION # 65
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:
Explanation
Box 1: TOPN
TOPN returns the top N rows of the specified table.
Box 2: SUMMARIZE
SUMMARIZE returns a summary table for the requested totals over a set of groups.
Box 3: DESC
Sort in descending order.
It is last in the TOPN command.
TOPN syntax:
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]...]) Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax
NEW QUESTION # 66
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?
- A. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
- B. Duplicate the Date query in Power Query and use active relationships between both Date tables.
- C. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.
- D. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
Answer: C
Explanation:
Explanation
Only one relationship can be active.
Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
NEW QUESTION # 67
......
Easy Success Microsoft PL-300 Exam in First Try: https://www.actualtestsit.com/Microsoft/PL-300-exam-prep-dumps.html
A Fully Updated PL-300 Exam Dumps - PDF Questions and Testing Engine: https://drive.google.com/open?id=1vX0jOFLf2-W_L2gzkWnn-wokg2XBsHbJ