PL-300 Exam – Practice 11 Welcome to your PL-300 Exam - Practice 11 Question 1 You have two tables as shown in the exhibit. There are no unique values in either table. The tables are related by the product name.You need to create relationships in the data model to enable visuals to be created that contain data from both tables. How should you model these tables? Create a table that contains unique IDs and create two one-to-many relationships. Set the relationship cardinality to one-to-one between the two tables. Set the relationship cardinality to one-to-many between the two tables. Set the relationship cardinality to many-to-many between the two tables. Question 2 You create a report using the RegionalSales table as shown in the exhibit. You use the PERCENTILEX.EXC function in a measure to calculate the 95% percentile for the Sales column in the RegionalSales table as shown below:Percentile95 = PERCENTILEX.EXC(RegionalSales, RegionalSales[Sales], 0.95)When you add the measure to a line chart visualization, an error is shown with unsupported percentile.You need to resolve the error and show the 95% percentile on the visual. What should you do? Replace the function with the PERCENTILEX.INC function. Use binning and add 20 bins to the value column. Add a forecast to the visualization at 95% confidence level. Replace the function with the PERCENTILE.EXC function. Question 3 You have a very large dataset, and you want to reduce its size. A table called Telemetry contains multiple records per day with the datetime, deviceid, devicetype, readingtype, and readingvalue.You need to produce reports showing average values for devicetype and readingtype. The Telemetry table is set to DirectQuery storage mode. You need to create aggregations for date, devicetype, readingtype, and readingvalue.Which of the following five actions should you perform in sequence? 1. Create a new table named Telemetry_Aggregate containing the columns to hold aggregate data. 2. Select the Telemetry table and select Manage aggregations. 3. Select the Telemetry_Aggregate table as the aggregation table. 4. Select the Summarization type. 5. Select the table and column from the Telemetry table. 1. Select the Telemetry table and select Manage aggregations. 2. Select the Telemetry table as the aggregation table. 3. Select the Telemetry_Aggregate table and select Manage aggregations. 4. Set the storage mode for the Telemetry table to Import. 5. Select the Summarization type. 1. Select the Telemetry table as the aggregation table. 2. Select the Telemetry table and select Manage aggregations. 3. Create a new table named Telemetry_Aggregate containing the columns to hold aggregate data. 4. Set the storage mode for the Telemetry table to Import. 5. Select the Summarization type. 1. Create a new table named Telemetry_Aggregate containing the columns to hold aggregate data. 2. Select the Telemetry table as the aggregation table. 3. Select the Telemetry_Aggregate table as the aggregation table. 4. Select the table and column from the Telemetry table. 5. Select the Summarization type. Question 4 You are modeling sales data as shown in the below exhibit.You need to show the variance of sales for the different product types. You decide to use a Quick measure.How should you configure the Quick measure? Select the correct column names for the Quick Measure setup. Base Value = Order Number Category = Amount Base Value = Amount Category = TypeName Category = Order Number Base Value = TypeName Question 5 You create a Power Bl report for regional sales data.You write a measure to calculate the Percentage of Sales. The measure is calculating the percentages incorrectly as shown in the exhibit named Incorrect below.IncorrectYou need to re-write the measure so that the percentage is correct for each country and region and the total percentage is 100 percent. The measure should calculate the percentages as shown in the below exhibit named Correct. CorrectHow should you re-write the measure? To answer, select the appropriate option from the drop-down menu. Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionaISaIes[Sales]), REMOVEFILTERS() )) Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionaISaIes[Sales]), ALL(RegionalSales[Country]) )) Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionaISaIes[Sales]), ALLSELECTED('RegionalSales'[Region]) )) Question 7 You work for a retail organization that uses Power Bl. The schema for the tables is shown in the below exhibits. The Customer table contains the names and IDs of the customers. The Product table contains the ids and names of the products. When a customer purchases from the retail establishment, a record in the Basket table is created to link the Customer to that purchase. The Products added to their Basket are stored in the Basket Items table.You need to find the number of customers who purchased the same set of products. You add a slicer for Product Name to your report to choose the set of products.How should you create the measure to count the number of customers who purchased the products selected? To answer, select the appropriate option. ProductsSelected = COUNT('Product'[ProductID]) PurchasedSelected = IF(COUNT('Basket Items'[ProductID]) [ProductsSelected], 1, 0) CustomerCount = SUM(VALUES(Customer[CustomerID]), [PurchasedSelected]) ProductsSelected = COUNTX('Product'[ProductID]) PurchasedSelected = SUM(COUNTX('Basket Items'[ProductID]) [ProductsSelected], 1, 0) CustomerCount = SUM(VALUES(Customer[CustomerID]), [PurchasedSelected]) ProductsSelected = DISTINCTCOUNT('Product'[ProductID]) PurchasedSelected = IF(DISTINCTCOUNT('Basket Items'[ProductID]) [ProductsSelected], 1, 0) CustomerCount = SUMX(VALUES(Customer[CustomerID]), [PurchasedSelected]) ProductsSelected = COUNTX('Product'[ProductID]) PurchasedSelected = SUMX(COUNTX('Basket Items'[ProductID]) [ProductsSelected], 1, 0) CustomerCount = IF(VALUES(Customer[CustomerID]), [PurchasedSelected]) Question 8 You import a table into Power BI. The schema is shown in the below exhibit.You need to configure the columns in the table.Which Summarize option should you recommend for aggregating the columns for use in visualizations? Amount: Sum Order Number: Average DateKey: Count Amount: Sum Order Number: Count DateKey: None Amount: Sum Order Number: Sum DateKey: Average Amount: None Order Number: Count DateKey: Average Question 9 You have tables named Employee and Salary, as shown in the below exhibit. You have a slicer that filters employees based on Salary range. You have another slicer that filters employees based on Company.A visualization that shows employees along with salaries is not showing the correct values. You need the Company slicer to show only values within the range of the Salary slicer. You need to fix the relationship between the Employee and Salary tables.Which two actions should you perform? Each correct answer presents part of the solution. Set the cross filter direction to single. Set the cross filter direction to both. Set cardinality to one-to-many from the Employee table to the Salary table. Select Apply security filter in both directions. Question 10 You need to create time-series visualizations based on the dates in the table shown in the below exhibit. Orders are received during the working week and are typically shipped within a week.You need to define a date table to support visualizations. For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. A date table must have a column with the Date data type.2. You can mark the table named Sales as a date table.3. You can create two date tables, one for order date and one for ship date, and mark both as date tables. 1. Yes 2. Yes 3. No 1. No 2. No 3. No 1. Yes 2. Yes 3. Yes 1. Yes 2. No 3. No 1. Yes 2. No 3. Yes 1. No 2. Yes 3. No Question 11 You create a data model and report in Power Bl desktop. The data model contains multiple tables, many relationships, and a set of measures.Users report poor performance when using your report.How can you identify the source of the performance issues? use the Performance analyzer. use the ALM Toolkit. use the Tabular Editor. use the DAX Studio tool. Question 12 You create reports using the data model shown in the below exhibit. You have the following measure that is performing poorly The measure calculates the change in sales each year.SalesChangeYoY = IF(SUM(Sales[Amount]), DIVIDE([SumofSales] – CALCULATE([SumofSales], SAMEPERIODLASTYEAR(Sales[Date])), CALCULATE([SumofSales], SAMEPERIODLASTYEAR(Sales[Date]))))You need to improve the performance of the measure. What should you do? Change the cardinality of both relationships to many-to-many Create a calculated column containing the sales amount for the previous year Change the cross filter directions on both relationships to Both Rewrite the measures using DAX variables Question 13 You have a table named Sales. You need to create a measure that calculates sales from the previous year based on a dynamic period, as shown in the below exhibit. Which two DAX expressions can you use to achieve your goal? Each correct answer presents a complete solution. _PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD('Calendar'[Date].[Date], -1, MONTH)) _PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD('Calendar'[Date].[Date], -1, YEAR)) _PY Sales = CALCULATE(SUM(Sales[Sales]), PARALLELPERIOD('Calendar'[Date], -1, YEAR)) _PY Sales = CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR('Calendar'[Date])) Question 14 You have a Product table and a Sales table that are connected through a one-to-many relationship using the ProductName column, as shown in the exhibit. You need to optimize model performance. Which two actions should you perform? Each correct answer presents part of the solution. Create a new one-to-many relationship between the Sales and Product tables using the ProductlD column. Create a new one-to-many relationship between the Product and Sales tables using the ProductlD column. Change the data type of the ProductName column from text to whole number in the Product table. Remove the existing relationship based on the ProductName column between the Product and Sales tables. Question 15 You load sales data into Power BI. Your organization uses many different terms for sales data such as revenue, net sales, and total sales.You need to configure the Sales table and its columns for users to successfully use the Q&A feature in Dashboards.Solution: Mark the Sales table as the date table. Does this solution meet the goal? Yes No Question 16 You create a report to help sales users understand their data. You need to use the appropriate type of visualization for each of the requirements of the sales team.Which visualizations should you use for each requirement stated below:Identify outliers in customers with sales opportunities. Scatter Waterfall Treemap Card Key influencers KPI Question 17 Which of the following visuals is not included as part of Power Bl and must be added as a custom visual? Stacked Area Histogram Donut Waterfall Question 18 You create multiple Power Bl dashboards. You define the data classifications and tags.You need to show users how the data in the dashboards is classified.For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. Data classifications are defined at the tenant level.2. Access to dashboards with data classification configured is controlled by Azure Active Directory (AD) security groups.3. The data classification for a dashboard is always displayed. 1. Yes 2. No 3. No 1. Yes 2. Yes 3. Yes 1. No 2. No 3. Yes 1. Yes 2. No 3. Yes 1. No 2. Yes 3. Yes 1. No 2. No 3. No Question 19 You create the stacked column chart shown in the below exhibit. When you hover over a data point in the visual you need to also show the value of goods sold, Total sales.What are two possible ways to achieve this goal? Each correct answer presents a complete solution. Enable Total labels on the visual Add Total sales to Drill through on the visual Enable Data labels on the visual Add Total sales to Tooltips on the visual Create a report tooltip page with a card visual for Total sales Question 20 After you have pinned a report visual to create a dashboard tile, you can later modify the visual’s properties and the Power Bl service will automatically update the dashboard tile with the new visual property values. Correct Incorrect Question 21 You have two dashboards in the same workspace named Production and Manufacturing. Your company Power Bl administrator creates the following two dashboard data classifications:• Medium Impact (MEDI) as default.• High Impact (HIGH).You need to use the newly created classifications in the dashboards. The Production dashboard should be classified as Medium Impact. The Manufacturing dashboard should be classified as High Impact.Which two actions should you perform? Each correct answer presents part of the solution. Set Data classification as Medium Impact. Go to Production dashboard > settings. Go to Manufacturing dashboard > settings. Set Data classification as High Impact. Question 22 To create a column chart that displays Quantity by Color and can be drilled down to show Quantity by Stock Item.Which of the following solves the problem? More than one answer can be correct. Put Color on Axis and Stock Item on Tooltips Put Color and Stock Item on the axis Put Color on axis and Stock Item on legend Create a Stock Item hierarchy that includes Color and Stock Item and use the hierarchy on axis. Question 23 You create a report page and pin the page to a dashboard in the Power BI service. You receive many enquiries from users asking you about the data and requesting additional visuals on the dashboard.You need to enable the Q&A feature that appears as “Ask a Question about your data” at the top of the dashboard above the visuals.How should you enable this feature?Solution: Add Q&A button on the report page.Does this solution meet the goal? Yes No Question 24 You create Power Bl reports and dashboards.Your company has standard corporate colors and fonts that must be used on reports and dashboards. There is a set list of colors for data in visuals. The colors are shades of red, crimson, and maroon. All tiles should have a background color of light blue. Your company also wants to use different pictures for report and dashboard backgrounds at special times during the year, such as holidays and the end of the company’s financial year.You need to customize themes to meet these requirements.Which theme should you use for the following requirement?“Set the tile background color” Dashboard or report theme Dashboard theme Report theme Question 25 You have Power Bl Premium with assigned capacity. You have a dataset containing employee key performance indicators (KPls).You create a Power Bl report with a visual that shows employees with low scoring KPls. You pin the visual to a dashboard and share the dashboard with users in Human Resources (HR).HR users need to be able to generate a list of employees to investigate for poor performance and import that list into their HR system.What should you do? Configure Cloud App Security. Grant HR users the Reshare permission on the dataset. Grant HR users Build permission on the dataset. Apply a sensitivity label in the dashboard settings. Question 26 What happens when you click on Focus mode of a tile in Power Bl dashboard? The tile you selected expands and takes the full space The Power Bl desktop file opens. The Power Bl desktop file gets downloaded The report from which the tile was pinned opens. Question 27 You create a report to help sales users understand their data. You need to use the appropriate type of visualization for each of the requirements of the sales team.Which visualizations should you use for each requirement stated below:Show the factors that affect the outcome of sales opportunities. Waterfall Treemap KPI Key influencers Scatter Card Question 28 You create a Power Bl report to help users understand their data. You need to use the appropriate type of visualization for each of the requirements.Which visualizations should you use for the below-stated requirement?“Take actions from within a report” Power Apps Python D3 R Question 29 You import a set of financial data and create a measure to show the percentage change since the previous quarter.You need to format a visualization to match the one shown in the exhibit. The graduated color is determined by the percentage change since the previous quarter.How should you configure the visual? Select the appropriate option for the two process steps. Format by: Rules Conditional formatting: Icons Format by: Field value Conditional formatting: Data bars Conditional formatting: Font color Conditional formatting: Background color Format by: Color scale Question 30 You create a Power Bl report containing a corrplot R visual for a dataset that has 1 million rows of sales data. You publish the report to the Power Bl service. Users can only see some of the sales data and an error is displayed.You need to identify the root cause of this issue. What is preventing all the data from be displayed? The visual has too many rows. The data rows are unique. The report has been published in an app. Corrplot is not supported in Powerbi.com. Question 31 You create several Power Bl report pages.You need to make the report pages more interactive for users.To answer, drag the appropriate Power Bl feature for the stated requirement.“Create a view of a report page with the filters applied” Bookmarks Buttons Comments Selection pane Question 32 You create Power Bl reports and dashboards.Your company has standard corporate colors and fonts that must be used on reports and dashboards. There is a set list of colors for data in visuals. The colors are shades of red, crimson, and maroon. All tiles should have a background color of light blue. Your company also wants to use different pictures for report and dashboard backgrounds at special times during the year, such as holidays and the end of the company’s financial year.You need to customize themes to meet these requirements.Which theme should you use for the following requirement?“Set the colors for data in visuals” Dashboard or report theme Report theme Dashboard theme Question 33 You work for a multinational company as a data analyst.You create a Power Bl report for your company. The report has three pages containing visualizations of sales data. You need to filter the visuals for all three report pages whenever a country is selected.What are two possible ways to achieve this goal? Each correct answer presents a complete solution. Create a bookmark for each page and for each country. Add a page level filter to each of the three pages using Country as the data field. Add a report level filter using Country as the data field. Add a slicer to each of the three pages with Country as the field and configure Sync slicers. Create a visual for Country and set the interaction behavior for each of the other visuals Question 34 You have a matrix visual that shows Sales % and Sales by Product Line as shown in the exhibit.The Sales % measure shows as a percentage the contribution of sales in that product line for overall sales. You need to add a background color to the Sales measure as follows:When the Sales % contribution is >= 15 and <=17 percent, highlight it in light yellow.What should you do to configure conditional formatting? To answer, select the appropriate options for each of the blank field. is greater than or equal to 0.15 Number Based on field > Sales Format by > Color Scale Based on field > Sales % Format by > Rules is less than or equal to 0.17 Number Question 35 You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.How should you configure the home page to allow users to navigate to the report pages?Solution:• Create a bookmark for each report page.• Add four buttons to the home page and set action type to Bookmark.• On each button, select the bookmark for the page.Does this solution meet the goal? Yes No Question 36 You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.How should you configure the home page to allow users to navigate to the report pages?Solution:• Set Include in app to Yes for the report.• Create a Power BI app.• Enable navigation builder.• Include the report in the navigation.• Publish the app.Does this solution meet the goal? Yes No Question 37 You create the report page shown in the below exhibit. You need to configure the interactions of the visuals.For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. To make the Sales by Product visual show the portion of the segment selected in the Pie chart, you should select the Sales by Product visual and edit the interactions on the Sales by Segment chart.2. To not filter the Sales by Segment chart when a column in the Sales by Product visual is clicked, you should set the interaction behavior to None.3. To focus on the proportion of Sales by Product for a selected segment, you should set the interaction behavior to Filter. 1. Yes 2. Yes 3. No 1. Yes 2. No 3. No 1. Yes 2. Yes 3. Yes 1. No 2. Yes 3. Yes 1. No 2. No 3. Yes 1. No 2. Yes 3. No Question 38 Which page view types are available in Power Bl Report View? Choose the correct answers. Fit to Width Fit to page Full Screen Actual Size Question 39 You create a report to help sales users understand their data. You need to use the appropriate type of visualization for each of the requirements of the sales team.Which visualizations should you use for each requirement stated below:Show progress of sales opportunities won against target. Scatter Key influencers Card KPI Waterfall Treemap Question 40 You create a report page and pin the page to a dashboard in the Power BI service. You receive many enquiries from users asking you about the data and requesting additional visuals on the dashboard.You need to enable the Q&A feature that appears as “Ask a Question about your data” at the top of the dashboard above the visuals.How should you enable this feature?Solution: Enable the Q&A option in Page information on the report page.Does this solution meet the goal? Yes No Question 41 You have a dashboard in Power Bl that has visuals created from data in the Common Data Service. The dashboard contains a KPI visual.You need to automate the notification of alerts when the KPI value exceeds a threshold. Which two options are available when configuring an alert in Power Bl service? Each correct answer presents a complete solution. Push a notification to a mobile device Send an email Call a webhook Run a Power Automate flow Question 42 Which fields are available when creating a Pie chart visualization? Group Value Details Legend Question 43 You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.How should you configure the home page to allow users to navigate to the report pages?Solution:• Add four images to the home page and set action type to Page navigation.• Select the destination page for each image.Does this solution meet the goal? Yes No Question 44 You create a report in Power Bl.You need to configure the page for use with screen reader software for partially sighted users.What should you configure on the report page so that the screen reader follows a logical sequence? Tab order Focus mode Layer order Bookmark groups Question 45 You create Power Bl reports and dashboards.Your company has standard corporate colors and fonts that must be used on reports and dashboards. There is a set list of colors for data in visuals. The colors are shades of red, crimson, and maroon. All tiles should have a background color of light blue. Your company also wants to use different pictures for report and dashboard backgrounds at special times during the year, such as holidays and the end of the company’s financial year.You need to customize themes to meet these requirements.Which theme should you use for the following requirement?“Set the background image” Report theme Dashboard theme Dashboard or report theme Question 46 Which properties of a tile can be edited in the Power Bl dashboard from the Tile details window? Choose the correct answers. Subtitle Color scheme Title Destination link Question 47 By default, which filter level behaves the same as a slicer in a report in Power BI Desktop? Report level filter Visual level filter Page level filter Query level filter Question 48 What is the specific name for visualizations added to a dashboard as displayed below? Reports Datasets Tile Bar charts Question 49 You create a Power Bl report.You need to improve report navigation.Which options should you use for the stated task?“Preserve visual selection of a specific report page” Buttons Bookmarks Question 50 You create a dashboard in Power Bl with several visuals.You need to explain how the dashboard will appear on a mobile device using the Power Bl app. For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. By default, in the Power Bl mobile, all tiles on a dashboard appear with the same size in a vertical list.2. Enabling Dashboard tile flow causes the tiles to be displayed on a mobile device as they are on a web browser.3. Creating a Phone view of a dashboard, allows you to resize and rearrange the visuals for the Power Bl mobile app. 1. No 2. Yes 3. Yes 1. Yes 2. Yes 3. No 1. Yes 2. No 3. Yes 1. No 2. No 3. Yes 1. Yes 2. Yes 3. Yes 1. No 2. No 3. No Question 51 You create several Power Bl report pages.You need to make the report pages more interactive for users.To answer, drag the appropriate Power Bl feature for the stated requirement.“Show and hide visuals on a report page” Bookmarks Comments Selection pane Buttons Question 52 You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.How should you configure the home page to allow users to navigate to the report pages?Solution:• Add four buttons to the home page and set action type to Page navigation.• Select the destination page for each button.Does this solution meet the goal? Yes No Question 53 You create a Power Bl report.You need to improve report navigation.Which options should you use for the stated task?“Add report navigation, so users can directly go to a specific report page” Buttons Bookmarks Question 54 You have a report page named Sales which contains visual A, showing total sales for each city for the selected year, as shown in the below exhibit. You need to configure an interaction for this visual. When clicking Drill through, it should redirect to a detail page that shows Sales for the selected city by Product Line and will preserve all the filters from the Sales page.Which four actions should you perform? Each correct answer presents part of the solution. On the Sales page, under the drill through option, set Keep all filters to On. On the Sales page, under the drill through option, add City column as the drill through field. Create a new page named Detail. On the Detail page, under the drill through option, set Keep all filters to On. Create a table visual named Visual B to show total sales by city and product line. On the Detail page, under the drill through option, add City column as the drill through field. Question 55 You create a Power Bl report. The report has multiple pages with many visuals.Users need to be able to view this report on their mobile devices.You need to optimize the report for use on mobile devices.Which two optimizations can you perform? Each correct answer presents a complete solution. Set slicers to be responsive. Set the page size. Remove data labels. Select and resize the visuals. Apply a report theme. Question 56 You need to configure data alerts for a dashboard.Which three visuals can be configured for data alerts? Each correct answer presents a complete solution. Gauge visual KPI visual Matrix visual Card visual Line visual Question 57 You create a report page in Power BI.You need to create a dashboard that will be simultaneously updated whenever the report page is updated.What should you do? Pin the report to a new dashboard as a live page. Enable Persistent filters in report settings. Create a new dashboard and pin each of the visuals from the report page as individual tiles. Enable Dashboard tile flow in dashboard settings. Question 58 You create a Power Bl report to help users understand their data. You need to use the appropriate type of visualization for each of the requirements.Which visualizations should you use for the below-stated requirement?“Use scikit learn machine learning in visuals” Python R Power Apps D3 Question 59 What is the file format used to define a theme for a Power Bl report? Power BI Markup Language (PBIML) Cascading Style Sheets (CCS) JavaScript Object Notation (JSON) Extensible Markup Language (XML) Question 60 You create a Power Bl report to help users understand their data. You need to use the appropriate type of visualization for each of the requirements.Which visualizations should you use for the below-stated requirement?“Use JavaScript to create visuals” Power Apps Python D3 R Question 61 You create a report in Power Bl Desktop containing many visualizations.You need to apply the fonts and colors to match your corporate standards. What should you do? Customize the theme. Set the Data colors on each visualization. Set the font family on the page display settings. Change the font on each visualization. Question 62 You have a dashboard tile that shows the manufacturing effciency using a card visual. The manufacturing effciency measure is formatted as a percentage. Your company requires a notification to be sent when effciency drops below 70 percent.You need to configure email alerts to meet this requirement.Which four actions should you perform? Each correct answer presents part of the solution. Check the Send me email too checkbox and click Save and close. Click the Save and close button. Click the + Add alert rule button. Choose Below in the Condition field and set the Threshold value to 0.7. Choose Below in the Condition field and set the Threshold value to 70. Choose More options on the Manufacturing efficiency card visual and click on Manage alerts. Question 63 You work on the new filter pane experience for a Power Bl report.What can you achieve by using the new filter pane experience?For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. Hide specific filters from report consumers.2. Lock specific filters so report consumers cannot edit them.3. Disable the search for the Filters pane. 1. Yes 2. Yes 3. No 1. No 2. No 3. No 1. Yes 2. No 3. No 1. Yes 2. Yes 3. Yes 1. No 2. Yes 3. No 1. No 2. Yes 3. Yes Question 64 Months are sorted alphabetically in Stacked bar chart. What can you do to sort it by month number? Right Click on field in report view and select sort by, then select MonthNumber Click on ellipses on Right Top Corner of visual > Sort by - MonthNumber Modeling > Select Month Column > Sort By - MonthNumber Question 65 Using the bookmarking features in the report designer in Power BI Desktop, there is a limitation of creating only one bookmark per page in a report.Is this statement correct? Yes No Time's up Trần Quân PL-300 Exam – Practice 10 PL-300 Exam – Practice 12