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

Page 17 of 62
PDF with 246 Questions

HOTSPOT (Drag and Drop is not supported)
You have a Power BI report named Orders that supports the following analysis:
-Total sales over time
-The count of orders over time
-New and repeat customer counts

The data model size is nearing the limit for a dataset in shared capacity.
The model view for the dataset is shown in the following exhibit.

The data view for the Orders table is shown in the following exhibit.

The Orders table relates to the Customers table by using the CustomerID column.
The Orders table relates to the Date table by using the OrderDate column.
For each of the following statements, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: No
Would not support total sales over time.

Box 2: No
Would not support new and repeat customer counts
Box 3: Yes



HOTSPOT (Drag and Drop is not supported)
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: CALCULATE
Calculate the sum.

Box 2: DATEADD
DATEADD1 QUARTER will give the previous month.

Box 3: DIVIDE
Use DIVIDE to get the relative change.



DRAG DROP (Drag and Drop is not supported)
You are creating a Power BI model and report.
You have a single table in a data model named Product. Product contains the following fields:
-ID
-Name
-Color
-Category
-Total Sales

You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.

How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value 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.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: TOPN
TOPN returns the top N rows of the specified table.
Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]ג€¦])

Box 2: DESC
Descending order to get the highest values first.


Reference:

https://docs.microsoft.com/en-us/dax/topn-function-dax



You are creating a sales report in Power BI for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:


The report will facilitate the following analysis:
-The count of orders and the sum of total sales by Order Date
-The count of customers who placed an order
-The average quantity per order

You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. Set the data type for SalesOrderNumber to Decimal Number.
  2. Remove the CustomerKey and ProductKey columns.
  3. Remove the TaxAmt and Freight columns.
  4. Filter the data to only the NorthWest region sales territory.

Answer(s): C,D

Explanation:

C: Remove columns that are not used in the report.
D: Reduce the number of rows.
Incorrect:
Not A: Not possible.
Not B: Need CustomerKey to count of customers who placed an order



Page 17 of 62



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

Tejaswini commented on December 19, 2024
For my understanding
Anonymous
upvote

Tejaswini commented on December 19, 2024
Going throught questions for practice
Anonymous
upvote

Sheetal commented on November 24, 2024
Just going through the questions for my understanding of Power Bi
Anonymous
upvote

Eb'Oney commented on November 12, 2024
I think the answer here should be B. Split the Logged column by using at as the delimiter
UNITED STATES
upvote

Anouar commented on November 08, 2024
contenu enrichissant
Anonymous
upvote

Anouar commented on November 08, 2024
Salut ! Quelqu'un a-t-il tenté cet examen récemment ? Si c'est le cas, veuillez me faire savoir si ces questions sont toujours pertinentes et apparaissent dans l'examen sous le même
Anonymous
upvote

Luntz commented on November 05, 2024
If you want to just prepare for your exam and then clear it then this is a good source. But not for deep learning.
GERMANY
upvote

Gutsy commented on November 05, 2024
Pretty clear and close to content of real exam.
UNITED STATES
upvote

Jeron commented on October 15, 2024
Family hard exam. Unless you're an expert you cannot pass without using these exams.
UNITED KINGDOM
upvote

Elon commented on September 29, 2024
Hi! Has anyone attempted this exam recently? If so, please let me know if these questions are still relevant and appearing in the exam in the same format.
Anonymous
upvote

lala commented on September 26, 2024
really helping
Anonymous
upvote

Subrata commented on September 19, 2024
Good questions
Anonymous
upvote

Sulaksha commented on September 16, 2024
Good site to practice
Anonymous
upvote

Hatime commented on August 24, 2024
please i neeed more explantation over Question 10: why response C is incorrect??
Anonymous
upvote

Dinona commented on August 20, 2024
Good questions for practicing
Anonymous
upvote

zubair commented on August 05, 2024
Good Site to practice
PAKISTAN
upvote

john commented on August 04, 2024
good website
UNITED STATES
upvote

Pradeep commented on August 02, 2024
This is very informative
UNITED STATES
upvote

Prajwal commented on July 21, 2024
good websit for learning
Anonymous
upvote

Reet commented on July 08, 2024
This site is nyc
Anonymous
upvote

Reet commented on July 08, 2024
This site is very useful
Anonymous
upvote

Pinkey commented on July 08, 2024
Very useful this site
Anonymous
upvote

Rasmita commented on July 08, 2024
This link very helpfull
Anonymous
upvote

Your Guardian Angel commented on July 02, 2024
I have pl 300 certification exam in few days. if this is helpful i will update here (if there is no update from my side then this is waste of time ).
Anonymous
upvote

Adam commented on June 27, 2024
Passed this exam today. Valid dumps.
UNITED KINGDOM
upvote

Alven commented on June 21, 2024
I found this site extremely useful and the PDF is well formed. I had used other sites before where the PDF was full of watermark and typos, grammar mistakes and missing exhibits. This site provides the best one.
EUROPEAN UNION
upvote

Santosh K commented on June 21, 2024
In order to pass this exam you need this exam dumps. You will not be able to pass without knowing the questions. Thanks to sites like this.
UNITED STATES
upvote

Anonymous commented on June 17, 2024
Extremely useful and well formed questions for PL - 300 preparations
Anonymous
upvote

Baboo commented on June 16, 2024
wah bhai wah... Ek Dam Superb!
INDIA
upvote

Damyan commented on June 16, 2024
Very good material. The price is right and the content is well covered. The test engine software needs some improvements as per me opinion which I already shared with support team. Aside for that spot on!
Anonymous
upvote

Lulu commented on June 06, 2024
Good material!
Anonymous
upvote

Anonymous commented on May 01, 2024
good so far
PHILIPPINES
upvote

Janiece commented on April 20, 2024
This is preparation package is very nicely put together. It covers every single topic of the exam.
United States
upvote

Preemjeet commented on April 11, 2024
Questions are valid in India. Get the PDF which has all the questions. Free version does not include all questions and explanations.
INDIA
upvote