PL-300 Dumps are Available for Instant Access [2024]
Practice with these PL-300 dumps Certification Sample Questions
The PL-300 exam covers a wide range of topics related to data analysis and visualization, including data modeling, data preparation, data visualization, and data analysis. Candidates are tested on their ability to create and manage datasets, design and develop reports and dashboards, and use Power BI to gain insights into business data.
NEW QUESTION # 190
You have a table that contains the following three columns:
City
Total Sales
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
How should you configure the visualization? 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-influencers
NEW QUESTION # 191
You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.
You add a sheer named Country to each page of the report.
You need to configure the report to meet the following requirements:
* When a user selects a country on the first page, the report must filter the other pages.
* The second and third pages must display only the filtered results.
Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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.Ther NOTE Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 192
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)
The related dimension tables are imported into the model.
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:
Explanation
Reference:
https://finance-bi.com/power-bi-basket-analysis/
NEW QUESTION # 193
You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A. Column profile
- B. Column distribution
- C. Show whitespace
- D. Column quality
- E. Monospace
Answer: A,B
NEW QUESTION # 194
You have a report in Power BI Desktop 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:
NEW QUESTION # 195
You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements:
* Customer must be refreshed daily.
* Date must be refreshed once every three years.
* Sales must be refreshed in near real time.
* SalesAggregate must be refreshed once per week.
You need to select the storage modes for the tables. The solution must meet the following requirements:
Answer:
Explanation:
NEW QUESTION # 196
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:
Reference:
https://docs.microsoft.com/en-us/dax/allselected-function-dax
NEW QUESTION # 197
You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.
You have a Power Bl dashboard named DashboardA that has Q&A enabled.
You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to Dashboard 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 - From powerbi.com, upload Excel1.
2 - From powerbi.com, import Excel1 as a dataset.
3 - From powerbi.com, add a tile for the Excel1 dataset to DahboardA.
NEW QUESTION # 198
You have a report in Power BI Desktop 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:
NEW QUESTION # 199
Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)
You need to ensure that all the users can access the dashboards.
What should you do first?
- A. From the Power BI Admin portal, modify the Privacy Settings.
- B. From the properties of each dashboard, modify the Share dashboard settings.
- C. Instruct each user to install Microsoft Office 2016.
- D. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
Answer: D
Explanation:
References:
http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/
NEW QUESTION # 200
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. Create a horizontal line that has a fixed value of 24,000.
- 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. Add a measure to the visual that uses the following DAX expression. Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],6.40)
Answer: C
NEW QUESTION # 201
You have the Power Bl data model shown in the following exhibit.
You create two row-level security (RlS) roles named Manager and CFO.
You plan to publish the dataset to the Power Bl service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
* Each manager must see only the data in the Sales and Human Resources tables for their own country.
* The CFO must be prevented from seeing the data in the Human Resources table.
* The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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.
The Country table contains the following data.
You plan to publish the dataset to the Power Bl service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
* Each manager must see only the data in the Sales and Human Resources tables for their own country.
* The CFO must be prevented from seeing the data in the Human Resources table.
* The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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:
Explanation:
NEW QUESTION # 202
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. Increase the number of times that the dataset is refreshed
- B. Replace the default visuals with AppSource visuals.
- C. Remove unused columns from tables in the data model.
- D. Change any DAX measures to use iterator functions.
Answer: A
NEW QUESTION # 203
You have a report page that contains the visuals 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:
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions
NEW QUESTION # 204
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.
The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Order table and the Store table on the Store_ID column.
What should you do before you create the relationship?
- A. In the Order table query, use the Table.TrasformRows function.
- B. In the Order table query, use the Table.TrasformColumnTypes function.
- C. In the Store table query, use the Table.TrasformColumnTypes function.
- D. In the Store table query, use the Table.TrasformRows function.
Answer: C
NEW QUESTION # 205
You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.
You have a Power Bl dashboard named DashboardA that has Q&A enabled.
You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to Dashboard 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 - From powerbi.com, upload Excel1.
2 - From powerbi.com, import Excel1 as a dataset.
3 - From powerbi.com, add a title for the Excel1 dataset to DashboardA.
NEW QUESTION # 206
You have a Power B1 model that contains a table named Date. The table has the following columns.
Answer:
Explanation:
see the expalanation for the answer below.
Explanation
Answer is below.
NEW QUESTION # 207
......
Get Instant Access REAL PL-300 DUMP Pass Your Exam Easily: https://www.pass4sures.top/Microsoft-Certified-Power-BI-Data-Analyst-Associate/PL-300-testking-braindumps.html
PL-300 Free Exam Questions with Quality Guaranteed: https://drive.google.com/open?id=1V7XqCmnz-2FuztBA_mlq-zNcURMDu9fc