PL-300 Microsoft Power BI Certification Exam Questions with 100% correct answers 2024

You have a Power Bl workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do? A. Grant the Read permission for the datasets to the user. B. Add the user as a Viewer of the workspace. C. Share the reports with the user. D. Create a row-level security (RLS) role and add the user to the role. E. Add the user as a member of the workspace. B You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard. You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report. Which two actions should you perform? Each correct answer presents part of the solution. A. Use quick insights on the dashboard. B. Hide the report page. C. Ask a question by using Q&A. D. Add the visual to the report. E. Pin the visual to the dashboard. C+E You need to create a Power 31 theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do? A. From Power Bl Desktop, customize the current theme, B. From power Bl Desktop, use a built in report theme. C. Create a theme as a JSON file and import the theme into Power Bl Desktop. D. Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop. B You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group. Does this meet the goal? A. Yes B. No A Explanation: Statements and questions are tricky and confusing. When the access is granted for the group (all users) for ALL (each) dashboards and ALL (each) reports in the workspace, then the will have read access to the specific (A, one) Dashboard and several reports, because they are part of all dashboards and reports. There is no statement, that for the other dashboards (except the one) and the other reports (except the several) that access must be prevented. They are also accessible (maybe it is not desired but not stated here). You have a Power BI app named App1. The privacy for the App1 workspace is set to Private. A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account. You need to ensure that User sees App1 from the My organization AppSource. What should you do? A. From the app workspace, click Update app, configure the Content settings, and then click Update app. B. From the app workspace settings, add a member. C. From the app workspace, click Update app, configure the Access setting, and then click Update app. D. From the app workspace, share the dashboard. C You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table: The report will facilitate the following analysis: • The count of orders and the sum of total sales by Order Date • The count of customers who placed an order • The average quantity per order You need to reduce data refresh times and report query times. Which two actions should you perform? Each correct answer presents part of the solution. A. Fillet the data to only the NorthWest region sales territory. B. Remove the CustomerKey and ProductKey columns. C. Remove the TaxAmt and Freight columns. D. Set the data type for SatesOrderNumber to Decimal Number A+C In Power BI Desktop, you are building a sales report that contains twotables. Both tables have row-level security (RLS) configured. You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings. What should you do? A. Create an active relationship between the tables and select Assume referential integrity. B. Create an inactive relationship between the tables and select Assume referential integrity. C. Create an inactive relationship between the tables and select Apply security filter in both directions. D. Create an active relationship between the tables and select Apply security filter in both directions. D Explanation: By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID. Graphical user interface, application, Word Description automatically generated You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create? A. scarterplot B. bar chart C. piechart B You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do? A. Sync the slicers on Page1 and Page3 B. On each page, modify the interactions of the slicer. C. Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2. B You have a Power Bl report that uses row-level security (RLS). You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards. What should you do? A. Add the Azure network security team as members of the RLS role. B. Instruct the Azure network security team to create security groups. Configure RLS to use the groups. C. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team. D. Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team. B You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source? A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode. B. Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode. C. Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode. D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode. D You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Sync the slicers across the pages. B. Replace the slicers with page-level filters. C. Replace the slicers with visual-level filters. D. Create a bookmark for each slicer value. E. Replace the slicers with report-level filters. A+E Explanation: Add a report-level filter to filter an entire report. The visuals on the active page, and on all pages in the report, change to reflect the new filter. You can sync a slicer and use it on any or all pages in a report. * 1. On the Power BI Desktop View menu, select Sync slicers. The Sync slicers pane appears between the Filters and Visualizations panes. You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel. Does this meet the goal? A. Yes B. No A Explanation: Instead modify the source step of the queries to use DataSourceExcel as the file path. Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns. You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use to link the tables? A. one-to-many from Customer to Transaction B. one-to-one between Customer and Transaction C. one-to-many from Transaction to Customer D. many-to-many between Customer and Transaction A Explanation: Each customer can have many transactions. For each transaction there is exactly one customer. You have a sales system that contains the tables shown in the following table. The Date table is marked as a date table. DatelD is the date data type. You need to create an annual sales growth percentage measure. Which DAX expression should you use? A. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]) B. (SUM('Sales'[sales_amount]) - CALCULATE(SUM('Sales'[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]))) / CALCULATE(SUM('Sales'[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])) C. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DateID])) D. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])) B Explanation: SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context. You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of . The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend? A. Change any DAX measures to use iterator functions. B. Replace the default visuals with AppSource visuals. C. Change the imported dataset to DirectQuery. D. Remove unused columns from tables in the data model. C Explanation: DirectQuery: No data is imported or copied into Power BI Desktop. Import: The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data. Benefits of using DirectQuery There are a few benefits to using DirectQuery: DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation. Underlying data changes can require a refresh of data. For some reports, the need to display current data can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports always use current data. The 1-GB dataset limitation doesn't apply to DirectQuery. You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard', What should you do? A. Refresh the dataset used by Report1 and Dashboard1. B. Select Refresh visuals for Dashboard1. C. Edit the details for the dashboard tile Of Dashboar1. D. Pin the Sales by month bar chart to Dashboard1. A You need to grant all organizational users read access to a dashboard and several reports. Solution: You publish an app to the entire organization. Does this meet the goal? A. Yes B. No A You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette. You are creating a Power Bl dashboard that will include two visuals from each report You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports. Which two actions should you perform? Each correct answer presents part of the solution. B. Select the dark dashboard theme. C. Turn on tile flow. D. When pinning visuals to the dashboard, select Use destination theme. E. For the browser, set the color preference to dark mode. B+D You have a Microsoft SQL Server database that contains the following tables. The following columns contain date information: - Date[Month] in the mmyyyy format - Date[Date_ID] in the ddmmyyyy format - Date[Date_name] in the mm/dd/yyyy format - Monthly_returns[Month_ID] in the mmyyyy format The Order table contains more than one million rows. The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables. You plan to use Power BI Desktop to create an analytics solution for the data. You need to create a relationship between the Order table and the Store table on the Store_ID column. What should you do before you create the relationship? A. In the Order table query, use the Table.TrasformRows function. B. In the Store table query, use the Table.TrasformRows function. C. In the Store table query, use the Table.TrasformColumnTypes function. D. In the Order table query, use the Table.TrasformColumnTypes function. C You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What is possible way to achieve this goal? A. Add a salary to the tooltips. B. Add a salary to the visual filters. C. Add salary to the drillthrough fields. A You have the Power Bl model shown in the following exhibit. There are four departments in the Departments table. You need to ensure that users can see the data of their respective department only. What should you do? A. Create a row-level security (RLS) role for each department, and then define the membership of the role. B. Create a DepartmentID parameter to filter the Departments table. C. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function. D. Create a slicer that filters Departments based on DepartmentID. A You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access: • External users can access the dashboard. • Managers can access the dashboard and a manager-specific report. • Employees can access the dashboard and a row-level security (RLS) constrained report. You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised. What should you use? A. subscriptions B. comments C. alerts D. chat in Microsoft Teams A You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: You add a report-level filter that filters based on the order date. Does this meet the goal? A. Yes B. No B Explanation: The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement. You are building a Power Bl report that uses data from an Azure SQL database named erp1. You Import the following tables. You need to perform the following analyses: • Orders sold over time that include a measure of the total order value • Orders by attributes of products sold The solution must minimize update times when interacting with visuals in the report. What should you do first? A. From Power Query, merge the Orders query and the Order Line Hems query. B. Calculate the count of orders per product by using a DAX function. C. Create a calculated column that adds a list of product categories to the Orders table by using a DAX function. D. From Power Query, merge the Order Line Items query and the Products query. A You have a Power Bi report for the procurement department. The report contains data from the following tables. There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table. You need to minimize the size of the dataset without affecting the visuals. What should you do? A. Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month B. Merge Suppliers and Uneltems. C. Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price). D. Remove the Lineitems[Description] column. D