You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
To create a dimension containing a list of unique countries, you should first delete the City column because it is not needed for the Country dimension. Then, you can remove duplicates from the Country column to ensure that the list contains unique values. Removing the City column simplifies the table, and removing duplicates from the Country column ensures that only distinct countries are included in the dimension.
DE is correct we only need the countries
Agree The table has tocontain unique values for "Country" column, so - delete the city column --> in fact this column is not requested - Remove dupicates from the Country column
This was on the exam
DB should also be accepted since the table has only one row after deleting City column.
This is was on the exam today. 2024-04-19
DE is correct, but feel like BD could also work, since it technically does the same thing
DE or ED give you absolutely the same result. I hate questions like this because the test has only one correct answer :( Even more, "delete the city column" and "remove duplicates from the table" (step: Table.Distinct) it still correct. So, we have three correct answers.
D and E are correct.
It was so easy that I was suspicious...
one could say it was stress free
DE is correct
B & E are the correct answers. B. Remove duplicates from the table: this action will ensure that only unique rows (combinations of Country and City) remain in the table, effectively removing any duplicate countries. E. Remove duplicates from the country column: This action specifically removes duplicates from the "Country" column, ensuring that we have a list of unique countries. B & E actions, when performing in sequence, will give you a dimension with a list of unique countries, which is what we need for the star schema.
DE and BE Would Work. !!
piece of cake d, e
DE is correct
CONFUSING OPTIONS....BEST OPTION IS NEWCOUNTRY=ALLNOBLANKROW(COUNTRY[COUNTRY])
yeah no
now we can only hope that it'd show up in the exam
BD works but you are doing unnecessary filtering of a city column, which is irrelevant here, so the best solution is to remove the City column first and then remove the duplicates in the Country column so DE is the better option.
De is correct