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: 28)

Page 27 of 85
PDF with 356 Questions

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. Implement row-level security (RLS).
  2. Remove unused columns from tables in the data model.
  3. Replace the default visuals with AppSource visuals.
  4. Enable visual interactions.

Answer(s): B



HOTSPOT (Drag and Drop is not supported)
You have a Power BI data model that contains a table named Stores. The table has the following columns:
• Store Name
• Open Date
• Status
• State
• City
You need to create a calculated column named Active Store Name that meets the following requirements:
• When the value of the Status column is “A”, the value in the Store Name column must be returned.
• When the value of the Status column is NOT “A”, the value in the Store Name column that is prefixed with "Inactive - " must be returned.
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.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

  1. Apply a transformation to extract the first 11 characters of the logged column.
  2. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
  3. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
  4. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

Answer(s): C



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 create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
Does this meet the goal?

  1. Yes
  2. No

Answer(s): B






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

PL-300 Exam Discussions & Posts