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

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

List of questions

Question 351

Report
Export
Collapse

You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue.

Solution: You Normalize casing in the source query or Power Query Editor.

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 352

Report
Export
Collapse

You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.

You attempt to refresh the data and receive the following error message.

Expression.Error: The Colum 'cost' of the table wasn't found.

What is a possible cause of the error?

Become a Premium Member for full access
  Unlock Premium Member

Question 353

Report
Export
Collapse

You attempt to connect Power BI Desktop to a Cassandra database.

From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.

You need to select an alternate data connector that will connect to the database.

Which type of connector should you choose?

Become a Premium Member for full access
  Unlock Premium Member

Question 354

Report
Export
Collapse

HOTSPOT

You are profiting data by using Power Query Editor.

You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.

Microsoft PL-300 image Question 321 106578 10052024010717000000


Become a Premium Member for full access
  Unlock Premium Member

Question 355

Report
Export
Collapse

DRAG DROP

You have a Power BI workspace that contains a single report named Sales.

You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visual added to the page area added automatically to the dashboard.

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 356

Report
Export
Collapse

You have a data source that contain a column. The column contains case sensitive data.

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You implicitly convert the values into the required types.

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 357

Report
Export
Collapse

You create a Power Bl report1 named Summary1 You discover that Summary1 is slow.

You run Performance analyzer to identify performance metrics for Summary1

Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.

Become a Premium Member for full access
  Unlock Premium Member

Question 358

Report
Export
Collapse

HOTSPOT

You have a Power Bl semantic model that contains a table named Opportunity.

The Opportunity table contains a column named Qualification

The Qualification column contains values between 0 and V

You need to build a new measure to score the opportunities on a scale of low, medium, and high.

How should you complete the DAX formula? 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 359

Report
Export
Collapse

HOTSPOT

You have a Power BI semantic model.

You discover that he semantic model contains values that display as errors.

You need to use data profiling feature in Power Query to preview the date and identify the issues.

What should you select to gain into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 360

Report
Export
Collapse

HOTSPOT

You have a Power BI semantic model named Model1.

You need to create a measure that will display the sales result for all units. The solution must maintain the existing filter.

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
Total 370 questions
Go to page: of 37
Search

Related questions