Free PL-300 Exam Files Downloaded Instantly 100% Dumps & Practice Exam
Free Exam Updates PL-300 dumps with test Engine Practice
The PL-300 exam covers a wide range of topics related to Power BI, including data modeling, data analysis expressions, visualization, and data integration. PL-300 exam is designed to test your knowledge in each of these areas and assess your ability to create and manage data models, build reports, and analyze data using Power BI. PL-300 exam also covers topics related to data security and data privacy, which are critical aspects of any data analysis project.
NEW QUESTION # 20
You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
Box 1: Background color
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color.
In the Background color or Font color dialog box, select Field value from the Format by drop-down field.
Box 2: Field value
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
NEW QUESTION # 21
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 # 22
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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 # 23
You are developing a sales report that will have multiple pages. Each page will answer a different business question.
You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.
What should you include on the menu page?
- A. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.
- B. Create a button for each business question and set the action type to Bookmark.
- C. Create a text box for each business question and insert a link.
Answer: B
Explanation:
When you create a bookmark, the following elements are saved with the bookmark: - The current page - Filters - Slicers, including slicer type (for example, dropdown or list) and slicer state - Visual selection state (such as cross-highlight filters) - Sort order - Drill location - Visibility of an object (by using the Selection pane) - The focus or Spotlight modes of any visible object
NEW QUESTION # 24
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?
- A. Remove the Subject and Body columns during the import.
- B. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
- C. From Model view, set the Subject and Body columns to Hidden.
Answer: A
Explanation:
Incorrect Answers:
A, C: Does not reduce the size of the model.
NEW QUESTION # 25
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:
Explanation:
Box 1: many-to-one
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
The Suppliers table has a Region column.
Box 2: Suppliers table
NEW QUESTION # 26
You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:
The report will facilitate the following analysis:
* The count of orders and the sum of total sales by Order Date
* The count of customers who placed an order
* The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.
- A. Fillet the data to only the NorthWest region sales territory.
- B. Remove the TaxAmt and Freight columns.
- C. Remove the CustomerKey and ProductKey columns.
- D. Set the data type for SatesOrderNumber to Decimal Number
Answer: A,B
NEW QUESTION # 27
Drag and Drop Question
You have a Power BI semantic model that contains a table.
You need to create a Power BI report page that contains two visuals that meet the following requirements:
- Visual 1: Displays the distribution of hierarchical data
- Visual 2: Search and then filter by values
Which type should you choose for each visual? To answer, drag the appropriate visual types to the correct visuals. Each visual type 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 # 28
You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?
- A. 21318 Lasalle Street
- B. 21319 Lasalle Street
- C. 0
- D. 1
Answer: B
Explanation:
Example:
Replace the text "ur" with the text "or" in the table.
Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
NEW QUESTION # 29
You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:
* Date
* Fiscal year
* Fiscal Quartet
* Month Name
* Calendar Year
* Week Number
* Month Number
* Calendar Quarter
You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?
- A. SUMMARIZE
- B. DATATABLE
- C. ADDCOLUMS
- D. CALCULATE
Answer: A
NEW QUESTION # 30
You import a Power Bl dataset that contains the following tables:
* Date
* Product
* Product Inventory
The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.
The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?
- A. Remove MovementDate.
- B. Change the data type of UnitCost to Integer.
- C. Remove the relationship between Date and Product Inventory.
- D. Change Summarization for DateKey to Don't Summarize.
Answer: A
NEW QUESTION # 31
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 # 32
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 and set the data type of the new column to Date
- B. Create a column by example that starts with 2018-12-31.
- C. 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.
- D. Apply the parse function from the Date transformations options to the Logged column.
Answer: C
NEW QUESTION # 33
You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?
- A. Configure a bi-directional relationship between Region and Sales.Region.
- B. Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.
- C. In the Region table, create a hierarchy that has the manager name, and then the sales manager name.
- D. Apply row-level security (RLS) to the Region table based on the sales manager username.
Answer: C
Explanation:
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
NEW QUESTION # 34
Which DAX expression should you use to get the ending balances in the balance sheet reports?
- A. CALCULATE (
SUM( BalanceSheet [BalanceAmount] ),
LASTDATE( 'Date'[Date] )
) - B. CALCULATE (
SUM( BalanceSheet [BalanceAmount] ),
DATESQTD( 'Date'[Date] )
) - C. FIRSTNONBLANK ( 'Date' [Date]
SUM( BalanceSheet[BalanceAmount] )
) - D. CALCULATE (
MAX( BalanceSheet[BalanceAmount] ),
LASTDATE( 'Date' [Date] )
)
Answer: B
Explanation:
Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.
DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.
rence:
https://docs.microsoft.com/en-us/dax/datesqtd-function-dax
NEW QUESTION # 35
In Power BI Desktop, you are creating a report that will contain three pages.
You need to create a custom tooltip page and prepare the page for use.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. For the tooltip page, configure filters.
- B. For the tooltip page, set Allow use as tooltip to On.
- C. Add and configure visuals on the tooltip page.
- D. Configure filters on the target visual.
- E. For the target page, set Allow use as tooltip to On.
Answer: B,C,D
NEW QUESTION # 36
Hotspot Question
You have two Power BI workspaces named WorkspaceA and WorkspaceB. WorkspaceA contains two datasets named Sales and HR.
You need to provide a user named User1 with access to the WorkspaceB. The solution must meet the following requirements:
- Create reports that use the HR dataset.
- Publish the reports to WorkspaceB.
- Prevent the ability to modify the HR dataset.
- Prevent the ability to add users to Workspaces.
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 # 37
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 # 38
You have a Power BI model that contains the following data.
The Date table relates to the Sales table by using the Date columns.
You need to create a calculated table that v/ill contain the following:
Answer:
Explanation:
Explanation:
NEW QUESTION # 39
You have the line chart shown in the exhibit. (Click the Exhibit tab.)
You need to modify the chart to meet the following requirements:
Identify months that have order counts above the mean.
Display the mean monthly order count.
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
1. Select the line chart
2. Add the average line
3. Turn on Data Label
NEW QUESTION # 40
You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the virtualizations in the dashboard are updated daily.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.
Answer:
Explanation:
1 - Dowload and install an on-premises data gateway(personal).
2 - For each dataset, modify the Gateway Connection settings.
3 - For each dataset, modify the Schedule Refresh settings.
NEW QUESTION # 41
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 new percentile line that uses Total Sales as the measure and 40% as the percentile.
- B. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],.40) - C. Create a horizontal line that has a fixed value of 24,000.
- D. Add a measure to the visual that uses the following DAX expression.
Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
Answer: A
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 # 42
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:
see the explanation for the answer.
Explanation:
Answer as selected
NEW QUESTION # 43
......
Provide Valid Dumps To Help You Prepare For Microsoft Power BI Data Analyst Exam: https://www.prepawayete.com/Microsoft/PL-300-practice-exam-dumps.html
Updated Verified PL-300 dumps Q&As - 100% Pass Guaranteed: https://drive.google.com/open?id=1dhWBOnbG2YuEmsTgqmP4ZDPIDi7HlpaS