PL-300 Exam – Practice 5 Welcome to your PL-300 Exam - Practice 5 Question 1 You have the below relationship between sales, product and employees. The employees table is joined to the product table by category’, and the product table is joined to the sales table by ‘ProductKey.’Your boss asks you to build a visual for each Manager’s sales by Subcategory.What do you need to configure to solve that problem? Create a hierarchy in the product table for subcategory In the employees table, change EmployeeID to type text Set the cross-filter between product and employees to both In the Model view, change the product table’s toggle ‘is hidden’ to True Question 2 You want to create a hierarchy in the products table for Category and Subcategory. You will then use the hierarchy as a drill down for a sales by product visualization as per the below exhibit.What three actions should you perform in sequence? Right click on Category and select New Measure’ -> Right click on Subcategory and select Add to hierarchy’ -> In the visual add the hierarchy in the Axis and sales to the Values well Right click on Category and select ‘Create hierarchy’ -> Add Subcategory to the drill through fields -> In the visual add the hierarchy in the Axis and sales to the Values well Right click on Category and select ‘Create hierarchy’ -> Right click on Subcategory and select ‘Add to hierarchy’ -> In the visual add the category field to the Axis, which will automatically link the hierarchy Right click on Category and select ‘Create hierarchy’ -> Right click on Subcategory and select ‘Add to hierarchy’ -> In the visual add the hierarchy in the Axis and sales to the Values well Question 3 You need to create a table containing unique combinations of category and subcategory and aggregated sales.What DAX expression should you use? DATATABLE(‘sales‘,‘product‘[Category],‘product‘[Subcategory],“Sales Total“,SUM(sales[Sales Amount])) SUMMARIZECOLUMNS(‘product‘[Category],‘product‘[Subcategory],sales[Sales Amount]) SUMMARIZE(‘sales‘,‘product‘[Category],‘product‘[Subcategory],“Sales Total“,SUM(sales[Sales Amount])) SELECTCOLUMNS(‘sales‘,‘product‘[Category],‘product‘[Subcategory],sales[Sales Amount]) Question 4 You work as a Power BI professional within your company’s HR group. You are creating a data model to use for reporting within the group. As you start building relationships, you see there are issues connecting some of the tables.What two fixes are required to get the relationships working in your data model? Change the data type of Employees[PayID] and hide Employees[Relocation] and Employees[HR Manager] fields Change the data type of Employees[PayID] and BU[BUID] to Whole Number Ensure the cardinality between BU and Employees from Many to one (*:1) to Many to many (*:*) Change the data type of Employees[PayID] and BU[BUID] to Text Question 5 You work as a Power BI professional within your company’s HR group. The report you created for retention analysis worked fine in the development environment, but when deployed has performance issues.Solution: Remove columns from the data model not used in reportsDoes this solution meet the goal? Yes No Question 6 You work as a Power BI professional within your company’s HR group. The report you created for retention analysis worked fine in the development environment, but when deployed has performance issues.Solution: Hide columns and tables from the data model not used in reportsDoes this solution meet the goal? Yes No Question 7 You find an interesting visualization using the Python programming language that you want to run in Power BI.What are the three steps required before you can use Python in Power BI? Install Python on your local machine Enable R scripting Install the libraries matplotlib and pandas Enable Python scripting Install the libraries seaborn and keras Question 8 You are asked to optimize the performance of your data model. You have several intermediate queries that are not used for visualization and you have a large transactional table with a Date/Time field.What two optimizations should you do? Change all relationship cross filter directions to single Split the Date/Time field into a separate Date column and a separate Time column Turn off single select on slicers Disable Power Query load on intermediary queries Question 9 You receive a new table to incorporate into your analysis in Power BI. You use Power Query to preview the data.For each of the following statements, select Yes if the statement is true. Otherwise, select No. Yes / Yes / Yes No / Yes / Yes No / Yes / No No / No / Yes Question 10 You are the Power BI administrator at your company which builds VR headsets. You need to assign appropriate workspace roles to your colleagues and must use the lowest permission necessary to accomplish the task.Which roles should you use for the below workspace requirements?1. Update and delete workspaces2. Publish apps3. Publish content to the workspace Member / Member / Contributor Member / Member / Viewer Admin / Member / Contributor Admin / Admin / Contributor Question 11 You have a table of temperatures for various cities. Some cities use Fahrenheit, while others use Celsius. You need to write a DAX expression to create a new column called Category for the following conditions.· If the value is greater than 80 and Units are F, then Hot’. Otherwise Not Hot’· If the value is greater than 26 and Units are C, then Hot’. Otherwise Not Hot’Complete the below DAX expression by replacing [VALUE]:Category =[VALUE] ( [VALUE] ( [VALUE] (Temperature[Value] > 80,Temperature[Units]=“F“), [VALUE] (Temperature[Value] > 26,Temperature[Units]=“C“) ),“Hot“,“Not Hot“) SWITCH / AND / OR / AND SWITCH / OR / OR / AND IF / OR / AND / AND IF / AND / OR / AND WHILE / AND / OR / AND Question 12 Your boss has scrolled through the Theme Gallery on the website https://community.powerbi.com/.She asks you to use a particular theme for your company’s report in Power BI Service.How do you incorporate the theme in your report? Download the JSON file and in Custom Dashboard theme > Upload JSON theme Download the CSS file and in Custom Dashboard theme > Upload CSS theme Download the PNG file and right-click on a tile > Upload PNG theme Download the PDF file and right-click on the dashboard > Upload PDF theme Question 13 You are your company’s Power BI expert. You know that data lineage shows you which data sources are used by which datasets. One of your colleagues says he cannot access data lineage.What could be two possible explanations for data lineage not working? Only admins can see the lineage view You need a Power BI Pro license to see lineage view Lineage only works for DirectQuery datasets Lineage view is available only to users with higher than Viewer access to the workspace Each user needs to be granted lineage view permission in the tenant settings Question 14 You have a data set that shows employees and their bosses, as per the exhibit below. There is a field for each Employee called Employee_Name and a field for their boss Parent_Employee_Name.How would you create the Employee_Hierarchy column with a delimited hierarchy list in DAX? PATHITEM(employees[Employee_Name], employees[Parent_Employee_Name]) RELATED(employees[Parent_Employee_Name], employees[Employee_Name]) CONCATENATE(employees[Parent_Employee_Name], employees[Employee_Name]) PATH(employees[Employee_Name], employees[Parent_Employee_Name]) Question 15 You work for a computer accessories company and your data model contains the following tables:1. Accessories table: 1k rows that are updated monthly2. Sales table: 15M rows that are updated regularly with changes that need to be shown immediately3. Date table: 10k rows that are updated rarelyFor the three tables ABOVE, which storage mode should you use from the below options?· Import· DirectQuery· Dual Accessories: Import / Sales: DirectQuery / Date: Dual Accessories: Import / Sales: DirectQuery / Date: Import Accessories: DirectQuery / Sales: Import / Date: DirectQuery Accessories: Dual / Sales: Import / Date: DirectQuery Question 16 You work for a consulting company that has a contract with a large government department. Part of the requirements for the report is to configure the page for use with a screen reader for sight-impaired users.What should you configure in your report such that the page follows a logical sequence? Bookmarks Tab order Filters on all pages Layer order Question 17 You work at a sports betting company and have a table with US soccer scores and a second table with betting odds. Both tables share a common key called GameID. Your boss asks you to create a new combined table.Which transform should you use to create the dataset? Append queries as new Append queries Merge queries as new Merge queries Question 18 You work for a transportation company that uses Azure IoT devices to monitor the temperature within containers. The head of Supply Chain has asked you to create a dashboard for the streaming data from the IoT devices and you need to configure Power BI appropriately.For each of the following statements, select Yes is the statement is true. Otherwise, select No. No / Yes / No Yes / Yes / No No / No / Yes No / No / No Question 19 You are part of a planning team and are investigating the forecast accuracy across multiple plants, various products and a series of demand types (e.g. stable, seasonal, growing etc.) You use Power BI and know that there is a visual that can help you with the root cause of low forecast accuracy.Which visual should you choose? Waterfall Treemap Key influencers Decomposition tree Question 20 You work for a baseball hat retailer and you need to create a table of the top 3 team names by the total number of transactions. You have a table called Hat Sales and another for Team.Select the proper DAX functions to correctly complete the formula by replacing the [VALUE] field:Top Hat Sales = [VALUE] ( 3,[VALUE] ( HatSales, HatTeams[Team Name], “Transactions“, COUNT(HatSales[TransactionID])), [Transactions],DESC) RANKX - CALCULATE TOPN - CALCULATE FILTER - SUMMARIZE TOPN - SUMMARIZE Question 21 You import a large table from Excel into Power BI and you suspect there may be missing data.How would you find the percentage of empty cells in each column? Column quality Column profile Show whitespace Column distribution Question 22 You work for a shoe distribution company and your firm uses Power BI for reporting. One of the reports you have created is exported as a PDF so the warehouse staff can check off items on a hard copy. Your company, however, has a policy that all exported reports need to be encrypted.How can you meet this requirement? Use Row Level Security (RLS) Set the PDF options in the tenant settings Configure the dataset build permission security options Use sensitivity labels Question 23 You work for a share trading software company and have a dashboard for user trading times. The data set used for the analysis goes back seven years.When the data reloads, it takes excessive time as the full seven years are refreshed.How can you improve the dataset performance? Use an on-premises data gateway Configure incremental refresh in Power BI Desktop and enable it in Power BI service Enable incremental refresh directly in Power BI service Manually refresh the database when users are not active Question 24 You are in Power Query Editor and you see the below highlighted in the red box.What data preview option is used to create these charts? Monspaced Column distribution Column quality Column profile Question 25 You have a data model with two key tables: Region and Shipping. There is a one-to-many relationship between the Region and the Shipping table. The model also has two row-level security roles named Region_Texas and Shipping_Mode The DAX filters for the two security roles are:· Region_Texas filter is: Region[state] = “Texas”· Shipping_Mode filter is: Shipping[mode] = “Rail”If a manager is a member of both the Region_Texas and Shipping_Mode roles, what will they see in a report using this data model? The user will only see data for the state of Texas The user will only see data for the rail shipping mode The user will see data for which the state is Texas AND the shipping model is rail The user will see data for which the state is Texas OR the shipping mode is rail Question 26 You create an R visual in Power BI that has 500,000 rows. You notice that not all the data is shown and a message is displayed on the image.Your boss asks you the cause of this issue.What is the reason not all data is shown? You are using a version prior to 2.0 of the plotly library You are missing an R package The visual has too many rows The resolution is too high Question 27 You have one report page with multiple visuals that is running slow, leading to complaints from users.What TWO solutions will help optimize your visuals? Don’t use multiple colors on bar charts Apply filters to reduce the max number of items that a visual displays Replace the default visuals with custom visuals Limit the use of bar charts Limit the number of visuals on a particular report page to only what is necessary Question 28 You are asked to create a category percentage measure that will reflect the values selected when using a slicer. In the output below, you will see that the Bikes category is not selected in the slicer and the category percentage reflects the current filter context. All category percentage values add to 100% of the filter context.You are given a measure that sums the sales called Sales Total.How would you create a category percentage measure in DAX? VAR categoryTotal = CALCULATE([Sales Total],ALL(‘product‘[Category])) VAR categoryPercentage = DIVIDE([Sales Total],categoryTotal) RETURN categoryPercentage VAR categoryTotal = [Sales Total] VAR categoryPercentage = DIVIDE([Sales Total],categoryTotal) RETURN categoryPercentage VAR categoryTotal = CALCULATE([Sales Total],ALLSELECTED(‘product‘[Category])) VAR categoryPercentage = DIVIDE([Sales Total],categoryTotal) RETURN categoryPercentage VAR categoryTotal = CALCULATE([Sales Total],REMOVEFILTERS(‘product‘[Category])) VAR categoryPercentage = DIVIDE([Sales Total],categoryTotal) RETURN categoryPercentage Question 29 You work for a Japanese auto company whose fiscal year starts April 1. You have a table called Cars with orders for cars.You need to create a common date for a data model using DAX, respecting the fiscal period.How should you create a date table using DAX? CALENDAR(4) CALANDAR( DATE ( 2000,3,1), DATE ( YEAR ( LASTDATE ( Cars[OrderDate] ) ), 31, 3 )) CALANDAR( DATE ( YEAR ( FIRSTDATE ( Cars[OrderDate] ),4,1), DATE ( 2025, 12, 31 )) CALENDARAUTO(3) Question 30 You work in the spare parts department of an oil and gas company as a BI expert. The company has hundreds of parts, ten years of historic data, and hundreds of different order sizes from suppliers. You create a report in Power BI with aggregations for the following visuals:· A column chart of parts on the axis, but there are too many products showing· A stacked column chart of month number and order type, but too many months show· A histogram of supplier order sizes, but there are too many order sizesYou need to combine the data to make the visual more readable.How should you combine the data? Select the GROUPING TYPE for each of the THREE solutions below from top to bottom.1. Combined the product into categories of product2. Combine the columns into 3 month number blocks3. Combine order sizes into 8 groups LIST / BIN / LIST LIST / BIN / BIN BIN / LIST / LIST BIN / LIST / BIN Question 31 You are analyzing basketball total points for the NBA for the year 2021. You have a measure [Points Total] which sums up the points and a date table with a year column. How should you complete the below DAX formula to effectively use it independently from any other filters set on the report page? Select the appropriate DAX function in place of [VALUE].Sales 2021 =CALCULATE([Points Total],FILTER( [VALUE] (‘Date‘[Year]), ‘Date‘[Year] = 2021)) PATH ALL ALLEXCEPT RELATED Question 32 You want to use insights in Power BI Desktop to understand the increase from one quarter to the next in your sales column chart. Normally you would right-click the appropriate column and click on Analyze > Explain increase. However, this time insights does not appear to be available.What are TWO possible reasons insights is not working? You use hierarchies You use TOPN filters You have filtered measures You use a stacked column chart Question 33 You work for an aerospace company in their satellite division. You build a workspace called ‘satellite apps’ in Power BI service that contains several reports and management level apps. You have a new analyst come on board and need to allow them to edit and publish reports.How would you achieve this goal? Configure the security group from Azure Active Directory Add the user as a member in the role section of the ‘satellite apps’ workspace In Power BI Desktop set Row Level Security (RLS) Within the ‘satellite apps’ workspace, select update app Question 34 You have a line chart that shows units manufactured by month. You want to add the on-time delivery metric for each month when you hover the mouse over a data point.How would you provide the additional piece of data? Add on-time delivery to the drillthrough fields Add the on-time delivery column to the secondary values field Add on-time delivery column to the tooltips field Add the on-time delivery column to the small multiples field Question 35 You create a Power BI report with a line chart as per the below exhibit.How do you add the dotted horizontal line for the mean values? Add a fixed forecast line for the time series in the analytics pane Add an Average line for Sales Total in the analytics pane Add a trend line across years in the analytics pane Add a min line in the analytics pane Question 36 You have built several DAX measures. A senior Power BI member of your team asks you to improve the performance and readability of the below DAX expression?How would you achieve this goal?Annual Sales Growth % =DIVIDE(([Sales] – CALCULATE([Sales], PARALLELPERIOD(‘Date‘[Date], -12, MONTH))),CALCULATE([Sales], PARALLELPERIOD(‘Date‘[Date], -12, MONTH))) Replace DIVIDE with a simple divide calculation using the ‘/’ symbol Instead of PARALLELPERIOD(), use DATEADD() Mark date table as date Use VARIABLES and a RETURN statement Question 37 You work for a forklift manufacturer. You are building a data model in Power BI and have a sales table as per the below exhibit. Within the sales table, there is a field called Model.How would you complete the DAX expression below to generate a Model table? What would you fill in for the [VALUE] fields starting from left to right? Model Table = [VALUE] ( [VALUE] ) CALCULATE / Sales[Model] DISTINCT / Sales[Model] CALCULATE / (Sales[Model] , Model = “XPR”) DISTINCT / Sales[Model Desc] Question 38 You work for an eCommerce company that sells ergonomic office products. You are tasked with creating a Power BI report from your company’s transactional sales data in a table called ‘ergoSales’. Before you do anything with the data, you want to check that there are no negative amounts in the ‘ergoSales’[quantity] field.What is the most efficient way to check your data for negatives before creating the data model? Select Column profile and then click on ‘ergoSales’[quantity] Select Column quality and then click on ‘ergoSales’[quantity] Click on ‘ergoSales’[quantity] and select replace values Create a custom column using a conditional statement to filter negatives out Question 39 You work for a diesel engine company as an internal Power BI consultant. You have two tables as per the below exhibit. There are no unique values in either table. However, the tables are related by Model Name.You need to create relationships in the data model to enable a visual containing data from both tables.How would you model these two tables in the most efficient manner? Set the relationship between the two tables as one-to-one Set the relationship between the two tables as many-to-many Create a bridging table using unique IDs and create two one-to-many relationships Set the relationship between the two tables as one-to-many Question 40 You work for a manufacturing company with a metric called Supplied in Full on Time (SIFOT). In Power BI, you have built a dashboard to help management keep track of key summary data and metrics. One of your visuals is a gauge chart that shows the SIFOT values. The management team want a notification to be sent when SIFOT drops below 85%.You need to configure email alerts to management when this happens.Which four actions should you perform to create this alert? Select + Add alert rule, ensure the Active slider is set to On In the alert conditions choose ‘below’ and enter in a value of 85 Choose More options on the SIFOT gauge visual and select Manage alerts In the dropdown for notification type, select email In the alert conditions choose ‘below’ and enter in a value of 0.85 Check the ‘Send me email too’ and then save and close Question 41 You are the head of analytics for a software company, and you want to understand the importance of factors that drive sales in your pre-sales team.What visual in Power BI can help you achieve your goal? Custom R Dumbell Plot Q&A Decomposition Tree Key Influencers Question 42 You work in the marketing division for a sports apparel company. You have a sales fact table and multiple dimension tables as per the below exhibit. The head of marketing wants to encourage self-service analytics within the company and asks that you set up Q&A in the reports.Which of the following configurations will allow Q&A to work in your data model? Object level security with any type of data source Import Composite models Reporting Services Question 43 You have sales data by day in a time series chart and need to produce a 25 day forecast with a 90% confidence interval as per the below exhibit. There are some data anomalies in the last 5 days of data that you want to ignore for the forecast. Select the THREE actions required to create the forecast. Set forecast length to 25 months and ignore last 5 months Go to the analytics pane and under forecast select ‘+ Add’ Set the seasonality interval to 90% and click on apply Set forecast length to 25 points and ignore last 5 points Set the confidence interval to 90% and click on apply Question 44 You have a busy report page called Sales and decide to use a detailed chart in a separate page using the drill through feature. The Sales page shows a visual of total sales by month.When you click on drill through on the sales by month chart, it should redirect to a detail page called Sales Detail that shows sales for the selected month by category. The Sales Detail page should also preserve the filters from the original sales page.What FOUR actions should you perform? On the Sales Detail page, under drill through option add month as the drill through field On the Sales page, under drill through option add month as the drill through field Create a new page called Sales Detail On the Sales Detail page under Drill through, toggle Keep all filters on Create a table visual to show total sales by month and category On the Sales page under Drill through, toggle Keep all filters on Question 45 You are asked to present your findings on your company’s warehousing performance across several years. You have a number of column and line charts and a date slicer. You decide you will create a presentation using Power BI and will create a narrative using the date slicer.What should you do to save the views across different years for your presentation? Create page level filters and create a new groups Filter the charts using the date slicer, then create bookmarks Create drill throughs for each of the warehouse charts Create report level filters and create a new groups Question 46 You work in a marketing department as a Power BI professional.You are asked to create three different types of visuals for the marketing department.Which visualization should you use for the below three requirements?1. Show progress of conversion rates against a target2. Identify outliers in sentiment scores3. Show the factors that influence sentiment scores KPI / Waterfall / Treemap Card / Scatter / Funnel KPI / Scatter / Key influencers Card / Funnel / Scatter Question 47 You have built a report with multiple visuals for your food manufacturing company. As many senior members are often on the road, they ask that the reports be available for mobile devices. You need to optimize the report for mobile devices for the most critical visuals.Which three things can you do to optimize reports for mobile? Set slicers to be responsive Add the most important visuals to the mobile canvas Set the page size as tablet or smartphone Resize the visuals to fit the mobile canvas Add haptic feedback (vibration) for when a user taps a visual Remove chart axes Question 48 You work for a College Football team as a Power BI sports analyst. You have built a report in Power BI Desktop that contains many visuals. The coaching team is pleased with the content of the visuals but wants the colors to match the college’s color style guide.What should you do? Adjust the report CSS file Customize the current theme Change the fonts on each text box Change the colors on each visual Question 49 You work for a microbrewery as head of data visualization. You have a Power BI data model that relies on several Excel files that reside on your company’s internal server.You are emailed a new Excel workbook from the CEO that contains updated data. You place the new Excel workbook on your server and append the text v1.2’ to the name.For each of the following statements, select Yes if the statement is true. Otherwise, select No. Yes / No / No Yes / No / Yes No / Yes / Yes No / Yes / No Question 50 Your company uses Power BI Premium and your manager wants to create printed invoices. However, the reports must fit perfectly on a page.What would you suggest to your manager? Change the page view in Power BI Desktop Use paginated reports Use gridlines and snap to grid Use lock objects Question 51 You work in a shoe company’s reporting team and have been tasked with building a Power BI report showing procurement analytics. You have an on-premises Microsoft SQL Server database that you use to build the procurement report using a DirectQuery connection.You thoroughly test the report and then upload it to Power BI Service. However, once in Power BI Service, the visualizations no longer work.How would you solve this problem? Change the permissions on your Microsoft SQL Server database Upgrade your Power BI Desktop Install an on-premise data gateway Install Power BI Report Builder Question 52 You work as a BI analyst for a software company that allows users to manipulate images online.You have built a report that shows the conversion from free customers to premium customers.Your boss has asked you to provide a filter for the marketing’ industry.Solution:· Apply a filter on all pages of the report for the marketing’ industry· Share the report· Mark share report with current filters and slicer optionsDoes this solution meet the requirements? Yes No Question 53 You work as a BI analyst for a software company that allows users to manipulate images online.You have built a report that shows the conversion from free customers to premium customers.Your boss has asked you to provide a filter for the marketing’ industry.Solution:· Create a text parameter for industry· Set the parameter equal to ‘marketing’· Create a query parameter on the industry columnDoes this solution meet the requirements? Yes No Question 54 You work as a BI analyst for a software company that allows users to manipulate images online.You have built a report that shows the conversion from free customers to premium customers.Your boss has asked you to provide a filter for the marketing’ industry.Solution:· Add a slicer to the report and select the marketing’ industry· Sync slicers to all relevant pages of the reportDoes this solution meet the requirements? Yes No Question 55 You work for a financial institution, and you have built a data model and report in Power BI desktop. The report ran fine during testing, but when in production, users are complaining of performance issues.How can you improve the model’s performance?Solution: Hide intermediate tables in the model viewDoes this help improve performance? Yes No Question 56 You work for a financial institution, and you have built a data model and report in Power BI desktop. The report ran fine during testing, but when in production, users are complaining of performance issues.How can you improve the model’s performance?Solution: Convert source PO text column into a number by removing prefix, e.g. ‘PO12399’ to 12399Does this help improve performance? Yes No Question 57 You work for a financial institution, and you have built a data model and report in Power BI desktop. The report ran fine during testing, but when in production, users are complaining of performance issues.How can you improve the model’s performance?Solution: Remove unnecessary columnsDoes this help improve performance? Yes No Question 58 You have the schema for the tables used in a bicycle franchise. In your role as a BI consultant, you have been asked to generate some insights from the data.Company data schema: You are asked to create a visualization for the sales by product. However, what should you do before creating a relationship? Change the data type of Sales[ProductKey] to fixed decimal Create a calculated column of Product[ProductKey] Change the data type of Product[ProductKey] to whole number Create a measure for the sum of Sales[Order Quantity] Question 59 You have the schema for the tables used in a bicycle franchise. In your role as a BI consultant, you have been asked to generate some insights from the data.Company data schema:The product table’s color column has abbreviations as well as names. For instance, there is both Black and BLK.What do you need to do to ensure consistency in the color column? Export the table to Excel Use replace values in the transform ribbon in Power Query Editor Edit the source applied step in M code Remove duplicates in Power Query Editor Question 60 You have the schema for the tables used in a bicycle franchise. In your role as a BI consultant, you have been asked to generate some insights from the data.Company data schema:When reviewing the customer table, you find that some of the postcodes appear to be missing. For instance ‘0800’ does not seem to exist.What do you need to do to ensure all the Postcodes from the original data are in your model? Use ‘add columns from examples’ to fix discrepancies Use ‘transform’ and then adjust the rounding Go to the transform ribbon and click on ‘Use first row as header’ Make sure the postcode data type is ‘text’ and not ‘whole number’ Question 61 You are a Power BI specialist at your organization. In your finance table, you have a column called margin, which is defined as margin = revenue cost of goods sold.’ In your company, there are several different ways people refer to margin. Some people call margin by other terms such as income, profit or profit margin.To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to enable users to type in variations for margin.Solution: Add Synonyms to the finance tableDoes this solution meet the goal? Yes No Question 62 You are a Power BI specialist at your organization. In your finance table, you have a column called margin, which is defined as margin = revenue cost of goods sold.’ In your company, there are several different ways people refer to margin. Some people call margin by other terms such as income, profit or profit margin.To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to enable users to type in variations for margin.Solution: Add a detailed description of how you defined marginDoes this solution meet the goal? Yes No Question 63 You are a Power BI specialist at your organization. In your inventory table, there are several different ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or supply.To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and columns.Solution: Set the row label on the inventory tableDoes this solution meet the goal? Yes No Question 64 You are a Power BI specialist at your organization. In your inventory table, there are several different ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or supply.To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and columns.Solution: Use Teach Q&ADoes this solution meet the goal? Yes No Question 65 You are working on a fast moving R&D project for an autonomous vehicle company. You create a dashboard but find that management wants you to make quick changes to both content and layout that they can see immediately on the dashboard. Management is only comfortable using a dashboard.What should you do to achieve this goal? Create an app Add management to the workspace as viewer roles Create a refresh schedule for twice a day Pin the report as a live page Time's up Trần Quân PL-300 Exam – Practice 4 PL-300 Exam – Practice 6