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

Page 22 of 85
PDF with 356 Questions

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
DATEADD -1 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



You are creating a Power BI model that contains a table named Store. Store contains the following fields.
You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City.
What should you do to ensure that the locations are mapped properly?

  1. Change the data type of City, State/Province, and Country.
  2. Set Summarization for City, State/Province, and Country to Don't summarize.
  3. Set the data category of City, State/Province, and Country.
  4. Create a calculated column that concatenates the values in City, State/Province, and Country.

Answer(s): C






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

PL-300 Exam Discussions & Posts