ExamGecko
Home / Microsoft / PL-300 / List of questions
Ask Question

Microsoft PL-300 Practice Test - Questions Answers, Page 30

List of questions

Question 291

Report
Export
Collapse

You are creating a dashboard by using the Power Bl service.

You have an existing report page that contains three charts.

You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 292

Report
Export
Collapse

You have a dataset that is used infrequently and refreshes every hour.

You receive a notification that the refresh was disabled due to inactivity.

Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Become a Premium Member for full access
  Unlock Premium Member

Question 293

Report
Export
Collapse

In Power BI Desktop, you are creating a report that will contain three pages.

You need to create a custom tooltip page and prepare the page for use.

Which three actions should you perform? Each correct answer presents part of the solution.

Become a Premium Member for full access
  Unlock Premium Member

Question 294

Report
Export
Collapse

You are creating a query to be used as a Country dimension in a star schema.

A snapshot of the source data is shown in the following table.

Microsoft PL-300 image Question 261 106518 10052024010716000000

You need to create the dimension. The dimension must contain a list of unique countries.

Which two actions should you perform? Each correct answer presents part of the solution.

Become a Premium Member for full access
  Unlock Premium Member

Question 295

Report
Export
Collapse

Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.

Microsoft PL-300 image Question 262 106519 10052024010716000000

You need to shape the query to display the following three columns:

* Month

* Sales

* Year

What should you select in Power Query Editor?

Become a Premium Member for full access
  Unlock Premium Member

Question 296

Report
Export
Collapse

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the fol-lowing format:

2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 297

Report
Export
Collapse

DRAG DROP

You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.

You add a sheer named Country to each page of the report.

You need to configure the report to meet the following requirements:

• When a user selects a country on the first page, the report must filter the other pages.

• The second and third pages must display only the filtered results.

Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE Each correct selection is worth one point.



Become a Premium Member for full access
  Unlock Premium Member

Question 298

Report
Export
Collapse

HOTSPOT

You have the Power Bl data model shown in the following exhibit.

Microsoft PL-300 image Question 265 106522 10052024010716000000

You need to create a measure to count the number of product categories that had products sold during a selected period. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 299

Report
Export
Collapse

DRAG DROP

You have the Power Bl data model shown in the following exhibit.

You create two row-level security (RlS) roles named Manager and CFO.

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

• Each manager must see only the data in the Sales and Human Resources tables for their own country.

• The CFO must be prevented from seeing the data in the Human Resources table.

• The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Microsoft PL-300 image Question 266 106523 10052024010716000000

The Country table contains the following data.

Microsoft PL-300 image Question 266 106523 10052024010716000000

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

• Each manager must see only the data in the Sales and Human Resources tables for their own country.

• The CFO must be prevented from seeing the data in the Human Resources table.

• The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 300

Report
Export
Collapse

You are building a Power Bl report.

Users will view the report by using their mobile device.

You need to configure the report to display data based on each user s location.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Become a Premium Member for full access
  Unlock Premium Member
Total 370 questions
Go to page: of 37
Search

Related questions