nerdexam
Microsoft

PL-300 · Question #114

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

Sign in or unlock PL-300 to reveal the answer and full explanation for question #114. The question stem and answer options stay visible for context.

Submitted by carlos_mx· Apr 18, 2026Model the data

Question

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?

Options

  • ACreate a new aggregation that summarizes by employee.
  • BCreate a new group on the state column and set the Group type to List.
  • CCreate a new group on the state column and set the Group type to Bin.
  • DCreate a new aggregation that summarizes by state.

Unlock PL-300 to see the answer

You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Data Grouping#Power BI Desktop#Categorical Data Transformation#Report Design
Full PL-300 Practice