Exam 70-768 All Questions

View all questions & answers for the 70-768 exam

Exam 70-768 topic 1 question 4 discussion

Actual exam question from Microsoft's 70-768

Question #: 4
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: A 🗳️

by mkatic at June 27, 2019, 1:17 p.m.

Comments

Submit Cancel

mkatic

Highly Voted 6 years ago

Questions 4 and 6 . shouldn't it be the other way around? That 6 is correct and 4 incorrect? Because in question 4 you have CASE When KpiValue("Reseller Average Unit Price").... and in question 6 you have CASE When KpiValue("Large Sales Target")... Shouldn't the name of the KPI (which is Large Sales Target) come in brackets after KpiValue? In that case, the solution in question 6 should be correct. Or maybe that in question 4 you have CASE When [Measure].[Reseller Average Unit Price]...

upvoted 8 times

...

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 B.

upvoted 8 times

...

DudeHere

Most Recent 4 years, 5 months ago

All other values would get -1 which is red. B is the Answer

upvoted 1 times

...

othman_ee

4 years, 6 months ago

Going with B

upvoted 1 times

...

panal

4 years, 7 months ago

I Think the correct Answer is B (No) KpiValue and KPIGOAL must be "Large Sales Target"

upvoted 2 times

...

GervasioMontaNelas

4 years, 8 months ago

This one is No, KpiValue and KpiGoal should both be Large Sales Target

upvoted 3 times

...

Anette

4 years, 11 months ago

I Agree with Lenny001 and I think the answer is NO, for question 6 the answer is YES.

upvoted 3 times

...

Jrestrepo

5 years ago

I'm looking at this a second time and I'm thinking it should be =>.85 (.15 or more below the goal (.1 - .15 = .85).

upvoted 1 times

Jrestrepo

5 years ago

Ignore my previous statement, the answer is "No", because 15% or more (meaning 16%, 17%, 18%....) below the goal would be .84, .83, .82 .... and the statement >.85 would include .86 (which represents 14%, which is not below the 15% below the goal). LOL! I'm overthinking this too much.

upvoted 2 times

...

Jrestrepo

5 years ago

The answer is "No" because the statement >.85 would include 1.1

upvoted 1 times

Jrestrepo

5 years ago

Ignore my previous message, the answer is A.

upvoted 1 times

...

AbdulKabani

5 years, 6 months ago

In both questions: Expression value type "Value" Description "the reseller average unit price" Therefore answer to Q4 is Yes and Anwer to Q6 is No

upvoted 1 times

...

lele

5 years, 10 months ago

All the questions from the exam appeared here, if you can really remember everrything from here you should pass.

upvoted 2 times

...

kosa

5 years, 11 months ago

https://docs.microsoft.com/en-us/sql/mdx/kpivalue-mdx?view=sql-server-2017 KPIValue (MDX) Returns the member that calculates the value of the specified Key Performance Indicator (KPI). Syntax KPIValue(KPI_Name) Arguments KPI_Name A valid string expression that specifies the name of the KPI.

upvoted 6 times

...