Oct-2021 Latest TestKingFree Desktop-Certified-Associate Exam Dumps with PDF and Exam Engine Free Updated Today!
Following are some new Desktop-Certified-Associate Real Exam Questions!
NEW QUESTION 32
Connect to the "Education" data source. Create a histogram using the Total score field and having a bin size of
100. Find out in which bin the students scored the highest verbal percentage? [Note: Verbal percentage should be calculated by considering how many marks scored in the verbal out of the total marks scored.]
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Explanation
Create a calculated field to compute the contribution of verbal marks in percentage:
Select the Total Score field and using Show me create a histogram.
Edit the Total Score(bin) and provide the Size of bins as 100:
Drop the % Verbal field to the Label, your view will look like this:
Chart, histogram Description automatically generated
NEW QUESTION 33
Which of the following are valid calculations?
- A. SUM([Profit]) * SUM([Quantity])
- B. MAX(SUM(Profit), (Sales))
- C. SUM([Profit]) * 1000
- D. SUM([Profit]) * [Quantity]
Answer: A,C
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
NEW QUESTION 34
Which of the following are true regarding the data highlighter in Tableau?
- A. You can turn on the highlighter for any field available in your view.
Table Description automatically generated
- B. If you update the underlying data source for your view the data shown in the highlighter is automatically updated too.
- C. If you want to change the format for the highlighter card after you turn it on, select Format > Highlighter.
- D. If you have multiple highlighters showing on a dashboard, only one highlighter can be active at a time.
Answer: B,C,D
Explanation:
The first option is wrong here, you can turn on the highlighter only for the discrete fields in your view.
Refer: https://help.tableau.com/current/pro/desktop/en-us/actions_highlight_highlighter.htm
NEW QUESTION 35
Connect to the "Significant Volcano Eruption" data source. Find out the distance between Okmok and Vsevidof volcanoes in Aleutian Island?
- A. 50 km
- B. 64 km
- C. 71 km
- D. 39 km
Answer: A
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 36
How to rename the Measure Names field in Tableau?
- A. Rename the field from the Data Source page
- B. Rename the field from the Metadata grid
- C. None of the above
- D. Right Click on Measure Names, and select Rename
Answer: C
Explanation:
Measure Names is Tableau generated field, so you cannot rename it.
NEW QUESTION 37
To create a choropleth map, your data source should include the following types of information?
- A. Quantitative or qualitative values
- B. Location names or custom polygons
- C. Background image
- D. Custom Territories
Answer: A,B
Explanation:
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_howto_choropleth.htm
NEW QUESTION 38
Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place within 30 miles of the Black Peak volcano in the Alaska Peninsula?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Add the Latitude to Rows and Longitude to columns. Or double click on these fields.
Don't use Latitude (generated)/Longitude (generated) fields.
Drop Location to filter and select 'Alaska Peninsula'
Drop Name to the Label Marks card.
Your view will look like this:
Map Description automatically generated
Use the radial selection tool to find the number of volcano eruptions that took place within 30 miles of the Black Peak volcano. You need to zoom-in first, only then you would be able to find the distance using a radial selection tool.
A picture containing chart Description automatically generated
There were no eruptions that took place with 30 miles of Black Peak.
NEW QUESTION 39
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 custom geocoding
- C. Using drop lines
- 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 40
When it is recommended to create multiple table extracts?
- A. If we are using extract filters to limit the data
- B. If row-level security needs to be enforced
- C. If incremental refresh is configured
- D. None of the above
Answer: B
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 41
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: A
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 42
Connect to the "Significant Volcano Eruption" data source. Using the elevations field, create bins of size 1000 and find out in which bin has the most total deaths?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Select the 'Elevation' field from measures, and go to show me. Click on Histogram.
Right-Click on the "Elevation (bin)" dimension and select Edit. Change the size of bins to 1000.
Graphical user interface, application Description automatically generated
Drop the Total Death to Label.
Chart, histogram Description automatically generated
The total number of deaths reported in the bin of 2000.
Note that the lower limit is inclusive. So 2000 bin means 2000 to 2999.
NEW QUESTION 43
Connect to the "Global Superstore" data source and use the Orders table. Find out how many days in the month of May 2012 were profitable?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Graphical user interface, application Description automatically generated
Here we have created the Fixed LOD expression and fixing the order date. If profit is greater than 0 it means profitable day/month/quarter/year depends on what you need to find. If profit < 0 then not profitable.
Drop the Order Date to the rows and drill-down it till months.
Drop the profitable days field to the Text, aggregated as SUM. So it will find a number of days.
Graphical user interface, application Description automatically generated
NEW QUESTION 44
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. Tables
- B. Binders
- C. Appliances
- D. Storage
Answer: B
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 45
Using which options you can automatically add the phone layouts on your dashboard?
- A. Select Size and then choose Phone
- B. In device preview mode, check the Tableau mobile app
- C. choose Dashboard > Add Phone Layouts to Existing Dashboards
- D. choose Dashboard > Add Phone Layouts to New Dashboards
Answer: C,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 46
Connect to the "WorldBank Data" and use the Development Indicators table. Create a country map of the Europe and Central Asia region. Find out which neighboring country of Romania is having a greater average GDP per capita than Romania?
- A. Hungary
- B. Serbia
- C. Bulgaria
- D. Ukraine
Answer: A
Explanation:
Explanation
Drop the Country field to the view.
Drop the Region to the filters shelf and select Europe & Central Asia.
Drop the GDP per capita to the label and change the aggregation to Avg.
NEW QUESTION 47
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.294316
- B. 0.167531
- C. 0.133134
- D. 0.180067
Answer: C
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
NEW QUESTION 48
......
Resources From:
- 2021 Latest TestKingFree Desktop-Certified-Associate Exam Dumps (PDF & Exam Engine) Free Share: https://www.testkingfree.com/Tableau/Desktop-Certified-Associate-practice-exam-dumps.html
- 2021 Latest TestKingFree Desktop-Certified-Associate PDF and Desktop-Certified-Associate Exam Dumps Free Share: https://drive.google.com/open?id=1C_hLrlF4K0e2A_rAXlSd8WdfQQaRQEoJ
Free Resources from TestKingFree, We Devoted to Helping You 100% Pass All Exams!