Real Desktop-Certified-Associate Exam PDF Test Engine Practice Test Questions [Q28-Q50]

Real Desktop-Certified-Associate Exam PDF Test Engine Practice Test Questions

Tableau Desktop-Certified-Associate Real 2022 Braindumps Mock Exam Dumps

NEW QUESTION 28
Connect to the "Global Superstore" data source and use the Orders table. Predict the profit of January 2016 using the profit data through December 2015. What is the profit value of January 2016?

A. $46,917
B. $39,921
C. $33,759
D. $35,152

Answer: D

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

NEW QUESTION 29
Connect to the "Kiva Loans - India" data source, which sector's funded amount is closest to the median of all the sectors?

A. Construction
B. Clothing
C. Education
D. Retail

Answer: B

Explanation:
Drop Sector to columns and Funded Amount to Rows.
From Analytics, drop the Median with Quartiles to your view or drop the reference line, select the Median.
Your view will look like this:
Chart, bar chart Description automatically generated

Here, the Clothing funded amount is exactly similar to the Median.

NEW QUESTION 30
Connect to the "Global Superstore" data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?

A. North Carolina, South Carolina, Virginia
B. California, Idaho, Nevada
C. New York, Massachusetts, Rhode Island
D. Texas, New Mexico, Colorado

Answer: B

Explanation:
Drop the State field to a view, you will get >1k unknown.
Drop the Country to the Filters Shelf and Select the United States, all unknowns should be gone.
Also, drop the Order Date to the Filters Shelf and choose Years as:
Graphical user interface, application Description automatically generated

Check for the Year 2013.
Drop the Sales field to the Label in the Marks card, your view should look like this:
Graphical user interface Description automatically generated with medium confidence

Now use the Lasso Selection tool from the Map tools:
Graphical user interface, diagram Description automatically generated

And create the group of states as per our answer options.
Example - for New York, Massachusetts, Rhode Island, Similarly, do for other 3 options as well.
Map Description automatically generated

Duplicate this worksheet and remove the Latitude and Longitude from the view and drop this new dimension of groups to the view. California, Idaho, Nevada is the right answer.
Graphical user interface, text, application Description automatically generated

NEW QUESTION 31
Connect to the "Covid data" source. What is the percentage increase in the new cases from July 2020 to Jan
2021?

A. 125%
B. 113.50%
C. 98%
D. 118.50%

Answer: B

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

NEW QUESTION 32
Using the Sales Analysis Dashboard, If you click on any of the products, it should navigate to the All Products worksheet. How you will accomplish it?

A. Go to Dashboard->Actions and create the go to sheet action
B. Right-click on the view, go to format, and provide the URL.
C. Go to Dashboard->Actions and create the Highlight action
D. Go to Dashboard->Actions and create the go to URL action

Answer: B

Explanation:
Go to Dashboard->Actions and create the go to sheet action
Graphical user interface, application Description automatically generated

NEW QUESTION 33
In your view, you are using a background image. How can you find the X and Y coordinates on your image?

A. Using drop lines
B. By annotate a point
C. By annotate an area
D. Using custom geocoding

Answer: B

Explanation:
Explanation
https://help.tableau.com/current/pro/desktop/enus/
bkimages_coordinates.htm#:~:text=Right%2Dclick%20anywhere%20on%20the,Annotation
%20dialog%20box%2C%20click%20OK.

NEW QUESTION 34
Connect to the "World Cup Results" and use tables WorldCupMatches, WorldCups. Which of the following year had the highest percentage of Away goals? Consider only those years when the host country did not win the world cup.

A. 0
B. 1
C. 2
D. 3

Answer: D

Explanation:
Explanation
In WorldCupMatches table, we have the information of Away goals, and in the WorldCups table, we have the information of the Winner team and goal scored.
In WorldCups, there is only row for each year. But in WorldCupMatches, there is a separate row for each match. This is the perfect example to use blend as here we need to first aggregate the data from WorldCupMatches table.
Let's establish the blend relationship between these two data sources, on the basis of Country and Year.

Let's use WorldCups as the primary data source, so add the field from this data source to the view. Drop Year to Rows and change it discrete. Drop Country and Winner field as well to the rows.

In WorldCupMatches data source, create a calculated field :
Drop this field to the Text, and format it so that it will be shown in percentage.
Out of the given options, only in 1934 host country won the world cup

2010 is the correct answer.

NEW QUESTION 35
In Forecast, what is the shaded region?

A. none of these
B. forecast model
C. prediction interval
D. exponential smoothing

Answer: C

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

NEW QUESTION 36
Connect to the "Significant Volcano Eruption" data source. What is the interquartile range of the distribution of Total Injuries data of the 21st century (show null values at default location)?

A. 0
B. 1
C. 2
D. 3

Answer: C

Explanation:
Drop year to filter shelf and select from 2000.
Graphical user interface Description automatically generated

Drop Total injuries field to rows, go to Analysis -> Aggregated Measures (Untick this, it will disaggregate the total injuries field.
Click on Show Me, and select Box and whisker Plot.
IQR = Upper hinge - Lower hinge
Graphical user interface Description automatically generated with low confidence

Here IQR = 32 -2 = 30
Topic 1, Exam Pool B
Download the Dataset from here:
https://drive.google.com/file/d/1z7LPBQNPWHChteShl0QL3yu_JcvstLGl/view?usp=sharing
Use the above data set to answers the questions under Exam Pool B.

NEW QUESTION 37
When we create a filter action in a dashboard, what all we must specify so that it will work?

A. Run action on
B. Target Sheet
C. Source Sheet
D. Target filter on Selected fields

Answer: A,B,C

Explanation:
Even if you don't select the target filters, your filter action will work. Rest all you need to provide so that it will work.
Graphical user interface Description automatically generated

NEW QUESTION 38
Connect to the "Global Superstore" data source and create a view to show only those orders which were returned. What is the unique number of orders returned in the North Africa region in the office supplies category? Consider only those orders which were shipped using Standard Class ship mode.

A. 0
B. 1
C. 2
D. 3

Answer: B

Explanation:
Create an inner join between Orders and Returns table using Order ID
Graphical user interface, application Description automatically generated

Create a calculated field to find the unique order.
Graphical user interface, text, application Description automatically generated

Drop Region, Ship Mode, and Category to Rows. And drop 'countd order' field to Text. The final view would look like this:
Graphical user interface, text, application Description automatically generated

NEW QUESTION 39
Connect to the "Education" data source. Analyze the Math score and create 3 categories. If the score is less than 500 then consider the student as 'Low Performer'. If the score is greater than or equal to 500 but less than
600 then call it 'Average Performer'. If the score is greater than or equal to 600 then 'High Performer'. Find out the percentage of Average Performers in males?

A. 42.84%
B. 32.25%
C. 44.33%
D. 32.38%

Answer: C

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

NEW QUESTION 40
Connect to the "WorldBank Data" and use the Development Indicators table. Create a relationship between the avg. birth rate and avg. death rate using scatterplot aggregated at the region level, plot death rate on Y-axis and birth rate on X-axis. Add an exponential trendline and find out how many regions are above the trend line?

A. 0
B. 1
C. 2
D. 3

Answer: B

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

Here, 5 points are above the exponential trend line.

NEW QUESTION 41
Connect to the Olympic Athletes data source, find out how many countries participated in 5 different sports from 2000 to 2012?

A. 0
B. 1
C. 2
D. 3

Answer: D

Explanation:
First, find the distinct sports for each country:
Graphical user interface Description automatically generated with medium confidence

It will be created as a Measure, move this to Dimension
Get the distinct countries:
Graphical user interface Description automatically generated with medium confidence

drop these columns to the view, final view will look like this:
The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.
Chart Description automatically generated

NEW QUESTION 42
Which of these dashboard actions do not have target sheets?

A. Change Set Values
B. Filter
C. Change Parameters
D. Go to URL

Answer: A,D

Explanation:
Explanation
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.

NEW QUESTION 43
Extract can't be created in which of the scenario?

A. When you perform the blend
B. When you perform the union
C. When you perform the traditional join
D. When you perform cross-database joins

Answer: A

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

NEW QUESTION 44
Which of the following are true when you use the cube data source in Tableau?

A. You cannot create groups when working with a cube data source.
B. The cube data source can only be used as a secondary data source for blending data in Tableau.
C. Forecasting and trend lines are not supported.
D. Data source filters are not available.

Answer: A,C,D

Explanation:
Cube data sources can only be used as the primary data source for blending data in Tableau.
All others are true.
Refer: https://help.tableau.com/current/pro/desktop/en-us/cubes.htm

NEW QUESTION 45
You have connected to the employee table in your data source and are adding a join on the Employee Manager table. If you would like to see all of the records from the employee table and only matching records from the employee manager table. Which join type will you use?

A. Left join
B. Right join
C. Outer join
D. Inner join

Answer: A

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
Topic 2, Exam Pool C
Download the Dataset from here:
https://drive.google.com/file/d/1hGTUYyq6Y7DLt-DwxVaR4tNLS-FYvD22/view?usp=sharing
Use the above data set to answers the questions under Exam Pool C.

NEW QUESTION 46
Connect to the "Global Superstore" data source and use the Orders table. Find out in which year the furniture sales were more than the average sales of that year?

A. 0
B. 1
C. 2
D. 3

Answer: C

Explanation:
Drop Order Date to columns, Category to Rows, and Sales to Text.
Go to Analysis -> Totals -> Show Columns Grand Total
Graphical user interface, text, application Description automatically generated

Update Total All Using to Average:
Graphical user interface, text, application Description automatically generated

Table Description automatically generated

In the year 2012, the furniture sales were more than the average sales of that year.

NEW QUESTION 47
You need to create a filled map using the City field, you drop the City field to your view. And you get the location error 'Ambigious', what does it mean, and how you will fix this issue?
Larger image

A. Click on the Reset matches button to fix this issue.
B. More than one city has that name. Update the data type of the field to fix this issue.
C. The city name must be misspelled. Correct the spelling to fix the issue.
D. More than one city has that name. Adjust the geographic roles to fix this issue.

Answer: D

Explanation:
Click on the State/Province list, and select the State. So Tableau will recognize the city as part of the states in the Country/Region United States.

NEW QUESTION 48
Using which options you can automatically add the phone layouts on your dashboard?

A. choose Dashboard > Add Phone Layouts to New Dashboards
B. choose Dashboard > Add Phone Layouts to Existing Dashboards
C. Select Size and then choose Phone
D. In device preview mode, check the Tableau mobile app

Answer: A,B

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

NEW QUESTION 49
Using the Profit Analysis Dashboard twbx file, find out the 5th most profitable product in the state of New York? You can add the functionality to the dashboard.

A. GBC DocuBind TL300 Electric Binding System
B. HP Designjet T520 Inkjet Large Format Printer - 24" Color
C. Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind
D. Canon imageCLASS 2200 Advanced Copier

Answer: A

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