[Jan 04, 2022] Desktop-Certified-Associate Exam Dumps, Desktop-Certified-Associate Practice Test Questions
Free Desktop-Certified-Associate Study Guides Exam Questions & Answer
NEW QUESTION 35
Connect to the "Covid data" source. What is the percentage increase in the new cases from July 2020 to Jan
2021?
- A. 118.50%
- B. 98%
- C. 113.50%
- D. 125%
Answer: C
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 36
Using which options you can automatically add the phone layouts on your dashboard?
- A. Select Size and then choose Phone
- B. choose Dashboard > Add Phone Layouts to New Dashboards
- C. In device preview mode, check the Tableau mobile app
- D. choose Dashboard > Add Phone Layouts to Existing Dashboards
Answer: B,D
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 37
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
Answer: A
Explanation:
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:
NEW QUESTION 38
When it is recommended to create multiple table extracts?
- A. None of the above
- B. If we are using extract filters to limit the data
- C. If incremental refresh is configured
- D. If row-level security needs to be enforced
Answer: D
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
NEW QUESTION 39
Connect to the "Significant Volcano Eruption" data source. Find out the distance between Okmok and Vsevidof volcanoes in Aleutian Island?
- A. 64 km
- B. 39 km
- C. 71 km
- D. 50 km
Answer: D
Explanation:
Explanation
Drop the longitude field to Columns and latitude to Rows.
Add Location filter and select Aleutin IS
Drop the Name field to Labels
Your view will look like this:
We need to find in Km so go to Map -> Map options and select Units as Metric
Use the radial selection tool to find out the distance between Okmok and Vsevidof volcanoes
NEW QUESTION 40
Connect to the "Global Superstore" data source and use the Orders table. Find out how many days in the 4th quarter of 2015 had a profit ratio greater than 25%?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Explanation
Calculate the Profit Ratio:
Create a LOD expression -> for each order date if profit ratio is greater than 25% returns 1.
Drop the Order date to Rows and drill-down it to Quarters.
Drop the profit ratio >.25 field to Text:
NEW QUESTION 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
Answer: C,D
Explanation:
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
NEW QUESTION 42
In your view, you are using a background image. How can you find the X and Y coordinates on your image?
- A. By annotate an area
- B. Using drop lines
- C. Using custom geocoding
- D. By annotate a point
Answer: D
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 43
Connect to the "Global Superstore" data source and use the Orders table. Create a view using Profit and Sales.
Find out which sub-category is above the profit median but below the sales median value?
- A. Appliances
- B. Storage
- C. Tables
- D. Binders
Answer: D
Explanation:
Drop Sales to columns and profit to rows, and Sub-Category to details.
Add two reference lines, one on the sales axis:
Graphical user interface Description automatically generated
Add similarly on profit axis as well.
Out of the following options, only the Binders sub-category is above the profit median but below the sales median value.
A picture containing chart Description automatically generated
NEW QUESTION 44
Blend the Significant Volcano Eruption dataset with the Country population dataset using year and country.
Find out which country is having 4 volcano eruptions in the year 1963 and what was the population of this country in the same year?
- A. Japan and 96,812,000
- B. Japan and 9,103,406,453
- C. Indonesia and 9,103,406,453
- D. Indonesia and 95,055,669
Answer: D
Explanation:
Add the Country population excel sheet as a New Data Source.
Select column 1960 to 2013, click on Pivot.
Graphical user interface, application Description automatically generated
Rename the new fields as Year and population.
Go to Data ->Edit Blend Relationship
Click on Custom and Add
Graphical user interface, text, application Description automatically generated
Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.
Drop the year to the filters shelf and only enter 1963.
Graphical user interface Description automatically generated
Drop Country and Number of Records / volerup(Count) field to the view.
And drop population to the view from the secondary data source. Your view will look like this:
Graphical user interface, text, application, chat or text message Description automatically generated
NEW QUESTION 45
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. Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind
- B. GBC DocuBind TL300 Electric Binding System
- C. HP Designjet T520 Inkjet Large Format Printer - 24" Color
- D. Canon imageCLASS 2200 Advanced Copier
Answer: B
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
NEW QUESTION 46
Connect to the "Global Superstore" data source and use the Orders table. Find out the average quantity ordered by customers whose first name starts with an 'S' alphabet?
- A. 3.43
- B. 3.39
- C. 3.56
- D. 4.02
Answer: C
Explanation:
Create a Calculation to get the first alphabet of the customer name.
Graphical user interface, text, application Description automatically generated
Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this:
NEW QUESTION 47
How to create custom territories on a map?
- A. Create a territory from a geographic field
- B. Select and group locations on a map
- C. Geocode a territory field using another geographic field
- D. By using a background image on a map
Answer: A,B,C
Explanation:
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_custom_territories.htm
NEW QUESTION 48
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: C
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 49
Which of these chart types are primarily used to compare measures against goals?
- A. Histogram
- B. Bullet graphs
- C. Bar-in-Bar Chart
- D. Pareto chart
Answer: B,C
Explanation:
Explanation
Bar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.
NEW QUESTION 50
Connect to the "Global Superstore" data source and use the Orders table. What is the total profit earned by all the cities in Wake County, North Carolina from the year 2012 to 2014?
- A. $427
- B. $403
- C. $527
- D. $503
Answer: B
Explanation:
Drop the State to the View. And drop the Country to the Filter Shelf and Select the United States.
Drop the City to the view, and add the State to the Filter shelf and select North Carolina.
Also, drop the Order Date to the Filters and select year 2012, 2013, 2014 Graphical user interface, text, application, email Description automatically generated
Now, drop the Profit field to the tooltip. As of now, your view should look like this:
A picture containing map Description automatically generated
Now, we have to find the total profit earned by all the cities in Wake County.
Drop the City field to the view and drop the state to the Filters shelf and Select North Carolina only.
Graphical user interface, text, application, chat or text message Description automatically generated
To show the County go to the Map->Map Layers.
Check County Names and County Borders.
Graphical user interface, text, application Description automatically generated
the total profit earned by all the cities in Wake County is $403.
A picture containing map Description automatically generated
NEW QUESTION 51
Which type of sort is applied in the Ship Mode field?
Larger image
- A. Data Source Order
- B. Nested Sort
- C. Field Sort
- D. Alphabetic Sort
Answer: B
Explanation:
Refer to Nested Sort section:
https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sorting_computed_howto.htm
NEW QUESTION 52
......
Desktop-Certified-Associate Exam Dumps, Desktop-Certified-Associate Practice Test Questions: https://www.prep4away.com/Tableau-certification/braindumps.Desktop-Certified-Associate.ete.file.html