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

Page 25 of 85
PDF with 356 Questions

You have the Power BI data model shown in the following exhibit.
The Sales table contains records of sales by day from the last five years up until today’s date.
You plan to create a measure to return the total sales of March 2021 when March 2022 is selected.
Which DAX expression should you use?

  1. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])
  2. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )
  3. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
  4. SUM(Sales[Sales])

Answer(s): C



You use Power BI Desktop to load data from a Microsoft SQL Server database.
While waiting for the data to load, you receive the following error.
You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  1. Reduce the number of rows and columns returned by each query.
  2. Split log running queries into subsets of columns and use Power Query to merge the queries.
  3. Use Power Query to combine log running queries into one query.
  4. Disable query folding on long running queries.

Answer(s): A,B



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 split the IoT DateTime column into a column named Date and a column named Time.
Does this meet the goal?

  1. Yes
  2. No

Answer(s): A



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 remove the IoT GUID column and retain the IoT ID column.
Does this meet the goal?

  1. Yes
  2. No

Answer(s): A






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

PL-300 Exam Discussions & Posts