PL-300 Exam – Practice 1 Welcome to your PL-300 Exam - Practice 1 1. [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? Dataverse Microsoft Teams Personal Analytics SQL Server database Dataflows 2. [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? By adding a column that has longitude and latitude Choose the Country field and change the data type from the Modeling tab Choose the Country field and change the data category from the Modeling tab Create another table named Area and make a relationship between Area and Registrations Tables 3. [PL-300] Question 15 Which of the following elements can you set in a bookmark? The visibility property of all visuals in the selection pane The visibility property of some selected visuals in the selection pane The list of visual types available in the visualization pane The sort order on any visualizations that have been set The visibility properties of fields in the report pane 4. Question 11 You need to configure a Gauge chart. Where would you set the goal for this? DAX Expression Format Settings Power Query Calculated Column 5. [PL-300] Question 14 Which of the following statements are true regarding Slicer Visual in a Power BI report? A slicer visual from the report can be pinned to a dashboard for making the dashboard interactive You can configure the slicer visual based on the Date column to utilize slider controls All of the above While adding a field to the Field Well of a slicer visual, you can use either a measure or a column The use of a slicer visual on Power BI reports is to offer the report consumers with interactive filtering behavior 6. [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? Edit interactions in the report and set all interactions to Filter Pin the report page as a live tile Edit the dashboard theme and pin each chart as a tile Pin each chart as a tile 7. [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. 1,2 4,16 4,1 1,4 2,8 8. [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-c-b-e-d-f c-d-a-e-b-f c-a-d-b-e-f a-b-c-d-e-f c-a-d-e-b-f a-c-b-d-e-f 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 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 Modifying the consumers>> query by adding an Index column 10. [PL-300] Question 39 How can you ensure that datasets are up-to-date in Power BI? Manually refresh each dataset Use a scheduled refresh Use a live connection to the data source Use a direct query to the data source 11. [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. For the key column, use Duplicate Values Modify the Data Type of the Value Column Use Remove Errors for Column3 Rename column3 Change the Aggregate Value Function of the Pivot 12. [PL-300] Question 21 Which of the following visualization charts would you create to meet the requirements of Sales Managers? Funnel chart KPI Key influencers Pie Chart Card 13. [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) CALCULATETABLE, FILTER and Orders[ShippedDate]>=Orders[RequiredDate] CALCULATE, FILTER and Orders[ShippedDate]>Orders[RequiredDate] FILTER, CALCULATE, and Orders[ShippedDate]=Orders[RequiredDate] CALCULATE, FILTER and Orders[ShippedDate]>=Orders[RequiredDate] 14. [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 15. [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? Change the data type of the Logged column to Date. Apply the Parse function from the Data transformations options to the Logged column. Split the Logged column by using at as the delimiter Create a column by example that starts with 2018-12-31 16. [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 dev.powerbi.com/apps and register an application Go to Office 365 Admin portal and register a web 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 17. [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 All the above DAX Expressions cant be applied if a numeric column has one or multiple NULL values . DAX expression having SUM function on such data will provide incorrect results DAX expression having MAX function on such data will provide incorrect results 18. [PL-300] Question 42 How can you ensure that only authorized users have access to a dataset in Power BI? Use column-level security Use row-level security Use workspace-level security Use object-level security 19. [PL-300] Question 48 Which of the following can't be seen from the data lineage view in Power BI? Where the dataflows are being utilized as a data source for datasets Where gateways are being utilized as a data source for datasets The credentials utilized to connect to datasets The data sources that are being utilized by the dashboards/reports/datasets in a workspace 20. [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? K*K points 1 point K+1 points K-1 points K points 21. [PL-300] Question 43 How can you manage permissions for a workspace in Power BI? Assign roles to members Set permissions for specific reports Add or remove members Delete a workspace 22. [PL-300] Question 7 Which of the following are the valid reasons to design your data model as a star schema? Only Models designed with Star Schema can be published to Power BI service It makes it clear to the end-users or the report builders which business attributes or entities they can slice and dice by Having a Date dimension is a recommended practice methodology to perform time intelligence in Power BI 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 It permits one to many relationships, which is the most recommended relationship type in Power BI, between the tables 23. [PL-300] Question 44 What is the purpose of the Power BI Gateway? To allow users to create custom visuals To allow users to share reports with others To allow users to create dashboards To allow users to connect to on-premises data sources 24. [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? No Yes 25. [PL-300] Question 45 What is the purpose of the Power BI data model? To provide a visual representation of data To store data in a centralized location To create reports and dashboards To analyze data using DAX formulas 26. [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? You don't have an Azure Information Protection license No MS Information Protection sensitivity labels are defined/specified in the organization Any of the above Sensitivity labels haven't been migrated to the MS Information Protection version that Power BI support 27. [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? UPPER N TOP N Advanced Basic 28. [PL-300] Question 37 You need to create a data model that includes multiple tables. Which tool should you use? Power Query Power BI Power Apps Power Automate 29. [PL-300] Question 10 Can you create a relationship between two columns having different DATA TYPE? Yes, but the cardinality of the relationship needs to set as one to many 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 30. [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? Pie, doughnut, bar, line Bar, column and line Bar, column, area and line 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 Combine Files Command . Adding every single file to the model and then using Merge Query Command 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 32. [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? WHOLEYEAR FIRSTDATE ALL ENDOFYEAR FILTER 33. [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? 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. Change the Microsoft Power BI license type of the sales manager. 34. [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 No because bar charts cannot be broken down into small multiples 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 35. [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 36. [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 dataflows Only dashboards Only datasets Only datasets and reports All including reports, datasets, dataflows, and dashboards Only reports 37. [PL-300] Question 38 You want to show the relationship between two variables in a dataset. Which chart type would be best to use? Line chart Scatter chart Bar chart Pie chart 38. [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? Pie Chart Scatterplot Funnel Chart Bar Chart 39. [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? A DAX calculated measure None of the above An M custom column A DAX calculated column 40. [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? . Active Directory groups Feedback Data Classifications Comment Tiles 41. 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 42. [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 43. [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? Previous Linear Subsequent Padding Zero Fixed 44. [PL-300] Question 19 Which of the following reserved parameters respectively configure the start and end of where Incremental refresh should happen? StartRefresh and EndRefresh parameters RefreshStart and RefreshEnd parameters Start and End parameters StartRange and EndRange parameters RangeStart and RangeEnd parameters 45. [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. 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 These issues can be resolved but none of the given issues will resolve the problem It is not possible to resolve such type of issues Build a calculated column or measure for expensive items using the filter condition in DAX and utilize it in the Question 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 46. [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. Use the columns of the geography data type in all visuals For the relevant columns, set synonyms to match common geographical terms From Power Query Editor, detect the data types of the relevant columns. In Data Category, set the geographic data category for the relevant columns. Create a hierarchy for columns of the geography data type 47. [PL-300] Question 41 What is the difference between a shared and a personal workspace in Power BI? Shared workspaces can be accessed by multiple users Personal workspaces can only be accessed by the owner Personal workspaces can be shared with other users Shared workspaces can be edited by multiple users 48. [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? No Yes 1 out of 5 TokTips PL-300 Exam – Practice 2 PL-300 – All