exam questions

Exam 70-768 All Questions

View all questions & answers for the 70-768 exam

Exam 70-768 topic 1 question 6 discussion

Actual exam question from Microsoft's 70-768
Question #: 6
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 a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order data for customers in the United States only. The database contains the following objects:

You must create a KPI named Large Sales Target that uses the Traffic Light indicator to display status. The KPI must contain:

You need to create the KPI.
Solution: You set the value of the Status expression to:

Does the solution meet the goal?

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

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, 2 months ago
KpiValue and KpiGoal accept a single parameter, that is the name of a Kpi. In this case "Large Sales Target". The solution is A.
upvoted 10 times
...
Anette
Highly Voted 4 years, 9 months ago
Question is very clear: create a KPI named Large Sales Target . And based on theory: KPIValue - Returns the member that calculates the value of the specified Key Performance Indicator (KPI). Syntax: KPIValue(KPI_Name) Where KPI_Name is a valid string expression that specifies the name of the KPI. So the answer is YES. Q4 is NO. Don't be confused from Table of expression where Value is the reseller average unit price.
upvoted 9 times
...
othman_ee
Most Recent 4 years, 4 months ago
Going with A (yes)
upvoted 2 times
...
bhrv
4 years, 5 months ago
any source you visit for KPI MDX you will always find that KPIVALUE and KPIGOAL use the same measure.
upvoted 1 times
...
panal
4 years, 6 months ago
I Think the correct answer is A (YES)
upvoted 2 times
...
JayBaba
4 years, 9 months ago
it is B. "Large Sale Target/Large Sale Target" will always be equal to 1 i.e x/x = 1
upvoted 1 times
eceb
4 years, 7 months ago
no!! it's kpivalue divided by kpigoal, not always equal to 1!!
upvoted 1 times
...
...
Jrestrepo
4 years, 10 months ago
The arguments for KPIValue and KPIGoal can't be the same
upvoted 1 times
Anette
4 years, 9 months ago
no way, who told you that?! https://docs.microsoft.com/en-us/sql/mdx/kpivalue-mdx?view=sql-server-ver15
upvoted 5 times
...
...
Mikeyyyyyyyyyy
4 years, 10 months ago
Can someone confirm if it is A and why? Conflicting arguments on both pages
upvoted 2 times
...
bjamsh
5 years ago
B is the answer for this question because the measure name passed to KpiValue is not correct (it must be Reseller Average Unit Price)
upvoted 4 times
radissoufan
5 years ago
MAN it says KPI_NAME inside the parameters of kpivalue and kpigoal... in the question it says that the kpi name is "large reseller value" its true
upvoted 4 times
radissoufan
5 years ago
sorry I mean "Large Sales Target "
upvoted 2 times
Anette
4 years, 9 months ago
I agree, Q6 is NO and Q4 is yes.
upvoted 1 times
eceb
4 years, 7 months ago
Anette, I agree with your other comment below, not this one. The correct answers are: - Q6 YES - Q4 NO (the kpiname is not Reseller Average Unit Price, should be Large Sales Target)
upvoted 2 times
...
...
...
...
...
AbdulKabani
5 years, 4 months ago
In both questions Q4 and 6: Expression value type "Value" Description "the reseller average unit price" Therefore answer to Q4 is Yes and Anwer to Q6 is No
upvoted 2 times
...
mimie
5 years, 4 months ago
must be A. why is it B when number 4 is A and they both are status expressions
upvoted 1 times
...
kosa
5 years, 9 months ago
not A?
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago