PL-300 practice questions 61–70

1. Question 61 · 358 in bank

   HOTSPOT - You publish the dataset to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   No - Azure SQL Server, therefore no need for an on-premise Gateway as Service and Azure are in the cloud. No - DirectQuery mode for the DB connection, so no need to schedule a refresh. DirectQuery is a live connection. No - Azure SQL supports the following connections from Power BI: Windows, Database and Microsoft Account. (Basic is reserved for Power Query Online. Do not confuse Database with Basic.): https://learn.microsoft.com/en-us/power-query/connectors/azuresqldatabase https://learn.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect

   Source: Adapted from community discussion — NotMeAnyWay

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

2. Question 62 · 358 in bank

   What should you create to meet the reporting requirements of the sales department?

   • Aa measure column that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])
   • Ba calculated column that uses the following formula: ABS(Sales[sales_amount])
   • Ca calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))
   • Da measure that uses the following formula: SUM(Sales[sales_amount])

   Show answer

   Answer: A

   Explanation

   According to other websites the correct options are A. a measure that uses a formula of SUM (sales[sales_id]) B. a calculated column that use a formula of COUNTA(sales [sales_id]) C. a measure that uses a formula of COUNTROWS (Sales) D. a calculated column that use a formula of SUM (sales [sales_id]) The sale department require reports that contain the number of sales transactions. Correct answer is C

   Source: Adapted from community discussion — Orkhannnn

   References

   • Microsoft Learn

   Next question

3. Question 63 · 358 in bank

   HOTSPOT - You need to grant access to the business unit analysts. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: App permissions - App permissions. This section describes the kinds of permissions you can grant to the specified users * Allow all users to connect to the app's underlying datasets using the Build permission This option grants build permission on the app's underlying datasets. * Etc. Note: Contoso identifies the following security requirements for analyst access: ✑ Analysts must be able to access all balance sheet and product catalog data. ✑ Analysts must be able to access only the profit and loss data of their respective business unit. ✑ Analysts must be able to create new reports from the dataset that contains the profit and loss data, but the reports built by the analysts must NOT be included in the quarterly reports for the board. ✑ Analysts must NOT be able to share the quarterly reports with anyone. ✑ Analysts must NOT be able to make new reports by using the balance sheet data. Incorrect: Not Member role: Would grant too much permissions. Not Viewer role: Need more granular permissions. Box 2: Reshare - App permissions, This section describes the kinds of permissions you can grant to the specified users * Allow users to share the app and the app's underlying datasets using the share permission This option grants users reshare permission on the app's underlying datasets. * Etc. Note: Analysts must be able to create new reports from the dataset that contains the profit and loss data, but the reports built by the analysts must NOT be included in the quarterly reports for the board. Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

   Source: Adapted from community discussion — LucasCovey

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

4. Question 64 · 358 in bank

   HOTSPOT - How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Using a workspace membership Note 1: The company wants to provide the board with a single package of reports that will contain custom navigation and links to supplementary information. Sharing is the easiest way to give people access to your reports and dashboards in the Power BI service. You can share with people inside or outside your organization.ֲ¨ Where you can share: You can share reports and dashboards from My Workspace. You can share from workspaces other than My Workspace, if you have the Admin or Member role in the workspace. If you have the Contributor or Viewer role, you can share if you have Reshare permissions. You can share from the Power BI mobile apps. You can't share directly from Power BI Desktop. Box 2: A mail-enabled security group in Azure Active Directory Mail-Enabled Security Group - This group also contains a list of email addresses of members and can also be used to control access to OneDrive and SharePoint. The Mail-Enabled Security Group can be created in the Office 365 Admin Portal Note: The reports must be made available to the board from powerbi.com. An Azure Active Directory (Azure AD) group will be used to share information with the board. Incorrect: * Distribution Group This group can also be called and Distribution List. The Distribution Group is a group which contains a list of email addresses of members, all of whom will be sent an email when an email is sent to the distribution groups email address. The Distribution Group can be created in the Azure Active Directory Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards https://www.fourmoo.com/2020/04/01/power-bi-which-groups-can-be-used-to-set-permissions-in-power-bi/

   Source: Adapted from community discussion — Shalaleh

   

   Next question

5. Question 65 · 358 in bank

   You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort. What should you do?

   • AFrom each report in powerbi.com, select Refresh visuals.
   • BFrom Power BI Desktop, download the PBIX file and refresh the data.
   • CConfigure a scheduled refresh without using an on-premises data gateway.
   • DConfigure a scheduled refresh by using an on-premises data gateway.

   Show answer

   Answer: C

   Explanation

   From your link: "Scheduled refresh of reports isn’t supported with Dynamics 365 (on-premises) datasets that are published to the Power BI service. You can refresh reports using in Microsoft Power BI Desktop or Microsoft Office Excel and then upload the reports to the Power BI service." So D is impossible. C is correct.

   Source: Adapted from community discussion — simba_10

   References

   • Microsoft Learn

   Next question

6. Question 66 · 358 in bank

   You have a Power BI semantic model that imports data from a Microsoft SQL Server database and an Oracle database. The semantic model is deployed to the Power BI service. Parameters are already used for the SQL Server data source. You are planning to make change to the semantic model that will ensure consistent behavior across all the data sources. You need to enable parameterization for the Oracle data source. The solution must minimize changes to the existing model. What should you do?

   • AFrom Power BI Desktop, modify the Oracle data source to use a parameter, and then republish the model to the Power BI service.
   • BFrom the Power BI service, modify the parameters of the SQL Server data source.
   • CFrom the Power BI service, create a new semantic model that uses the existing model as a data source, and then parameterize the new model.
   • DFrom the Power BI service, set a parameter value for the model.

   Show answer

   Answer: A

   Next question

7. Question 67 · 358 in bank

   What is the minimum number of Power BI datasets needed to support the reports?

   • Aa single imported dataset
   • Btwo imported datasets
   • Ctwo DirectQuery datasets
   • Da single DirectQuery dataset

   Show answer

   Answer: B

   Explanation

   Hi, Just an update. I got 958/1000 but was hungover af and not feeling my best. Every single question bar 1 was from these 250 questions. Guys it was so easy, finished it in 30 minutes. The most important thing is to know these questions BY HEART! know every single answer (or at least a decent amount of them) and you will be fine. The questions are exactly the same. Obviously read the comments and don't go by what this website says it is.

   Source: Adapted from community discussion — 08b2ddd

   Next question

8. Question 68 · 358 in bank

   You are creating a report in Power BI Desktop. You load a data extract that includes a free text field named coll. You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model. What should you do?

   • AIn the report, add a DAX calculated column that calculates the length of col1
   • BIn the report, add a DAX function that calculates the average length of col1
   • CFrom Power Query Editor, add a column that calculates the length of col1
   • DFrom Power Query Editor, change the distribution for the Column profile to group by length for col1

   Show answer

   Answer: D

   Explanation

   Wrong answer, A will affect the size of the model as would C. B doesn't give you enough information about the distribution (just the average) D is the right answer.

   Source: Adapted from community discussion — Muffinshow

   References

   • Microsoft Learn

   Next question

9. Question 69 · 358 in bank

   HOTSPOT - You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales. You need to create a measure that calculates the total sales from the equivalent month of the previous year. How should you complete the calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: CALCULATE - Box 2: PARALLELPERIOD - PARALLELPERIOD returns a table that contains a column of dates that represents a period parallel to the dates in the specified dates column, in the current context, with the dates shifted a number of intervals either forward in time or back in time. Syntax: PARALLELPERIOD(<dates>,<number_of_intervals>,<interval>) dates: A column that contains dates. interval: The interval by which to shift the dates. The value for interval can be one of the following: year, quarter, month. Incorrect: 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. Syntax: SAMEPERIODLASTYEAR(<dates>) DATESMTD returns a table that contains a column of the dates for the month to date, in the current context. Syntax: DATESMTD(<dates>) Box 3: 'DATE' [Month] Reference: https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

   Source: Adapted from community discussion — Dovoto

   References

   • Microsoft Learn

   

   Next question

10. Question 70 · 358 in bank

    Select 2

    You have a Power BI semantic model that contains two queries. You discover that a report based on the model has performance issues. You plan to use Power Query to reduce the data loaded to the model. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

    • AApply group by and summarize techniques.
    • BCombine the queries by using Append.
    • CRemove unnecessary columns and rows.
    • DCombine the queries by using Merge.
    • ECreate a new query group.

    Show answer

    Answer: AC

    Explanation

    B. Combine the queries by using Append While combining queries via append can help merge multiple datasets, it typically does not reduce the data size. In fact, it may increase the dataset size unless managed carefully. D. Combine the queries by using Merge Merging queries is useful for joining data from different sources, but it is not inherently a data reduction technique. It may help in certain cases, but it is not directly aimed at reducing the amount of data loaded to the model. E. Create a new query group A query group is simply an organizational tool in Power Query to manage your queries better. It has no impact on performance or data reduction.

    Source: Adapted from community discussion — amiruladliroslibin

    References

    • Microsoft Learn

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PL-300 practice, question 61. 358 questions available.