Question 332 of 388
Choose 2You 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.
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.
✓
Correct Answer: D, E
Delete the City column.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.