Which two actions should you perform?

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.
A . Remove duplicates from the Country column.
B. Remove duplicates from the City column.
C. |Remove duplicates from the table.
D. Delete the City column.
E. Delete the Country column.

View Answer

Answer: A,D

Explanation:

To create a dimension table for Country from your source data, you need to perform these two actions34:

✑ Delete the City column. You don’t need this column for your Country dimension, as it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis.

✑ Remove duplicates from the Country column. You want to have a list of unique countries in your dimension table, so you need to remove any duplicate values from this column.