PL-300 Exam – Practice 16 Welcome to your PL-300 Exam - Practice 16 Question 1 You create the below data model in Power BI.The Permissions table defines the Account Types that individual employees can access. Select and order the actions you need to perform to ensure that dynamic row-level security works for users logged into Power BI. Note: A security role is created on the Permissions table with the DAX expression: [User Name] = USERPRINCIPALNAME () Set the cross filter direction between the Accounts and Account Types table to Both Check Apply security filter in both directions Set the cross filter direction between the Permissions and Account Types table to Both Check Apply security filter in both directions Change the relationship cardinality from Permissions -> Account Types to One to many Set the Cross filter direction between the Permissions and Account Types table to Both Change the relationship cardinality from Permissions -> Account Types to One to many Check Apply security filter in both directions Question 2 You monitor an active fraudulent activity report in the Power BI service that connects to a backend financial data mart. The Teradata Database is updated whenever customers use a credit card. You have to detect counterfeit transactions as soon as they happen.How would you set up the data connection from Power BI? Use DirectQuery as Data Connectivity mode with reports on shared capacity Use Import as Data Connectivity mode with reports on Premium capacity Use Import as Data Connectivity mode with reports on shared capacity Use DirectQuery as Data Connectivity mode with reports on Premium capacity Question 3 Koovs is an online e-commerce store based in India that sells women’s shoes. On each of their product pages, they display two metrics: Product ratings and Answered Questions. Here is a view of the sample dataset imported into Power BI. The Sales Manager has to understand the relationship between No. of. ratings and No. of. answered Questions. They also need to find high-performing product categories (based on these metrics).Which chart best meets the needs of the sales manager? Scatter chart Line chart Stacked bar chart Bubble chart Question 4 You have a dataset on the bulk orders your company received from across India via different Sales Channels. You have to create a transformation query for the No of bulk orders received from each City and Sales channel. Which of the following options would you choose? Create a Basic Group by transform. And set the Group by operation to Count Rows Create an Advanced Group by transform. And set the Group by operation to Count Rows Create a Basic Group by transform. And set the Group by operation to Count Distinct Rows Create an Advanced Group by transform. And set the Group by operation to Count Distinct Rows Question 5 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have a data model with the Date table related to the Offline Sales table by columns of date data type (Date[Date] -> ‘Offline Sales‘[Due Date]). The Date table is marked as a date table. Goal: You have to use the appropriate date field to create a quick measure for calculating the Month-over-month change of the Sales Amount.Solution: You use the Date column from the Date table in the Date field. Does the solution meet the stated goal? Yes No Question 6 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have a data model with the Date table related to the Offline Sales table by columns of date data type (Date[Date] -> ‘Offline Sales‘[Due Date]). The Date table is marked as a date table. Goal: You have to use the appropriate date field to create a quick measure for calculating the Month-over-month change of the Sales Amount.Solution: You use the Due Date column from the Offline Sales table in the Date field. Does the solution meet the stated goal? Yes No Question 7 This Question is part of repeated scenario Questions that contain a similar stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You create a Power BI model (shown below) to analyze the yearly income of your customers across different occupations and sales territories. You have to grant report access so users can view customer’s income data only for the high-profile occupation Management in the Sales Territory Region Germany.Solution: You create a row-level security role. This role contains two filters:DimSalesTerritory[Sales Territory Region] = “Germany“ and DimCustomer[Occupation] = “Management“You assign this role to the user.Does the solution meet the goal? Yes No Question 8 This Question is part of repeated scenario Questions that contain a similar stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.To the existing Power BI model, you import one more table DimEmployee to analyze the yearly income of your customers across different occupations and sales territories. You have to grant report access so each employee can access the customer’s income and occupation data only for the Sales Territory Region he is assigned.Solution: You create a row-level security role with the filter:DimEmployee [Email Address] = USERNAME ()You assign this role to all your employees.Does the solution meet the goal? Yes No Question 9 Standard Motor Products is a leading manufacturer of replacement parts in the aftermarket industry. You build the below data model to help their sales managers understand the sales performance of automotive products.You have to create a table chart that displays the total sales value of the last three transactions for each product. How would you create the measure for the visual? Option1: CALCULATETABLE Option 2: SUM Option 3: RANKX Option 4: Sales [Sales Amount] Option1: EVALUATE Option 2: SUMMARIZE Option 3: TOPN Option 4: Sales [Sales ID] Option1: CALCULATE Option 2: SUM Option 3: TOPN Option 4: Sales [Order Date Key] Option1: FILTER Option 2: SUMX Option 3: RANKX Option 4: Sales [Sales Amount] Question 10 You enable users to naturally interact with your Power BI report using the Q&A feature. You create a Date hierarchy (contains Year and Month) in the Date table to visualize Affiliate Income.When users run a query Affiliate Income by date hierarchy, they get correct results. But, when they run Affiliate Income by Calendar, they do not get any results.You have to set up the model so that the users can query the model with Affiliate Income by Calendar and get the same results.What would you do? You add a synonym to the Date hierarchy You add a description to the Date hierarchy You add a synonym to the Date table, as you cannot add a synonym to a hierarchy You add a synonym to the year and month fields of the hierarchy Question 11 You are analyzing a Power BI data model with only a Sales table. From the Order Date hierarchy, you can analyze the sales values by Year, Month, and Day. You want to view the sales value every week. Which of the following is the easiest/elegant option? Create a new group with Group type set to ‘Bin‘ and Bin Type set to ‘Number of bins‘ Create a new Date table with CALENDARAUTO and WEEKNUM function Create a new group with Group type set to ‘List‘ Create a new group with Group type set to ‘Bin‘ and Bin Type set to ‘Size of bins‘ Question 12 You plot an R visual that maps the global locations of active COVID-19 cases in Power BI. By looking at the above chart, you realize that data is missing in Iceland, Northern Russia, Scandinavian & several other countries (marked ?).What do you think is the reason behind the missing data? The script calculating the R visual times out The R script encounters an error The R script failed to run correctly due to a missing R package Data size limitations for the R visual is exceeded Question 13 You have a clustered column chart that displays Units Sold by Year and Country. What is the best way to split this chart into multiple visuals so you can analyze the data side-by-side across different Years? By creating several column charts By creating small multiples By creating Sparklines By creating Bookmarks Question 14 You perform transformations in Power Query to import table rows of only the top 40 frequently purchasing customers from a fact table in SQL Server.Which tool cannot indicate whether all the performed transformations are folded (i.e., if query folding occurs) to SQL Server? View Native Query option Query Diagnostics Performance Analyzer SQL Server Profiler Question 15 You need to test your reports in multiple environments like Dev, UAT & Prod (DTAP street). The data source for each environment is on a different physical machine running a separate instance of SQL Server 2019.Which of the following is the best way to test your reports across all the environments? Create Power BI variables Create Power BI what-if parameters Create Power Query parameters In the Power Query M code, replace the references to the server Question 16 In the Power BI Desktop, we have an imported table that details a list of Ordered Products for each Invoice Number (shown below). You need to ensure that each Ordered Product belongs to a separate row. Which operation would you use? Pivot the table Split the column Unpivot the table Transpose Question 17 Below is the Key influencer chart for customer feedback provided by Microsoft.What does the dotted Average line indicate? Percentage of Administrators, Consumers, and Publishers who gave low ratings Percentage of low ratings given by Administrator and Publishers Percentage of low ratings given by Administrator, Consumers, and Publishers Percentage of Administrators and Publishers who gave low ratings Question 18 You are working with the Wide World Importers Data Warehouse. You need to do the following:· Import a sample data into Power BI Desktop from the Sales fact table that contains more than 350,000 transactions.· Choose the most efficient method to fetch the data.Which of the following solutions would you implement? Choose two options. You write a native SQL query during import. You use the Power Query editor to filter the data. You create a DAX expression with the FILTER function. You use Power BI report-level filters. Question 19 Microsoft stock is traded on the NASDAQ stock exchange, operational on all days except weekends and market holidays.Below is a data model with details of daily Microsoft’s stock prices for the year 2021. Which of the following DAX formulas would you use to display the Close value of the Microsoft stock each month?Note:MS Close Price =SUM ( ‘MS Stock Prices‘[Close] ) Month Closing Price = CALCULATE ( SUM ( ‘MS Stock Prices‘[Close] ), LASTDATE ( ‘Date‘[Date] ) ) Month Closing Price = CALCULATE ( SUM ( ‘MS Stock Prices‘[Close] ), LASTNONBLANK ( ‘Date‘[Date], [MS Close Price] ) ) Month Closing Price = CALCULATE ( [MS Close Price], LASTNONBLANK ( ‘Date‘[Date], SUM ( ‘MS Stock Prices‘[Close] ) ) ) Month Closing Price = CALCULATE ( [MS Close Price], LASTDATE ( ‘Date‘[Date] ) ) Question 20 You (a developer) build and deploy a production analytics dashboard for a manufacturing team to analyze the operational efficiency metrics of the product lines.After some months, you have a request from the sales team to build a sales dashboard.While developing sales reports, you observe that you apply a similar set of multiple-step transformations to create the Product dimension table in Power Query. You realize this is a duplication of efforts and want to streamline the data transformation process for future requests.Which of the following would you do? Build a data flow for the Product table Copy the M query from the PBIX file used to build the production analytics dashboard Use the shared dataset of the production analytics report/dashboard Create a Power BI datamart Question 21 You analyze sales data of a sports equipment company. You observe a lot of fluctuations in the data, such as low sales mid-week and high sales on Friday and Saturday. Your manager asked you to create a quick measure for the weekly rolling average to smooth out daily fluctuations. How would you complete the quick measure? Days, 7, 7 Days, 6, 6 Days, 6, 0 Days, 7, 0 Days 7, 1 Question 22 You create the below KPI visual in Power BI to understand your sales team’s performance compared to their sales target this year. What does the value 19462 indicate? Average sales value for all the years Sales value for all the years Average sales value for all the previous years Sales value for the current year Question 23 Your HR team gives you a dataset with a list of employees who left/joined the organization last year since its beginning on Jan 1, 2020. You have to visualize the running headcount of the organization (as employees leave/join) each month. Which chart would you use?Note: Status 1 indicates that an employee is hired. Status -1 indicates that the employee is terminated/resigned. Waterfall chart Line chart Gantt chart Stacked area chart Question 24 You are a new Power BI developer hired by your company. You need to develop a table matrix visual that displays the organization’s last year’s Revenue for each month. Which of the following DAX formulas would you use?(Select 2 options) CALCULATE ( [Revenue], DATEADD ( ‘Date‘[Date], -1, YEAR ) ) CALCULATE ( [Revenue], PARALLELPERIOD ( ‘Date‘[Date], -1, YEAR ) ) CALCULATE ( [Revenue], PREVIOUSYEAR (‘Date‘[Date] ) ) CALCULATE ( [Revenue], SAMEPERIODLASTYEAR ( ‘Date‘[Date] ) ) Question 25 There is a table visual that displays change in Quarter-over-Quarter sales value in percentage terms (Sales Last Year QoQ%). In some quarters, the sales has decreased compared to the same quarter the previous year, and so QOQ percentage values are negative. To visually communicate this aspect, the client asks you to replace Sales Last Year QoQ% values with color bands that convey the magnitude and direction of change in QoQ percentage values.What can you do to achieve this? Use data bars to color code a cell Add a column with a list of color names. And use this column to apply conditional formatting Apply a background conditional formatting with the Format style set as the Field value Apply the same conditional formatting to a field’s font & background color Question 26 Below is a line chart that plots Apple stock’s daily closing price for the past five years and the 200-Day Simple Moving Average (200 DMA). Some traders use 200 DMA to enter/exit positions in a stock.As a trader, if Apple’s stock price goes above 200 DMA, you enter a position. If Apple’s stock goes below 200 DMA, you exit a position. Accordingly, you want Power BI to notify you of such price movements. What would you do? Create a Subscription Create a data alert Integrate Power BI notifications with Power Automate It’s not possible to achieve the goal with the above options Question 27 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have a simple data model with the Product & the Sales table. You have to compute the highest total sales value for any product each month. Solution: You write the below DAX formula:Highest sales value for any Product =MAXX (‘Product‘,SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] ))Does the solution meet the stated goal? Yes No Question 28 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have a simple data model with the Product & the Sales table. You have to compute the highest total sales value for any product each month. Solution: You write the below DAX formula:Highest sales value for any Product =MAXX (‘Product‘,SUMX ( RELATEDTABLE ( Sales ), Sales[Quantity] * Sales[Unit Price] ))Does the solution meet the stated goal? Yes No Question 29 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have a simple data model with the Product & the Sales table. You have to compute the highest total sales value for any product each month. Solution: You write the below DAX formula:Highest sales value for any Product =MAXX (‘Product‘,CALCULATE ( SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] ) ))Does the solution meet the stated goal? Yes No Question 30 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have a simple data model with the Product & the Sales table. You have to compute the highest total sales value for any product each month. Solution: You write the below DAX formula:Highest sales value for any Product =MAXX ( ‘Product‘, CALCULATE ( [Total Sales] ) )Does the solution meet the stated goal? Yes No Question 31 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have a simple data model with the Product & the Sales table. You have to compute the highest total sales value for any product each month. Solution: You write the below DAX formula:Highest sales value for any Product =MAXX ( ‘Product‘, [Total Sales] )Does the solution meet the stated goal? Yes No Question 32 The HR analytics team at Canva has prepared the below New Hire Report in Power BI. If an HR manager selects any gender from the pie chart, the following interactions should happen on other visuals in the report:1. The column chart should display the new hire data of all the regions for the selected gender.2. The line chart shall show the nature of employment data every month for the selected gender.3. The clustered column chart should display a section of new hires every month for the selected gender.How would you configure the interactions between the visuals? Cross-highlight the column chart Cross-filter the line chart Cross-highlight the clustered column chart Cross-filter the column chart Cross-filter the line chart Cross-highlight the clustered column chart Cross-filter the column chart Cross-highlight the line chart Cross-highlight the clustered column chart Cross-filter the column chart Cross-filter the line chart Set no visual interaction for the clustered column chart Question 33 SwipeWire is an online merchandise company that sells T-shirts. Below is the table displaying the company’s Revenue and EBITDA across all its regions. You need to calculate and display the EBITDA margin on a card visual in Power BI Desktop.Note: EBITDA margin is the company‘s operating profit (EBITDA) as a percentage of its Revenue.Which of the following would you create? A calculated column A measure A custom column Question 34 You have trading data that has the stock trade details across several months. The stock deals contain data at the granularity of a minute, captured by the DateTime column of type Date/time. How would you optimize the column storage while still retaining all the relevant information? Format the DateTime column as two separate columns: a Date column and a Time column Modify the data type of the DateTime column from Date/time to Date In Power Query, separate the DateTime column into a Date column and a Time column. Delete the original DateTime column Create a calculated column that floors the time part of the DateTime column to the nearest 15 minutes Question 35 Your Power BI report displays sensitive information like customers’ Social Security Numbers to report users. You export the report from the service as PDF/PowerPoint and share it with your vendors for collaboration. You have to ensure that only the authorized users (in the vendor team) can access the exported reports.Which of the following features would you use? Row-level security Sensitivity labels Object-level security Data loss prevention policies Question 36 Standard Motor Products is a leading manufacturer of replacement parts in the aftermarket industry. You build the below data model to help the sales managers understand the sales performance of automotive products.You have to create a table chart that displays the sum of the highest three sales transactions for each product. How would you create the measure for the visual? Option1: CALCULATETABLE Option 2: SUM Option 3: RANKX Option 4: Sales [Sales Amount] Option1: EVALUATE Option 2: SUMMARIZE Option 3: TOPN Option 4: Sales [Sales ID] Option1: FILTER Option 2: SUMX Option 3: RANKX Option 4: Sales [Order Date Key] Option1: CALCULATE Option 2: SUM Option 3: TOPN Option 4: Sales [Sales Amount] Question 37 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.Below is a Power BI Column chart that displays the Total Marks obtained by 15 Grade X students in Marion Cross School. You need to create a reference line that shows which students are above/below the median class marks.Solution: You create a constant line and set the Value to 300Does the solution meet the goal? Yes No Question 38 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.Below is a Power BI Column chart that displays the Total Marks obtained by 15 Grade X students in Marion Cross School. You need to create a reference line that shows which students are above/below the median class marks.Solution: You create an average line using the Total Marks measure.Does the solution meet the goal? Yes No Question 39 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.Below is a Power BI Column chart that displays the Total Marks obtained by 15 Grade X students in Marion Cross School. You need to create a reference line that shows which students are above/below the median class marks.Solution: You create a percentile line using the Total Marks measure and set the Percentile to 50%Does the solution meet the goal? Yes No Question 40 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.Below is a Power BI Column chart that displays the Total Marks obtained by 15 Grade X students in Marion Cross School. You need to create a reference line that shows which students are above/below the median class marks.Solution: You create a median line using the Total Marks measure.Does the solution meet the goal? Yes No Question 41 The Repair & Maintenance team of a centrifugal pump manufacturing company generates a CSV file with information about when the machines halt for any maintenance operation. This organization-wide data is shared with your IT team and has the following schema. You have to analyze the maintenance events by the event date. What would you do?Note: In the future, you may need to analyze the event data every hour. Change the data type of Occurred At column to date Extract the first 11 characters of the Occurred At column using the Extract transform Split the Occurred At column by first 11 characters using the Split transform Parse the Occurred At column using the Parse transform Question 42 From the AdventureWorks Data warehouse, you import the below tables into Power BI Desktop. You have to analyze Reseller Sales for each Sales Territory. How would you configure the relationship between Dim Geo and Dim Territory? Area 1: Many-to-one Area 2: Both Area 1: Many-to-one Area 2: Single Area 1: Many-to-many Area 2: Single Area 1: One-to-one Area 2: Single Question 43 You import the below Orders table in Power BI, which has some null values in the Order Value column. Select the correct M query expression you would use to replace null values with a 0 in Power Query. = Table.ReplaceValue(“Order Value”,null,0,Replacer.ReplaceValue,{Orders}) = Table.ReplaceValue(Orders,null,0,{“Order Value“}) = Table.ReplaceValue(“Order Value”,null,0,{Orders}) = Table.ReplaceValue(Orders,null,0,Replacer.ReplaceValue,{“Order Value“}) Question 44 Sugar Paper LA sells stationery items for its US customers. Their sales managers have to visualize how the percentage of units sold for each of the four products (Eraser, Highlighter, Paper clip, & Stapler) contribute to the total units sold by the company in the last seven days. Which chart is best suited for this scenario? Line chart Area chart Stacked area chart 100% stacked area chart Question 45 You generate invoices for orders placed by customers to procure specific quantities of raw material for their business. From the invoice details in the Purchase table, you need to find the lowest Order Quantity value for any order each month. Which of the following DAX formulas can you use? Select two options.Note:[Total Order Quantity] =SUM ( ‘Purchase‘[Ordered Quantity] ) Lowest Order Quantity value = MINX ( ‘Purchase‘, [Total Order Quantity] ) Lowest Order Quantity value = MINX ( ‘Purchase‘, SUM ( ‘Purchase‘[Ordered Quantity] ) ) Lowest Order Quantity value = MINX ( ‘Purchase‘, CALCULATE ( MAX ( ‘Purchase‘[Ordered Quantity] ) ) ) Lowest Order Quantity value = MINX ( ‘Purchase‘, CALCULATE ( MIN ( [Total Order Quantity] ) ) ) Question 46 Which of the following statements about creating a portrait version of your reports/dashboards for mobile devices is TRUE? You can create a portrait version of your reports for mobile devices only on Power BI Desktop You can create a portrait version of your reports for mobile devices on both Power BI Desktop and service You can create a portrait version of your reports for mobile devices only on the Power BI service You can create a portrait version of only your dashboards for mobile devices Question 47 Your organization has published an unlisted video of the last quarter’s recordings of the All-Hands-Meet on its official YouTube channel. They would like to make this video available to all the internal users who have access to the Organizational performance dashboard.Which of the following is the best way to surface the video? Create a video tile in the Power BI report Create a web content tile in the Power BI dashboard Create a web content tile in the Power BI report Create a video tile in the Power BI dashboard Question 48 You have a Sales table that has sales transactions. You have to find the percentage of transactions performed by non-unique customers. Which data preview tool in Power Query is the most suitable choice? Column distribution Column profile Column quality Column statistics Question 49 You import a Customer Purchases JSON file into Power BI Desktop. Below is the structure of the JSON file, with some customers purchasing a different number of products. When you import this JSON file into Power BI, the Source step is a List of Records. Rearrange the remaining order of steps to flatten out the JSON file into a Power BI table. Convert to Table Expand the Column Expand Purchase Records to New columns Expand Purchase Lists to New Rows Convert to List Expand the Column Convert to Table Expand Purchases Lists to New columns Convert to Table Expand the Column Convert to List Expand Purchases Lists to New columns Convert to Table Expand the Column Expand Purchase Lists to New Rows Expand Purchase Records to New columns Question 50 The users in an organization access the company’s financial dashboard in Power BI from the web.The users accessing data from a mobile device should view all the dashboard tiles except those on sales/profits. Select and order three steps you would perform to create a mobile dashboard layout that displays the information in the best possible way. Edit the dashboard layout from web to mobile Move around the tiles in the mobile view as per the requirement Hide tiles related to profit/sales from the mobile view Edit the dashboard layout from web to mobile Hide tiles related to profit/sales from the mobile view Save the dashboard’s mobile layout Edit the dashboard layout from web to mobile Hide tiles related to profit/sales from the mobile view Move around the tiles in the mobile view as per the requirement Add a mobile layout for the dashboard Hide tiles related to profit/sales from the mobile view Move around the tiles in the mobile view as per the requirement Add a mobile layout for the dashboard Hide tiles related to profit/sales from the mobile view Save the dashboard’s mobile layout Question 51 You create the below Power BI KPI visual to compare this year’s sales to the previous year’s sales and to analyze the company‘s sales performance. The fields used for Indicator, Trend axis, and Target goals are shown in the representation below. where Total Sales and Sales Last Year are measures defined by the following DAX formulas:Total Sales =CALCULATE ( SUM ( Sales[Sales Amount] ) )Sales Last Year =CALCULATE ( [Total Sales], PREVIOUSYEAR ( ‘Date‘[Date] ) )Why do you think the goal value is blank? The DAX formula to calculate Sales Last Year is incorrect The Trend axis and Target goals have different granularities Trend axis accepts fields only of Date data type There is a syntax error in the Sales Last Year measure Question 52 You have a Power BI column chart that displays sales across different countries based on a transactional data store. When a user places the cursor on any individual column in the column chart, the visual should display additional data points like Average Units Sold, Highest discount offered.How would you achieve this objective? Use drillthrough Use tooltips Use drill down Use a hierarchy Question 53 You import the below data that displays the number of units sold of various products across different branches. You need to apply Power Query transformation steps and shape the data in the below format: Select the steps you would apply in the correct order. Use First Row as Headers Rename the Attribute and Value columns Use Headers as First Row Pivot Branch Office column Transpose table Use Headers as First Row Transpose table Use First Row as Headers Pivot Branch Office column Rename the Attribute and Value columns Use Headers as First Row Rename the Attribute and Value columns Use First Row as Headers Unpivot Branch Office column Transpose table Use First Row as Headers Transpose table Use Headers as First Row Unpivot all the columns other than Branch Office Rename the Attribute and Value columns Use Headers as First Row Transpose table Use First Row as Headers Unpivot all the columns other than Branch Office Rename the Attribute and Value columns Question 54 Which of the following statements/scenarios about creating data alerts in Power BI is valid? (Choose two options) You cannot create alerts on tiles created using push datasets directly from the Power BI dashboard. You can create alerts on any workspace you can access if you have a Power BI Premium Per User (PPU) license. You, the owner of a Supplier Quality Analysis dashboard, share the dashboard with your colleague. He sets alerts to notify if the metric Total Downtime Minutes goes below a specific value. To validate the alert rule, you check your dashboard. Strangely, you cannot find any alerts. Data alerts are available for all platforms like Power BI Service, Desktop, and Power BI mobile apps. You publish a report (by importing a CSV file from your drive) to the Power BI service. You pin the tile to the dashboard and create alerts for the tile. For any updates in the CSV file, you automatically see alerts in Power BI, if the threshold is met. Question 55 A bank’s Dynamics 365 system has a huge number of customer’s credit card records that you want to import into Power BI for creating reports.Task: You have to hide the customer’s card PIN from report viewers.Which of the following tasks would you perform that optimizes the model size? Mask the card PIN column Remove the card PIN column in Power Query From the model view, hide the card PIN column in the report view Implement object-level security to hide the card PIN column Question 56 You work with a data model with only the Purchases table in Power BI Desktop (There is no Date table). You have to create a table visual that displays both the Delivery Amount and the Order Amount each year in the same table. Can you build the visual?Assume the auto date/time option is set to ON. Yes No Question 57 You have a Power BI model with sales data between 2011 and 2013. You need to develop a measure that returns the YOY YTD Total Revenue of the company every month.Which of the following measures would you create? Select two options. Revenue YTD = TOTALYTD ( [Revenue], ‘Date‘[Date] ) Revenue Last Year YTD = CALCULATE ( [Revenue YTD], SAMEPERIODLASTYEAR (‘Date‘[Date] ) ) YOY YTD Total Revenue = DIVIDE ( [Revenue YTD] - [Revenue Last Year YTD], [Revenue Last Year YTD] ) Revenue YTD = TOTALYTD ( [Revenue], ‘Date‘[Date] ) Revenue Last Year YTD = CALCULATE ( [Revenue YTD], DATEADD ( ‘Date‘[Date], -4,QUARTER ) ) YOY YTD Total Revenue = DIVIDE ( [Revenue YTD] - [Revenue Last Year YTD], [Revenue Last Year YTD] ) Revenue YTD = TOTALYTD([Revenue], ‘Date‘[Date]) Revenue Last Year YTD = CALCULATE ( [Revenue YTD], DATESBETWEEN ( ‘Date‘[Date], STARTOFYEAR ( PREVIOUSYEAR(‘Date‘[Date] ) ), LASTDATE ( ‘Date‘[Date])-365 ) ) YOY YTD Total Revenue = DIVIDE ( [Revenue YTD] - [Revenue Last Year YTD], [Revenue Last Year YTD] ) Revenue YTD = TOTALYTD ( [Revenue], ‘Date‘[Date] ) Revenue Last Year YTD = CALCULATE([Revenue YTD], DATESINPERIOD ( ‘Date‘[Date], MAX ( ‘Date‘[Date] ), -1, YEAR ) ) YOY YTD Total Revenue = DIVIDE ( [Revenue YTD] - [Revenue Last Year YTD], [Revenue Last Year YTD] ) Question 58 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have to calculate the Quarter-to-date sales values from the Sales table. Below is the given data model. Solution: You perform the following steps:a. Create a relationship between the date column in the Date table and the Order Date column in the Sales tableb. Mark the Date table as a date table.c. You create the measure Sales QTD = CALCULATE([Sales Amount], DATESQTD(‘Date‘[Date]))Do the above steps help you to calculate the QTD sales values? Yes No Question 60 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have to calculate the Quarter-to-date sales values from the Sales table. Below is the given data model. Solution: You perform the following steps:a. Create a relationship between the date column in the Date table and the Order Date column in the Sales tableb. You do not Mark the Date table as a date table.c. You create the measure Sales QTD = CALCULATE([Sales Amount], DATESQTD(‘Date‘[Date]))Do the above steps help you to calculate the QTD sales values? Yes No Question 61 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have to calculate the Quarter-to-date sales values from the Sales table. Below is the given data model. Solution: You perform the following steps:a. Create a relationship between the Date Key column in the Date table and the Order Date Key column in the Sales tableb. Mark the Date table as a date table.c. You create the measure Sales QTD = CALCULATE([Sales Amount], DATESQTD(‘Date‘[Date]))Do the above steps help you to calculate the QTD sales values? Yes No Question 62 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have to calculate the Quarter-to-date sales values from the Sales table. Below is the given data model. Solution: You perform the following steps:a. Create a relationship between the Date Key column in the Date table and the Order Date Key column in the Sales tableb. You do not Mark the Date table as a date table.c. You create the measure Sales QTD = CALCULATE([Sales Amount], DATESQTD(‘Date‘[Date]))Do the above steps help you to calculate the QTD sales values? Yes No Question 63 This Question is part of repeated scenario Questions that contain the same stem but with a different solution for each Question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario Questions might contain either none, one, or many solutions.You have to calculate the Quarter-to-date sales values from the Sales table. Below is the given data model. Solution: You perform the following steps:a. Create a relationship between the Date Key column in the Date table and the Order Date Key column in the Sales tableb. You do not mark the Date table as a date table.c. You create the measureSales QTD =CALCULATE ([Sales Amount],DATESQTD ( ‘Date‘[Date] ),REMOVEFILTERS ( ‘Date‘ ))Do the above steps help you to calculate the QTD sales values? Yes No Question 64 For a diagnostic test center, you have to create standard dimension tables like Patient, Pathologist, and Tests that can be used in your organization for data modeling and report creation.Which of the following would you do/create? Shared datasets Dataflows Use Common Data Model Certify the dataset Question 65 Below is the Key influencer chart for customer feedback provided by Microsoft. What does 2.57x in the green circle indicate? The ratio of the percentage of low ratings given by consumers to the percentage of low ratings given by other roles The ratio of the percentage of consumers who give a low rating to the percentage of other roles who give a low rating The ratio of the percentage of consumers who give a low rating to the percentage of all roles who give a low rating The ratio of the percentage of low ratings given by consumers to the percentage of low ratings given by all roles Time's up Trần Quân PL-300 Exam – Practice 15 PL-300 Exam – Practice 17