Question 114 of 388
Single answerYour 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?
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.
✓
Correct Answer: B
Create a new group on the state column and set the Group type to List.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.