Valid PL-300 Dumps shared by ExamDiscuss.com for Helping Passing PL-300 Exam! ExamDiscuss.com now offer the newest PL-300 exam dumps, the ExamDiscuss.com PL-300 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com PL-300 dumps with Test Engine here:
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.
Correct Answer: A,D
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.