PL-300 MIcrosoft Power BI Certificate Exam with complete solutions 2024 latest update

You are planning to configure the relationship between Chart of Accounts and Predicted Sales to meet the security requirements. You need to be able to apply the security filter in both directions. What should you do? Set the Cross filter direction option to Both You need to create a table containing unique countries, and a table of unique combinations of countries and territories. Which DAX expressions should you use? Country = VALUES ('Predicted Sales '[Country]) Territory = SUMMARIZ('Predicted Sales', [Territory], [Country]) You need to create a workspace for report development. What should you add when creating the workplace? The name of an Office 365 Group How should you configure Power BI workspaces to meet the security requirements for the management of reports and dashboards? Create a workspace for development. Create a deployment pipeline and assign the development workspace to the development stage. Define data source rules, and deploy to test and production. What are two possible ways of controlling access to data in the Sales department? 1. Publish the app from the Sales workplace and add the users in the Sales department to the app. 2. Assign the Viewer role in the Sales workspace to the users in the Sales department. How should you provide access for Board members? Add the Board members as guests in Azure AD B2B, create an app, and invite the guest users How do you add report navigation so that users can go directly to a specific report page? through Buttons How do you preserve Preserve the slicer selection for a specific report page? through Bookmarks How do you preserve the visual selection for a specific report page? Bookmarks You need to configure the chart to show the average number of units sold per order. What are two possible ways to achieve this goal? 1. Right click on the units sold in Values for the visual and change the summarization to Average. 2. Create a measure using the AVERAGE DAX function and replace the number of units sold with the measure You need to discover which data source has stale data. What should you do? Use the Lineage view feature You need to configure data alerts for a dashboard. Which three visuals can you configure data alerts for? 1. KPI visual 2. Gauge visual 3. Card visual To read workspace reports: Viewer To publish content to the workspace: Contributor To publish apps: Member You need the visual to show the amounts chronologically with gaps where there is no data for a date. Which two actions should you perform? 1. Set Type as Continuous 2. Create a date table You need to configure the page for use with screen reader software for partially sighted users. What should you configure on the report page so that the screen reader follows a logical sequence? Tab Order To take actions from within a report Power Apps To use scikit-learn machine learning in visuals: Python To use JavaScript to create visuals: D3 You need to certify the report in your company's workspace. You should minimize the number of requests to the tenant administrator. Which two actions should you perform? 1. From Power BI Desktop, publish the report. 2. Request that the Power BI administrator endorses the report as certified You need to apply the fonts and colors to match your corporate standards. What should you do? Customize the theme You need to connect to datasource1 using the tabular data stream (TDS) protocol. Which two actions should you perform? 1. Use the Dataverse connector. 2. Input ics .com:5558 as the connection URL. You have pinned a card visual with the total sales from the current quarter on this dashboard. The sales manager wants to automatically receive a weekly email with the total sales. You need to meet the manager's requirement. What should you do? Create a subscription You need to be able to see all levels of the management hierarchy and be able to create visualizations that show data at each level of the hierarchy. Which three actions should you perform in sequence? 1. Use the PATH DAX function to extract a text column containing all the hierarchy of employee ids. 2. Use the PATHITEM DAX function to extract the management levels. 3. Create a new hierarchy and add the management levels. Your company requirement is to define a table that starts from Feb 2015 and ends in Dec 2030. You need to create a common date for a data model using DAX. How should you complete the DAX expression? Date = CALENDAR, DATE(2015,02,01), DATE(2030,12,31) You need to see how many empty and error rows are in a dataset, as shown in the exhibit. Which two data quality options can you use to meet your goal? 1. Column profile 2. Column quality You need to provide a set of custom visuals for users to add to their reports in the Power BI service. What should you do? Add the permitted custom visuals to Organizational visuals. You need to allow users to add new visuals to Power BI dashboards with minimal configuration. What should you do? Use the View insights option from a visual on a dashboard You are configuring row-level security (RLS) roles for a Power BI report. You need to define which rows are available when creating a role. What should you create? DAX Expression You are creating a report of financial transactions showing monthly trends. The source transaction table has in excess of 10 million rows. You need to optimize the report's performance. Which two actions should you perform? Set the Storage mode on the transactions table to DirectQuery. Create a summary table in the data source with the transaction data grouped by month. Which storage mode should you use for Customer and Territory as slicers.: Dual Which storage mode should you use for Q&A in reports: Import Which storage mode should you use to create a calculated table using DAX.: Import