Pass Desktop-Certified-Associate Exam in First Attempt Guaranteed 2021 Dumps!
Desktop-Certified-Associate Dumps Full Questions - Exam Study Guide
NEW QUESTION 58
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
Answer: A
Explanation:
A blend is worksheet-specific, so you cannot create the extract while creating a blend.
NEW QUESTION 59
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: A
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 60
Connect to the "Kiva Loans - India" data source, find out the average number of days it took to disbursed the funded amount in catering activity, and what is the total funded amount?
- A. 26, $2275
- B. 26.5, $325
- C. 26.5, $2275
- D. 26, $325
Answer: C
Explanation:
Graphical user interface Description automatically generated with medium confidence
Filter the Activity = Catering
Drop the activity to rows, and no of days to columns, change the aggregation to AVG.
Also, drop the Funded Amount to the Tooltip.
Graphical user interface, application Description automatically generated
NEW QUESTION 61
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 want to change the format for the highlighter card after you turn it on, select Format > Highlighter.
- C. If you update the underlying data source for your view the data shown in the highlighter is automatically updated too.
- 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 62
To create this view, what all you have to do from the following options?
Larger image
- A. Add the Columns Totals on Top from Analysis Menu
- B. Drop the measure to the color marks card
- C. Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
- D. Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
Answer: B,D
Explanation:
Option 1 - It is not valid, as we are not showing Columns Totals on Top.
Option 3 - It is not valid, as we are modifying the row divider settings and not the column divider settings.
Rest are true.
NEW QUESTION 63
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 64
In table calculations, partitioning fields define the direction of the calculation.
- A. FALSE
- B. TRUE
Answer: A
Explanation:
Explanation
When you add a table calculation, you must use all dimensions in the level of detail either for partitioning (scoping) or for addressing (direction).
Refer:https://help.tableau.com/current/pro/desktop/enus/
calculations_tablecalculations.htm
NEW QUESTION 65
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: A
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 66
Which of the following are valid calculations?
- A. SUM([Profit]) * 1000
- B. MAX(SUM(Profit), (Sales))
- C. SUM([Profit]) * [Quantity]
- D. SUM([Profit]) * SUM([Quantity])
Answer: A,D
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 67
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 68
You are unable to join two tables because tableau throws the type mismatch error. How you can solve it most likely?
- A. Using cross-database join
- B. Using Union
- C. Using Join Calculations
- D. Using Blend
Answer: C
Explanation:
Explanation
Use join Calculations while joining two tables.
NEW QUESTION 69
Which calculation will color the sales by state, while the city is on the Marks card, as shown in this view?
Larger image
- A. { Exclude [State] : SUM([Sales])}
- B. { Exclude : SUM([Sales])}
- C. {SUM([Sales])}
- D. { Exclude [City] : SUM([Sales])}
Answer: D
Explanation:
Explanation
{ Exclude [City] : SUM([Sales])} => using this calculation we can exclude the City dimension from all the dimensions present in the view. So here SUM(sales) would be the aggregation of sales in the state level only, even though city field is available in the view.
NEW QUESTION 70
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
Answer: D
Explanation:
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END Refer: https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function
NEW QUESTION 71
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: B
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 72
Connect to the "Flight" data source and find out which carrier was having the highest percentage of delayed flights in 2013?
- A. Frontier
- B. American
- C. JetBlue
- D. ExpressJet
Answer: A
Explanation:
Explanation
Create the calculated field:
Drop the carrier name to the view and % of delayed flights to text.
We only have 2013 data, so filter won't make a difference:
NEW QUESTION 73
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. The city name must be misspelled. Correct the spelling to fix the issue.
- B. Click on the Reset matches button to fix this issue.
- C. More than one city has that name. Update the data type of the field to fix this 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 74
Connect to the "Education" data source. Which college(s) average math, verbal, and writing scores are lesser than the overall 70% percentile in these subjects?
- A. Business
- B. Public Affairs
- C. Communication
- D. Education
Answer: A,B
Explanation:
Explanation
Create a bar chart using field college and Math. Change the Math aggregation to AVG.
Drop the Verbal field to Y axis, to create the combined axis chart. And change the aggregation to Avg.
Follow the same for Writing field.
Now from the Analytics menu, drop the Distribution band to the view, select the scope as entire table, and select the value as 70 percentiles.
Your view will look like this:
70 percentiles are 547.8
Business and public affairs have all the individual subject values lesser than 547.8.
NEW QUESTION 75
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. Inner join
- C. Outer join
- D. Right 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 76
In Forecast, what is the shaded region?
- A. exponential smoothing
- B. forecast model
- C. none of these
- D. prediction interval
Answer: D
Explanation:
Explanation
Refer:https://help.tableau.com/current/pro/desktop/en-us/forecast_create.htm
NEW QUESTION 77
......
Tableau Desktop Certified Associate Free Certification Exam Material from Prep4sures with 110 Questions: https://www.prep4sures.top/Desktop-Certified-Associate-exam-dumps-torrent.html