Exam PL-300 topic 3 question 32 discussion

Actual exam question from Microsoft's PL-300

Question #: 32
Topic #: 3

Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?

A. Create a new aggregation that summarizes by state.
B. Create a new aggregation that summarizes by employee.
C. Create a new group on the state column and set the Group type to List.
D. Create a new group on the state column and set the Group type to Bin.

Show Suggested Answer

Suggested Answer: C 🗳️

by Aiti at Oct. 13, 2022, 1:46 p.m.

Comments

Submit Cancel

SamuComqi

Highly Voted 1 year, 11 months ago

Selected Answer: C

I passed the exam today (948/1000). My answer was: - Create a new group on the state column and set the Group type to List.

upvoted 28 times

76ceb45

1 year, 10 months ago

thanks Samu

upvoted 4 times

...

Danylessoucis

Highly Voted 2 years, 6 months ago

Selected Answer: C

C s the correct answer. A & B are wrong. D is wrong because bins do not allow to choose which states corresponds to what region.

upvoted 5 times

5bf040d

3 months, 3 weeks ago

Bins are for numerical values

upvoted 1 times

...

rcaliandro

Most Recent 10 months, 3 weeks ago

Selected Answer: C

I was in doubt between A and C. I will trust you and I will choose C. Can you explain me why A is not correct?

upvoted 2 times

Data_Island

2 months, 2 weeks ago

Hi, a bit late to this but A doesn't solve the question which is viewing the employees by region. It does not categorize states into regions as it only provides the summary data at the state level.

upvoted 1 times

...