Microsoft Exam PL-300 Topic 11 Question 31 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 31
Topic #: 11

[All PL-300 Questions]

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.

ARemove duplicates from the Country column.

BRemove duplicates from the City column.

C|Remove duplicates from the table.

DDelete the City column.

EDelete the Country column.

Show Suggested Answer

Suggested 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.

by Dalene at Oct 02, 2023, 07:07 PM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!