[Feb-2022] Exam Desktop-Certified-Associate: New Brain Dump Professional - VCE4Dumps

Free Desktop-Certified-Associate Exam Dumps to Improve Exam Score

NEW QUESTION 49
Which type of sort is applied in the Ship Mode field?
Larger image

• A. Field Sort
• B. Nested Sort
• C. Data Source Order
• 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 50
Which of the following are true regarding custom geocoding and data blending?

• A. Using custom geocoding, you can create new geographic hierarchies but it is not true while using data blending
• B. In data blending, you can use any data but custom geocoding requires text file based data
• C. Using custom geocoding, you can plot your own locations on a map but it is not true while using data blending
• D. You can create new geographic roles both in data blending and custom geocoding

Answer: A,B

Explanation:
Refer to the quick comparison of data blending and custom geocoding -
https://help.tableau.com/current/pro/desktop/en-us/maps_customgeocode_datablend.htm

 

NEW QUESTION 51
Connect to the "Flight" data source and find out which carrier was having the highest percentage of delayed flights in 2013?

• A. Frontier
• B. ExpressJet
• C. American
• D. JetBlue

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 52
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 LOD expression is not correctly set up
• C. The filter is applied before the Table calculation is performed
• D. The market filter is not correctly set up

Answer: C

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

 

NEW QUESTION 53
Connect to the "Global Superstore" data source and use the Orders table. Find out how many distinct customers have made 6 orders?

• A. 0
• B. 1
• C. None of the above
• D. 2

Answer: B

Explanation:
Find out the distinct orders for each customer
Graphical user interface, text, application Description automatically generated

Move this field from Measure to Dimension.
Drop this field to the Columns Shelf and drop customer ID to Rows, aggregate the Customer ID using CountD, and drop this field to Label as well. Your view will look like this:
Chart Description automatically generated

29 distinct customers have made 6 orders.

 

NEW QUESTION 54
Connect to the "Significant Volcano Eruption" data source. Create a histogram using field Death and having a bin size of 500. Find out which country reported 9 deaths in the bin of 0-500?

• A. Chile
• B. United States
• C. Japan
• D. Indonesia

Answer: B

Explanation:
Explanation
Select the measure "Death" and go to the Show Me and Click on Histogram When we are binning the measure, it will create the dimension, so you get a new dimension as Death (bin).
Right-click on this and click on Edit. Update the size of bins to 500.
Graphical user interface, application Description automatically generated

Drop the Country to the color, so our view will look like this:
Chart Description automatically generated

Now drop the Country to the filter and select 4 countries mentioned in our options.
Hover the bar, it shows the United States has reported 9 deaths.
Chart Description automatically generated

 

NEW QUESTION 55
Connect to the "Global Superstore" data source and use the Orders table. Create a bar in bar chart and compare the profit against the target profit for Canada Region. Consider target profit is 30% of the sales. Which of the following sub-categories has met or exceed the target profit?

• A. Tables
• B. Labels
• C. Paper
• D. Copiers

Answer: A,B,D

Explanation:
Graphical user interface, application Description automatically generated

Drop Region at the filter and Select Canada
Drop Profit to columns and Sub-Category to Rows
Then drop the target profit to profit axis, it will create the combined axis chart.
Chart, bar chart Description automatically generated with medium confidence

Now drop the Measure Names field from the Rows to the Color Marks Card.
Chart, bar chart Description automatically generated

Go to the Analysis menu -> Stack Marks -> Off (so that your both profit and target profit bars will start from
0)
Graphical user interface Description automatically generated with medium confidence

Tables, Labels and Copiers sub-categories has met or exceed the target profit.
Chart Description automatically generated

 

NEW QUESTION 56
How to add reference lines in a view? (Select correct two answers)

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

Answer: B,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 57
What is the default join type when you blend two data sources?

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

Answer: A

Explanation:
Explanation
Blend is the left outer join after aggregation at the level of granularity.

 

NEW QUESTION 58
Which LOD calculations can be used in Columns shelf to create this view?
Larger image

• A. { FIXED [Region] : SUM([Profit])}
• B. {SUM([Profit])}
• C. { FIXED [Category] : SUM([Profit])}
• D. {FIXED : SUM([Profit])}

Answer: B,D

Explanation:
{ FIXED [Category] : SUM([Profit])} - It calculates the profit of each category. In our view, all the profits values are the same, so it is not the right answer.
{ FIXED [Region] : SUM([Profit])} - It calculates the profit of each region.
{SUM([Profit])} is equivalent to {FIXED : SUM([Profit])}. It is the table level scope, which means this is the profit of the entire dataset.

 

NEW QUESTION 59
In which of the following scenarios you should use the blend?

• A. The data to combine is at a different level of detail.
• B. The data to combine has the same structure but consists of data of different years.
• C. The combined data will be used in many worksheets in the current workbook.
• D. All of the above.

Answer: A

Explanation:
Union - The data to combine has the same structure but consists of data of different years.
Blend - The data to combine is at a different level of detail.

 

NEW QUESTION 60
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 61
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 62
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 63
You are unable to join two tables because tableau throws the type mismatch error. How you can solve it most likely?

• A. Using Union
• B. Using Join Calculations
• C. Using Blend
• D. Using cross-database join

Answer: B

Explanation:
Explanation
Use join Calculations while joining two tables.

 

NEW QUESTION 64
Connect to the "Significant Volcano Eruption" data source. What percentage of total deaths caused by volcanoes which were having a volcano index greater than 2 and elevation greater than 5000?

• A. 6.58%
• B. 3.45%
• C. 5.61%
• D. 0.27%

Answer: A

Explanation:
Create a calculated field as:
Graphical user interface, text, application Description automatically generated

Drop this field to Rows and Total Death to the Columns. And Select the Quick Table Calculation-> Percent of Total.
Graphical user interface, application Description automatically generated

Graphical user interface, application, table, Word Description automatically generated

 

NEW QUESTION 65
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 66
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. 23.41%
• B. 14.52%
• C. 19.65%
• D. 16.86%

Answer: B

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

 

NEW QUESTION 67
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. Public Affairs
• B. Business
• 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 68
......

Powerful Desktop-Certified-Associate PDF Dumps for Desktop-Certified-Associate Questions: https://examboost.vce4dumps.com/Desktop-Certified-Associate-latest-dumps.html