exam questions

Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 76 discussion

Actual exam question from Microsoft's 70-779
Question #: 76
Topic #: 1
[All 70-779 Questions]

You are building a KPI.
You need to configure the KPI to display a red icon when the sales from a month is less than nine percent of the sales from the last 12 months.
What should you use to define the target value?

  • A. a measure
  • B. a calculated column
  • C. a calculated field
  • D. an absolute value
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
Reference:
https://support.office.com/en-us/article/key-performance-indicators-kpis-in-power-pivot-e653edef-8a21-40e4-9ece-83a6c8c306aa

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
CABREU
Highly Voted 5 years, 4 months ago
A is correct. Must be a measure because "last 12 months" is dynamic. You won't reach this requirement with an absolute value.
upvoted 39 times
...
iaaqq
Most Recent 4 years, 5 months ago
A. a measure CORRECT ANS
upvoted 2 times
...
wanjinyou
4 years, 8 months ago
I think the correct answer is C. The target value only has two choices. Absolute value and Calculated field. Absolute value is for the fixed value. https://www.youtube.com/watch?v=jpBcPt8qp1U
upvoted 1 times
...
MCyay
4 years, 8 months ago
Is A or D right?
upvoted 1 times
kannn
4 years, 7 months ago
A is correct
upvoted 1 times
...
...
lyniguez
4 years, 9 months ago
Target value A Target value is also a calculated field that results in a value—perhaps an absolute value. For example, a calculated field could be used as a target value, in which the business managers of an organization want to compare how the sales department is tracking toward a given quota, where the budget calculated field would represent the target value. An example in which an absolute value would be used as a target value is the common case of an HR manager needing to evaluate the number of paid-time-off hours for each employee—and then compare it the average. The average number of PTO days would be an absolute value.
upvoted 2 times
...
r8d1
4 years, 11 months ago
in support of A Create a measure to calculate the sales from the last 12 months.
upvoted 1 times
...
CibrevN
5 years ago
D. an absolute value, is correct. I have checked!
upvoted 2 times
...
SN22
5 years, 4 months ago
Correct answer is D
upvoted 3 times
...
Vishy
5 years, 5 months ago
It can be both as per the statement - The KPI gauges the performance of the value, defined by a Base measure (also known as a calculated field in Power Pivot in Excel 2013), against a Target value, also defined by a measure or by an absolute value.
upvoted 1 times
...
Shil
5 years, 6 months ago
The right answer is D-An absolute value. For KPI's, a Measure is used as a base value.
upvoted 4 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
Loading ...