Desktop-Certified-Associate Sample Questions Answers

Explanation:

The first option is wrong here, you can turn on the highlighter only for the discrete fields in your view.

Refer:https://help.tableau.com/current/pro/desktop/en-us/actions_highlight_highlighter.htm

Create the Calculated field ‘Math Performers’:

Drop the Math Performer field to the Rows and drop gender to filter, select ‘Men’

Drop the Number of Records (if tableau version prior to 2020.2) to the Text

Or

Drop the Education.csv(Count) (tableau version 2020.2 and after) to the Text

Apply ‘Percent of Total’ Quick table calculation to the field on the Text marks card:

Explanation:

Find the minimum order date for each customer

Graphical user interface, text, website Description automatically generated

Drop the order date, Min Order date, and Sales to the view

A picture containing graphical user interface Description automatically generated

$2,263,137 is the sales value in 2013 of the customers who placed their first order in 2013.

Explanation:

A blend is worksheet-specific, so you cannot create the extract while creating a blend.

Explanation:

Graphical user interface, application Description automatically generated

Drop Region at the filter and Select Canada

Drop Profit to columns and Sub-Category to Rows

Then drop the target profit to profit axis, it will create the combined axis chart.

Chart, bar chart Description automatically generated with medium confidence

Now drop the Measure Names field from the Rows to the Color Marks Card.

Chart, bar chart Description automatically generated

Go to the Analysis menu -> Stack Marks -> Off (so that your both profit and target profit bars will start from 0)

Graphical user interface Description automatically generated with medium confidence

Tables, Labels and Copiers sub-categories has met or exceed the target profit.

Chart Description automatically generated

https://help.tableau.com/current/pro/desktop/enus/

bkimages_coordinates.htm#:~:text=Right%2Dclick%20anywhere%20on%20the,Annotation

%20dialog%20box%2C%20click%20OK.

After following the steps mentioned in the question your view will look like this:

Here, 5 points are above the exponential trend line.

Create the calculated field:

Drop the carrier name to the view and % of delayed flights to text.

We only have 2013 data, so filter won’t make a difference:

Drop the Country field to the view.

Drop the Region to the filters shelf and select Europe & Central Asia.

Drop the GDP per capita to the label and change the aggregation to Avg.

Blend is the left outer join after aggregation at the level of granularity.

Explanation:

Graphical user interface Description automatically generated

Explanation:

Drop the Date to the columns and select the continuous month. Drop New Deaths to rows.

Click on the Show/Hide card and enable the Summary Card.

Chart, line chart Description automatically generated

You will see the Summary Card on the right, if Excess Kurtosis is not enabled, click on the drop-down and select the Excess Kurtosis.

Graphical user interface, application Description automatically generated

Explanation:

Option 1 - It is not valid, as we are not showing Columns Totals on Top.

Option 3 - It is not valid, as we are modifying the row divider settings and not the column divider settings.

Rest are true.