PL-300 · Question #332
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
The correct answer is D. Delete the City column. E. Remove duplicates from the Country column.. 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
Question
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.
Options
- ADelete the Country column.
- BRemove duplicates from the table.
- CRemove duplicates from the City column.
- DDelete the City column.
- ERemove duplicates from the Country column.
How the community answered
(33 responses)- A9% (3)
- B3% (1)
- C18% (6)
- D70% (23)
Explanation
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
Community Discussion
No community discussion yet for this question.