You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used
in the definition of a hierarchy. The City column exists in the Geography table that is related
to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?
A.
City:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])
B.
City:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey])
C.
=RELATED(Geography[City]) =RELATED(Geography.City)
D.
=VALUES(Geography[City])
E.
City:=VALUE5(Geography[City])
Correct answer should be:
=RELATED(Geography[City])
Tablet arÄ™ related SO need to usesomething wlse
I meant… Tables are related, so solution from Du is correct. It is probably answer “C”
Tables are already related.
It`s C =RELATED(Geography[City])
C is Correct
Passed successfully! Not Difficult at all! I have already uploaded my 70-466 practice questions here for free download and learning: https://drive.google.com/folderview?id=0B75b5xYLjSSNfjdMb2txSGJsT3V3cDFiaFpzdndqaVBUVWcyWnhFNWdoQ1h1N1FSVTBWU1E&usp=sharing
Wish this file can help you a little bit and pass successfuly!