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

3 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

3 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

Corinne

2 months 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

...

Elenor

2 months 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

2 months 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

2 months 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

2 months 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

3 months 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

3 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

2 months 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

3 months 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

3 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

3 months ago

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

upvoted 0 times

...

Brice

4 months ago

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

upvoted 0 times

Arletta

2 months 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

2 months 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

3 months 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

3 months ago

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

upvoted 0 times

...

Bette

4 months ago

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

upvoted 0 times

...

Lenna

4 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

4 months ago

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

upvoted 0 times

...