ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 8 question 4 discussion

Actual exam question from Microsoft's PL-300
Question #: 4
Topic #: 8
[All PL-300 Questions]

What should you create to meet the reporting requirements of the sales department?

  • A. a measure that uses a formula of COUNTROWS(Sales)
  • B. a calculated column that use a formula of COUNTA(Sales[sales_id])
  • C. a calculated column that uses a formula of SUM(Sales[sales_id])
  • D. a measure that uses a formula of SUM(Sales[sales_id])
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by olajor at Sept. 19, 2022, 9:54 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
fred92
Highly Voted 2 years, 6 months ago
Selected Answer: A
Answer is correct
upvoted 10 times
...
Hoeishetmogelijk
Highly Voted 2 years, 4 months ago
Selected Answer: A
A is correct. It must be a count function and a measure.
upvoted 8 times
...
jaume
Most Recent 5 months, 1 week ago
Selected Answer: A
There is a requirement to not consider negative and missing sales_amount but this is just for the total sales_amount calculation so we should assume every row in the "sales" table stands for one single transaction and we should count all of them, so right answer should be option A counting the ROWS of he "Sales" table We need a measure to return a scalar and options B and C are about adding calculated columns. In option D it's suggested to SUM the [Sales_id] but there is no sense summing any field to count number of transactions and even less summing some Id which could be usin any coding to identify sales.
upvoted 1 times
...
Newb007
2 years ago
Why not B? whats wrong with a new column ? also what about the blanks in sales?
upvoted 1 times
Shalaleh
2 years ago
we do not need calculated column! calculated column uses row- filter but we need a scaler value!
upvoted 2 times
...
...
olajor
2 years, 7 months ago
Shouldn't it be B though? You don't want to count blank sales_ids
upvoted 2 times
June15
2 years, 7 months ago
B says it's a column, not a measure.
upvoted 3 times
...
KAYBOL
1 year, 6 months ago
sales_ids are unique identifier (primary key) of the table; cant be null
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago