30 Free Azure PL-300 Practice Questions

You are a Power BI specialist at your organization. In your finance table, you have a column called margin, which is defined as 'margin = revenue - cost of goods sold.' In your company, there are several different ways people refer to margin. Some people call margin by other terms such as income, profit or profit margin. To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to enable users to type in variations for margin. Solution: Add Synonyms to the finance table Does this solution meet the goal?

You are a Power BI specialist at your organization. In your finance table, you have a column called margin, which is defined as 'margin = revenue - cost of goods sold.' In your company, there are several different ways people refer to margin. Some people call margin by other terms such as income, profit or profit margin. To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to enable users to type in variations for margin. Solution: Add a detailed description of how you defined margin Does this solution meet the goal?

You are a Power BI specialist at your organization. In your inventory table, there are several different ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or supply. To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and columns. Solution: Set the row label on the inventory table Does this solution meet the goal?

You are a Power BI specialist at your organization. In your inventory table, there are several different ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or supply. To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and columns. Solution: Use Teach Q&A Does this solution meet the goal?

You have the following relationship between sales, product and employees. The employees table is joined to the product table by 'category', and the product table is joined to the sales table by 'ProductKey.' Your boss asks you to build a visual for each Manager's sales by Subcategory. What do you need to configure to solve that problem?

You need to create a table containing unique combinations of category and subcategory and aggregated sales. What DAX expression should you use?

You work as a Power BI professional within your company's HR group. You are creating a data model to use for reporting within the group. As you start building relationships, you see there are issues connecting some of the tables. What two fixes are required to get the relationships working in your data model?

You work as a Power BI professional within your company's HR group. The report you created for retention analysis worked fine in the development environment, but when deployed has performance issues. Solution: Remove columns from the data model not used in reports Does this solution meet the goal?

You work as a Power BI professional within your company's HR group. The report you created for retention analysis worked fine in the development environment, but when deployed has performance issues. Solution: Hide columns and tables from the data model not used in reports Does this solution meet the goal?

You find an interesting visualization using the Python programming language that you want to run in Power BI. What are the three steps required before you can use Python in Power BI?

You are asked to optimize the performance of your data model. You have several intermediate queries that are not used for visualization and you have a large transactional table with a Date/Time field. What two optimizations should you do?

You are the Power BI administrator at your company which builds VR headsets. You need to assign appropriate workspace roles to your colleagues and must use the lowest permission necessary to accomplish the task. Which roles should you use for the following workspace requirements? 1. Update and delete workspaces 2. Publish apps 3. Publish content to the workspace

Your boss has scrolled through the Theme Gallery on the website https://community.powerbi.com/. She asks you to use a particular theme for your company's report in Power BI Service. How do you incorporate the theme in your report?

You are your company's Power BI expert. You know that data lineage shows you which data sources are used by which datasets. One of your colleagues says he cannot access data lineage. What could be two possible explanations for data lineage not working?

You work for a consulting company that has a contract with a large government department. Part of the requirements for the report is to configure the page for use with a screen reader for sight-impaired users. What should you configure in your report such that the page follows a logical sequence?

You work at a sports betting company and have a table with US soccer scores and a second table with betting odds. Both tables share a common key called GameID. Your boss asks you to create a new combined table. Which transform should you use to create the dataset?

You are part of a planning team and are investigating the forecast accuracy across multiple plants, various products and a series of demand types (e.g. stable, seasonal, growing etc.) You use Power BI and know that there is a visual that can help you with the root cause of low forecast accuracy. Which visual should you choose?

You import a large table from Excel into Power BI and you suspect there may be missing data. How would you find the percentage of empty cells in each column?

You work for a shoe distribution company and your firm uses Power BI for reporting. One of the reports you have created is exported as a PDF so the warehouse staff can check off items on a hard copy. Your company, however, has a policy that all exported reports need to be encrypted. How can you meet this requirement?

You work for a share trading software company and have a dashboard for user trading times. The data set used for the analysis goes back seven years. When the data reloads, it takes excessive time as the full seven years are refreshed. How can you improve the dataset performance?

You have a data model with two key tables: Region and Shipping. There is a one-to-many relationship between the Region and the Shipping table. The model also has two row-level security roles named Region_Texas and Shipping_Mode The DAX filters for the two security roles are: - Region_Texas filter is: Region[state] = "Texas" - Shipping_Mode filter is: Shipping[mode] = "Rail" If a manager is a member of both the Region_Texas and Shipping_Mode roles, what will they see in a report using this data model?

You create an R visual in Power BI that has 500,000 rows. You notice that not all the data is shown and a message is displayed on the image. Your boss asks you the cause of this issue. What is the reason not all data is shown?

You have one report page with multiple visuals that is running slow, leading to complaints from users. What TWO solutions will help optimize your visuals?

You are asked to create a category percentage measure that will reflect the values selected when using a slicer. In the output below, you will see that the Bikes category is not selected in the slicer and the category percentage reflects the current filter context. All category percentage values add to 100% of the filter context. You are given a measure that sums the sales called Sales Total. How would you create a category percentage measure in DAX?

You work for a Japanese auto company whose fiscal year starts April 1. You have a table called Cars with orders for cars. You need to create a common date for a data model using DAX, respecting the fiscal period. How should you create a date table using DAX?

You work in the spare parts department of an oil and gas company as a BI expert. The company has hundreds of parts, ten years of historic data, and hundreds of different order sizes from suppliers. You create a report in Power BI with aggregations for the following visuals: - A column chart of parts on the axis, but there are too many products showing - A stacked column chart of month number and order type, but too many months show - A histogram of supplier order sizes, but there are too many order sizes You need to combine the data to make the visual more readable. How should you combine the data? Select the GROUPING TYPE for each of the THREE solutions below from top to bottom. 1. Combined the product into categories of product 2. Combine the columns into 3 month number blocks 3. Combine order sizes into 8 groups

You want to use insights in Power BI Desktop to understand the increase from one quarter to the next in your sales column chart. Normally you would right-click the appropriate column and click on Analyze > Explain increase. However, this time insights does not appear to be available. What are TWO possible reasons insights is not working?

You work for an aerospace company in their satellite division. You build a workspace called 'satellite apps' in Power BI service that contains several reports and management level apps. You have a new analyst come on board and need to allow them to edit and publish reports. How would you achieve this goal?

You have a line chart that shows units manufactured by month. You want to add the on-time delivery metric for each month when you hover the mouse over a data point. How would you provide the additional piece of data?

You have built several DAX measures. A senior Power BI member of your team asks you to improve the performance and readability of the following DAX expression? How would you achieve this goal? Annual Sales Growth % = DIVIDE( ([Sales] - CALCULATE([Sales], PARALLELPERIOD('Date'[Date], -12, MONTH))), CALCULATE([Sales], PARALLELPERIOD('Date'[Date], -12, MONTH)) )