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, 08: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

Izetta

7 days ago

Agree, that's the way to go!

upvoted 0 times

...

Maryann

13 days ago

Definitely need to remove duplicates from the Country column.

upvoted 0 times

...

Gilma

19 days 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

24 days 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

1 month 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

1 month ago

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

upvoted 0 times

...

Youlanda

1 month 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

1 month 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

1 month 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

1 month 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

1 month 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

2 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

2 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

2 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

...