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.

Questions › Category: PL-300 › 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.

0 Vote Up Vote Down

Admin Staff asked 4 months ago

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.

A. Delete the Country column.

B. Remove duplicates from the table.

C. Remove duplicates from the City column.

D. Delete the City column.

E. Remove duplicates from the Country column.






 

Suggested Answer: DE



This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate