Tableau Desktop Certification Exam Questions & Answers 100% Correct(rated A+)
Which of these file types can NOT be loaded into Tableau? - ANSWER-exe
When data from an Excel file is loaded into Tableau, how are blank cells from the source represented? - ANSWER-As null values
Which of these column types is a split option available for? - ANSWER-String
What is the default aggregation performed by Tableau for a numeric value conveyed on a chart? - ANSWER-SUM
An axis for a numeric value can use a linear scale. Which of these is another scaling option for an axis in a Tableau chart? - ANSWER-Logarithmic
When working with a bar graph, Tableau includes an option to "Explain Data" for a particular bar. What type of information would be available in such a view for a categorical field? - ANSWER-Outliers in the category
What does the color blue represent in tableau? - ANSWER-Discrete
Can a measure be discrete? - ANSWER-Yes
What is a visual cue to know that we are using a measure? - ANSWER-Measures are aggregated by default
Which of the following is NOT an aggregation provided by Tableau? - ANSWER-
Difference
Continuous fields form _______ whereas discrete fields will form _____ - ANSWER-
Axis, headers
Which of the following would be best suited as a dimension - ANSWER-the name of someone
If you see a blue field, generally it will add ____ to the view - ANSWER-headers Which of the following options best describe measures? - ANSWER-They are numerical, quantitative
Dates in tableau are typically treated as - ANSWER-dimensions
How can you change the default Tableau repository location? - ANSWER-By clicking File --> Repository location and choosing a new location
Which of the following joins does a blend replicate - ANSWER-Left join
When you use an ___ join to combine tables, the result is a table that contains values that have matches in both tables - ANSWER-inner
When using blends, the primary data source is represented by the color ____ and the secondary data source by the color ____ - ANSWER-blue, orange
True or false: Renaming a field in Tableau will also automatically rename the field in the original data source - ANSWER-False
which of the following connection types would you use if your work demands that you use the freshest possible data at all times? - ANSWER-Live
Which of the following is a benefit of using a tableau data source (.tds)? - ANSWER-To not contain the actual data, but rather the information necessary to connect to the actual
data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc.
You can create _____ for members in a dimension so that their labels appear differently
in the view - ANSWER-aliases
we can join a maximum of __ tables in Tableau - ANSWER-32
When working with Excel, text file data, JSON file, .pdf file data, you can use ____ to union fields across folders, and worksheets across workbooks. Search is scoped to the selected connection - ANSWER-wildcard search
When field names in the Union do not match, then: - ANSWER-Both field names are present in the Union, but contain several null values
Beginning in version 10.5, when you create a new extract, it uses the ___ format instead of the .tde format - ANSWER-.hyper
_____ is a snapshot of the data that Tableau stores locally. Good for very large datasets which we only need few fields - ANSWER-Tableau Data Extract (.tde)
Which of the following is NOT a valid trend line in Tableau? - ANSWER-Gaussian
Which of these file types can NOT be loaded into Tableau? - ANSWER-exe
When data from an Excel file is loaded into Tableau, how are blank cells from the source represented? - ANSWER-As null values
Which of these column types is a split option available for? - ANSWER-String
What is the default aggregation performed by Tableau for a numeric value conveyed on a chart? - ANSWER-SUM
An axis for a numeric value can use a linear scale. Which of these is another scaling option for an axis in a Tableau chart? - ANSWER-Logarithmic
When working with a bar graph, Tableau includes an option to "Explain Data" for a particular bar. What type of information would be available in such a view for a categorical field? - ANSWER-Outliers in the category
What does the color blue represent in tableau? - ANSWER-Discrete
Can a measure be discrete? - ANSWER-Yes
What is a visual cue to know that we are using a measure? - ANSWER-Measures are aggregated by default
Which of the following is NOT an aggregation provided by Tableau? - ANSWER-
Difference
Continuous fields form _______ whereas discrete fields will form _____ - ANSWER-
Axis, headers
Which of the following would be best suited as a dimension - ANSWER-the name of someone
If you see a blue field, generally it will add ____ to the view - ANSWER-headers Which of the following options best describe measures? - ANSWER-They are numerical, quantitative
Dates in tableau are typically treated as - ANSWER-dimensions
How can you change the default Tableau repository location? - ANSWER-By clicking File --> Repository location and choosing a new location
Which of the following joins does a blend replicate - ANSWER-Left join
When you use an ___ join to combine tables, the result is a table that contains values that have matches in both tables - ANSWER-inner
When using blends, the primary data source is represented by the color ____ and the secondary data source by the color ____ - ANSWER-blue, orange
True or false: Renaming a field in Tableau will also automatically rename the field in the original data source - ANSWER-False
which of the following connection types would you use if your work demands that you use the freshest possible data at all times? - ANSWER-Live
Which of the following is a benefit of using a tableau data source (.tds)? - ANSWER-To not contain the actual data, but rather the information necessary to connect to the actual
data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc.
You can create _____ for members in a dimension so that their labels appear differently
in the view - ANSWER-aliases
we can join a maximum of __ tables in Tableau - ANSWER-32
When working with Excel, text file data, JSON file, .pdf file data, you can use ____ to union fields across folders, and worksheets across workbooks. Search is scoped to the selected connection - ANSWER-wildcard search
When field names in the Union do not match, then: - ANSWER-Both field names are present in the Union, but contain several null values
Beginning in version 10.5, when you create a new extract, it uses the ___ format instead of the .tde format - ANSWER-.hyper
_____ is a snapshot of the data that Tableau stores locally. Good for very large datasets which we only need few fields - ANSWER-Tableau Data Extract (.tde)
Which of the following is NOT a valid trend line in Tableau? - ANSWER-Gaussian
