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.
=RELATEDTABLE(Geography)
B.
=RELATED(Geography[City])
C.
=Geography[City]
D.
City:=Geography[City]
E.
City:=RELATED(Geography[City])
F.
City :=RELATEDTABLE (Geography)
C
B is correct
E
City := – gives the column correct name
RELATED(Geography[City]) – returns city name from related table Geography
why do you give different answer for the same question?
http://www.aiotestking.com/microsoft/how-should-you-write-the-calculation-2/
He doesnt look closer.
I agree with Ralph
Measures require name before “:=”, but columns are defined without it in the formula textbox.
Just google “calclulated column” and you will see the difference.
Agreed with Ruslan. So answer is B
This is confusing question, even though adding just the formula will not give the correct column name “City”, I think it is still B.
https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/ssas-calculated-columns
E, I agree with Ralph