Desktop-Certified-Associate Practice Exam Questions with Answers Tableau Desktop Certified Associate Certification

Refer section “Quality Metrics” athttps://help.tableau.com/current/pro/desktop/enus/

forecast_describe.htm

Explanation:

Add year and location filter as:

Graphical user interface, application Description automatically generated

Graphical user interface, text, application Description automatically generated

Drop Name, year, month to the rows. Change year and month to discrete from continuous.

A picture containing chart Description automatically generated

So, 3 volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year.

You can also use the map view to get the results, here I added the month filter as well and drop the count of records to the text.

Map 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:

Create a filter on date field and select only July 2020 and Jan 2021.

Graphical user interface, application Description automatically generated

Drop Date Month Discrete to Columns and New cases to the Text.

Right-Click on New Cases field and Quick Table Calc ->Percent Difference

Graphical user interface, application Description automatically generated

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

Explanation:

Select California State from the Map

Explanation:

Find out how many gold medals each athlete won in the 2008 Olympics

Graphical user interface, text, application, website Description automatically generated

Drop Athlete to Rows and 2008 golds to the Text. Drop gold medals to the view. Your view will look like this:

Graphical user interface, text, application Description automatically generated

Now we need work on "won at least 4 golds in 2012 Olympics"

Drop years to filters and select 2012.

Drop Gold Medals to filter and mention 4 in range of values (as we need to find athletes who won at least 4 gold medals)

Graphical user interface Description automatically generated

Final view:

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

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 Orders Date to the Columns shelf and change it to the Month Date Value and drop the profit to the rows shelf. Your view will look like this:

Graphical user interface, text, application Description automatically generated

Go to the Analytics tab and drop the Forecast to your view.

Right-Click on the view, Select Forecast -> Forecast Options. Change the Ignore last to 0 months,

Graphical user interface, text, application Description automatically generated

$35,152 is the correct answer.

Graphical user interface, chart, line chart Description automatically generated

Explanation:

While creating the parameter action, it is not mandatory to specify the aggregation.

All others are true.

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

Explanation:

{ FIXED [Category] : SUM([Profit])} - It calculates the profit of each category. In our view, all the profits values are the same, so it is not the right answer.

{ FIXED [Region] : SUM([Profit])} - It calculates the profit of each region.

{SUM([Profit])} is equivalent to {FIXED : SUM([Profit])}. It is the table level scope, which means this is the profit of the entire dataset.

Explanation:

Group can be used in a calculated field

Graphical user interface, text, application Description automatically generated