PL-300 Exam – Practice 2 Welcome to your PL-300 Exam - Practice 2 1. Question 37 You need to create a dimension table from the data source which is a single flat table (For example, create an item dimension from a list of transactions of item details). Choose the correct sequence of the following steps that you will perform.Connect to the data source (Staging Query)Develop a surrogate key (index column) if needed and link back to the fact tableEliminate the duplicates from the table to have a unique list of itemsDelete all the columns other than the ones having item details from the new query for the dimensionMake references to the staging query. One reference for the fact table and one reference for every dimension you desire to create 1-5-4-3-2 1-3-2-4-5 1-2-3-4-5 5-4-3-2-1 1-2-5-4-3 2. Question 64 You work for a Bike company and create a report of Sales and Category. You build a measure for the Sales % of Categories and want to add conditional formatting such that the colors for low values are red, center values are orange and high values are green.How would you achieve this goal? Use conditional formatting with a Color scale using default settings Use conditional formatting with Rules Use conditional formatting with Field values Use conditional formatting with a Color scale and check the diverging setting 3. Question 62 Your team manager has asked you to print some Power BI reports and distribute them among the team members during the Review meeting. Before starting the printing of reports, you notice that some tables are showing fewer rows as compared to the actual rows present there. Which of the following is the right method to resolve this issue? Change the visual from the table to Matrix Expand the table to the whole page Reduce the table size by grouping the rows Create a paginated report Create a customize tooltip 4. Question 30 There is a dataset containing the survey results for the percentage of Facebook usage by Gender, year, and age. The age of the survey respondents lies between 10 and 70 years. You need to build a bar chart demonstrating the percentage of Facebook usage for equal age ranges of 15 years.Here is the list of some actions that might be performed.a. Set the group type to Binb. Set the Bin size to 4c. Set the Bin Count to 15d. Set the Bin count to 4e. Set Group type to listf. Set the Bin type to the number of Binsg. Right-click on the column Age and Choose New GroupChoose the correct sequence of the actions (you may choose some or all actions from the given list) that you would perform. a-c-b-g-h a-g-f-d a-b-c-f-g a-b-c-e-g g-a-f-d 5. Question 16 Select the types from the below-given list which is not valid in the M Programming language? DataFrame Table Function Record Type List 6. Question 31 Which of the below-given settings are possible to be managed in a dataset in Power BI Service? Creating a new table relationship Adding a new data source Adding a new DAX measure View the refresh history Configure Scheduled Refreshes If you are not the current owner, you can take over the dataset. 7. Question 33 Which of the following is not a benefit offered by the workspaces? Workspaces ensure the highest level of security by controlling who can access the dashboards, reports, and datasets Workspaces can be used to house dashboards and reports for use by multiple teams Workspaces allow you to share and present dashboards and reports in a single environment Workspaces allow you to view and edit the data model, create visualizations and transform the data 8. Question 61 Where is it possible to configure and set data alerts? You can set Data alerts only in the Power BI desktop on any type of visual You can set Data alerts only in the Power BI service on any type of visual You can set data alerts only in the Power BI service on some specific type of visuals like gauges, KPI and cards You can set data alerts only in the Power BI desktop on some specific type of visuals like gauges, KPI and cards You can set Data alerts in both Power BI Desktop and Power BI Service on any type of visual 9. Question 57 Which of the following is the possible outcome of removing the unnecessary columns and rows? Removing necessary columns and rows will result in reducing the dataset size and its always a preferable practice to load only the necessary data in your data model Removing unnecessary columns and rows can damage the structure of your data model You should not delete unnecessary columns and rows as it’s always a preferable practice to all the metadata intact All of the above 10. Question 47 You develop a dataset named from the flat files that will use incremental refresh. The dataset with other related reports is deployed to the Premium Power BI. You notice that the incremental refresh for the dataset gets failed due to the lack of resources. Which of the following might be a potential reason for the problem? You chose only to refresh the complete periods No filter is applied to the file Query folding is not happening Data type for the column that is utilized for data partition has changed 11. Question 55 You want to create a calculated column in DAX that returns a value if the word “Admin” is present in the corresponding “Role” Column. Which of the following DAX functions can be used for the purpose? FIND CONTAINSSTRING SEARCH CONTAINSSTRINGEXACT TRIM REPT 12. Question 49 Which of the following is a potential way to improve the performance while getting the data in Power BI? Using SELECT SQL statement in SQL queries while pulling the data from a relational database Combining the date and time columns in a single column Pulling the data only into Power BI Service, nor Power BI Desktop Performing some calculations in the original data source 13. Question 51 Consider the statement below: Queries in the Query editor don’t need to be loaded to the data model. You can decide and select whether to load them or not. False True 14. Question 18 Which of the below-given statements correctly define the rules for creating the table relationships while designing a data model? A relation between two tables must be created using a single field from every table A relation between two tables can be created using multiple fields from every table At least 1 column defined in a table relation needs to have unique values You can create multiple relations between two tables and all these relations can be marked as active You can create multiple relations between two tables but only one of these relations can be marked as active 15. Question 7 What is the unique benefit of using a customized tooltip? It can demonstrate the value and category of the data points With a customized tooltip, any image or color can be set as the background for the visual It can demonstrate the images, visuals, and any other collection of items that are created by the user on the report page With a customized tooltip, a border can be created around the visual for isolating the visual from other elements on the canvas 16. Question 22 Which of the following is the right DAX function to modify a single directional relationship to a bi-directional relationship on the fly (within the measure)? USERELATIONSHIP RELATEDTABLE TREATAS CROSSFILTER RELATED 17. Question 29 Which of the following are the potential ways to enhance the performance of a report? Restrict the number of data points shown in a visual for example in a table with the help of the Top N filter Use FILTER as parts of CALCULATE measure instead of writing the filter condition directly within the function Reduce the number of bookmarks applied to a report. Optimize the DAX expressions to iterate through fewer rows Aggregate the data to reduce the number of rows. For example, the transactions can be grouped by the month rather than showing them by date Split out the dimensions and associated attributes into their own tables minimizing the number of columns within a fact tables 18. Question 5 Which of the following statements are true for dashboards and reports? Dashboards can have only a single page while reports can have multiple pages Reports can have only a single page while Dashboards can have multiple pages Dashboards can be refreshed to display the latest data while the reports can’t Reports can be refreshed to display the latest data while the Dashboards can’t Both reports and dashboards can be refreshed to display the latest data Both Dashboards and Reports can have multiple pages 19. Question 25 Select the correct Power BI report settings that you can customize with the help of a report theme? Set of the custom colors that are utilized by the visuals throughout the report Default features of the new visuals which are included in the report Background color for the report All of these 20. Question 26 There are some health and safety videos of your organization that are deployed to Microsoft (MS) Stream. You want to surface these videos directly in a Power BI dashboard.Which of the following tile would be suitable to add? Video Custom streaming Data Web content Image Text box 21. Question 9 Which of the following is not a core component of Q & A Visualization? The Question box where the Question is entered by the users. It also shows the suggestions to the users that help them in completing their Questions An icon that can be selected by the users to automatically create a custom tooltip An icon that can be selected by the users to open Q&A tooling where they can configure the underlying natural language engine An icon that can be selected by the users to convert the Q&A visual into a standard visual A pre-populated list of suggested Questions 22. Question 10 Which of the following chart is the great choice to identify or display the outliers? Bar chart Line Chart Donut chart Scatter Chart 23. Question 46 Your team is working on a project where they will come across different scenarios to use the decomposition tree. The team is confused and wants to be assured of where to use the decomposition tree. For which of the following purposes, you won‘t recommend them to use decomposition tree? To visualize the data across multiple dimensions To show the beginning and ending headcount for the organization in a year To conduct root cause analysis To automatically analyze the chosen dimensions to check where the measure is having the lowest or highest value To conduct what-if analysis with built-in parameters 24. Question 54 Choose the correct return type for the FILTER function in DAX. Column Integer Character Row Table 25. Question 38 Consider the below given Power BI model. This model shows the relationship of the Product table with the Product category on column SKU.Here is the sample of the data that both the tables have:Product TableSKU: E-01, Product: Lenovo Ideapad Slim 5i, Color: GreySKU: E-02, Product Sony headset, Color: RedSKU: E-03, product- Samsung TVs, Color: BlackProduct CategorySKU: E-01, Category: laptopsSKU: E-02, Category: HeadsetsSKU: E-03, category: TelevisionsYou need to utilize a Hierarchy in your Power BI report that demonstrates two levels i.e product and category.To achieve the goal, you decide to create a DAX expression with the CONCATENATEX function between the Product and Category columns.Will it really help you in achieving the goal? True False 26. Question 59 You are publishing a report to “Consumer Services” Workspace. The report basically identifies the consumers having data quality problems that need to be investigated by the consumer services department of the company. You want to allow the consumer service managers to create the task lists in Microsoft Excel depending upon the data. How would you configure the report setting? Permit the users to include the comments in the report Select the type of data you want to allow the end-users to export Modify the default visual interaction from cross highlighting to cross-filtering Enable the modified filter pane and display the filters in the visual header of the report Don’t permit the end users to save filters on the report 27. Question 39 You can create some very powerful data analysis solutions with the help of measures. Which of the following statement is true about the measures in Power BI? All of the above Whenever you do interact with the report, the context in which the measure calculates and shows its results changes A measure can be referenced in a DAX expression by writing the “[“ bracket A new measure can be created by clicking the “New Measure” button present in the Home tab of Power BI Desktop 28. Question 35 A Microsoft SQL Server Analysis Services (SSAS) cube has been connected to Power BI Desktop, producing the following query: The query returns 18,550 records. After going through the data source, you find that source is having a total of 21,550 records. Which of the following can you do to ensure that the query returns all 21,550 records? Modify the query to use the “Import Connection” mode Use “Rename Column” From Power Query, choose the “Unpivot Columns” command Delete the “Remove Duplicates” steps Modify the query to use “Direct Query” mode 29. Question 40 What does “Assume Referential Integrity” mean in Power BI Desktop while developing the relationships between the tables? It considers that there are no null or blank values in any data table in the relationships It automatically considers the relationship as one to one (instead of one to many or many to one) Setting Assume referential integrity makes queries to utilize OUTER JOIN statements instead of INNER JOIN, which increases the query efficiency Setting Assume referential integrity makes queries utilize INNER JOIN statements instead of OUTER JOIN, which increases the query efficiency It permits the calculated columns to be considered as the relationship column between the tables 30. Question 53 What is the use of Row Level Security (RLS) in Power BI? All the above Adding the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO) Assigning the security permissions for the underlying Power BI Azure SQL Database Restrictions to specific measures within Power BI reports to some specific users Restricting data access for the given users ( By assigning users to roles) 31. Question 8 You have created a line visual that displays the number of students getting scholarships over time. Now, you are interested in seeing the total scholarship cost of the students when you hover over a data point. Which of the following are the possible options to accomplish this goal? Add a Scholarship_amount to the drill through fields None of the above Add a Scholarship_amount to the Tooltips Add a Scholarship_amount to the Visual Filters 32. Question 52 Consider the two tables: Courses and Teachers with the following snapshots You desire to set a relationship between the tables courses and teachers with many-to-one cardinality, but it is not available in the relationship settings (as demonstrated in the below picture).What should you do before creating the Many-to-One relationship? Use the “Remove Errors“ command for the Courses table Use the “Remove Duplicates“ command for the Teachers table Filter out the blank values from the Teachers table Use the “Remove Duplicates“ command for the Courses table Add a new index column “Teacher Name” to the table Courses 33. Question 34 Select the capabilities from the given list that you can use while connected to a data model via Live Connection. See the data model in Relationships or model view in Power BI Desktop Edit or simply view the DAX measures existing in the data model Writing measures back to the data model Writing report level measures (specific only to that report, not written back to the Data Model) 34. Question 43 You have the responsibility to configure the Microsoft Power BI dashboard. You need to add the feature that the users of the dashboard can provide you with feedback and that feedback should be visible to the other users of the dashboard? In this case, what would you use? Feedback Bookmark Subscribe Mark as favorite Comments 35. Question 23 You have a custom connector that returns email-ID, From, To, Body and attachments for each email sent in a specified year and more than 10 million records have been returned by this connector. Your manager has asked you to build a report to analyze the internal network of employees depending upon whom they send mails to. Also, the report recipients should not be able to read the analyzed emails. The solution is supposed to minimize the size of the model. What would you do? Implementing Dynamic row-level security During the import, Remove the columns Subject and Body Implement row-level security to allow the report recipients to only to view the results depending upon the emails they sent Through Model view, set the columns Subject and Body to Hidden 36. Question 24 There is a product dataset with the columns Unit_Price and ordered_quantity. You have been asked to build a visualization that displays the relationship between Unit_Price and Ordered_Quantity and the orders having similar unit price and ordered_quantity should be highlighted. Which of the following visualization and feature would you use? Visualization: A column chart for Unit_Price and Quantity_ordered by year and Feature: Find where the distribution is different Visualization: A column chart for Unit_Price and Quantity_ordered by year and Feature: Automatically finds clusters Visualization: A scatter Plot for Unit_price and Quantity_ordered by item and Feature: Automatically Finds Clusters Visualization: A scatter Plot for Unit_price and Quantity_ordered by item and Feature: Find where the distribution is different Visualization: A Line chart for Unit_Price and Quantity_ordered by year and Feature: Automatically Finds Clusters 37. Question 60 Which of the following are the benefits of Power BI Reports over Power BI Dashboards? Report offers storytelling capability with the help of bookmarks Reports offer a better interactive drill down and filtering experience Reports offer a better real-time experience while showing data from a streaming dataset Report definitions are possible to save using PBIX, an external file format, and checked into source control Reports update automatically whenever the data of the underlying dataset is updated 38. Question 50 You need to import a dataset into the Power BI Desktop from an Excel document. While performing the tables profiling, you notice that two columns require some fixings where Column1 is having many values starting with space and column2 is having a number of non-printable characters.Which of the following commands can help you in fixing the errors in Column1 and Column2? Column1: Capitalize Each Word Column2: Trim Column1: Length Column2: TRIM Column1: Capitalize Each Word Column2: Clean Column1: Clean White Spaces Column2: Trim Column1: Clean White Spaces Column2: Clean Column1: Trim Column2: Clean 39. Question 56 Consider that you want to split your query into two parts. Which of the following options would you use in Power BI? Extract previous Split Query Format Query Mark Query 40. Question 63 For the custom column Formula: =if[state]= “LA” then “Los Angeles” else[state]Select the statement that rightly describes the value for the custom column formula. The value of the formula will either be “Los Angeles“ or whatever the value for the State column is The value of the formula will be “LA“ The value of the formula will be the same value as the State column The value of the formula will be “Los Angeles“ 41. Question 14 You need to create Power BI reports which are to be deployed to Power BI Report Server. Which of the following tools would you use? Power BI Desktop Power BI Report Builder Power BI Desktop optimized for Report Server Power BI desktop optimized for Paginated reports 42. Question 13 Which of the following is not the feature of the “Lineage view” in Power BI? It simplifies the task of identifying the dashboards and reports that haven‘t been refreshed It helps in analyzing the data sets and finding the patterns, trends, and outliers It allows the users to manage the workspaces and analyze the impact of a single change in one dataset to dashboards and reports It allows the users to troubleshoot the flow of data from its source to its destination 43. Question 44 You are creating a sales report that is supposed to have multiple pages. Each page would be specific to the answer for a specific business query.You decide to have a menu page that will demonstrate all the business queries. Users should be able to click any business query and after that directed to the page having the answer for the clicked query. Also, you need to ensure that the menu page works when published to any workspace.What would you do to make this work? Add filters to the menu page None of the above Build a Power Apps visual containing a drop-down list. This list will consist of all business queries Add a text box for every business query and insert a link Add a button for every business query and set the action type to Bookmark 44. Question 12 Promotion and certification are two ways to endorse dataset. Which of the following statements are true about Promotion and Certification? Promotion needs permission from the dataset owner or admin to access the dataset whereas Certification does not require specific permissions from the admin, whereas Certification In terms of permission, there is no difference between promotion and certificationright Certification is the ideal way to endorse the dataset when the dataset is ready for broad usage Promotion is the ideal way to endorse the dataset when the dataset is ready for broad usage Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset 45. Question 20 Consider the below given Power BI model.This model shows the relationship of Product table with Product category on column SKU.Here is the sample of the data that both the tables have:Product TableSKU: E-01, Product: Lenovo Ideapad Slim 5i, Color: GreySKU: E-02, Product Sony headset, Color: RedSKU: E-03, product- Samsung TVs , Color : BlackProduct CategorySKU: E-01, Category: laptopsSKU: E-02, Category: HeadsetsSKU: E-03, category: TelevisionsIn your Power BI report, you need to create a Hierarchy that demonstrates two levels i.e. Product and Category.Solution: From Power Query, merge the tables and then create the hierarchy.Will the given solution help in achieving the goal? False True 46. Question 36 You have 2 Azure SQL databases having the same tables and columns. For every database, you create a query to retrieve the data from the EMPLOYEES table. You want to combine both EMPLOYEES tables into a single table. The solution needs to minimize the data model size and support the scheduled refresh in powerbi.com. Which of the following actions would you perform respectively; to combine the EMPLOYEES tables and on the original two SQL database queries? Append queries and disable loading the query to the data model Append queries as new and disable loading the query to the data model Append queries and delete the queries Merge queries and disable loading the query to the data model Merge queries as new and disable loading the query to the data model Merge queries and delete the queries 47. Question 4 You need to register an app for embedding Power BI content. You are thinking of using an account which does not have a Power BI Pro license. Will it work for you? No Yes 48. Question 28 You are creating a complex report having a lot of visuals in Power BI. You want to ensure that the users read it in a logical way when they use the keyboard. From the following list, select the right option which you need to work on. Page Order Bookmark Order Tab Order Field Hierarchy Layer Order 49. Question 6 You have created a dashboard with the help of Microsoft Power BI Service. The dashboard has a card visual that displays the total sales from the last year.You provide users access to the dashboard through the Viewer role on the workspace.A user is interested in receiving daily notifications for the number displayed on the card visual. Which of the following is the right choice to automate the notifications? Tagging the user in a comment Creating a data alert Sharing the dashboard to the user Creating a subscription 50. Question 21 What will be the result of the following DAX formula if the year 2020 is chosen on a slicer of a report?2019 Salary_Cost = CALCULATE([Total Salary_cost], Filter (Date, Date[Year]=2019)) Salary_cost for the Year 2020 as Slicer Selection overrides DAX Filter It will return Salary_cost records for the year 2019 as well as 2020 Salary_cost for the Year 2019 as DAX Filter overrides Slicer Selection Blank. It will return no records 51. Question 2 Which of the following options is not a privacy level in Power BI desktop? Private Organizational Confidential Public 52. Question 15 Which of the following might be the possible considerations for using the “Add Column From Examples” feature in the query editor? You’re sure about the data that you need in your new column, but you are not sure about the transformation or set of transformations, that will get you the same You’re sure about the transformations that you need, but you are not sure what to choose in the UI to let them happen All the above You’re confirmed about all the transformations that you need using a Custom Column expression in M language, but one (or more) of these expressions are not available in the UI 53. Question 48 Which of the following tasks can be done only by the workspace admin, not by the users with lesser authorities and privileges? Creating, editing, or deleting the content in the workspace Publishing workspace content in the app Adding or removing the other users from the workspace Scheduling the data refreshes Creating a report in another workspace depending upon the dataset of this workspace 54. Question 3 You need to ensure that the managers of each product category can view the sales records for their product category only while the Chief executive officer should be able to view all sales records in the same report. Which of the following is the potential solution with minimal efforts? Creating a separate report for chief executive officer and separate reports for every product category manager using a different product category filter in every report Creating a product_category slicer in the report Implementing Dynamic row-level security None of these 55. Question 19 You are modelling the data with the help of Microsoft Power BI. The data model consists of a large Microsoft SQL Server table titled Transactions with records higher than 120 million.During the development phase, it is required to import a sample of data from the Transactions table.You decide to write a DAX expression that utilizes a filter function. Will this help you in achieving the goal? No Yes 56. Question 11 You need to create a report that will demonstrate the sales performance of the company. The sales team has requested you to add a single visualization (if possible) that might help them in identifying the factors that drive the sales and affect the success. Which of the following visualization would you use? Funnel chart Key influencers Donut Chart Q&A visualization 57. Question 45 There is a dashboard named Salary_Cost having Q&A enabled on it. When a user tries to get the count of Employees, the query gets failed. On the other hand, when the user asks for the count of workers, the query returns the expected result.You need to ensure that the same result is returned by both queries. Which of the following actions would you perform? Editing synonyms from the Power BI Desktop Editing Relationships from the Power BI Desktop Editing synonyms from the Power BI service Editing tables from the Power Query in Power BI Desktop 58. Question 41 You have a Consumer Sales Revenue monthly report. You analyze and notice that the attrition Rate metric is sharply increased.You are interested in understanding the variables that might affect this result.Which of the following visuals can you use to understand and explore the potential causes in Power BI Desktop? Waterfall Visual Combo visual Key Influencer Visual Decomposition tree visuals Funnel Visual 59. Question 17 You have 3 queries in Power BI Desktop: Query A, Query B and Query C. You are developing Query D that will be appended to query B. Which of the queries will get refreshed while loading the data? Query D only Query A to Query D Query A to Query C Query B and Query D Query B only 60. Question 1 Which of the following tasks can’t be performed using the dataset settings option of the Power BI Service? Define the sensitivity label for the dataset Change the credentials used for connecting to the underlying data source Mark the dataset as certified or promoted Modify query editor parameter values Check the cardinality for the columns in the dataset 61. Question 58 You need to create some visualizations in Power BI Desktop using Python Scripting. After installing and configuring Python for Power BI Desktop, you run the below-given code:In the response, you get the following error message. How would you fix this issue? By refreshing the IDE settings By refreshing the dataset origin connection By enabling the python visuals before code is run By adding the command “pyplot.show()” to the script 62. Question 42 You want to develop some visualizations in Power BI Desktop using R Scripting. Which of the following actions do you need to perform to use R scripting in Power BI Desktop? R scripting is by default available in Power BI Desktop. You don’t need to perform any special action to use R scripting You need to install Microsoft R on your system at which Power BI Desktop is already installed You need to install R Plug-in for Power BI Desktop You need to install RStudio on your system at which Power BI Desktop is already installed 63. Question 32 You develop a Power BI Report for a huge dataset. You are looking to enhance the performance of dataset refresh through an incremental refresh. Which of the following statements are true regarding this scenario? A date field is needed on a table in the dataset Use Incremental Refresh feature for all data sources RangeStart and RangeEnd are two PowerQuery parameters that are needed for the incremental Refresh Use Incremental Refresh feature only for the data sources supporting query folding 64. Question 27 You are developing a visual to demonstrate the ranking of the product types by sales revenues. As per your company‘s security policies, you can‘t send the data outside of your Power BI tenant. Which of the following approach would provide the widest variety of visuals while sticking to the security policies? Using default or custom visuals from the .pbiviz file Using default visuals or certified custom visuals Using default visuals or custom visuals from the marketplace Using only the default visuals 1 out of 4 Please fill in the comment box below. Time is Up! Time's up TokTips PL-300 Exam – Practice 1