30 Free Azure PL-300 Practice Questions

PL-300 Practice Questions

1. Question 1.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?

   • A.Yes(correct answer)
   • B.No
   Show answer & explanationHide answer

   Correct answer: A

   Yes

   Explanation

   In the modelling tab in Power BI Desktop, you can add synonyms to a column. When a user uses Q&A, Power BI will check for synonyms when interpreting the question.

2. Question 2.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?

   • A.Yes
   • B.No(correct answer)
   Show answer & explanationHide answer

   Correct answer: B

   No

   Explanation

   In the modelling section, you can add a description within the properties of a column. A description is helpful for other modellers to understand the purpose of the column. However, this description does not have any impact on how Q&A interprets synonyms.

3. Question 3.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?

   • A.Yes(correct answer)
   • B.No
   Show answer & explanationHide answer

   Correct answer: A

   Yes

   Explanation

   When you click on the table name in the modelling view, you can assign a row label to the column. A role label allows you to define which column best identifies a row in the table. This label assists Q&A to generate better visualisations as it knows the best column that identifies a table.

4. Question 4.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?

   • A.Yes(correct answer)
   • B.No
   Show answer & explanationHide answer

   Correct answer: A

   Yes

   Explanation

   When you click on the Q&A setup button in the home ribbon on Power BI Desktop, one of the options is to Teach Q&A. Teach Q&A allows you to enter in a question in the language that someone in your organization may use such as 'What was my stock at the end of August.' If Power BI does not know understand a word such as 'stock', you are promted to define what 'stock' refers to. This way, when someone asks a similar question, Power BI will interpret the question correctly.

5. Question 5.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?

   • A.Create a hierarchy in the product table for subcategory
   • B.In the employees table, change EmployeeID to type text
   • C.Set the cross-filter between product and employees to both(correct answer)
   • D.In the Model view, change the product table's toggle 'is hidden' to True
   Show answer & explanationHide answer

   Correct answer: C

   Set the cross-filter between product and employees to both

   Explanation

   The current filter direction on the employees table does not allow you to select manager and the sales and category fields. You need to alter the cross-filter direction to enable the filter to flow from the employees table to the product table. Creating a hierarchy in the product table does not help with the cross-filter direction issue in the employees table. Changing the EmployeeID to type text is not relevant. The key used to join the employees and product tables is 'category.' Toggling the product's table to hidden will prevent users from seeing the product table. We want to use the fields in the products table to create visuals. This will not help solve our issue.

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

   • A.DATATABLE('sales','product'[Category],'product'[Subcategory],"Sales Total",SUM(sales[Sales Amount]))
   • B.SUMMARIZECOLUMNS('product'[Category],'product'[Subcategory],sales[Sales Amount])
   • C.SUMMARIZE('sales','product'[Category],'product'[Subcategory],"Sales Total",SUM(sales[Sales Amount]))(correct answer)
   • D.SELECTCOLUMNS('sales','product'[Category],'product'[Subcategory],sales[Sales Amount])
   Show answer & explanationHide answer

   Correct answer: C

   SUMMARIZE('sales','product'[Category],'product'[Subcategory],"Sales Total",SUM(sales[Sales Amount]))

   Explanation

   You can use SUMMARIZE to create a summary of the input table grouped by the specified columns. You can alias an expression by using quotation marks such as "Sales Total". Also, note that you need to use the aggregation SUM() for the sales amount, or all sales lines will show. In A, do not use DATATABLE. The DATATABLE function is used to build constant tables with code. In B, the SUM() aggregation is missing on the sales amount field. In D, do not use SELECTCOLUMNS. The SELECTCOLUMNS function adds a calculated column to a table and expect the input and .

7. Question 7.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?

   • A.Change the data type of Employees[PayID] and hide Employees[Relocation] and Employees[HR Manager] fields
   • B.Change the data type of Employees[PayID] and BU[BUID] to Whole Number(correct answer)
   • C.Ensure the cardinality between BU and Employees from Many to one (*:1) to Many to many (*:*)
   • D.Change the data type of Employees[PayID] and BU[BUID] to Text
   Show answer & explanationHide answer

   Correct answer: B

   Change the data type of Employees[PayID] and BU[BUID] to Whole Number

   Explanation

   You need to change the data type of Employees[PayID] and BU[BUID] to Whole Number. If data types between tables do not match, you will not be able to create joins. Answer A is incorrect as hiding fields does not help the relationship between tables. Answer C is wrong as there is no need to change the BU relationship to Many to many Answer D is incorrect as Text is the wrong data type, the correct data type is whole number

8. Question 8.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?

   • A.Yes(correct answer)
   • B.No
   Show answer & explanationHide answer

   Correct answer: A

   Yes

   Explanation

   Removing unnecessary columns from the model will reduce the data model size and allow for improved refresh time.

9. Question 9.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?

   • A.Yes
   • B.No(correct answer)
   Show answer & explanationHide answer

   Correct answer: B

   No

   Explanation

   Hiding a column or a table will hide the items from the user in the Report view. The hidden column and tables are still processed by Power BI and do not affect model size or performance

10. Question 10.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?

    • A.Install Python on your local machine(correct answer)
    • B.Enable R scripting
    • C.Install the libraries matplotlib and pandas(correct answer)
    • D.Enable Python scripting(correct answer)
    • E.Install the libraries seaborn and keras
    Show answer & explanationHide answer

    Correct answer: A, C, D

    Install Python on your local machine / Install the libraries matplotlib and pandas / Enable Python scripting

    Explanation

    The steps to get started with Python in Power BI are: 1. Install Python on your local machine 2. Install the libraries matplotlib and pandas 3. Enable Python scripting Answer B is incorrect. R scripting is a separate language and has no relation with Python. Answer E is incorrect. While seaborn is used for data visualization, matplotlib and pandas are required libraries for Python integration. Note that keras is a deep learning library and is not used for data visualization.

11. Question 11.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?

    • A.Change all relationship cross filter directions to single
    • B.Split the Date/Time field into a separate Date column and a separate Time column(correct answer)
    • C.Turn off single select on slicers
    • D.Disable Power Query load on intermediary queries(correct answer)
    Show answer & explanationHide answer

    Correct answer: B, D

    Split the Date/Time field into a separate Date column and a separate Time column / Disable Power Query load on intermediary queries

    Explanation

    A Date/Time field has many contain unique or high cardinality values making optimization within the VertiPaq engine difficult. By splitting the Date/Time field into a separate Dat and Time field, you reduce the uniqueness of the data and allow for greater storage optimization. Intermediate queries that are intended to support data integration with other queries should not be loaded into the model. To avoid loading the query to the model, ensure that you disable query load in these instances. Answer A is not correct. You should use the relationship cross filter direction to enable reporting requirements. Answer C is not correct. Single select works more efficiently than multi-select on slicers.

12. Question 12.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

    • A.Member / Member / Contributor
    • B.Member / Member / Viewer
    • C.Admin / Member / Contributor(correct answer)
    • D.Admin / Admin / Contributor
    Show answer & explanationHide answer

    Correct answer: C

    Admin / Member / Contributor

    Explanation

    An admin can update and delete workspaces. A member can publish apps, and a contributor can publish content to the workspace.

13. Question 13.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?

    • A.Download the JSON file and in Custom Dashboard theme > Upload JSON theme(correct answer)
    • B.Download the CSS file and in Custom Dashboard theme > Upload CSS theme
    • C.Download the PNG file and right-click on a tile > Upload PNG theme
    • D.Download the PDF file and right-click on the dashboard > Upload PDF theme
    Show answer & explanationHide answer

    Correct answer: A

    Download the JSON file and in Custom Dashboard theme > Upload JSON theme

    Explanation

    You can download a JSON file from the theme gallery. To import the theme into Power BI service, select Upload JSON theme in the Custom Dashboard theme window. Themes are only in JSON format. All other file formats such as CSS, PNG or PDF will not work.

14. Question 14.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?

    • A.Only admins can see the lineage view
    • B.You need a Power BI Pro license to see lineage view(correct answer)
    • C.Lineage only works for DirectQuery datasets
    • D.Lineage view is available only to users with higher than Viewer access to the workspace(correct answer)
    • E.Each user needs to be granted lineage view permission in the tenant settings
    Show answer & explanationHide answer

    Correct answer: B, D

    You need a Power BI Pro license to see lineage view / Lineage view is available only to users with higher than Viewer access to the workspace

    Explanation

    For lineage to work, you need to ensure you have a Power BI Pro license and you have access to the workspace. Furthermore, users must have an Admin, Member, or Contributor role in the workspace. Users with a Viewer role can't switch to lineage view. Answer A is incorrect. Users with Admin, Member, or Contributor roles in the workspace can see lineage view. Answer C is incorrect. Lineage is not limited to DirectQuery datasets. Answer E is incorrect. You do not need to assign individual permissions for lineage view in the tenant settings.

15. Question 15.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?

    • A.Bookmarks
    • B.Tab order(correct answer)
    • C.Filters on all pages
    • D.Layer order
    Show answer & explanationHide answer

    Correct answer: B

    Tab order

    Explanation

    The tab order is used by keyboard users to navigate the report page. Screen reader and accessibility software follow the sequence of tab order. You should not use bookmarks on your report for this purpose. Bookmarks save the current filters and slicers, cross-highlighted visuals, sort order. You should not use Filters on all pages. Filters select a subset of your data and do not help with accessibility. You should not use layer order. The layer order is used to control the order in which visuals are shown and is used if you have visuals that overlap.

16. Question 16.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?

    • A.Append queries as new
    • B.Append queries
    • C.Merge queries as new(correct answer)
    • D.Merge queries
    Show answer & explanationHide answer

    Correct answer: C

    Merge queries as new

    Explanation

    You should use the merge queries as new transformation to create a new table with soccer scores and the betting odds. A merge query allows you to combine two or more tables into a single table based on a common column between the tables. This is similar to a JOIN in SQL. You should not use append queries as new or append queries. An append query transformation combines tables with the same schema. This is similar to a UNION query in SQL. Since we want to add a column and the tables do not have the same schema we cannot use an append transformation. You should not use merge queries since your boss specifically asked for a new combined table. You should use the merge queries as new transformation.

17. Question 17.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?

    • A.Waterfall
    • B.Treemap
    • C.Key influencers
    • D.Decomposition tree(correct answer)
    Show answer & explanationHide answer

    Correct answer: D

    Decomposition tree

    Explanation

    You should use the decomposition tree. A decomposition tree lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order. It also uses artificial intelligence, so you can ask it to find the next dimension to drill down into based on certain criteria, making it useful for root cause analysis. You should not use a waterfall chart. A waterfall visual is used to show how an initial value is affected by a series of changes and does not help with root cause analysis. You should not use a treemap. A treemap displays hierarchical data as a set of nested rectangles. Each level of the hierarchy is represented by a colored rectangle (branch) containing smaller rectangles (leaves). A treemap does not help with root cause analysis. You should not use a key influencers visual. A key influencers chart helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers. The key influencers ranks factors and is not used for root cause analysis.

18. Question 18.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?

    • A.Column quality(correct answer)
    • B.Column profile
    • C.Show whitespace
    • D.Column distribution
    Show answer & explanationHide answer

    Correct answer: A

    Column quality

    Explanation

    The Column quality checks the quality of the data in terms of Valid, Error & Empty and is expressed as a percentage. Column profile provides a more in-depth look at the data in a column. Apart from the column distribution chart, it contains a column statistics chart. While column profile provides the count of empty cells, it does not show a percentage of empty cells. The whitespace feature in data preview shows whitespace and newline characters. Column distribution provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns.

19. Question 19.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?

    • A.Use Row Level Security (RLS)
    • B.Set the PDF options in the tenant settings
    • C.Configure the dataset build permission security options
    • D.Use sensitivity labels(correct answer)
    Show answer & explanationHide answer

    Correct answer: D

    Use sensitivity labels

    Explanation

    When you apply a sensitivity label to a report, Power BI automatically applies the label to the exported file and protects it according to the label's file encryption settings. This way, your data can remain protected, even when it leaves Power BI. Do not use Row-level Security (RLS) for PDF exports. Row-level Security is used to restrict data access for given users by filtering the rows they see. Row-level does nothing to encrypt reports that are printed to PDF. There are no PDF options in the tenant settings. Do not use the dataset build permission security option. The dataset build permission allows other users in power BI Service to discover and reuse the dataset you've shared. The build permission does not protect any exported PDFs.

20. Question 20.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?

    • A.Use an on-premises data gateway
    • B.Configure incremental refresh in Power BI Desktop and enable it in Power BI service(correct answer)
    • C.Enable incremental refresh directly in Power BI service
    • D.Manually refresh the database when users are not active
    Show answer & explanationHide answer

    Correct answer: B

    Configure incremental refresh in Power BI Desktop and enable it in Power BI service

    Explanation

    With incremental refresh, the service dynamically partitions and separates data that needs to be refreshed frequently from data that can be refreshed less frequently. Table data is filtered using Power Query parameters with the names 'RangeStart' and 'RangeEnd,' defined using Power BI Desktop. Once the incremental refresh has been configured in Power BI Desktop, the dataset can be uploaded to Power BI service. In answer A, an on-premise data gateway is used to access local files and does not help with optimizing the refresh process. In answer C, incremental refresh cannot be configured directly in Power BI service. Incremental refresh must first be configured in Power BI Desktop. Manually refreshing the dataset is not an efficient long term solution. Use incremental refresh instead.

21. Question 21.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?

    • A.The user will only see data for the state of Texas
    • B.The user will only see data for the rail shipping mode
    • C.The user will see data for which the state is Texas AND the shipping model is rail
    • D.The user will see data for which the state is Texas OR the shipping mode is rail(correct answer)
    Show answer & explanationHide answer

    Correct answer: D

    The user will see data for which the state is Texas OR the shipping mode is rail

    Explanation

    When multiple roles are applied, a user with see filter 1 or filter 2. If the data has any states with Texas rows, the user will see those. If the data has the shipping mode of rail, then the user will also see those. The user is not restricted to both conditions, i.e. where a row is from Texas and has a rail shipping mode. In answer A, the user will not see only Texas. They will also see rail shipments. In answer B, the user will not see only rail shipments. They will also see Texas shipments. In answer C, the user will see Texas OR rail shipments.

22. Question 22.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?

    • A.You are using a version prior to 2.0 of the plotly library
    • B.You are missing an R package
    • C.The visual has too many rows(correct answer)
    • D.The resolution is too high
    Show answer & explanationHide answer

    Correct answer: C

    The visual has too many rows

    Explanation

    R visuals for plotting are limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a limit of 250 MB. The version of the plotly will not affect the number of rows. All R visuals are limited to 150,000 rows. If you are missing an R package, no image will show and you will only get an error message. R visuals are all displayed at a 72 DPI resolution. The resolution does not affect the number of rows that can be plotted.

23. Question 23.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?

    • A.Don't use multiple colors on bar charts
    • B.Apply filters to reduce the max number of items that a visual displays(correct answer)
    • C.Replace the default visuals with custom visuals
    • D.Limit the use of bar charts
    • E.Limit the number of visuals on a particular report page to only what is necessary(correct answer)
    Show answer & explanationHide answer

    Correct answer: B, E

    Apply filters to reduce the max number of items that a visual displays / Limit the number of visuals on a particular report page to only what is necessary

    Explanation

    The more data that a visual needs to display, the slower that visual is to load. For instance, as a default, you may use the "Top N" filter to reduce the max number of items that a visual displays. It's highly recommended you limit the number of visuals on a particular report page to only what is necessary. Drillthrough pages and report page tooltips are great ways to provide additional details without jamming more visuals onto the page. Answer A, using multiple colors on bar charts will not help optimize the visual. In answer C, replacing the visual with custom visuals will not help optimize your report page. Answer D, limiting the use of bar charts will not help optimize your report page.

24. Question 24.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?

    • A.VAR categoryTotal = CALCULATE([Sales Total],ALL('product'[Category])) VAR categoryPercentage = DIVIDE([Sales Total],categoryTotal) RETURN categoryPercentage
    • B.VAR categoryTotal = [Sales Total] VAR categoryPercentage = DIVIDE([Sales Total],categoryTotal) RETURN categoryPercentage
    • C.VAR categoryTotal = CALCULATE([Sales Total],ALLSELECTED('product'[Category])) VAR categoryPercentage = DIVIDE([Sales Total],categoryTotal) RETURN categoryPercentage(correct answer)
    • D.VAR categoryTotal = CALCULATE([Sales Total],REMOVEFILTERS('product'[Category])) VAR categoryPercentage = DIVIDE([Sales Total],categoryTotal) RETURN categoryPercentage
    Show answer & explanationHide answer

    Correct answer: C

    VAR categoryTotal = CALCULATE([Sales Total],ALLSELECTED('product'[Category])) VAR categoryPercentage = DIVIDE([Sales Total],categoryTotal) RETURN categoryPercentage

    Explanation

    The ALLSELECTED() function returns all the rows in a table, ignoring any filters that might have been applied inside the query, but keeping filters that come from outside. The categoryTotal value in this example equals $15.188 M and not the grand total of all category sales of $109.81 You can then use the DIVIDE() function to return the percentage of the category. Answer A is incorrect since the ALL() function will ignore all filters and return the grand total of all category sales of $109.81 Answer B is incorrect because no filtering of categories is applied. Answer D is wrong as REMOVEFITLERS() is an alias for ALL() and returns the grand total of all category sales of $109.81 M.

25. Question 25.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?

    • A.CALENDAR(4)
    • B.CALANDAR( DATE ( 2000,3,1), DATE ( YEAR ( LASTDATE ( Cars[OrderDate] ) ), 31, 3 ))
    • C.CALANDAR( DATE ( YEAR ( FIRSTDATE ( Cars[OrderDate] ),4,1), DATE ( 2025, 12, 31 ))
    • D.CALENDARAUTO(3)(correct answer)
    Show answer & explanationHide answer

    Correct answer: D

    CALENDARAUTO(3)

    Explanation

    CALANDARAUTO() returns a table with a single column named "Date" containing a set of dates. The range of dates is calculated automatically based on data in the model. The parameter within the function gives the end month of the fiscal year. Since the fiscal year ends March 31, the parameter is 3. In answer A, the CALENDAR() function expects a start and end date. In answer B, the start date needs to be April / 1. A dynamic way would be to use FIRSTDATE and LASTDATE. In answer C, the end date needs to be March / 31. A dynamic way would be to use FIRSTDATE and LASTDATE.

26. Question 26.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

    • A.LIST / BIN / LIST
    • B.LIST / BIN / BIN(correct answer)
    • C.BIN / LIST / LIST
    • D.BIN / LIST / BIN
    Show answer & explanationHide answer

    Correct answer: B

    LIST / BIN / BIN

    Explanation

    You should use the List grouping type for text data such as products. You can combine a list of values into a category to simplify the data. You should use Binning to combine numeric data such as dates and quantity.

27. Question 27.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?

    • A.You use hierarchies
    • B.You use TOPN filters(correct answer)
    • C.You have filtered measures(correct answer)
    • D.You use a stacked column chart
    Show answer & explanationHide answer

    Correct answer: B, C

    You use TOPN filters / You have filtered measures

    Explanation

    Insights are based on the change from the previous data point, and they aren't available when you select the first data point in a visual for several scenarios. Insights will not work with a scenario when you use TOPN filters or when you have filtered measures such as 'Total Sales for California.' Note that insights are also not supported for data sources such as DirectQuery and Live connect. In answer A, hierarchies will work with insights. In answer D, you can use a stacked column chart for insights.

28. Question 28.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?

    • A.Configure the security group from Azure Active Directory
    • B.Add the user as a member in the role section of the 'satellite apps' workspace(correct answer)
    • C.In Power BI Desktop set Row Level Security (RLS)
    • D.Within the 'satellite apps' workspace, select update app
    Show answer & explanationHide answer

    Correct answer: B

    Add the user as a member in the role section of the 'satellite apps' workspace

    Explanation

    Roles let you manage who can do what in the new workspaces, so teams can collaborate. New workspaces allow you to assign roles to individuals, and to user groups: security groups, Microsoft 365 groups, and distribution lists. Answer A is not correct, we do not wish to configure a security group. We want to add a new role to the workspace. Answer C is not correct, Row Level Security is a way to filter rows and does not enable editing and publishing Answer D is not correct, update app is used to edit the content of an app and not assign edit and publish roles.

29. Question 29.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?

    • A.Add on-time delivery to the drillthrough fields
    • B.Add the on-time delivery column to the secondary values field
    • C.Add on-time delivery column to the tooltips field(correct answer)
    • D.Add the on-time delivery column to the small multiples field
    Show answer & explanationHide answer

    Correct answer: C

    Add on-time delivery column to the tooltips field

    Explanation

    A tooltip is a way of providing more contextual information and detail to data points on a visual. When you hover over a data point, the tooltip data will show. Answer A is incorrect. Drillthrough fields do not show on hover. When report readers use a drillthrough, they right-click a data point in other report pages, and drillthrough to the focused page to get details that are filtered to that context. Answer B is incorrect. A secondary values field is used to show other numeric data on a line chart. Answer B is incorrect. Small multiple is used to split your visuals into multiple smaller visuals, based on your selected fields.

30. Question 30.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)) )

    • A.Replace DIVIDE with a simple divide calculation using the '/' symbol
    • B.Instead of PARALLELPERIOD(), use DATEADD()
    • C.Mark date table as date
    • D.Use VARIABLES and a RETURN statement(correct answer)
    Show answer & explanationHide answer

    Correct answer: D

    Use VARIABLES and a RETURN statement

    Explanation

    Variables and a return statement are used to improve the performance and readability of DAX expressions. The above expression could be re-written as the below: Annual Sales Growth % = VAR SalesPriorYear = CALCULATE([Sales], PARALLELPERIOD('Date'[Date], -12, MONTH)) RETURN DIVIDE(([Sales] - SalesPriorYear), SalesPriorYear) In answer A, replacing the DIVIDE() function with '/' will not improve performance. The benefit of using the DIVIDE() function is it automatically handles divide by zero issues. In answer B, using DATEADD() instead of PARALLELPERIOD() will not have an effect on performance and readability. In answer C, marking the date table as date will not have an effect on the measure performance.

Frequently Asked Questions

Keep studying

Full exam

Azure Power BI Data Analyst (PL-300) details

Free practice

Microsoft AZ-900

Free practice

Microsoft AZ-104

Free practice

Microsoft SC-900