Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 321:

  You have a Power BI data model that contains a table named Employees. The table has the following columns: Employee Name Email Address

  Start Date Job Title You are implementing dynamic row-level security (RLS). You need to create a table filter to meet the following requirements: Users must see only their own employee data

  The DAX expression must work in both Power 81 Desktop and the Power BI service. Which expression should you use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 322:

  You have a Microsoft SharePoint Online site that contains several document libraries.

  One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

  You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.

  What should you do?

  A. Get data from a SharePoint folder, enter the site URL and then select Combine and Load

  B. Get data from a SharePoint list and enter the site URL Select Combine and Transform, then filter by the folder path to the manufacturing reports library.

  C. Get data from a SharePoint list enter the site URL and then select Combine and Load

  D. Get data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library,

  Correct Answer: D

• Question 323:

  From Power Query Editor, you attempt to execute a query and receive the following error message.

  Datasource.Error: could not find file.

  What are two possible causes of the error? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. The file is locked

  B. An incorrect privacy level was used for the data source.

  C. The referenced file was moved to a new location

  D. You do not have permissions to the file.

  Correct Answer: BD

• Question 324:

  You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.

  You need to create a Power BI report that connects to the project management app. Which connector should you select?

  A. Microsoft Teams Personal Analytics

  B. SQL Server database

  C. Dataverse

  D. Dataflows

  Correct Answer: C

• Question 325:

  You have a Power B1 report. The report contains a line chart that displays sales data for several regions.

  You need to add an element to the report that will enable users to filter the sales data to include only a selected region.

  Which two elements achieve the goal? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. a slicer visual

  B. a drillthrough filter

  C. a table visual

  D. a card visual

  E. a Key Performance Indicator (KPI) visual

  Correct Answer: AD

• Question 326:

  You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.

  The finance team at your company is NOT currently a member of any Power B1 workspace roles.

  You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.

  What should you do?

  A. Create a row-level security (RLS) role and add the finance team to the role as members.

  B. Provide an Excel workbook that is connected to the Finance dataset.

  C. Grant the finance team write permissions to the Finance dataset.

  D. Grant the finance team build permissions to the Finance dataset.

  Correct Answer: D

• Question 327:

  You have data in a Microsoft Excel worksheet as shown in the following table.

  

  You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

  If the discount column returns an error, a discount of 0.05 must be used.

  All the rows of data must be maintained.

  Administrative effort must be minimized.

  What should you do in Power Query Editor?

  A. Select Keep Errors

  B. Edit the query in the Query Errors group.

  C. Select Replace Errors

  D. Select Remove Errors.

  Correct Answer: C

• Question 328:

  You have a Power Bl model that contains two tables named Population and Date.

  The Population table contains two columns named Population Amount and Date Key.

  DateKey contains date values that represent the first day of a year and are used to create a many-to.

  The Power Bl model contains two measures that have the following definitions.

  Total Population = Sum ('Population'[Population Amount])

  2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023)

  You create a table visual that displays Date[Year] and [2023 Population].

  What will the table visual show?

  A. one row per year that contains blank values for every year except 2023

  B. one row per date that contains the population value for the corresponding year repeated in each row

  C. a single row for the year 2023 that contains the related population value

  D. one row per year that contains the same value repeated for each year

  Correct Answer: C

• Question 329:

  You have a Power B1 report that contains the visuals shown in the following table.

  

  You need to modify the location of each visual.

  What should you modify for each visual?

  A. the layer order

  B. the padding

  C. the position

  D. the tab order

  Correct Answer: C

• Question 330:

  You have five reports and two dashboards in a workspace.

  You need to grant all organizational users read access to one dashboard and three reports

  Solution: In Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra. you create a group that contains all the users. You share each selected report and the one dashboard to the group.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B