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

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

List of questions

Question 281

Report
Export
Collapse

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. From Power Query Editor, you profile the data shown in the following exhibit.

Microsoft PL-300 image Question 248 106505 10052024010716000000

The IoT GUID and IoT ID columns are unique to each row in query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You split the loT DateTime column into a column named Date and a column named Time.

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 282

Report
Export
Collapse

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. From Power Query Editor, you profile the data shown in the following exhibit.

Microsoft PL-300 image Question 249 106506 10052024010716000000

The IoT GUID and IoT ID columns are unique to each row in query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You remove the loT GUID column and retain the loT ID column.

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 283

Report
Export
Collapse

You have a Power BI data model that anafollowing tables.

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

Microsoft PL-300 image Question 250 106507 10052024010716000000

A one-to-many relationship exists between the tables.

The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter. Which two actions should you perform?

Microsoft PL-300 image Question 250 106507 10052024010716000000

Become a Premium Member for full access
  Unlock Premium Member

Question 284

Report
Export
Collapse

What is the minimum number of Power BI datasets needed to support the reports?

Become a Premium Member for full access
  Unlock Premium Member

Question 285

Report
Export
Collapse

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI report that imports a date 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 the date foreign keys.

Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date. Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 286

Report
Export
Collapse

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI report that imports a date 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 the date foreign keys.

Solution: For each date foreign key, you add inactive relationships between the sales table and the date table. Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 287

Report
Export
Collapse

You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.

You add the following fields to the Explain By field:

* Customer Country

* Product Category

* Supplier Country

* Sales Employee

* Supplier Name

* Product Name

* Customer City

The key influencers visual returns the results shown in the following exhibit.

Microsoft PL-300 image Question 254 106511 10052024010716000000

What can you identify from the visual?

Become a Premium Member for full access
  Unlock Premium Member

Question 288

Report
Export
Collapse

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. From Power Query Editor, you profile the data shown in the following exhibit.

Microsoft PL-300 image Question 255 106512 10052024010716000000

The IOT ID columns are unique to each row in query.

You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance. Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns. Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 289

Report
Export
Collapse

You have a Microsoft Excel file on a file server.

You create a Power BI report and import a table from the Excel file.

You publish the report.

You need to ensure that the data refreshes every four hours.

What should you do first?

Become a Premium Member for full access
  Unlock Premium Member

Question 290

Report
Export
Collapse

HOTSPOT

You have the Azure SQL databases shown in the following table.

Microsoft PL-300 image Question 257 106514 10052024010716000000

You plan to build a single PBIX file to meet the following requirements:

• Data must be consumed from the database that corresponds to each stage of the development lifecycle. • Power Bl deployment pipelines must NOT be used.

• The solution must minimize administrative effort.

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


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

Related questions