Microsoft PL-300 Exam - 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

Tawna

3 months ago

Removing duplicates from the table itself is also a good idea!

upvoted 0 times

...

Kirby

3 months ago

Wait, why would we delete the Country column? That sounds wrong.

upvoted 0 times

...

Leonida

3 months ago

Removing duplicates from the City column? Seems unnecessary.

upvoted 0 times

...

Izetta

4 months ago

Agree, that's the way to go!

upvoted 0 times

...

Maryann

4 months ago

Definitely need to remove duplicates from the Country column.

upvoted 0 times

...

Gilma

4 months ago

I’m a bit confused about whether we should delete the City column or just focus on duplicates. I feel like we might need it for other queries.

upvoted 0 times

...

Sheron

4 months ago

This question feels similar to one we practiced where we had to clean up data for a dimension. I think removing duplicates from the Country column is key.

upvoted 0 times

...

Viola

4 months ago

I'm not entirely sure, but I remember something about not needing to touch the City column for this specific task.

upvoted 0 times

...

Adolph

5 months ago

I think we definitely need to remove duplicates from the Country column to get unique country values.

upvoted 0 times

...

Youlanda

5 months ago

I'm not sure about this one. Should I be removing duplicates or deleting columns? I'll need to think this through carefully to make sure I get the right solution.

upvoted 0 times

...

Leah

5 months ago

I've got this! The key is to remove duplicates from the Country column to create the dimension. Deleting the City column or the entire table would be overkill.

upvoted 0 times

...

Leonora

5 months ago

Okay, I'm a bit confused here. Should I be removing duplicates from the City column instead? Or do I need to remove duplicates from the entire table?

upvoted 0 times

...

Marylyn

5 months ago

Hmm, this looks like a straightforward data cleansing task. I think I'll start by removing duplicates from the Country column to get a unique list of countries.

upvoted 0 times

...

Howard

5 months ago

Ah, I see what they're asking for. Removing duplicates from the Country column is the way to go. That will give me a clean, unique list of countries to use in the dimension.

upvoted 0 times

...

Remedios

5 months ago

Ah, I see what's going on now. The "Inherited (On)" state indicates that the Web Reputation Protection Module setting is being inherited from a higher-level policy, while the other modules were explicitly turned on in this specific policy. I think I've got a good handle on this.

upvoted 0 times

...

Justine

5 months ago

I think the global load balancer option is interesting, but deploying in multiple regions seems like the better approach here to handle the scaling and redundancy needs. We should definitely validate the regional quotas, as Mike mentioned.

upvoted 0 times

...

Valentin

5 months ago

I remember discussing how the partnership name can't be used after dissolution, but I'm uncertain if that affects existing contracts. Is that mentioned in the question?

upvoted 0 times

...