Free Tableau Desktop Certified Associate Exam Desktop-Certified-Associate Exam Practice Test

What is the default join type when you blend two data sources?

• Inner join
• Outer join
• Left outer join
• Right join

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?

• Inner join
• Outer join
• Left join
• Right join

When it is recommended to create multiple table extracts?

• If incremental refresh is configured
• If we are using extract filters to limit the data
• If row-level security needs to be enforced
• None of the above

Which of the following are true regarding parameter actions?

• While creating the parameter action, you must specify the aggregation.
• The aggregation that you choose for the parameter action can be different than the aggregation used for the field in the view.
• You can create multiple parameter actions in your dashboard.
• Using parameter action, you can update the reference line.

To create a choropleth map, your data source should include the following types of information?

• Quantitative or qualitative values
• Location names or custom polygons
• Background image
• Custom Territories

Select the correct options that allow you to ensure that your Phone layout automatically reflects changes to the Default dashboard?

• Click the open lock icon on right of your phone layout option
• Click the 3 dots on right of your phone layout option and select Optimize Layout
• Click the 3 dots on right of your phone layout option and select Auto-Generate Layout
• All of the above

In table calculations, partitioning fields define the direction of the calculation.

• TRUE
• FALSE

When we blend the data, sometimes a Null value appears in place of data. What could be the possible reasons for the same?

• The data to combine is at different level of detail.
• The values in the primary and secondary data sources use different casing.
• The secondary data source does not contain values for the corresponding values in the primary data source.
• The data types of the fields you are blending on are different.

In which of the following scenarios you should use the blend?

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

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

• Bar-in-Bar Chart
• Histogram
• Bullet graphs
• Pareto chart