PL-300 Exam – Practice 1 Welcome to your PL-300 Exam - Practice 1 1. [PL-300] Question 48 Which of the following can't be seen from the data lineage view in Power BI? The data sources that are being utilized by the dashboards/reports/datasets in a workspace Where the dataflows are being utilized as a data source for datasets The credentials utilized to connect to datasets Where gateways are being utilized as a data source for datasets 2. [PL-300] Question 13 You have several dashboards. You want to ensure that when the users browse the available dashboards from powerbi.com, they should be able to view which dashboards have personally identifiable information (PII). The solution needs to minimize the configuration efforts and effect on the dashboard design. Which of the following would you use? Tiles Feedback Comment Data Classifications . Active Directory groups 3. [PL-300] Question 24 To return the % of late orders, you need to create a suitable measure.Complete the below given DAX expression to meet the goal.Late orders percent=VAR OrderCount=COUNTROWS(Orders)VAR LateOrders= _____________ COUNTROWS('Orders'), __________(orders, ______________)RETURN DIVIDE(LateOrders, OrderCount) CALCULATE, FILTER and Orders[ShippedDate]>=Orders[RequiredDate] CALCULATE, FILTER and Orders[ShippedDate]>Orders[RequiredDate] FILTER, CALCULATE, and Orders[ShippedDate]=Orders[RequiredDate] CALCULATETABLE, FILTER and Orders[ShippedDate]>=Orders[RequiredDate] 4. [PL-300] Question 37 You need to create a data model that includes multiple tables. Which tool should you use? Power Automate Power BI Power Apps Power Query 5. [PL-300] Question 12 There is a table Registrations that have the Registration data for Ph.D scholars from scholars throughout the world. The below table shows the sample dataset:Country Year No_of_registrationsUS 2020 500India 2020 350UK 2020 450New Zealand 2020 550You try to develop a map to demonstrate the Registrations by Country, but you notice that the map does not work. How would you fix the map visualization? Choose the Country field and change the data category from the Modeling tab Choose the Country field and change the data type from the Modeling tab By adding a column that has longitude and latitude Create another table named Area and make a relationship between Area and Registrations Tables 6. [PL-300] Question 46 You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.You need to create a Power BI report that connects to the project management app.Which connector should you select? SQL Server database Dataflows Dataverse Microsoft Teams Personal Analytics 7. [PL-300] Question 36 You are creating a dashboard by using the Power BI service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do? Pin each chart as a tile Pin the report page as a live tile Edit interactions in the report and set all interactions to Filter Edit the dashboard theme and pin each chart as a tile 8. [PL-300] Question 32 As only a limited number of summaries can be created, Smart Narratives considers only the most interesting stuff to summarize for the visual. Complete the sentence below by filling in the blanks.Smart Narratives can create up to _______ summaries per visual and up to ______ summaries per page. 2,8 1,2 4,1 1,4 4,16 9. [PL-300] Question 4 Suppose you have developed a query named consumers in Power BI Desktop to append the rows from 3 external tables with consumer data into a single table consumer.Now you want to ensure that each row in the consumer table has a unique ID value. Which of the following is the best way to add a new fabricated ID column to the consumer table? Modifying the consumers>> query by adding a Counter column Modifying the consumers>> query by adding an Index column Changing the data model by extending consumer table with a Counter column Changing the data model by extending the consumers table with an Index column 10. [PL-300] Question 25 As per the case study, you are supposed to create the Top Customers report. Which of the following type of filters would you use at the visual level to meet the goal? Advanced TOP N UPPER N Basic 11. [PL-300] Question 35 You have just created a bar chart visualizing the actual sales figures by region for the past years. In order to give decision makers a deeper insight, you want to extend the visual with a breakdown by countries using the small visuals feature, and you also want to enhance it by showing the trend lines.Is it a feasible way of solving the problem? No because adding trend lines to small multiples charts is currently not available You have just created a bar chart visualizing the actual sales figures by region for the past years. In order to give decision makers a deeper insight, you want to extend the visual with a breakdown by countries using the small visuals feature, and you also want to enhance it by showing the trend lines. Is it a feasible way of solving the problem? Yes because while many formatting options doesn't work for small multiples, trend lines can be applied with no limitation No because bar charts cannot be broken down into small multiples 12. [PL-300] Question 15 Which of the following elements can you set in a bookmark? The visibility properties of fields in the report pane The visibility property of some selected visuals in the selection pane The list of visual types available in the visualization pane The visibility property of all visuals in the selection pane The sort order on any visualizations that have been set 13. [PL-300] Question 6 Consider the following table: After you pivot the columns, the table appears as shown below:As you can see, there is an Error in the 3rd row. How would you fix this error? The solution needs to preserve all the data. Rename column3 For the key column, use Duplicate Values Change the Aggregate Value Function of the Pivot Modify the Data Type of the Value Column Use Remove Errors for Column3 14. [PL-300] Question 21 Which of the following visualization charts would you create to meet the requirements of Sales Managers? Card Key influencers Pie Chart KPI Funnel chart 15. [PL-300] Question 31 Microsoft Information Protection sensitivity labels allow the users to classify the sensitive/critical content in Power BI without affecting the productivity or the collaborating ability.These Sensitivity labels can be applied to which of the following items in Power BI Service? Only datasets Only dataflows Only reports All including reports, datasets, dataflows, and dashboards Only datasets and reports Only dashboards 16. [PL-300] Question 33 While creating visuals for your Power BI dashboards, there is an opportunity to break down your visuals into slices called small multiples.Which of the following options cover the full list of visuals supporting small multiples? Bar, column and line Bar, column, area and line Pie, doughnut, bar, line 17. [PL-300] Question 43 How can you manage permissions for a workspace in Power BI? Add or remove members Delete a workspace Assign roles to members Set permissions for specific reports 18. [PL-300] Question 23 You want to calculate/ return the last day of the month in the BS data to make sure that the BS data can be related to the Date table. Which of the following type of calculations would you use? None of the above A DAX calculated column An M custom column A DAX calculated measure 19. [PL-300] Question 17 You need to create a histogram with a fixed number of bins in Power BI. Below are the few steps (given in improper sequence) that you need for creating the histogram.a. Choose New Groupb. Enter the bin countc. Choose the clustered column chart icon on the visualization Paned. In the Fields Pane, right-click the data field that you need to analyzee. Set the Group type option to "Bin" and Bin Type option to "Number of bins"f. Drag the new Field (Buckets) into the axis of your chart and apply count measure on values.Choose the right sequence of the steps that you will follow. [Build the suitable visualization type first] a-b-c-d-e-f a-c-b-e-d-f c-d-a-e-b-f c-a-d-e-b-f a-c-b-d-e-f c-a-d-b-e-f 20. [PL-300] Question 10 Can you create a relationship between two columns having different DATA TYPE? Yes, the latest versions of Power BI Desktops fully support creating relationships between such columns No, the columns in a relationship need to share the same data type Yes, but the cardinality of the relationship needs to set as many to many Yes, but the cardinality of the relationship needs to set as one to many 21. [PL-300] Question 34 For your Power BI dashboard, you have just created a pie chart visualizing the actual sales figures by region for the last year. In order to give decision makers a deeper insight, you want to extend the visual with a breakdown by countries. You decide to use the small multiples feature as a comfortable way of exploding visuals by a given dimension.Is it a feasible solution? Yes No 22. [PL-300] Question 27 Is it possible to create a relationship between the two columns i.e ProductID column of the Order Details table and the ProductName column of the Products table? Yes No 23. [PL-300] Question 44 What is the purpose of the Power BI Gateway? To allow users to connect to on-premises data sources To allow users to share reports with others To allow users to create dashboards To allow users to create custom visuals 24. [PL-300] Question 38 You want to show the relationship between two variables in a dataset. Which chart type would be best to use? Bar chart Pie chart Scatter chart Line chart 25. [PL-300] Question 40 You are building a Power BI report.Users will view the report by using their mobile device.You need to configure the report to display data based on each user‘s location.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. Create a hierarchy for columns of the geography data type Use the columns of the geography data type in all visuals In Data Category, set the geographic data category for the relevant columns. For the relevant columns, set synonyms to match common geographical terms From Power Query Editor, detect the data types of the relevant columns. 26. [PL-300] Question 45 What is the purpose of the Power BI data model? To store data in a centralized location To provide a visual representation of data To create reports and dashboards To analyze data using DAX formulas 27. [PL-300] Question 16 You are working with Q&A visual to display the expensive items (that you know are defined in your store as Rate>$140). But when you type this as a Question, you got it underlined in Red. What can be done to resolve this issue or get the expected outcome. Go to "Teach Q&A" option in Q&A setup and define an adjective filter condition in "Teach Q&A" for defining the expensive items Build the visual just demonstrating the items ( without any filter condition in the Question) and after building the visual, apply a visual level filter on Rate It is not possible to resolve such type of issues These issues can be resolved but none of the given issues will resolve the problem Build a calculated column or measure for expensive items using the filter condition in DAX and utilize it in the Question 28. [PL-300] Question 14 Which of the following statements are true regarding Slicer Visual in a Power BI report? All of the above You can configure the slicer visual based on the Date column to utilize slider controls A slicer visual from the report can be pinned to a dashboard for making the dashboard interactive The use of a slicer visual on Power BI reports is to offer the report consumers with interactive filtering behavior While adding a field to the Field Well of a slicer visual, you can use either a measure or a column 29. [PL-300] Question 7 Which of the following are the valid reasons to design your data model as a star schema? Performance as filtering on dimension rows, which are fewer, is generally faster than filtering directly on a larger fact table Star Schema minimizes data redundancy by avoiding the repetition of data values as much as possible Only Models designed with Star Schema can be published to Power BI service Having a Date dimension is a recommended practice methodology to perform time intelligence in Power BI It permits one to many relationships, which is the most recommended relationship type in Power BI, between the tables It makes it clear to the end-users or the report builders which business attributes or entities they can slice and dice by 30. [PL-300] Question 19 Which of the following reserved parameters respectively configure the start and end of where Incremental refresh should happen? Start and End parameters StartRefresh and EndRefresh parameters RefreshStart and RefreshEnd parameters StartRange and EndRange parameters RangeStart and RangeEnd parameters 31. [PL-300] Question 1 You need to import 45 Excel files to Power BI Desktop. All these files are in a unique desktop local folder and share the same structure. You want to import all these Excel files into a single table. Which of the following would help you in achieving the goal? Adding the folder data source; using the Append Queries command Adding the MS Excel Data Source; selecting all files of the folder Adding a folder data source and using the Merge Queries Command . Adding every single file to the model and then using Merge Query Command Adding the folder data source; using the Combine Files Command 32. [PL-300] Question 30 While attempting to enable the security labels in Power BI, you receive an error message and are not able to enable the security labels. Which of the following might be the possible reason? Any of the above You don't have an Azure Information Protection license No MS Information Protection sensitivity labels are defined/specified in the organization Sensitivity labels haven't been migrated to the MS Information Protection version that Power BI support 33. [PL-300] Question 3 You have a 200 GB data warehouse that has data consolidated from several applications and runs on SQL Server 2017 Enterprise Edition. You notice that with your reports, there is a default limitation of eight daily refreshes. Your manager asks you to ensure that the reports are never more outdated than 1 hour. Which of the following can help you in achieving the same? Adding an SSAS tabular layer on top and enabling the Live connections Building an application for monitoring the changes in the database and pushing them out utilizing the real-time streaming API Convert to DirectQuery to access the data warehouse Migrating the content to Power BI Premium 34. Question 8 Consider the statement below.Row Level Security can't be applied in Power BI Desktop while connecting via a Live connection to Analysis Services, these need to be set within the AS model. False True 35. [PL-300] Question 20 Your company is planning to utilize the Power BI Service to get multiple visualizations from data stored in a custom application.The developers ask to push the data into the Power BI Service from the custom app.How would you ensure this task? Go to Office 365 Admin portal and register a web application Go to dev.powerbi.com/apps and register an application Go to app.powerbi.com and build an empty report Go to tenant settings from the Power BI admin portal and set the API permissions 36. [PL-300] Question 47 You have four sales regions. Each region has multiple sales managers.You implement row-level security (RLS) in a data model. You assign the relevant mail-enabled security group to each role.You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.A sales manager changes to a different region.You need to ensure that the sales manager can see the correct sales data.What should you do? Change the Microsoft Power BI license type of the sales manager. Request that the sales manager be added to the correct Azure Active Directory group. Manage the permissions of the underlying dataset. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports. 37. [PL-300] Question 5 Why is it advised to avoid the NULL values in the numeric column? DAX expression having an AVERAGE function on such data will provide incorrect results . DAX expression having SUM function on such data will provide incorrect results All the above DAX Expressions cant be applied if a numeric column has one or multiple NULL values DAX expression having MAX function on such data will provide incorrect results 38. [PL-300] Question 39 How can you ensure that datasets are up-to-date in Power BI? Use a scheduled refresh Manually refresh each dataset Use a direct query to the data source Use a live connection to the data source 39. [PL-300] Question 22 You are supposed to create or manage the required relationships to accomplish the requirements of the customer services department. As you are confused about what relations should be created, you take advice from one of your friends. He advises you that one of the relations that you must create is:One to many relationships between Dates[date_id] to Weekly_Return[week_id]Will it help in meeting the goal? Yes No 40. [PL-300] Question 18 Consider the statement below.The nodes in a decomposition tree (the fields through which the metric is analyzed by in the visuals) are fixed and can‘t be modified by the end-users viewing the report. False True 41. Question 11 You need to configure a Gauge chart. Where would you set the goal for this? Format Settings Power Query Calculated Column DAX Expression 42. [PL-300] Question 9 You need to write a measure that will calculate the ratio of a month of sales in a year. Which of the following function can be used for the purpose? FIRSTDATE WHOLEYEAR ALL FILTER ENDOFYEAR 43. [PL-300] Question 26 You have been asked to create an On-Time Shipping report which must contain a visualization that demonstrates the % of late orders.Which of the following type of visualization would you create? Scatterplot Pie Chart Bar Chart Funnel Chart 44. [PL-300] Question 29 There are several methods that can be used to fill/handle the missing values (known as nan) in the merged table. Which of the following fillNAMethod would you use to fill the nan with the padding value? Linear Fixed Previous Subsequent Padding Zero 45. [PL-300] Question 28 You are working on the K sliding window for model training and stuck with the inference. You approach your manager to know how many data points at a minimum should be accessible from the source file to ensure valid outcomes at the time of inference. What did he suggest? 1 point K points K-1 points K*K points K+1 points 46. [PL-300] Question 42 How can you ensure that only authorized users have access to a dataset in Power BI? Use workspace-level security Use object-level security Use row-level security Use column-level security 47. [PL-300] Question 41 What is the difference between a shared and a personal workspace in Power BI? Personal workspaces can be shared with other users Shared workspaces can be accessed by multiple users Shared workspaces can be edited by multiple users Personal workspaces can only be accessed by the owner 48. [PL-300] Question 2 You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do? Create a column by example that starts with 2018-12-31 Apply the Parse function from the Data transformations options to the Logged column. Change the data type of the Logged column to Date. Split the Logged column by using at as the delimiter 1 out of 5 TokTips PL-300 Exam – Practice 2 PL-300 – All
