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

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

List of questions

Question 301

Report
Export
Collapse

You have a Microsoft SharePoint Online site that contains several document libraries.

One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.

What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 302

Report
Export
Collapse

You are building a data model for a Power Bl report. You have data formatted as shown in the following table.

Microsoft PL-300 image Question 269 106526 10052024010716000000

You need to create a clustered bar chart as shown in the following exhibit.

Microsoft PL-300 image Question 269 106526 10052024010716000000

What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 303

Report
Export
Collapse

DRAG DROP

You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

Microsoft PL-300 image Question 270 106527 10052024010716000000

You plan to build a data model for a Power Bl report.

You need to prepare the data so that it is available to the model in the format shown in the following table.

Microsoft PL-300 image Question 270 106527 10052024010716000000

Which three actions should you perform in sequence in Power Query Editor? 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 304

Report
Export
Collapse

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

• A shape named Shape 1

• A card named Sales Summary

• A clustered bar chart named Sales by Region

You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?

Become a Premium Member for full access
  Unlock Premium Member

Question 305

Report
Export
Collapse

DRAG DROP

You use Power Query Editor to preview customer feedback data.

You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:

• What the customers most often provide feedback about

• Whether the customers like your company’s product

• The language of the feedback

Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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 306

Report
Export
Collapse

You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:

• Date

• Fiscal year

• Fiscal Quartet

• Month Name

• Calendar Year

• Week Number

• Month Number

• Calendar Quarter

You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

Become a Premium Member for full access
  Unlock Premium Member

Question 307

Report
Export
Collapse

HOTSPOT

You are creating a Power Bi model in Power BI Desktop

You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX 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 308

Report
Export
Collapse

DRAG DROP

You have a Power Bi report that contains five bookmarks.

You need to add an object to the report from which users can navigate between three specific bookmarks.

How should you complete the task? To answer, drag the appropriate actions to the correct steps, each action may be used once more than once, or not at all. You may need to drag the split bar between panes or scroll lo view content.

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 309

Report
Export
Collapse

You have a Power B1 report named ReportA.

You have a Power B1 tenant that allows users to export data.

You need to ensure that consumers of ReportA cannot effort any data from visuals.

Which two actions should you perform? 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 310

Report
Export
Collapse

You have a Rawer Bl report That imports a dace table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

• Due Date

• Order Date

• Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

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

Related questions