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