Tableau Exam Desktop-Certified-Associate Topic 6 Question 17 Discussion

Actual exam question for Tableau's Desktop-Certified-Associate exam

Question #: 17
Topic #: 6

[All Desktop-Certified-Associate Questions]

Connect to the "Global Superstore" data source and use the Orders table. Create a hierarchy of Segment, Category, Region. Create a crosstab using this hierarchy and add profit, profit ratio fields. Which of the following are true from the below options?

AThe overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)

BThe Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765

CThe Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment

DThe overall highest profit ratio is of North Africa region in Technology Category and Corporate segment (among all the segments)

Show Suggested Answer

Suggested Answer: B, D

Go to the menu Dashboard -> Action -> Add Action

Select Filter, here you will find the Target Sheets

For all other options, you will not find the Target Sheets. Try it yourself.

by Cassi at Jul 16, 2024, 10:48 PM

Limited Time Offer

25%

Off

Get Premium Desktop-Certified-Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lashaunda

1 months ago

Hold up, 'Central Asia' and 'North Africa' regions? I'm pretty sure those are not part of the standard US regional breakdown. Someone's been watching too much 'Game of Thrones'.

upvoted 0 times

...

Elli

1 months ago

Alright, time to put my problem-solving skills to the test. I wonder if I can find the hidden punchline in this question.

upvoted 0 times

Elenor

12 days ago

B) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765

upvoted 0 times

...

Bernardine

13 days ago

A) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)

upvoted 0 times

...

Larae

15 days ago

C) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment

upvoted 0 times

...

Kaitlyn

17 days ago

B) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765

upvoted 0 times

...

Junita

29 days ago

A) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)

upvoted 0 times

...

Cheryll

2 months ago

Wait, did they just throw in 'Global Superstore' data? I hope I haven't been living under a rock and missed the latest business craze.

upvoted 0 times

Roslyn

6 days ago

I agree, the 'Global Superstore' data is widely used for business analysis. Option A does seem to be the correct choice.

upvoted 0 times

...

Laura

23 days ago

I believe option A is true. Central Asia region in Furniture Category and Corporate segment has the lowest profit ratio.

upvoted 0 times

...

Ben

1 months ago

I think they did mention the 'Global Superstore' data source. It's a popular dataset for analyzing sales and profits.

upvoted 0 times

...

Myrtie

2 months ago

Okay, let's see here. Profit ratios, crosstabs, and data sources - this is my kind of challenge!

upvoted 0 times

...

Brice

2 months ago

Hmm, this question seems straightforward enough. Let me take a closer look at the options.

upvoted 0 times

Arletta

2 days ago

I believe option D is correct, North Africa region has the highest profit ratio in Technology Category and Corporate segment.

upvoted 0 times

...

Reita

23 days ago

Option C states that Central Africa region has a profit value of $10,709 in the Office Supplies category in the Corporate Segment.

upvoted 0 times

...

Francine

24 days ago

I think option B is also true, Southern US has the third-lowest profit ratio in Technology Category in Home Office Segment.

upvoted 0 times

...

Ilona

1 months ago

Option A seems correct, Central Asia region in Furniture Category and Corporate segment has the lowest profit ratio.

upvoted 0 times

...

Bette

2 months ago

Hmm, that's interesting. I guess we'll have to double-check our calculations before the exam.

upvoted 0 times

...

Lenna

2 months ago

I disagree, I believe the answer is D. North Africa region has the highest profit ratio in Technology Category.

upvoted 0 times

...

Bette

2 months ago

I think the answer is A, because Central Asia region has the lowest profit ratio in Furniture Category.

upvoted 0 times

...