CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. PL-300

Free PL-300 Exam Braindumps (page: 27)

Page 26 of 85
PDF with 356 Questions

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.
The IoT GUID and IoT ID columns are unique to each row in the query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You change the IoT DateTime column to the Date data type.
Does this meet the goal?

  1. Yes
  2. No

Answer(s): B



You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?

  1. Change any DAX measures to use iterator functions.
  2. Remove unused columns from tables in the data model.
  3. Replace the default visuals with AppSource visuals.
  4. Increase the number of times that the dataset is refreshed.

Answer(s): B



DRAG DROP (Drag and Drop is not supported)
You have a Power BI data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the DAX measure? To answer, drag the appropriate DAX functions to the correct targets. Each function 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.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have a Power BI data model that analyzes product sales over time. The data model contains the following tables.
A one-to-many relationship exists between the tables.
The auto date/time option for the data model is 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? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

  1. Create a relationship between the Date table and the Sales table.
  2. Disable the auto date/time option.
  3. Create a Date table and select Mark as Date Table.
  4. Disable the load on the Date table.
  5. Remove the relationship between the Product table and the Sales table.

Answer(s): A,C






Post your Comments and Discuss Microsoft PL-300 exam with other Community members:

PL-300 Exam Discussions & Posts