← Back to exam page

PL-300 – Microsoft Power BI Data Analyst

Loading demo links...

Showing 13–15 of 15 questions

Question 13 (Misc. Questions)

You have a Power Bl report that contains five pages.

Pages 1 to 4 are visible and page 5 is hidden.

You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.

What should you do first?

Select an option, then click Submit answer.

  • ○

    Add a blank button to page 1.

  • ○

    Add a bookmark navigation button to page 1.

  • ○

    Create a bookmark for each page.

  • ○

    Add a page navigation button to page 1.
Question 14 (Misc. Questions)

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 custom visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report

You need to recommend a solution to improve the performance of the report.

What should you recommend?

Select an option, then click Submit answer.

  • ○

    Split the visuals onto multiple pages.
  • ○

    Implement row-level security (RLS).
  • ○

    Replace the default visuals with custom visuals.
  • ○

    Increase the number of times that the dataset is refreshed.
Question 15 (Misc. Questions)

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.

You have a Microsoft SQL Server database that contains the following tables.

Table Description automatically generated

The following columns contain date information:

- Date[Month] in the mmyyyy format

- Date[Date_ID] in the ddmmyyyy format

- Date[Date_name] in the mm/dd/yyyy format

- Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.

You plan to use Power BI Desktop to create an analytics solution for the data.

You need to create a relationship between the Order table and the Store table on the Store_ID column.

What should you do before you create the relationship?

Select an option, then click Submit answer.

  • ○

    In the Order table query, use the Table.TrasformRows function.
  • ○

    In the Store table query, use the Table.TrasformRows function.
  • ○

    In the Store table query, use the Table.TrasformColumnTypes function.
  • ○

    In the Order table query, use the Table.TrasformColumnTypes function.