← Back to exam page

PL-300 – Microsoft Power BI Data Analyst

Loading demo links...

Showing 10–12 of 15 questions

Question 10 (Contoso Ltd, Case Study)

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
  • ○

    a clustered column chart that shows balances by date (x-axis) and account category (legend) without
    filters.
  • ○

    a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
  • ○

    a pie chart that shows balances by account category without filters.
  • ○

    a ribbon chart that shows balances by quarter and accounts in the legend.
Question 11 (Litware, Inc. Case Study)

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

Select an option, then click Submit answer.

  • ○

    an additional date table named ShipDate, a one-to-many relationship from
    Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from
    Sales[sales_ship_date_id] to ShipDate[date_id]
  • ○

    an additional date table named ShipDate, a many-to-many relationship from
    Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from
    Sales[sales_ship_date_id] to ShipDate[date_id]
  • ○

    a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
  • ○

    a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many
    relationship from Sales[sales_ship_date_id] to Date[date_id]
  • ○

    a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
Question 12 (Misc. Questions)

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

Select an option, then click Submit answer.

  • ○

    Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
  • ○

    Publish the reports to a different workspace other than the one hosting the datasets.
  • ○

    Publish the reports in an app and grant the HR managers access permission.
  • ○

    Add the HR managers as members of the existing workspace that hosts the reports and the datasets.