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
DB should also be accepted since the table has only one row after deleting City column.
This was on the exam
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
It was so easy that I was suspicious...
one could say it was stress free
D and E are correct.
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.
De is correct
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.
CONFUSING OPTIONS....BEST OPTION IS NEWCOUNTRY=ALLNOBLANKROW(COUNTRY[COUNTRY])
yeah no
now we can only hope that it'd show up in the exam
DE is correct
piece of cake d, e
DE and BE Would Work. !!
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 is correct