Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 4 question 4 discussion

Actual exam question from Microsoft's DA-100

Question #: 4
Topic #: 4

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 employee.
B. Create a new group on the state column and set the Group type to List.
C. Create a new group on the state column and set the Group type to Bin.
D. Create a new aggregation that summarizes by state.

Show Suggested Answer

Suggested Answer: B 🗳️

by Sunny93 at Oct. 2, 2020, 9:31 a.m.

Comments

Submit Cancel

Sunny93

Highly Voted 4 years, 8 months ago

Correct answer is - B. Because List is used to create string groups. Bin is used to create numeric groups.

upvoted 191 times

Zakriya

4 years, 1 month ago

B is correct, as the values are string.

upvoted 6 times

...

VR1

Highly Voted 4 years, 8 months ago

Ans is B - It should be Group and List. Bin is for numeric and Dates

upvoted 32 times

...

QWERTYman

Most Recent 2 years, 10 months ago

Selected Answer: B

Answer is B

upvoted 1 times

...

edriska1

2 years, 11 months ago

answer was B on exam 7/11/22 passed

upvoted 1 times

...

elviskftsang

2 years, 11 months ago

Selected Answer: B

This is definitely B

upvoted 1 times

...

Mad0701

3 years ago

Selected Answer: B

correct answer is B , group by Bin is applicable to numerical values.

upvoted 2 times

...

TechDiva

3 years, 3 months ago

I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.

upvoted 1 times

Boefie

2 years, 11 months ago

I think this user is a robot :) same response but switching dates haha online business

upvoted 1 times

...

TechDiva

3 years, 3 months ago

Answered:B

upvoted 1 times

...

PatrickStr

3 years, 6 months ago

on exam 12/10/2021

upvoted 2 times

...

aguilartu1

3 years, 7 months ago

on exam - Nov 11, 2021. my answer: Create a new group on the state column and set the Group type to List.

upvoted 3 times

...

kcwood94

3 years, 8 months ago

On exam 10/14/21

upvoted 2 times

Ihueghian

3 years, 8 months ago

Me too 16/10

upvoted 2 times

...

mullered

4 years, 2 months ago

The argument to defend the provided answer contradicts the answer given.

upvoted 1 times

...

Cherishworth

4 years, 2 months ago

B. As for the string type data (region), there is only one option "List". You can't set the group as "bin".

upvoted 4 times

...

RehafKH

4 years, 2 months ago

the answer is B. the field type is string not numeric or date (You can set the bin size for numerical and time fields in Power BI Desktop.) https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

upvoted 1 times

...

sandra1981

4 years, 2 months ago

B is the Correct Answer

upvoted 1 times

...

aclacl

4 years, 2 months ago

The correct answer is B

upvoted 1 times

...

EmperorWenchang

4 years, 2 months ago

B. Create a new group on the state column and set the Group type to List. My Power BI instructor confirms that B is the correct answer without any doubt.

upvoted 3 times

...

mojedapr

4 years, 3 months ago

Answer is B because you are going to group strings, not numbers nor dates

upvoted 2 times

...

Load full discussion...