2024 Latest PL-300 dumps Exam Material with 375 Questions
Microsoft PL-300 Questions and Answers Guarantee you Oass the Test Easily
NEW QUESTION # 79
You have a Power Bi report. The report contains a visual that snows gross sales by date The visual has 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 Legend field well
- B. Increase the Expected range transparency setting,
- C. Increase the Sensitivity setting.
- D. Add a data field to the Secondary values field weft
Answer: C
Explanation:
If you increase the sensitivity, the algorithm is more sensitive to changes in your data. In that case, even a slight deviation is marked as an anomaly. If you decrease the sensitivity, the algorithm is more selective on what it considers an anomaly. reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection
NEW QUESTION # 80
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:
See the answer as below in explanation.
Explanation:
Answer as below
NEW QUESTION # 81
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?
- A. Create a data alert.
- B. Share the dashboard to the user.
- C. Create a subscription.
- D. Tag the user in a comment.
Answer: C
Explanation:
You can subscribe yourself and your colleagues to the report pages, dashboards, and paginated reports that matter most to you. Power BI e-mail subscriptions allow you to:
Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or once a day after the initial data refresh.
Choose the time you want to receive the email, if you choose daily, weekly, hourly, or monthly.
Note: Email subscriptions don't support most custom visuals. The one exception is those custom visuals that have been certified.
Email subscriptions don't support R-powered custom visuals at this time.
Incorrect Answers:
A: Set data alerts to notify you when data in your dashboards changes beyond limits you set.
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
NEW QUESTION # 82
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 GUID and IoT ID columns are unique to each row in query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You split the loT DateTime column into a column named Date and a column named Time.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 83
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.
Measure - PERCENTUEX.EXC (Sales,Sales[Total Sales],40) - B. Add a measure to the visual that uses the following DAX expression.Measure = 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 # 84
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. Set the data type for SatesOrderNumber to Decimal Number
- B. Remove the CustomerKey and ProductKey columns.
- C. Fillet the data to only the NorthWest region sales territory.
- D. Remove the TaxAmt and Freight columns.
Answer: C,D
NEW QUESTION # 85
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 # 86
A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
The managers must only see the data of their respective country.
The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.
- B. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
- C. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
- D. Create one role for each country.
- E. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
Answer: B,C
Explanation:
In Power BI Service the username and userprincipalname both return the email address, it's only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service. See https://community.powerbi.com/t5/Community-Blog
/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-Power-BI-Embedded/ba-p/1867670 for more information.
NEW QUESTION # 87
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:
Explanation
NEW QUESTION # 88
You have a Power B1 report that contains the table visual shown in the following exhibit.
You need to modify the visual to display as shown in the following exhibit.
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:
NEW QUESTION # 89
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 # 90
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
Access a published Power BI app
Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? 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/service-create-distribute-apps
https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace
NEW QUESTION # 91
You have the Power Bl data model shown in the following exhibit.
You need to create a measure to count the number of product categories that had products sold during a selected period. 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:
NEW QUESTION # 92
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.
You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a report-level filter that filters based on the order date.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
The filter is applied after the data is imported.
Instead add a WHERE clause to the SQL statement.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
NEW QUESTION # 93
Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.
You need to shape the query to display the following three columns:
* Month
* Sales
* Year
'What should you select in Power Query Editor?
- A. Unpivot columns.
- B. Transpose
- C. Pivot column
- D. Merge columns
Answer: A
Explanation:
This will convert your column headers (Jan-20, Feb-20,...) into row values under a new column called Attribute. You can then rename this column as Month and change its data type to Date. You will also have a new column called Value that contains the sales amounts for each month. You can rename this column as Sales and change its data type to Decimal Number.
NEW QUESTION # 94
You have a sales system that contains the tables shown in the following table.
The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?
- A. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DateID]))
- B. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]))
- C. (SUM('Sales'[sales_amount]) - CALCULATE(SUM('Sales'[sales_amount]),
SAMEPERIODLASTYEAR('Date'[DateID])))
/ CALCULATE(SUM('Sales'[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])) - D. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
SAMEPERIODLASTYEAR('Date'[DateID])
Answer: C
Explanation:
SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.
Reference:
https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
NEW QUESTION # 95
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 # 96
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 # 97
You have a Power BI model that has the following tables:
Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, text Description automatically generated
NEW QUESTION # 98
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 # 99
You have a semantic model that has the permissions shown in the following exhibit.
Use the drop-down menus to select the answer choice the 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 # 100
......
Microsoft PL-300 exam evaluates the ability to design and create Power BI reports, dashboards, and visualizations. PL-300 exam also covers data analysis, data modeling, and data transformation using Power Query. Candidates will be tested on their knowledge of Power BI architecture, security, and administration. PL-300 exam also emphasizes the importance of collaboration and sharing insights with stakeholders and colleagues.
Share Latest PL-300 DUMP Questions and Answers: https://www.braindumpspass.com/Microsoft/PL-300-practice-exam-dumps.html
PDF Dumps 2024 Exam Questions with Practice Test: https://drive.google.com/open?id=1cqKc6zT4gdavxomBwLH0sQa8CmWmiKoO
