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

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

Suggested Answer: B 🗳️

by kosa at July 27, 2019, 7:10 a.m.

Comments

Submit Cancel

Lenny001

Highly Voted 5 years, 4 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, 11 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, 6 months ago

Going with A (yes)

upvoted 2 times

...

bhrv

4 years, 7 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, 7 months ago

I Think the correct answer is A (YES)

upvoted 2 times

...

JayBaba

4 years, 11 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, 9 months ago

no!! it's kpivalue divided by kpigoal, not always equal to 1!!

upvoted 1 times

...

Jrestrepo

5 years ago

The arguments for KPIValue and KPIGoal can't be the same

upvoted 1 times

Anette

4 years, 11 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

5 years ago

Can someone confirm if it is A and why? Conflicting arguments on both pages

upvoted 2 times

...

bjamsh

5 years, 1 month 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, 1 month 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, 1 month ago

sorry I mean "Large Sales Target "

upvoted 2 times

Anette

4 years, 11 months ago

I agree, Q6 is NO and Q4 is yes.

upvoted 1 times

eceb

4 years, 9 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, 6 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, 6 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, 11 months ago

not A?

upvoted 1 times

...