PL-300 – All Welcome to your PL-300 - All 1. [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 bar charts cannot be broken down into small multiples Yes because while many formatting options doesn't work for small multiples, trend lines can be applied with no limitation 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? 2. [PL-300-2,PL-300] Question 15 All the above 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 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 3. [PL-300-2,PL-300] Question 9 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 convert the Q&A visual into a standard visual An icon that can be selected by the users to open Q&A tooling where they can configure the underlying natural language engine A pre-populated list of suggested Questions 4. [PL-300-2,PL-300] Question 19 Yes No 5. [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 Create a hierarchy for columns of the geography data type From Power Query Editor, detect the data types of the relevant columns. For the relevant columns, set synonyms to match common geographical terms In Data Category, set the geographic data category for the relevant columns. 6. [PL-300-4,PL-300] Question 1 Create a PBIDS file with your key data sources Create a template in lineage view Use an Excel Macro to build connections Create a dynamic M query 7. [PL-300-2,PL-300] Question 41 Waterfall Visual Combo visual Funnel Visual Decomposition tree visuals Key Influencer Visual 8. [PL-300-4,PL-300] Question 44 Add a text box tile Add an image tile Add a video tile Add a custom streaming data tile 9. [PL-300-2,PL-300] Question 14 Power BI Desktop optimized for Report Server Power BI desktop optimized for Paginated reports Power BI Report Builder Power BI Desktop 10. [PL-300-4,PL-300] Question 32 Format: ‘Rules’, Row 1: ‘0 / Number’ and ‘0.1 / Number’, Row 2: ‘0.1 / Number’ and ‘1 / Number’ Format: ‘Color Scale, Row 1: ‘0 / Percentage’ and ‘10 / Percentage’, Row 2: ‘10 / Percentage’ and ‘100 / Percentage’ Format: ‘Field Value’, Row 1: ‘0 / Percentage’ and ‘10 / Percentage’, Row 2: ‘10 / Percentage’ and ‘100 / Percentage’ Format: ‘Color Scale’, Row 1: ‘0 / Number’ and ‘10 / Number’, Row 2: ‘10 / Number’ and ‘100 / Number’ 11. [PL-300-2,PL-300] Question 27 Using default visuals or certified custom visuals Using default visuals or custom visuals from the marketplace Using default or custom visuals from the .pbiviz file Using only the default visuals 12. [PL-300-2,PL-300] Question 38 True False 13. [PL-300-2,PL-300] Question 5 Reports can be refreshed to display the latest data while the Dashboards can’t Dashboards can be refreshed to display the latest data while the reports can’t Reports can have only a single page while Dashboards can have multiple pages Both Dashboards and Reports can have multiple pages Dashboards can have only a single page while reports can have multiple pages Both reports and dashboards can be refreshed to display the latest data 14. [PL-300-4,PL-300] Question 51 Integrate the dashboard to Power BI Desktop Subscribe to the dashboard Ask the admin to add you as a contributor to the workspace Turn on notifications on your instance of Power BI Service 15. [PL-300-3,PL-300] Question 29 Install Power BI Report server to test reports Create separate workspaces for your team across the reporting lifecycle Change to paginated reports for your reporting lifecycle Create a deployment pipeline across development, test and production stages 16. [PL-300-3,PL-300] Question 16 Select all columns -> Pivot columns Select TransactionID -> Select Unpivot other columns Select TransactionID -> Select Pivot columns Select all columns -> Select Unpivot columns 17. [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? 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 Any of the above You don't have an Azure Information Protection license 18. [PL-300-2,PL-300] Question 61 You can set Data alerts in both Power BI Desktop and Power BI Service on any type of visual 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 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 19. [PL-300-4,PL-300] Question 53 In the relationship view, set the cross filter direction to Single In the relationship view, uncheck make this relationship active In the relationship view, check apply security filter in both directions In the relationship view, set the cross filter direction to Both 20. [PL-300-2,PL-300] Question 4 No Yes 21. [PL-300-2,PL-300] Question 52 Add a new index column “Teacher Name” to the table Courses Use the “Remove Errors“ command for the Courses table Filter out the blank values from the Teachers table Use the “Remove Duplicates“ command for the Courses table Use the “Remove Duplicates“ command for the Teachers table 22. [PL-300-4,PL-300] Question 2 You need to first install the library ‘tidyr’ ‘NA’ is transformed into ‘NULL’ by Power BI You have not used the correct R version Power BI only supports R dataframes 23. [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? Comment Tiles . Active Directory groups Feedback Data Classifications 24. [PL-300-2,PL-300] Question 45 Editing tables from the Power Query in Power BI Desktop Editing Relationships from the Power BI Desktop Editing synonyms from the Power BI Desktop Editing synonyms from the Power BI service 25. [PL-300-4,PL-300] Question 25 NONE / SUM / SUM COUNT / SUM / NONE MAX / NONE / SUM NONE / MAX / SUM 26. [PL-300-3,PL-300] Question 12 Write a custom script in R In the tenant settings, add an email for service notifications Create a subscription Create a data alert 27. [PL-300-2,PL-300] Question 39 A measure can be referenced in a DAX expression by writing the “[“ bracket Whenever you do interact with the report, the context in which the measure calculates and shows its results changes All of the above A new measure can be created by clicking the “New Measure” button present in the Home tab of Power BI Desktop 28. [PL-300-2,PL-300] Question 4 No Yes 29. [PL-300-2,PL-300] Question 28 Field Hierarchy Page Order Tab Order Bookmark Order Layer Order 30. [PL-300-2,PL-300] Question 55 TRIM FIND CONTAINSSTRINGEXACT CONTAINSSTRING SEARCH REPT 31. [PL-300-2,PL-300] Question 31 View the refresh history Adding a new data source Configure Scheduled Refreshes Creating a new table relationship If you are not the current owner, you can take over the dataset. Adding a new DAX measure 32. [PL-300-3,PL-300] Question 51 Color scheme Title Subtitle Destination link 33. [PL-300-2,PL-300] Question 52 Use the “Remove Duplicates“ command for the Courses table Add a new index column “Teacher Name” to the table Courses Use the “Remove Duplicates“ command for the Teachers table Filter out the blank values from the Teachers table Use the “Remove Errors“ command for the Courses table 34. [PL-300-3,PL-300] Question 26 In conditional formatting select “Sales % Category” and turn on data bars In conditional formatting select “Sales Total” and turn on data bars In conditional formatting select “Sales Total” and turn on background color In conditional formatting select “Sales % Category” and turn on background color 35. [PL-300-2,PL-300] Question 12 Certification is the ideal way to endorse the dataset when the dataset is ready for broad usage In terms of permission, there is no difference between promotion and certificationright Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset Promotion is the ideal way to endorse the dataset when the dataset is ready for broad usage 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 36. [PL-300-2,PL-300] Question 22 RELATED TREATAS USERELATIONSHIP CROSSFILTER RELATEDTABLE 37. [PL-300-3,PL-300] Question 40 Value Group Details Legend 38. [PL-300-2,PL-300] Question 2 Private Confidential Organizational Public 39. [PL-300-4,PL-300] Question 47 Ray = Admin / Jane = Member Ray = Member / Jane = Contributor Ray = Member / Jane = Member Ray = Member / Jane = Viewer 40. [PL-300-4,PL-300] Question 39 You have uploaded data to Power BI You have measures in your dataset Your dataset is not statistically significant Your dataset uses Direct Query Your dataset uses streaming 41. [PL-300-3,PL-300] Question 44 Maximum of 5 variables can be created per formula. Variables are created only one time in the current context Variables must be defined inside return 42. [PL-300-2,PL-300] Question 15 You’re sure about the transformations that you need, but you are not sure what to choose in the UI to let them happen 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 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 All the above 43. [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 an Index column 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 44. [PL-300-2,PL-300] Question 40 It considers that there are no null or blank values in any data table in the relationships 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 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 45. [PL-300-3,PL-300] Question 9 USERPRINCIPALNAME USEROBJECTID USERDOMAIN PATH 46. [PL-300-2,PL-300] Question 29 Split out the dimensions and associated attributes into their own tables minimizing the number of columns within a fact tables Use FILTER as parts of CALCULATE measure instead of writing the filter condition directly within the function 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 Restrict the number of data points shown in a visual for example in a table with the help of the Top N filter Reduce the number of bookmarks applied to a report. 47. [PL-300-4,PL-300] Question 34 VAR PreviousYearSales = SUMX([Sales Total], SAMEPERIODLASTYEAR (‘Date‘[Date],-1,YEAR)) VAR TargetSales = PreviousYearSales*1.1 Return TargetSales VAR PreviousYearSales = CALCULATE([Sales Total], PARALLELPERIOD (‘Date‘[Date],-1,MONTH)) VAR TargetSales = PreviousYearSales*1.1 Return PreviousYearSales VAR PreviousYearSales = CALCULATETABLE([Sales Total],DATEADD(‘Date‘[Date],-1,YEAR)) VAR TargetSales = PreviousYearSales*0.1 Return TargetSales VAR PreviousYearSales = CALCULATE([Sales Total],DATEADD(‘Date‘[Date],-1,YEAR)) VAR TargetSales = PreviousYearSales*1.1 Return TargetSales 48. [PL-300-4,PL-300] Question 21 Custom Light Dark Tab-order friendly Color-blind friendly 49. [PL-300-3,PL-300] Question 8 Run Q&A Run Query Diagnostics Run Performance Analyzer Run the ALM toolkit 50. [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 a folder data source and using the Merge Queries Command Adding the folder data source; using the Append Queries command Adding the MS Excel Data Source; selecting all files of the folder Adding the folder data source; using the Combine Files Command . Adding every single file to the model and then using Merge Query Command 51. Question 11 You need to configure a Gauge chart. Where would you set the goal for this? Power Query Calculated Column DAX Expression Format Settings 52. [PL-300-2,PL-300] Question 6 Creating a subscription Tagging the user in a comment Creating a data alert Sharing the dashboard to the user 53. [PL-300-3,PL-300] Question 4 SELECTCOLUMNS VALUES RELATED USERELATIONSHIP 54. [PL-300-3,PL-300] Question 21 Yes No 55. [PL-300-2,PL-300] Question 50 Column1: Capitalize Each Word Column2: Clean Column1: Clean White Spaces Column2: Trim Column1: Capitalize Each Word Column2: Trim Column1: Trim Column2: Clean Column1: Clean White Spaces Column2: Clean Column1: Length Column2: TRIM 56. [PL-300-4,PL-300] Question 15 Yes / Yes / No No / No / Yes Yes / No / No Yes / No / Yes 57. [PL-300-2,PL-300] Question 64 Use conditional formatting with Field values Use conditional formatting with a Color scale and check the diverging setting Use conditional formatting with Rules Use conditional formatting with a Color scale using default settings 58. [PL-300-2,PL-300] Question 58 By enabling the python visuals before code is run By refreshing the dataset origin connection By adding the command “pyplot.show()” to the script By refreshing the IDE settings 59. [PL-300-2,PL-300] Question 11 Donut Chart Key influencers Q&A visualization Funnel chart 60. [PL-300-3,PL-300] Question 2 Q&A Paginated reports Dashboards Row-level security (RLS) Quick insights 61. [PL-300-2,PL-300] Question 2 Organizational Confidential Public Private 62. [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 Padding Zero Subsequent Linear Fixed 63. [PL-300] Question 37 You need to create a data model that includes multiple tables. Which tool should you use? Power Query Power Apps Power BI Power Automate 64. [PL-300-2,PL-300] Question 33 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 view and edit the data model, create visualizations and transform the data Workspaces allow you to share and present dashboards and reports in a single environment 65. [PL-300] Question 44 What is the purpose of the Power BI Gateway? To allow users to create dashboards To allow users to share reports with others To allow users to connect to on-premises data sources To allow users to create custom visuals 66. [PL-300-2,PL-300] Question 23 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 Implementing Dynamic row-level security 67. [PL-300-2,PL-300] Question 6 Tagging the user in a comment Sharing the dashboard to the user Creating a subscription Creating a data alert 68. [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 Yes, but the cardinality of the relationship needs to set as one to many 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 69. [PL-300-2,PL-300] Question 21 Salary_cost for the Year 2020 as Slicer Selection overrides DAX Filter Salary_cost for the Year 2019 as DAX Filter overrides Slicer Selection Blank. It will return no records It will return Salary_cost records for the year 2019 as well as 2020 70. [PL-300-2,PL-300] Question 62 Expand the table to the whole page Create a customize tooltip Create a paginated report Reduce the table size by grouping the rows Change the visual from the table to Matrix 71. [PL-300-4,PL-300] Question 42 In the tenant settings, enable share content with external users In the tenant settings, enable email notification service for outages or incidents Make sure your supplier has upgraded to Power BI Premium Publish your dashboard to the web 72. [PL-300-2,PL-300] Question 44 Add a button for every business query and set the action type to Bookmark 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 filters to the menu page None of the above 73. [PL-300-2,PL-300] Question 59 Enable the modified filter pane and display the filters in the visual header of the report Select the type of data you want to allow the end-users to export Permit the users to include the comments in the report Don’t permit the end users to save filters on the report Modify the default visual interaction from cross highlighting to cross-filtering 74. [PL-300-3,PL-300] Question 57 Denormalize the data so it is one flat table Convert the report from DirectQuery mode to Import mode Migrate the data from SQL Server to the Azure SQL database Set up an Azure Machine Learning account in your Azure tenant 75. [PL-300-2,PL-300] Question 58 By enabling the python visuals before code is run By refreshing the dataset origin connection By refreshing the IDE settings By adding the command “pyplot.show()” to the script 76. [PL-300-2,PL-300] Question 64 Use conditional formatting with Field values Use conditional formatting with a Color scale and check the diverging setting Use conditional formatting with a Color scale using default settings Use conditional formatting with Rules 77. [PL-300-3,PL-300] Question 25 FORMAT(Date[Date], “D M Y“) FORMAT(Date[Date], “DD MMM YYYY“) FORMAT(Date[Date], “DD MMMM YYYY“) FORMAT(Date[Date], “D MM YYYY“) 78. [PL-300-2,PL-300] Question 27 Using only the default visuals Using default visuals or certified custom visuals Using default or custom visuals from the .pbiviz file Using default visuals or custom visuals from the marketplace 79. [PL-300-2,PL-300] Question 37 1-3-2-4-5 1-2-5-4-3 5-4-3-2-1 1-2-3-4-5 1-5-4-3-2 80. [PL-300-3,PL-300] Question 6 Use the TRIM function in a new column, then set the data type to Date Use the VALUE function in a new column, then set the data type to Date Add a Column by example and type 2022-03-20, then set the data type to Date Use the CONCATENATE function in a new column, then set the data type to Date 81. [PL-300-2,PL-300] Question 63 The value of the formula will be the same value as the State column 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 “Los Angeles“ 82. [PL-300-4,PL-300] Question 46 Create a script to continuously import the data Connect to the data with Live Connection Connect to the data with DirectQuery Connect to the data with AI Insights 83. [PL-300-4,PL-300] Question 10 On the home ribbon, click on properties and change the file path On the home ribbon, click on manage -> then file, then change the file path Click on the Applied step 'changed type’ and click on the cog in the corner to change the file location Click on the Applied step ‘source’ and click on the cog to change the file path 84. [PL-300-2,PL-300] 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? Expand the table to the whole page Create a customize tooltip Change the visual from the table to Matrix Create a paginated report Reduce the table size by grouping the rows 85. [PL-300-2,PL-300] Question 4 Yes No 86. [PL-300-4,PL-300] Question 13 Refresh time in a premium capacity is rounded to the nearest 30 minutes Use must first disable sharing of your workspace Your capacity administrator must enable the feature Your interval must be greater than the minimum refresh interval 87. [PL-300-2,PL-300] Question 51 False True 88. [PL-300-4,PL-300] Question 11 Click the Sync to organization button On the navigation tab, select the content to be visible in the app On the permissions tab, decide who has access to the app On the setup tab, fill in the name and description to help people find the app Before releasing the app, create a digital signature, so people know who built the app On the title tab, fill in the name and description to help people find the app 89. [PL-300-2,PL-300] Question 7 With a customized tooltip, a border can be created around the visual for isolating the visual from other elements on the canvas 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 It can demonstrate the value and category of the data points 90. [PL-300-2,PL-300] Question 30 g-a-f-d a-c-b-g-h a-b-c-e-g a-g-f-d a-b-c-f-g 91. [PL-300-2,PL-300] Question 40 It permits the calculated columns to be considered as the relationship column between the tables Setting Assume referential integrity makes queries to utilize OUTER JOIN statements instead of INNER JOIN, which increases the query efficiency It considers that there are no null or blank values in any data table in the relationships Setting Assume referential integrity makes queries utilize INNER JOIN statements instead of OUTER JOIN, which increases the query efficiency It automatically considers the relationship as one to one (instead of one to many or many to one) 92. [PL-300-2,PL-300] Question 61 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 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 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 93. [PL-300] Question 45 What is the purpose of the Power BI data model? To provide a visual representation of data To create reports and dashboards To analyze data using DAX formulas To store data in a centralized location 94. [PL-300-2,PL-300] Question 19 Yes No 95. [PL-300-2,PL-300] Question 45 Editing synonyms from the Power BI Desktop Editing synonyms from the Power BI service Editing tables from the Power Query in Power BI Desktop Editing Relationships from the Power BI Desktop 96. [PL-300-4,PL-300] Question 8 Promoted / Certified / Featured Featured / Sensitivity Label / Promoted Certified / Sensitivity Label / Promoted Sensitivity Label / Featured / Promoted 97. [PL-300] Question 43 How can you manage permissions for a workspace in Power BI? Add or remove members Assign roles to members Set permissions for specific reports Delete a workspace 98. [PL-300-2,PL-300] Question 27 Using only the default visuals 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 99. [PL-300-2,PL-300] Question 34 Edit or simply view the DAX measures existing in the data model See the data model in Relationships or model view in Power BI Desktop Writing report level measures (specific only to that report, not written back to the Data Model) Writing measures back to the data model 100. [PL-300-3,PL-300] Question 41 Page level filter Visual level filter Report level filter Query level filter 101. [PL-300-3,PL-300] Question 34 TRUE FALSE 102. [PL-300-3,PL-300] Question 3 Yes No 103. [PL-300-4,PL-300] Question 28 i / ii / iii ii / iii / v i / iv / iii ii / iv / v 104. [PL-300] Question 48 Which of the following can't be seen from the data lineage view in Power BI? Where gateways are being utilized as a data source for datasets The credentials utilized to connect to datasets Where the dataflows are being utilized as a data source for datasets The data sources that are being utilized by the dashboards/reports/datasets in a workspace 105. [PL-300-2,PL-300] Question 63 The value of the formula will be the same value as the State column 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 “Los Angeles“ The value of the formula will be “LA“ 106. [PL-300-2,PL-300] Question 26 Custom streaming Data Image Text box Web content Video 107. [PL-300-3,PL-300] Question 7 Scatter Area Key influencers Decomposition tree 108. [PL-300-2,PL-300] Question 5 Dashboards can have only a single page while reports can have multiple pages Both Dashboards and Reports can have multiple pages Reports can have only a single page while Dashboards can have multiple pages Reports can be refreshed to display the latest data while the Dashboards can’t Dashboards can be refreshed to display the latest data while the reports can’t Both reports and dashboards can be refreshed to display the latest data 109. [PL-300-2,PL-300] Question 13 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 troubleshoot the flow of data from its source to its destination It allows the users to manage the workspaces and analyze the impact of a single change in one dataset to dashboards and reports 110. [PL-300-4,PL-300] Question 31 No / Yes / No Yes / Yes / Yes Yes / No / Yes No / No / Yes 111. [PL-300-2,PL-300] Question 40 It automatically considers the relationship as one to one (instead of one to many or many to one) It considers that there are no null or blank values in any data table in the relationships 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 112. [PL-300-2,PL-300] Question 20 True False 113. [PL-300-2,PL-300] Question 39 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 All of the above Whenever you do interact with the report, the context in which the measure calculates and shows its results changes 114. [PL-300-3,PL-300] Question 15 No Yes 115. [PL-300-3,PL-300] Question 28 Monospaced Column distribution Column quality Column profile 116. [PL-300-2,PL-300] Question 53 Restrictions to specific measures within Power BI reports to some specific users Assigning the security permissions for the underlying Power BI Azure SQL Database Restricting data access for the given users ( By assigning users to roles) Adding the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO) All the above 117. [PL-300-2,PL-300] Question 13 It helps in analyzing the data sets and finding the patterns, trends, and outliers It simplifies the task of identifying the dashboards and reports that haven‘t been refreshed 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 118. [PL-300-2,PL-300] Question 20 True False 119. [PL-300-2,PL-300] Question 28 Bookmark Order Tab Order Layer Order Page Order Field Hierarchy 120. [PL-300-2,PL-300] Question 56 Extract previous Format Query Split Query Mark Query 121. [PL-300-2,PL-300] Question 35 Use “Rename Column” Modify the query to use the “Import Connection” mode Delete the “Remove Duplicates” steps From Power Query, choose the “Unpivot Columns” command Modify the query to use “Direct Query” mode 122. [PL-300-4,PL-300] Question 9 Select paginated report and configure the settings Create a slicer for category on each page and then Sync slicers on all pages Add a page level filter on all five pages Use a single button and set the action type to bookmark Create a report level filter using category in the Filter all pages’ well 123. [PL-300-3,PL-300] Question 14 Yes No 124. [PL-300-3,PL-300] Question 49 Dashboards provide a better interactive filtering and drill down experience. Dashboards update automatically whenever the data in the underlying data set is updated. Dashboards support using the Natural Language Q&A features of Power BI. Dashboard provide support for data-driven alerts. 125. [PL-300-2,PL-300] Question 59 Modify the default visual interaction from cross highlighting to cross-filtering Permit the users to include the comments in the report Don’t permit the end users to save filters on the report Enable the modified filter pane and display the filters in the visual header of the report Select the type of data you want to allow the end-users to export 126. [PL-300-3,PL-300] Question 22 Add sticky notes Add comments Add to group email Add to alerts 127. [PL-300-2,PL-300] Question 3 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 None of these Implementing Dynamic row-level security Creating a product_category slicer in the report 128. [PL-300-2,PL-300] Question 9 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 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 open Q&A tooling where they can configure the underlying natural language engine An icon that can be selected by the users to automatically create a custom tooltip 129. [PL-300-4,PL-300] Question 35 Use the Import storage mode for the dataset Only use line charts for visuals Create a summary table in the source data grouped by weekly volumes Use the Direct Query storage mode for the dataset Do not use tab or layer order 130. [PL-300-4,PL-300] Question 16 Merge queries as new Append queries Append queries as new Merge queries 131. [PL-300-2,PL-300] Question 42 You need to install RStudio 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 Microsoft R on your system at which Power BI Desktop is already installed R scripting is by default available in Power BI Desktop. You don’t need to perform any special action to use R scripting 132. [PL-300-2,PL-300] Question 11 Donut Chart Funnel chart Key influencers Q&A visualization 133. [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? TOP N UPPER N Basic Advanced 134. [PL-300-2,PL-300] Question 60 Reports offer a better interactive drill down and filtering experience Report definitions are possible to save using PBIX, an external file format, and checked into source control Report offers storytelling capability with the help of bookmarks Reports offer a better real-time experience while showing data from a streaming dataset Reports update automatically whenever the data of the underlying dataset is updated 135. [PL-300-2,PL-300] Question 45 Editing tables from the Power Query in Power BI Desktop Editing synonyms from the Power BI Desktop Editing synonyms from the Power BI service Editing Relationships from the Power BI Desktop 136. [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. True False 137. [PL-300-2,PL-300] Question 29 Optimize the DAX expressions to iterate through fewer rows Restrict the number of data points shown in a visual for example in a table with the help of the Top N filter Split out the dimensions and associated attributes into their own tables minimizing the number of columns within a fact tables 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 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. 138. [PL-300-2,PL-300] Question 48 Creating a report in another workspace depending upon the dataset of this workspace Creating, editing, or deleting the content in the workspace Adding or removing the other users from the workspace Scheduling the data refreshes Publishing workspace content in the app 139. [PL-300-2,PL-300] Question 36 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 Append queries and disable loading the query to the data model 140. [PL-300-2,PL-300] Question 8 Add a Scholarship_amount to the Visual Filters Add a Scholarship_amount to the drill through fields Add a Scholarship_amount to the Tooltips None of the above 141. 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 142. [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 tenant settings from the Power BI admin portal and set the API permissions Go to Office 365 Admin portal and register a web application Go to app.powerbi.com and build an empty report Go to dev.powerbi.com/apps and register an application 143. [PL-300-2,PL-300] Question 41 Funnel Visual Decomposition tree visuals Waterfall Visual Key Influencer Visual Combo visual 144. [PL-300-2,PL-300] Question 49 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 Performing some calculations in the original data source Pulling the data only into Power BI Service, nor Power BI Desktop 145. [PL-300-2,PL-300] Question 9 A pre-populated list of suggested Questions 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 146. [PL-300-2,PL-300] Question 57 Removing unnecessary columns and rows can damage the structure of your data model All of the above You should not delete unnecessary columns and rows as it’s always a preferable practice to all the metadata intact 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 147. [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 148. [PL-300-2,PL-300] Question 46 To conduct what-if analysis with built-in parameters To automatically analyze the chosen dimensions to check where the measure is having the lowest or highest value To conduct root cause analysis To show the beginning and ending headcount for the organization in a year To visualize the data across multiple dimensions 149. [PL-300-3,PL-300] Question 60 Allows you to edit any relations between merged queries in Power Query Automatically normalises your data model Allows you to edit relationships in the Data Analysis Expressions (DAX) data model Allows you to define relationships for SQL tables to improve query performance 150. [PL-300-3,PL-300] Question 33 In the Admin portal, go to tenant settings and disable ‘Allow content sharing with external users’ In the Admin portal, enable ‘Block embedded links’ In the Admin portal, go to tenant settings and disable ‘Publish to web’ In the Admin portal, disable ‘Allow URL links’ 151. [PL-300-4,PL-300] Question 17 Temporarily disable the tenant setting for custom visualization Add the custom visuals to the organizational store Use Power BI Desktop .pbiviz files with the custom visual Build a separate Power BI service instance for the custom visual 152. [PL-300-4,PL-300] Question 30 VAR SalesLastMonth = CALCULATE([Sales Total], PARALLELPERIOD (‘Date‘[Date],-1,QUARTER)) VAR SalesPercentageChange = DIVIDE([Sales Total]-SalesLastMonth,SalesLastMonth) Return SalesPercentageChange VAR SalesLastMonth = CALCULATE([Sales Total], SAMEPERIODLASTYEAR (‘Date‘[Date]) ) VAR SalesPercentageChange = DIVIDE([Sales Total]-SalesLastMonth,SalesLastMonth) Return SalesPercentageChange VAR SalesLastMonth = CALCULATE([Sales Total],DATEADD(‘Date‘[Date],-1,MONTH)) VAR SalesPercentageChange = Sales Total-SalesLastMonth Return SalesPercentageChange VAR SalesLastMonth = CALCULATE([Sales Total],DATEADD(‘Date‘[Date],-1,MONTH)) VAR SalesPercentageChange = DIVIDE([Sales Total]-SalesLastMonth,SalesLastMonth) Return SalesPercentageChange 153. [PL-300] Question 21 Which of the following visualization charts would you create to meet the requirements of Sales Managers? KPI Card Key influencers Funnel chart Pie Chart 154. [PL-300] Question 7 Which of the following are the valid reasons to design your data model as a star schema? Having a Date dimension is a recommended practice methodology to perform time intelligence in Power BI Only Models designed with Star Schema can be published to Power BI service It permits one to many relationships, which is the most recommended relationship type in Power BI, between the tables Star Schema minimizes data redundancy by avoiding the repetition of data values as much as possible Performance as filtering on dimension rows, which are fewer, is generally faster than filtering directly on a larger fact table It makes it clear to the end-users or the report builders which business attributes or entities they can slice and dice by 155. [PL-300] Question 19 Which of the following reserved parameters respectively configure the start and end of where Incremental refresh should happen? RefreshStart and RefreshEnd parameters Start and End parameters StartRefresh and EndRefresh parameters StartRange and EndRange parameters RangeStart and RangeEnd parameters 156. [PL-300-3,PL-300] Question 31 Add the user’s email to the workspace and change the role to a member Add the user to the Azure Active Directory for the Equipment Category In Power BI Service, add the new user’s email address to the Equipment category In Power BI Desktop, change the DAX filter for the role for the Equipment category 157. [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? Convert to DirectQuery to access the data warehouse Building an application for monitoring the changes in the database and pushing them out utilizing the real-time streaming API Migrating the content to Power BI Premium Adding an SSAS tabular layer on top and enabling the Live connections 158. [PL-300-4,PL-300] Question 7 Create a separate workspace for each department and create a report in each Create a separate dataset for each department and add a separate report Create separate Power BI Desktop report for each department and email the PBIX file Add a parameter to the report to filter department 159. [PL-300-4,PL-300] Question 22 Indicator: Sales Units Last Year , Trend axis: Fiscal Month , Target Goals: Sales Units This year Indicator: Sales Units This Year , Trend axis: Fiscal Year , Target Goals: Sales Units Last year Indicator: Sales Units This Year , Trend axis: Fiscal Month , Target Goals: Sales Units Last year Indicator: Sales Units This Year , Trend axis: Fiscal Month , Target Goals: Sales Units This year 160. [PL-300-2,PL-300] Question 38 False True 161. [PL-300-4,PL-300] Question 56 Invite external guests through the Azure Active Directory B2B Modify the workspace permissions to allow for the external users Go to the Power BI admin tenant setting and add the emails for the external users Click share directly from the dashboard 162. [PL-300-2,PL-300] Question 64 Use conditional formatting with a Color scale and check the diverging setting Use conditional formatting with Rules Use conditional formatting with Field values Use conditional formatting with a Color scale using default settings 163. [PL-300-2,PL-300] Question 18 You can create multiple relations between two tables but only one of these relations can be marked as active At least 1 column defined in a table relation needs to have unique values 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 You can create multiple relations between two tables and all these relations can be marked as active 164. [PL-300-2,PL-300] Question 10 Bar chart Scatter Chart Donut chart Line Chart 165. [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 166. [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. These issues can be resolved but none of the given issues will resolve the problem 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 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 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 167. [PL-300-3,PL-300] Question 32 node.js C++ R python 168. [PL-300-2,PL-300] Question 43 Bookmark Comments Subscribe Feedback Mark as favorite 169. [PL-300-2,PL-300] Question 48 Scheduling the data refreshes Adding or removing the other users from the workspace Creating a report in another workspace depending upon the dataset of this workspace Creating, editing, or deleting the content in the workspace Publishing workspace content in the app 170. [PL-300-2,PL-300] Question 63 The value of the formula will be “LA“ The value of the formula will be “Los Angeles“ The value of the formula will be the same value as the State column The value of the formula will either be “Los Angeles“ or whatever the value for the State column is 171. [PL-300-2,PL-300] Question 50 Column1: Capitalize Each Word Column2: Trim Column1: Clean White Spaces Column2: Trim Column1: Trim Column2: Clean Column1: Capitalize Each Word Column2: Clean Column1: Clean White Spaces Column2: Clean Column1: Length Column2: TRIM 172. [PL-300-3,PL-300] Question 46 Create one report for each category manager, with a different category filter in each report, and a separate report for the CEO. Your solution must involve minimal effort. Create a category slicer in the report. Implement Dynamic row-level security 173. [PL-300-3,PL-300] Question 18 Add to organizational visuals Place a request to Microsoft to add the custom visual to the standard charts Temporarily allow all visuals Reproduce the visual in R or Python 174. [PL-300-2,PL-300] Question 32 A date field is needed on a table in the dataset Use Incremental Refresh feature only for the data sources supporting query folding RangeStart and RangeEnd are two PowerQuery parameters that are needed for the incremental Refresh Use Incremental Refresh feature for all data sources 175. [PL-300-2,PL-300] Question 55 CONTAINSSTRING REPT CONTAINSSTRINGEXACT FIND TRIM SEARCH 176. [PL-300-3,PL-300] Question 38 Create the measure from any table, and then set the Home Table properties to Sales. On the Fields list, click the ellipsis next to the Sales table or right-click any field in the Sales table, and then click New Measure. Select the Sales table in the Fields list, and then click New Measure in the Modeling ribbon. Click New Measure, and then type in the formula Home Table = Sales 177. [PL-300-3] Question 36 Donut Waterfall Stacked Area Histogram 178. [PL-300-2,PL-300] Question 26 Video Text box Web content Image Custom streaming Data 179. [PL-300-2,PL-300] Question 37 1-5-4-3-2 1-2-3-4-5 5-4-3-2-1 1-3-2-4-5 1-2-5-4-3 180. [PL-300-2,PL-300] Question 18 A relation between two tables can be created using multiple fields from every table You can create multiple relations between two tables but only one of these relations can be marked as active A relation between two tables must be created using a single field from every table You can create multiple relations between two tables and all these relations can be marked as active At least 1 column defined in a table relation needs to have unique values 181. [PL-300-2,PL-300] Question 39 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 182. [PL-300-2,PL-300] Question 56 Extract previous Format Query Split Query Mark Query 183. [PL-300-2,PL-300] Question 29 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. 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 Restrict the number of data points shown in a visual for example in a table with the help of the Top N filter Optimize the DAX expressions to iterate through fewer rows Split out the dimensions and associated attributes into their own tables minimizing the number of columns within a fact tables 184. [PL-300-2,PL-300] Question 14 Power BI Report Builder Power BI Desktop optimized for Report Server Power BI desktop optimized for Paginated reports Power BI Desktop 185. [PL-300-2,PL-300] Question 32 Use Incremental Refresh feature for all data sources A date field is needed on a table in the dataset 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 186. [PL-300-2,PL-300] Question 54 Integer Column Table Character Row 187. [PL-300-3,PL-300] Question 35 A Slicer visual based on a Date column can be configured to use slider controls. A Slicer visual is used on Power BI reports to provide the report consumer with interactive filtering behavior. A Slicer visual from a Power BI report can be pinned to a dashboard to make the dashboard interactive. When adding a field to the Field well of a Slicer visual, you can use either a column or a measure. 188. [PL-300-2,PL-300] Question 58 By adding the command “pyplot.show()” to the script By refreshing the dataset origin connection By enabling the python visuals before code is run By refreshing the IDE settings 189. [PL-300-2,PL-300] Question 54 Character Integer Row Column Table 190. [PL-300-4,PL-300] Question 48 AVERAGEX( Transport, Transport[Freight ($)] + Transport[Surcharge ($)]) AVERAGEA( Transport, Transport[Freight ($)]) AVERAGE( Transport, Transport[Freight ($)] + Transport[Surcharge ($)]) SUMX(Transport, Transport[Freight ($)] + Transport[Surcharge ($)]) 191. [PL-300-3,PL-300] Question 45 Add an extra outer DIV with a style width:auto and height:auto value Remove the allowfullscreen parameter from the code Videos are fixed size and can't expand to fit tiles Change the iFrame width and height attribute values to 100% 192. [PL-300-2,PL-300] Question 8 Add a Scholarship_amount to the Visual Filters None of the above Add a Scholarship_amount to the Tooltips Add a Scholarship_amount to the drill through fields 193. [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 Change the Aggregate Value Function of the Pivot Use Remove Errors for Column3 Rename column3 194. [PL-300-4,PL-300] Question 5 Analyze -> Sales[Sales Quantity]; Explain by -> Product[Category]; Expand by -> Product[Color] Analyze -> Sales[Sales Amount]; Explain by -> Product[Category], Product[Color] Analyze -> Sales[Sales Quantity]; Explain by -> Product[Category], Product[Color] Analyze -> Sales[Sales Amount]; Expand by -> Product[Category], Product[Model] 195. [PL-300-2,PL-300] Question 17 Query B and Query D Query B only Query A to Query C Query A to Query D Query D only 196. [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 197. [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] CALCULATETABLE, FILTER and Orders[ShippedDate]>=Orders[RequiredDate] FILTER, CALCULATE, and Orders[ShippedDate]=Orders[RequiredDate] CALCULATE, FILTER and Orders[ShippedDate]>Orders[RequiredDate] 198. [PL-300-2,PL-300] Question 24 Visualization: A scatter Plot for Unit_price and Quantity_ordered by item and Feature: Automatically Finds Clusters Visualization: A column chart for Unit_Price and Quantity_ordered by year and Feature: Automatically finds clusters Visualization: A column chart for Unit_Price and Quantity_ordered by year 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 Visualization: A scatter Plot for Unit_price and Quantity_ordered by item and Feature: Find where the distribution is different 199. [PL-300-4,PL-300] Question 27 SUM(sales[Sales Amount]) + SUM(sales[Sales Tax]) SUMX(sales,if(sales[OrderDate]>=DATE(2018,1,1),sales[Sales Amount]+sales[Sales Tax],sales[Sales Amount]) ) SUM(sales,if(sales[OrderDate]>=‘1/1/2018’,sales[Sales Amount]+sales[Sales Tax],sales[Sales Amount]) SUMX(filter(sales,sales[OrderDate]>=DATE(2018,1,1)),sales[Sales Amount]+sales[Sales Tax]) 200. [PL-300-2,PL-300] Question 42 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 201. [PL-300-4,PL-300] Question 26 Create a line chart and add month to the axis well Create a tree map and add month to the details well Create a waterfall chart and add month to the breakdown well Create a scatter chart and add month to the play axis well 202. [PL-300-3,PL-300] Question 39 To improve the speed and performance of an existing table To perform different types of merge join To union tables To create a table based on the result of a function or formula 203. [PL-300-2,PL-300] Question 38 False True 204. [PL-300-2,PL-300] Question 35 Use “Rename Column” From Power Query, choose the “Unpivot Columns” command Modify the query to use the “Import Connection” mode Modify the query to use “Direct Query” mode Delete the “Remove Duplicates” steps 205. [PL-300-2,PL-300] Question 21 Salary_cost for the Year 2019 as DAX Filter overrides Slicer Selection It will return Salary_cost records for the year 2019 as well as 2020 Blank. It will return no records Salary_cost for the Year 2020 as Slicer Selection overrides DAX Filter 206. [PL-300-4,PL-300] Question 41 You can take a piece of text and return a list of key phrases You can build your own machine learning models and use them in Power BI desktop Sentiment Analysis is available for select languages You cannot use Power BI to tag images The decomposition tree requires a premium subscription 207. [PL-300-3,PL-300] Question 5 CALENDAR( DATE(2010,11,1), DATE(2025,12,31) ) CALENDAR( 2010/11/1, 2025/12/31) CALCULATE( CALENDAR( 2010/11/1’, 2025/12/31’) ) DATE ( 2010/11/1, 2025/12/31) 208. [PL-300] Question 39 How can you ensure that datasets are up-to-date in Power BI? Manually refresh each dataset Use a live connection to the data source Use a direct query to the data source Use a scheduled refresh 209. [PL-300-4,PL-300] Question 40 Yes / No / No Yes / No / Yes Yes / Yes / No No / No / Yes 210. [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,4 2,8 1,2 4,16 4,1 211. [PL-300-2,PL-300] Question 32 Use Incremental Refresh feature only for the data sources supporting query folding RangeStart and RangeEnd are two PowerQuery parameters that are needed for the incremental Refresh Use Incremental Refresh feature for all data sources A date field is needed on a table in the dataset 212. [PL-300-2,PL-300] Question 41 Funnel Visual Key Influencer Visual Combo visual Waterfall Visual Decomposition tree visuals 213. [PL-300-3,PL-300] Question 19 Yes No 214. [PL-300-2,PL-300] Question 49 Performing some calculations in the original data source Pulling the data only into Power BI Service, nor Power BI Desktop 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 215. [PL-300-2,PL-300] Question 23 Implement row-level security to allow the report recipients to only to view the results depending upon the emails they sent During the import, Remove the columns Subject and Body Implementing Dynamic row-level security Through Model view, set the columns Subject and Body to Hidden 216. [PL-300-2,PL-300] Question 25 Background color for the report Default features of the new visuals which are included in the report Set of the custom colors that are utilized by the visuals throughout the report All of these 217. [PL-300-2,PL-300] Question 30 a-b-c-f-g a-g-f-d g-a-f-d a-b-c-e-g a-c-b-g-h 218. [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? ALL WHOLEYEAR FILTER ENDOFYEAR FIRSTDATE 219. [PL-300-2,PL-300] Question 20 False True 220. [PL-300-2,PL-300] Question 16 DataFrame Record List Table Function Type 221. [PL-300-2,PL-300] Question 10 Scatter Chart Bar chart Donut chart Line Chart 222. [PL-300-2,PL-300] Question 51 False True 223. [PL-300-2,PL-300] Question 36 Append queries and delete the queries Merge queries as new and disable loading the query to the data model Merge 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 disable loading the query to the data model Merge queries and delete the queries 224. [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 Create another table named Area and make a relationship between Area and Registrations Tables By adding a column that has longitude and latitude Choose the Country field and change the data type from the Modeling tab 225. [PL-300-2,PL-300] Question 22 USERELATIONSHIP RELATEDTABLE TREATAS RELATED CROSSFILTER 226. [PL-300-2,PL-300] Question 47 Data type for the column that is utilized for data partition has changed Query folding is not happening You chose only to refresh the complete periods No filter is applied to the file 227. [PL-300-2,PL-300] Question 1 Define the sensitivity label for the dataset Change the credentials used for connecting to the underlying data source Modify query editor parameter values Check the cardinality for the columns in the dataset Mark the dataset as certified or promoted 228. [PL-300-2,PL-300] Question 25 All of these Background color for the report 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 229. [PL-300-4,PL-300] Question 12 Run an R script to determine the performance issues in report elements Use the cross report drillthrough feature to examine performance across the report Use the Performance Analyzer to examine report element performance Use the Dataverse button to drill into likely performance issues 230. [PL-300-4,PL-300] Question 45 Add a personal gateway to your organization’s dataset Add a streaming tile to your dashboard Configure incremental refresh Adjust the time zone in the tenant setting 231. [PL-300-2,PL-300] Question 62 Change the visual from the table to Matrix Reduce the table size by grouping the rows Create a customize tooltip Expand the table to the whole page Create a paginated report 232. [PL-300-2,PL-300] Question 2 Private Confidential Public Organizational 233. [PL-300-2,PL-300] Question 24 Visualization: A scatter Plot for Unit_price and Quantity_ordered by item and Feature: Find where the distribution is different Visualization: A scatter Plot for Unit_price and Quantity_ordered by item and Feature: Automatically Finds Clusters Visualization: A column chart for Unit_Price and Quantity_ordered by year and Feature: Automatically finds clusters Visualization: A column chart for Unit_Price and Quantity_ordered by year 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 234. [PL-300-2,PL-300] Question 13 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 simplifies the task of identifying the dashboards and reports that haven‘t been refreshed It allows the users to troubleshoot the flow of data from its source to its destination 235. [PL-300-3,PL-300] Question 30 Set the storage mode on the crypto transaction table to DirectQuery Create a summary table in the data source with the transactions grouped by month Limit visuals to bar and line charts Set the storage mode on the crypto transaction table to Import 236. [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 Line chart Scatter chart 237. [PL-300-2,PL-300] Question 3 Creating a product_category slicer in the report 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 Implementing Dynamic row-level security None of these 238. [PL-300-3,PL-300] Question 23 Use Track user activities Remove the HR manager from the role and re-assign Validate the HR manager’s role using View as’ and select the region Send the user your Power BI Desktop file 239. [PL-300-3,PL-300] Question 42 Size X Axis Y Axis Category 240. [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 Edit interactions in the report and set all interactions to Filter Edit the dashboard theme and pin each chart as a tile Pin the report page as a live tile 241. [PL-300-2,PL-300] Question 23 Implement row-level security to allow the report recipients to only to view the results depending upon the emails they sent Implementing Dynamic row-level security During the import, Remove the columns Subject and Body Through Model view, set the columns Subject and Body to Hidden 242. [PL-300-3,PL-300] Question 20 Yes No 243. [PL-300-4,PL-300] Question 52 Column histogram Column distribution Column profile Column quality 244. [PL-300-2,PL-300] Question 37 1-2-5-4-3 1-3-2-4-5 1-5-4-3-2 5-4-3-2-1 1-2-3-4-5 245. [PL-300-4,PL-300] Question 33 Select the fermentation time column, right click and select New Group -> Set Group type to Bin -> Set the Bin type to number of bins -> Make the bin count 6up type to Bin -> Set the Bin type to number of bins -> Make the bin count 6 Select the fermentation time column, right click and select New Group -> Set the Bin type to count of bins -> Set Group type to Bin -> Make the bin size 6 Set Group type to list -> Select the fermentation time column, right click and select New Group -> Set the Bin type to number of bins -> Make the bin count 30 Select the fermentation time column, right click and select New Group -> Set Group type to Bin -> Make the bin count 30 -> Set the Bin type to number of bins 246. [PL-300-2,PL-300] Question 52 Use the “Remove Errors“ command for the Courses table Use the “Remove Duplicates“ command for the Courses table Use the “Remove Duplicates“ command for the Teachers table Filter out the blank values from the Teachers table Add a new index column “Teacher Name” to the table Courses 247. [PL-300-4,PL-300] Question 20 Use Microsoft Power Automate to trigger additional actions Send a notification to mobile Use Microsoft Dataverse alert API Send an email 248. [PL-300-2,PL-300] Question 46 To conduct root cause analysis To automatically analyze the chosen dimensions to check where the measure is having the lowest or highest value To show the beginning and ending headcount for the organization in a year To visualize the data across multiple dimensions To conduct what-if analysis with built-in parameters 249. [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 Pie, doughnut, bar, line Bar, column, area and line 250. [PL-300-2,PL-300] Question 21 Salary_cost for the Year 2019 as DAX Filter overrides Slicer Selection 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 Blank. It will return no records 251. [PL-300-3,PL-300] Question 54 Fit to page Actual Size Full Screen Fit to Width 252. [PL-300-3,PL-300] Question 50 Reports provide story telling capabilities using bookmarks. Report definitions can be saved using an external file format (PBIX) and checked into source control. Reports provide a better real-time experience when displaying data from a streaming dataset. Reports provide a better interactive filtering and drilldown experience 253. [PL-300-4,PL-300] Question 4 Stacked column chart Card chart Funnel chart Gauge chart KPI chart 254. [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 and reports Only dataflows Only dashboards Only datasets All including reports, datasets, dataflows, and dashboards Only reports 255. [PL-300-3,PL-300] Question 27 Switch off interactions between visuals Switch off single select under slicers Under relationships, turn off security filters in both directions Remove any background images 256. [PL-300-3,PL-300] Question 11 Create several images and assign a bookmark Change the orientation to Horizontal and change the background color Change the orientation to Horizontal and toggle Responsive on Add individual buttons and assign actions to each 257. [PL-300-4,PL-300] Question 49 Column distribution Monospaced Column profile Column quality 258. [PL-300-3,PL-300] Question 24 From Get data, select SharePoint folder, navigate to the specific folder, select import or DirectQuery and specify any custom SQL code From Get data, select SharePoint folder, enter the URL and click import From Get data, enter the URL, select SharePoint folder and navigate to the specific folder From Get data, select SharePoint folder, enter the URL, navigate to the specific folder and Combine & Transform Data 259. [PL-300-2,PL-300] Question 50 Column1: Clean White Spaces Column2: Trim Column1: Length Column2: TRIM Column1: Capitalize Each Word Column2: Clean Column1: Trim Column2: Clean Column1: Capitalize Each Word Column2: Trim Column1: Clean White Spaces Column2: Clean 260. [PL-300-2,PL-300] Question 12 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 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 Certification is the ideal way to endorse the dataset when the dataset is ready for broad usage In terms of permission, there is no difference between promotion and certificationright 261. [PL-300-2,PL-300] Question 17 Query B only Query A to Query D Query D only Query A to Query C Query B and Query D 262. [PL-300-2,PL-300] Question 61 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 any type of visual You can set Data alerts in both Power BI Desktop and Power BI Service on any type of visual 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 only in the Power BI service on any type of visual 263. [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 be shared with other users Personal workspaces can only be accessed by the owner Shared workspaces can be edited by multiple users 264. [PL-300-2,PL-300] Question 16 Table List Type DataFrame Record Function 265. [PL-300-2,PL-300] Question 26 Text box Image Custom streaming Data Video Web content 266. [PL-300-4,PL-300] Question 6 Show whitespace Column profile Column quality Column distribution Monospaced 267. [PL-300-3,PL-300] Question 47 FALSE TRUE 268. [PL-300-4,PL-300] Question 29 Create a new dashboard for every new request and pin the new tiles On the report page, select embed in dashboard Create a hyperlink for the tiles and select embed in dashboard Pin the report page as live to the dashboard 269. [PL-300-2,PL-300] Question 44 Add a button for every business query and set the action type to Bookmark Add filters to the menu page None of the above Add a text box for every business query and insert a link Build a Power Apps visual containing a drop-down list. This list will consist of all business queries 270. [PL-300-2,PL-300] Question 33 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 271. [PL-300-3,PL-300] Question 48 Streaming Datasets Push Datasets Hybrid Datasets 272. [PL-300-3,PL-300] Question 55 To allow refreshing on-premises data sources from the Power BI Report Server To allow the rendering of mobile reports outside of the corporate network To store SSAS tabular models locally To allow refreshing on-premises data sources from the Power BI Service 273. [PL-300-3,PL-300] Question 53 Duplicate Name Synonyms Alternative 274. [PL-300-2,PL-300] Question 12 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 needs permission from the dataset owner or admin to access the dataset whereas Certification does not require specific permissions from the admin, whereas Certification Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset 275. [PL-300-3,PL-300] Question 1 Add a Play Axis to the visual Add a Forecast line in the Analytics pane Add a Trend line in the Analytics pane Add an Average line in the Analytics pane 276. [PL-300-4,PL-300] Question 24 Yes / No / No No / Yes / No Yes / Yes / Yes Yes / Yes / No 277. [PL-300-2,PL-300] Question 19 No Yes 278. [PL-300-2,PL-300] Question 5 Both reports and dashboards can be refreshed to display the latest data Dashboards can be refreshed to display the latest data while the reports can’t Reports can have only a single page while Dashboards can have multiple pages Both Dashboards and Reports can have multiple pages Reports can be refreshed to display the latest data while the Dashboards can’t Dashboards can have only a single page while reports can have multiple pages 279. [PL-300-3,PL-300] Question 52 ?navigationPane=false ?navigationPane=collapsed ?collapseNavigation=true ?collapseNavigation=collapsed 280. [PL-300-2,PL-300] Question 43 Comments Subscribe Bookmark Mark as favorite Feedback 281. [PL-300-2,PL-300] Question 46 To conduct what-if analysis with built-in parameters To visualize the data across multiple dimensions To show the beginning and ending headcount for the organization in a year To automatically analyze the chosen dimensions to check where the measure is having the lowest or highest value To conduct root cause analysis 282. [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? Split the Logged column by using at as the delimiter 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. 283. [PL-300-2,PL-300] Question 30 g-a-f-d a-b-c-f-g a-b-c-e-g a-g-f-d a-c-b-g-h 284. [PL-300-2,PL-300] Question 42 You need to install R Plug-in for 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 RStudio on your system at which Power BI Desktop is already installed You need to install Microsoft R on your system at which Power BI Desktop is already installed 285. [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? Dataflows SQL Server database Microsoft Teams Personal Analytics Dataverse 286. [PL-300] Question 5 Why is it advised to avoid the NULL values in the numeric column? All the above DAX expression having MAX function on such data will provide incorrect results DAX expression having an AVERAGE function on such data will provide incorrect results 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 287. [PL-300-2,PL-300] Question 11 Q&A visualization Donut Chart Key influencers Funnel chart 288. [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? 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. Request that the sales manager be added to the correct Azure Active Directory group. Manage the permissions of the underlying dataset. 289. [PL-300-2,PL-300] Question 34 See the data model in Relationships or model view in Power BI Desktop Writing report level measures (specific only to that report, not written back to the Data Model) Edit or simply view the DAX measures existing in the data model Writing measures back to the data model 290. [PL-300-4,PL-300] Question 38 Create a blank report page -> Restart Power BI -> Open performance analyzer and press start recording -> Ineract with the visuals -> Press stop and review results Restart Power BI -> Open performance analyzer and press start recording -> Check enable diagnostics logging -> Press stop and review results Create a blank report page -> Restart Power BI -> Click on SQL Server diagnostics -> Ineract with the visuals -> Press stop and review results Restart Power BI -> Open query diagnostics and press start recording -> Ineract with the visuals -> Press stop and review results 291. [PL-300-2,PL-300] Question 8 None of the above Add a Scholarship_amount to the drill through fields Add a Scholarship_amount to the Tooltips Add a Scholarship_amount to the Visual Filters 292. [PL-300-2,PL-300] Question 7 With a customized tooltip, any image or color can be set as the background for the visual It can demonstrate the value and category of the data points With a customized tooltip, a border can be created around the visual for isolating the visual from other elements on the canvas It can demonstrate the images, visuals, and any other collection of items that are created by the user on the report page 293. [PL-300-2,PL-300] Question 22 USERELATIONSHIP TREATAS CROSSFILTER RELATEDTABLE RELATED 294. [PL-300-4,PL-300] Question 43 Dual / Import / DirectQuery Import / Import / Live Connection Dual / Import / Live Connection Import / Import / DirectQuery 295. [PL-300-2,PL-300] Question 33 Workspaces can be used to house dashboards and reports for use by multiple teams Workspaces allow you to view and edit the data model, create visualizations and transform the data Workspaces ensure the highest level of security by controlling who can access the dashboards, reports, and datasets Workspaces allow you to share and present dashboards and reports in a single environment 296. [PL-300-2,PL-300] Question 28 Page Order Layer Order Field Hierarchy Tab Order Bookmark Order 297. [PL-300] Question 14 Which of the following statements are true regarding Slicer Visual in a Power BI report? The use of a slicer visual on Power BI reports is to offer the report consumers with interactive filtering behavior A slicer visual from the report can be pinned to a dashboard for making the dashboard interactive While adding a field to the Field Well of a slicer visual, you can use either a measure or a column You can configure the slicer visual based on the Date column to utilize slider controls All of the above 298. [PL-300-2,PL-300] Question 16 Record Type Function DataFrame Table List 299. [PL-300-2,PL-300] Question 56 Mark Query Extract previous Format Query Split Query 300. [PL-300-2,PL-300] Question 48 Creating, editing, or deleting the content in the workspace 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 Publishing workspace content in the app 301. [PL-300-3,PL-300] Question 17 SUMMARIZE EXCEPT INTERSECT CROSSJOIN 302. [PL-300-2,PL-300] Question 44 Add filters to the menu page None of the above Add a text box for every business query and insert a link Build a Power Apps visual containing a drop-down list. This list will consist of all business queries Add a button for every business query and set the action type to Bookmark 303. [PL-300-2,PL-300] Question 60 Report offers storytelling capability with the help of bookmarks Reports update automatically whenever the data of the underlying dataset is updated Reports offer a better real-time experience while showing data from a streaming dataset Reports offer a better interactive drill down and filtering experience Report definitions are possible to save using PBIX, an external file format, and checked into source control 304. [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 305. [PL-300-2,PL-300] Question 14 Power BI desktop optimized for Paginated reports Power BI Report Builder Power BI Desktop optimized for Report Server Power BI Desktop 306. [PL-300-2,PL-300] Question 17 Query A to Query D Query A to Query C Query D only Query B and Query D Query B only 307. [PL-300-2,PL-300] Question 47 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 You chose only to refresh the complete periods 308. [PL-300-2,PL-300] Question 10 Line Chart Bar chart Donut chart Scatter Chart 309. [PL-300-2,PL-300] Question 15 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 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 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 310. [PL-300-4,PL-300] Question 23 In the transformation, there is a promoted headers step that blocks the native query There is row-level security on the dataset You have used import as the storage mode Flat files do not support query folding 311. [PL-300-4,PL-300] <p>You are the Power BI admin at your company. You have assigned a colleague as a member role in your workspace.<br />What roles can she NOT perform?</p> You are the Power BI admin at your company. You have assigned a colleague as a member role in your workspace.What roles can she NOT perform? Update an app Update and delete the workspace Manage dataset permissions Allow others to reshare items 312. [PL-300-2,PL-300] Question 31 Configure Scheduled Refreshes Adding a new data source Creating a new table relationship Adding a new DAX measure If you are not the current owner, you can take over the dataset. View the refresh history 313. [PL-300-2,PL-300] Question 25 All of these 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 314. [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 sort order on any visualizations that have been set The list of visual types available in the visualization pane The visibility properties of fields in the report pane The visibility property of some selected visuals in the selection pane 315. [PL-300-4,PL-300] Question 37 Bookmarks / Edit interractions / Back button Edit interactions / Tab selection / Back button Tab selection / Format pane / Back button Edit interactions / Bookmarks / Back button 316. [PL-300] Question 42 How can you ensure that only authorized users have access to a dataset in Power BI? Use row-level security Use column-level security Use object-level security Use workspace-level security 317. [PL-300-3,PL-300] Question 13 Yes No 318. [PL-300-2,PL-300] Question 49 Combining the date and time columns in a single column Using SELECT SQL statement in SQL queries while pulling the data from a relational database Performing some calculations in the original data source Pulling the data only into Power BI Service, nor Power BI Desktop 319. [PL-300-2,PL-300] Question 43 Feedback Subscribe Bookmark Comments Mark as favorite 320. [PL-300-2,PL-300] Question 6 Tagging the user in a comment Sharing the dashboard to the user Creating a data alert Creating a subscription 321. [PL-300-4,PL-300] Question 14 Decomposition tree chart Key influencers chart Q&A chart Scatter chart 322. [PL-300-2,PL-300] Question 36 Append queries and delete the queries Append queries as new and disable loading the query to the data model Append queries and disable loading the query to the data model Merge queries and delete the queries Merge queries as new and disable loading the query to the data model Merge queries and disable loading the query to the data model 323. [PL-300-2,PL-300] Question 57 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 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 All of the above 324. [PL-300-2,PL-300] Question 47 Query folding is not happening No filter is applied to the file You chose only to refresh the complete periods Data type for the column that is utilized for data partition has changed 325. [PL-300-4,PL-300] Question 36 In the analytics pane, add a trendline In the chart values well, right click on sales and change the summarization to Median In the chart values well, right click on sales and change the show value as’ to a percent of grand total Create a new measure using the MEDIAN DAX function on the sales column Create a new measure using the Count (distinct) DAX function on the sales column 326. [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] c-a-d-e-b-f c-d-a-e-b-f a-c-b-d-e-f a-b-c-d-e-f a-c-b-e-d-f c-a-d-b-e-f 327. [PL-300-2,PL-300] Question 54 Column Character Row Integer Table 328. [PL-300-2,PL-300] Question 51 True False 329. [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? Bar Chart Pie Chart Scatterplot Funnel Chart 330. [PL-300-4,PL-300] Question 18 Word Sense Disambiguation Sentiment Analysis Language Detection Key Phrase Extraction 331. [PL-300-2,PL-300] Question 53 Restrictions to specific measures within Power BI reports to some specific users Assigning the security permissions for the underlying Power BI Azure SQL Database Restricting data access for the given users ( By assigning users to roles) Adding the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO) All the above 332. [PL-300-2,PL-300] Question 1 Check the cardinality for the columns in the dataset Modify query editor parameter values Mark the dataset as certified or promoted Change the credentials used for connecting to the underlying data source Define the sensitivity label for the dataset 333. [PL-300-4,PL-300] Question 19 In Power BI Service, change the Power BI workspace security and change the user’s email address to “contributor” Add the user to the Azure Active Directory for France In Power BI Desktop, edit the DAX expression on the role for France In Power BI Service, use “test as role” and use the email address of the new employee 334. [PL-300-3,PL-300] Question 59 Summing Aggregating List Grouping Binning 335. [PL-300-2,PL-300] Question 59 Permit the users to include the comments in the report Modify the default visual interaction from cross highlighting to cross-filtering Don’t permit the end users to save filters on the report Enable the modified filter pane and display the filters in the visual header of the report Select the type of data you want to allow the end-users to export 336. [PL-300-2,PL-300] Question 57 All of the above You should not delete unnecessary columns and rows as it’s always a preferable practice to all the metadata intact 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 337. [PL-300-2,PL-300] Question 60 Report definitions are possible to save using PBIX, an external file format, and checked into source control Reports offer a better interactive drill down and filtering experience Reports update automatically whenever the data of the underlying dataset is updated Reports offer a better real-time experience while showing data from a streaming dataset Report offers storytelling capability with the help of bookmarks 338. [PL-300-2,PL-300] Question 53 Restricting data access for the given users ( By assigning users to roles) Adding the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO) All the above Assigning the security permissions for the underlying Power BI Azure SQL Database Restrictions to specific measures within Power BI reports to some specific users 339. [PL-300-3,PL-300] Question 56 Row-level security Office 365 Groups Two factor authentication Query folding 340. [PL-300-2,PL-300] Question 1 Mark the dataset as certified or promoted Modify query editor parameter values Define the sensitivity label for the dataset Check the cardinality for the columns in the dataset Change the credentials used for connecting to the underlying data source 341. [PL-300-2,PL-300] Question 35 Use “Rename Column” Delete the “Remove Duplicates” steps Modify the query to use the “Import Connection” mode Modify the query to use “Direct Query” mode From Power Query, choose the “Unpivot Columns” command 342. [PL-300-2,PL-300] Question 18 At least 1 column defined in a table relation needs to have unique values A relation between two tables must be created using a single field from every table You can create multiple relations between two tables and all these relations can be marked as active A relation between two tables can be created using multiple fields from every table You can create multiple relations between two tables but only one of these relations can be marked as active 343. [PL-300-3,PL-300] Question 37 Cascading Style Sheets (CCS) Power BI Markup Language (PBIML) Extensible Markup Language (XML) JavaScript Object Notation (JSON) 344. [PL-300-4,PL-300] Question 3 Delete the active relationship and make the new relationship active Change the crossfilter direction to both in the modelling tab Use the LOOKUPVALUE() function Use the USERELATIONSHIP() function 345. [PL-300-2,PL-300] Question 7 It can demonstrate the value and category of the data points With a customized tooltip, a border can be created around the visual for isolating the visual from other elements on the canvas 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, any image or color can be set as the background for the visual 346. [PL-300-2,PL-300] Question 55 TRIM REPT FIND CONTAINSSTRINGEXACT CONTAINSSTRING SEARCH 347. [PL-300-3,PL-300] Question 58 Use the SUMMARIZE function in your DAX measures Convert to DirectQuery for your data connections Turn on run-length encoding and compression in the DAX storage engine Migrate your source database to Azure SQL database 348. [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 An M custom column A DAX calculated measure A DAX calculated column 349. [PL-300-3,PL-300] Question 10 Import all the data and then add a filter to the data Check HEAD to sample data from the advanced options Add a WHERE clause to SQL statement in the advanced options Change the data connectivity option to TOPN 350. [PL-300-2,PL-300] Question 34 Writing measures back to the data model Writing report level measures (specific only to that report, not written back to the Data Model) Edit or simply view the DAX measures existing in the data model See the data model in Relationships or model view in Power BI Desktop 351. [PL-300-2,PL-300] Question 3 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 352. [PL-300-3,PL-300] Question 43 Click on ellipses on Right Top Corner of visual -> Sort by - MonthNumber Right Click on field in report view and select sort by, then select MonthNumber Modeling -> Select Month Column -> Sort By - MonthNumber 353. [PL-300-2,PL-300] Question 24 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 Line 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: Find where the distribution is different 354. [PL-300-2,PL-300] Question 31 Creating a new table relationship Configure Scheduled Refreshes If you are not the current owner, you can take over the dataset. View the refresh history Adding a new DAX measure Adding a new data source 1 out of 8 TokTips PL-300 Exam – Practice 1 PL-300 Exam – Practice 3
