Practice Free PL-300 Exam Online Questions

You have a Power Bl query named Sates that imports the columns shown in the following table.

Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.

You need to reduce the load times of the query without affecting the analysis.

Which two actions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one pant.

Reveal Solution Hide Solution

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You enable included in app for all assets.

Does this meet the goal?

Reveal Solution Hide Solution

HOTSPOT

You have a report page that contains the visuals shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: cross-filter

By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.

Box 2: cross-highlight

Example:

By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.

You build a Power Bl report that displays 10T temperature data streaming from a refrigerator.

You publish the report to the Bl service.

You need to be notified when the temperature rises above four degrees Celsius.

What should you do?

Reveal Solution Hide Solution

HOTSPOT

You ate creating a Power 81 report that will show the number of current employees over time. The report will use Import storage mode for all tables.

The employment data will be imported from Azure SQL Database in a monthly snapshot.

The data will be stored in a table named Headcount and will contain the following:

• One row per employee for each month the employee is employed

• In each row, a date key that shows the first day of the month of each snapshot

You have a related date table that contains dates for the years 2020 to 2030.

Reveal Solution Hide Solution

Correct Answer:

DRAG DROP

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.

Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Reveal Solution Hide Solution

Correct Answer:

DRAG DROP

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.

Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Reveal Solution Hide Solution

Correct Answer:

You have an Azure SQL database that contains sales transactions. The database is updated frequently.

You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.

How should you configure the data connection?

Reveal Solution Hide Solution

DRAG DROP

You are creating a Power Bi model and report.

You have a single table in a data mode) named Product Product contains the following fields:

• ID

• Name

• Color

• Category

• Total Sales

You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.

How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets. Each value 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.

Reveal Solution Hide Solution

Correct Answer:

You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following 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?

Reveal Solution Hide Solution