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

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

List of questions

Question 321

Report
Export
Collapse

HOTSPOT

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales You need to create a measure that calculates the total sales from the equivalent month of the previous year.

How should you complete the calculation? 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 322

Report
Export
Collapse

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?

Microsoft PL-300 image Question 289 106546 10052024010716000000

Become a Premium Member for full access
  Unlock Premium Member

Question 323

Report
Export
Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 324

Report
Export
Collapse

HOTSPOT

You have a Power BI report that contains a page. The page contains the following visuals:

* A card

* A matrix

* A bar chart

You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix The card and the bar chart must change when a user selects a cell in the matrix.

What should you configure? To answer, select the appropriate options in the answer area.


Become a Premium Member for full access
  Unlock Premium Member

Question 325

Report
Export
Collapse

HOTSPOT

You are creating a Power 81 model to analyze inventory.

You load data into three tables named Date Product, and Inventor/. The Inventor/ table relates to the Date and Product tables by using one-to-many relationships.

Inventor)' data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month

You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.

How should you complete the measure? 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 326

Report
Export
Collapse

HOTSPOT

You create a Power Bl dataset that contains the table shown in the following exhibit.

Microsoft PL-300 image Question 293 106550 10052024010716000000

You need to make the table available as an organizational data type In Microsoft Excel.

How should you configure the properties of the table? 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 327

Report
Export
Collapse

You have a Power Bl model that contains the following data.

Microsoft PL-300 image Question 294 106551 10052024010716000000

The Date table relates to the Sales table by using the Date columns.

The model contains the following DAX measure.

Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

Which DAX calculation should you use?

Become a Premium Member for full access
  Unlock Premium Member

Question 328

Report
Export
Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 329

Report
Export
Collapse

DRAG DROP

You use Power Query Editor to preview the data shown in the following exhibit

Microsoft PL-300 image Question 296 106553 10052024010717000000

You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.

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.

Become a Premium Member for full access
  Unlock Premium Member

Question 330

Report
Export
Collapse

HOTSPOT

You have a query named All Sales that imports sales data into a Power BI model.

You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:

* Use All Sales as the source for three other queries named Sales Fact Product Dimension, and Customer Dimension.

* Minimize maintenance effort.

What should you do to create the Sales Fact query, and for which query should you clear Enable load? 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
Total 370 questions
Go to page: of 37
Search

Related questions