2022年01月12日更新されたDesktop-Certified-Associateトレーニング最新認定問題をゲットTableau Desktop Certified Associate合格目指せ [Q31-Q56]

2022年01月12日更新されたDesktop-Certified-Associateトレーニング最新認定問題をゲットTableau Desktop Certified Associate合格目指せ

認定トレーニングDesktop-Certified-Associate試験問題集でテストエンジン

質問 31
Connect to the "Global Superstore" data source and use the Orders table. Create a view showing sales over continuous months, find out which trend line model type provides the lowest R-squared value?

A. Polynomial, Degree 3
B. Linear
C. Polynomial, Degree 2
D. Exponential

正解: B

解説:
Drop Order Date to the Columns and change it to continuous month. Drop sales to the rows.
Go to Analytics and drop the trend line. Check for all trend lines, Linear is having the lowest R Square.
Chart, line chart Description automatically generated

質問 32
Why might this LOD expression for percent of total sales give different results than a table calculation for percent of total sales?
Larger image

A. The table calculation is not correctly set up
B. The filter is applied before the Table calculation is performed
C. The LOD expression is not correctly set up
D. The market filter is not correctly set up

正解: B

解説:
Explanation
As per the Tableau order of operation, dimension filter is applied before table calculation is computed. However, fixed LOD is executed before the dimension filter. That's why total sales are showing different results.
Reference -https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

質問 33
Connect to the "Global Superstore" data source and use the Orders table. Find out the customers who placed their first order in 2013 and what is the total sales value of these customers in the same year?

A. $2,385,198
B. $483,269
C. $2,263,137
D. $414,302

正解: B

解説:
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.

質問 34
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. New York, Massachusetts, Rhode Island
B. Texas, New Mexico, Colorado
C. California, Idaho, Nevada
D. North Carolina, South Carolina, Virginia

正解: C

解説:
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

質問 35
Connect to the "Significant Volcano Eruption" data source. In 1899, the Dona Juana volcano erupted in Colombia. Find out which volcano in the Popayan city is the closest to Dona Juana and how many death Dona Juana volcano caused?

A. Galeras, 55
B. Purace, 55
C. Purace, 0
D. Galeras, 0

正解: B

解説:
Drop the Latitude and Longitude fields to Rows and Columns shelf respectively. Or double click on these fields.
Drop the Location field to Filter shelf, select the Location as Colombia.
Drop the Name field to the Label.
To show the cities go to the Map -> Map layer and Check the Cities.
Graphical user interface, text, application Description automatically generated

Drop the Deaths and Year fields to the Tooltip. Now your view looks like this:
Map Description automatically generated

Zoom-in the map, you will find Purace is the nearest one in the Popayan city and Dona Juana was having 55 deaths.
Map Description automatically generated

質問 36
Connect to the "Global Superstore" data source and use the Orders table. Find out the percentage of total sales in all categories by customers who have purchased any product which contains the word 'Avery'?

A. 16.86%
B. 23.41%
C. 14.52%
D. 19.65%

正解: C

解説:
Add Product Name filter that contains the word Avery
Graphical user interface, text, application, email Description automatically generated

Drop the Customer ID to the rows, so these are all customers who have purchased the product contains the word Avery.
Select all these Customers and create a group.
Graphical user interface, text Description automatically generated

Now, right-click on the Customer ID (group) and click on Edit Group
Mark the Include 'Other' Checkbox.
Graphical user interface, text, application Description automatically generated

Now, you have two members in your group. First, one of those who purchased any product contains the word Avery, and the other ones are the rest of the customers.
Remove the Product Name from filters.
Drop the Sales to the Text, and right-click on Sales and Select Quick table calculations -> Percent of total.
Graphical user interface, text, application, chat or text message Description automatically generated

質問 37
In LOD calculation, we can use fields from multiple data sources (blended data source)?

A. True
B. False

正解: B

解説:
Graphical user interface, text, application, Word, email Description automatically generated

Here, the Location is in a primary data source, and the population field is in a secondary data source.
So the answer is FALSE.

質問 38
Which of these dashboard actions do not have target sheets?

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

正解: A,D

解説:
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.

質問 39
Connect to the "Global Superstore" data source and find out which region was having the highest percentage of returned orders in 2013?

A. Eastern Asia
B. North Africa
C. Western US
D. Southern Africa

正解: D

解説:
Explanation
Create a left outer join, so that we can calculate the percentage of the returned orders

Create a calculated field "% of returned orders":

Drop the Order Date to the filters shelf and select the year 2013
Drop the Region to the rows and % of returned orders to the Text:

質問 40
Connect to the "Global Superstore" data source and use the Orders table. Find out how many products from the Office Supplies category are in the Top 10 most profitable product list?

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

正解: A

解説:
Explanation
First, create a set using the Product Name. Select the Top condition as:
Drop this Set to the filters shelf and select IN only.

Drop this Set to the filters shelf and select IN only.

Drop the Category, Top 10 profitable products and Product Name to the view:

質問 41
How to add reference lines in a view? (Select correct two answers)

A. Using Data Pane
B. Using Analysis Menu
C. Using Analytics pane
D. Right Click on Axis and Add Reference Line

正解: C,D

解説:
Using Analytics pane:
Graphical user interface, application Description automatically generated

Right Click on Axis and Add Reference Line:
Graphical user interface, application Description automatically generated

質問 42
You have connected to an excel sheet that has two tables "orders" and "returns". You need to create a data extract and store it as Multiple Tables. But multiple tables option is greyed out. What is the possible reason for this?

A. It will only be enabled once you perform the data blending
B. It will only be enabled once you perform the join
C. It will only be enabled once you save the visualization to Tableau Server
D. It will only be enabled once you perform the union

正解: B

解説:
Explanation
Select the Extract connection and click on Edit as shown:

If you have single table on the canvas, then Multiple tables option remain disabled:

If you create a join, only then Multiple tables option will be enabled:

質問 43
Connect to the "Global Superstore" data source and use the Orders table. Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?

A. Bush Classic Bookcase, Pine
B. Nokia Smart Phone, with Caller ID
C. Cisco Smart Phone, Full Size
D. Belkin Router, USB

正解: A

解説:
Explanation
Drop the Product Name to the filters and Select Top 10 based on Sum of Profit.

Drop the Product Name to the Rows and Profit to the Text.
Drop the Market to the filter and select the Europe.
Your view will look like this:

Here, you are getting only 9 products.
Add Market filter to the context so that the Product Name dimension filter will be executed after the Market filter.

View:

質問 44
Connect to the "Global Superstore" data source and use the Orders table. Find out the percentage of total sales in all the categories in 2015 by customers who have purchased any product in the Phones sub-category in
2014? Use Customer ID.

A. 4.90%
B. 5.03%
C. 4.53%
D. 3.45%

正解: D

解説:
Explanation
Approach 1 - Using Groups
Drop the Customer ID to the Rows.
Add sub-category to the filter and select phone.
Add Order date to the filter and select the year 2014.

Select all the customers and click on paper clip icon to create the group.
So here we got all the customers who have purchased any product in the Phones subcategory in 2014.
Edit the group and select Include other

Clear the filter shelf, and again add Order date to the filter and select 2015.
Drop Sales to the Text.
Add 'Percent of Total' Quick Table Calculation to the Sales field.
Your view will look like this:

Approach 2 - Using LOD
Create a LOD expressions as:

It will return 1 for the customers who have purchased any product in the Phones sub-category in 2014. For others, it will return 0.
Drop this field to the Rows and add Order date to the filter and select the year 2015.

質問 45
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

正解: B

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

Here, 5 points are above the exponential trend line.

質問 46
Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year?

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

正解: A

解説:
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

質問 47
How the ATTR() is defined in Tableau?

A. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END
B. IF MIN ([dimension]) = MAX ([dimension]) THEN MAX ([dimension]) ELSE "*" END
C. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END
D. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END

正解: D

解説:
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END Refer: https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function

質問 48
Using the Sales Analysis Dashboard, create a filter action that will trigger once you select any state in Sales by State View, and it should update the Profit Vs Sales view. Find out using trend lines in the Profit Vs Sales view, how much does profit increase for each dollar of sales for the California state?

A. 0.180067
B. 0.167531
C. 0.294316
D. 0.133134

正解: D

解説:
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

質問 49
Connect to the Olympic Athletes data source, find out the average age of players who won at least one gold medal for the country?

A. 26.72
B. 26.41
C. 26.33
(Correct)
D. 26.02

正解: C

解説:
Drop the Age to the columns and change the aggregation to AVG.
Drop Gold Medals field to filter and select All values ->
Graphical user interface, text, application, email Description automatically generated

Change 1 from 0.
Graphical user interface, application Description automatically generated

質問 50
Extract can't be created in which of the scenario?

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

正解: A

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

質問 51
Which of these chart types are primarily used to compare measures against goals?

A. Bar-in-Bar Chart
B. Bullet graphs
C. Histogram
D. Pareto chart

正解: A,B

解説:
Explanation
Bar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.

質問 52
Use custom geocoding, when you need ___________ locations to map your data.

A. User-defined
B. Default
C. States
D. Tableau generated

正解: A

解説:
Explanation
Custom geocoding means that you assign latitude and longitude coordinates toyour locations so Tableau can plot them accurately.
Refer:https://help.tableau.com/current/pro/desktop/en-us/custom_geocoding.htm

質問 53
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%

正解: C

解説:
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:

質問 54
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

正解: C

解説:
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.

質問 55
Using the Regional Dashboard twbx file, consider the Obesity dashboard to find out how many counties in North Carolina are having an obesity rate that is 8% below the regional obesity rate?

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

正解: A

解説:
Explanation
Here we have to use the Obesity View only, so let's go to that sheet:

Click on go to sheet as per above.
Edit the State filter and select only North Carolina:

Duplicate this sheet as Crosstab

3 counties in North Carolina are having an obesity rate that is 8% below the regional obesity rate.
Graphical user interface, text, application Description automatically generated

Note: For dashboard questions, I prefer to follow above approach wherever it is applicable. I find it easy to get the answers.