Microsoft Exam DA-100 Topic 16 Question 22 Discussion

Actual exam question for Microsoft's DA-100 exam

Question #: 22
Topic #: 16

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?

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.

Show Suggested Answer

Suggested Answer: C

With grouping you are normally working with dimensional attributes.

Here we add three new groups (East, West, and North) and add each state to the appropriate group.

by Yolando at May 04, 2022, 08:59 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!