Desktop-Certified-Associate Tableau Desktop Certified Associate Exam Questions and Answers

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

Explanation:

Automatically add phone layouts

Two options let you automatically add phone layouts:

To create phone layouts whenever you open old dashboards that lack them, choose Dashboard > Add Phone Layouts to Existing Dashboards

To create phone layouts whenever you create a new dashboard, choose Dashboard > Add Phone Layouts to New Dashboards. (This option is on by default.)

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

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:

It is recommended to create multiple table extracts when row-level security needs to be enforced.

Refer: https://www.tableau.com/about/blog/2018/10/you-can-now-choose-multiple-table-storage-extracts-94776

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.

Explanation:

Create a hierarchy of Segment, Category, Region and drop it into the rows.

Text Description automatically generated

Create profit ratio calculated field:

Graphical user interface, text Description automatically generated

Drop the profit and profit ratio fields to the view, your view will look like this:

Graphical user interface, text, application Description automatically generated

Now let's go through each answer option.

1) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment - The profit ratio is -142.26% which is lowest overall so it is true.

2) 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 - It is true, the profit ratio is 2.06%, which is third-lowest.

3) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment - False, it is having a $2,245 profit.

4) The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment - False

Note: This is an easy question but time consuming, so attempt these types of questions in the end.

Explanation:

Select New York State, you are getting only 3 products, and not 5.

Timeline Description automatically generated

You need to add State as a Context filter in the Top 5 profitable products View. For that, go to the Top 5 profitable products sheet. (click on small arrow)

Chart, bar chart Description automatically generated

Select Add to Context on the State filter

Graphical user interface, text, application, chat or text message Description automatically generated

A picture containing graphical user interface Description automatically generated

Explanation:

When you use a left join to combine tables, the result is a table that contains all values from the left table and corresponding matches from the right table.

Refer Join Types: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm

Use join Calculations while joining two tables.

Explanation:

Tableau automatically associates discrete fields with categorical palettes

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

Explanation:

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

Configure the properties as:

Graphical user interface Description automatically generated

Ensure that West Region should be selected in the Region filter.

The final view should be:

Map Description automatically generated

profit increase by 0.133134 for each dollar of sales for the California state

Explanation:

By using the Measure Name field, we get multiple measures on a single axis

Chart, bar chart Description automatically generated

Explanation:

You cannot mix the aggregated and non-aggregated calculations.

MAX(SUM(Profit), (Sales)) -> Profit is aggregated but Sales is not.

SUM([Profit]) * [Quantity] -> Profit is aggregated but Quantity is not.

You can multiply the aggregated/non-aggregated fields with constant. That's why SUM([Profit]) * 1000, is correct.

SUM([Profit]) * SUM([Quantity]) - Both are aggregated