Exam MB-200 All Questions

View all questions & answers for the MB-200 exam

Exam MB-200 topic 3 question 12 discussion

Actual exam question from Microsoft's MB-200

Question #: 12
Topic #: 3

HOTSPOT -
You need to create a system chart for the Account entity.
The chart must display a count of accounts grouped by owner and then display the accounts by Address 1: State/Province for each owner. You begin to configure chart options as shown in the image below.

How should you complete the configuration? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point. The chart must display a count of accounts grouped by owner, and then display the accounts by State/Province for each owner.
Hot Area:

Show Suggested Answer

Suggested Answer:

by mgharably at Sept. 14, 2019, 7:47 p.m.

Comments

Submit Cancel

mgharably

Highly Voted 5 years, 10 months ago

the answers: account count all owner address1

upvoted 71 times

jasonscript

5 years, 8 months ago

I don't think there is any difference between the Horizontal Axis fields, so it can be Owner, Address1 or Address1, Owner

upvoted 5 times

MarkJSC

5 years, 8 months ago

If you group by Owner then Address 1: State/Province the initial grouping will show Owners with bars showing the count of each State/Province. If you group by Address 1: State/Province first then the initial grouping will show State/Provinces with a bar showing the count for each Owner. The answer is: Count: All, Owner, Address 1: State/Province

upvoted 12 times

MarkJSC

5 years, 8 months ago

I mistakenly left out the first part (Account): Account, Count: All, Owner, Address 1: State/Province

upvoted 6 times

javier

5 years, 4 months ago

The result of this, what I believe is the correct answer is -> https://1drv.ms/u/s!Ajlw_u-9iVJohwiZBSYd5KjDCKTq?e=vzFGZx

upvoted 5 times

...

FahadShaikh

Highly Voted 5 years, 7 months ago

Agreed with mgharably the answers: account count all owner address1

upvoted 15 times

...

kapaes

Most Recent 5 years, 2 months ago

Agreed with Fahad. Account, Count All, Owner, Address: State/Province

upvoted 1 times

...

kapaes

5 years, 2 months ago

Answer provided in the chart name field: "Account by Owner and Address 1: State/Province". :)

upvoted 2 times

...

Mattu

5 years, 5 months ago

points to note : 1.we can't do sum operation on account column so answer is countall on aggregate 2.we need to find out the from how many different provinces case records owned by each user. so first we need to have first Horinontal axis field as owner , then address 1

upvoted 5 times

...

KAL18

5 years, 7 months ago

Given the choices, answer posted by mgharably seems correct. However, just wondering if selecting address 1 state/prov here would really display the state/prov for each owner or the account?

upvoted 1 times

FahadShaikh

5 years, 7 months ago

No need to wonder, you can go and try yourself :) It's grouping.

upvoted 4 times

...

SoMuchConfusion

5 years, 6 months ago

For the Account. Getting the Owner's State/Province would be tougher. You would probably need a new custom field on the Account entity, which you keep up to date via a workflow (or via calculated field format) whenever the owner changes or the owner's state/prov changes, and then you could reference it in the Categories.

upvoted 1 times

...