exam questions

Exam 70-768 All Questions

View all questions & answers for the 70-768 exam

Exam 70-768 topic 1 question 12 discussion

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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets. You identify the following metrics for employees:
✑ Ninety percent or greater relative to sales target values is considered on target.
✑ Between 75 percent and 90 percent is considered slightly off target.
✑ Below 75 percent is considered off target.
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:

Does the solution meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
Lenny001
Highly Voted 5 years, 4 months ago
An employee with 74.5% is off-target, according to the requirements. In the expression 74,5% is not in the ELSE branch, but it is in the second one. So the solution is B: No.
upvoted 8 times
Lex_P
5 years, 2 months ago
I agree
upvoted 1 times
Jrestrepo
5 years ago
I agree, The second WHEN statatement on the "AND" part should be >= .75
upvoted 5 times
...
...
...
DudeHere
Most Recent 4 years, 5 months ago
Not reading into it. Let's just assume all percentages are rounded to .xx Sticking with A
upvoted 1 times
...
othman_ee
4 years, 6 months ago
Going with B
upvoted 1 times
...
radissoufan
5 years, 1 month ago
you right... but what if the question made wrong by Microsoft :\
upvoted 4 times
HaJee
4 years, 9 months ago
This is my main fear when making these exams
upvoted 2 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 ...