What statement correctly describes a requirement to create a reference line in Tableau?
Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?
When creating an extract, what are three options for specifying how much data to extract? Choose three.
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.
Relationships are represented by __________________ and operate at the ____________________.
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
As a general best practice, how many categories can a pie chart display effectively?
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?
A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data.
Which of the following are interactive elements that can be added to a dashboard for users?
Which of the following are valid ways to export a dashboard with multiple visualisations as an image?
You want to save a view as an image that you can paste into a Microsoft Word document. Which two statements accurately describe exporting a view as an image? Choose two.
You have a bar chart that has a dimension on the Columns shelf and a measure on the Rows shelf.
How can you make a stacked bar chart?
You have a scatter plot visualization.
What should you do to configure the visualization as a density map?
_____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines.
You need to create a calculation that returns a customer name followed by a comma, a space, and then the customer's age (for example: John Doe, 32).
What should you include in the calculation?
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________.
Which two functionalities can you provide to consumers by adding a parameter to a visualization? Choose two.
Which type of date filter can you use to choose a range of dates based on TODAY ()?
True or False: The Highlighting action can be disabled for the entire workbook.
______________ refers to the level of detail for a piece of data, wherever you are looking.
You have a workbook that contains one data source and you need to combine data from another database. What should you do first?
True or False: When relating tables, the fields that define the relationships must have the same data type.
When using Animations in a Tableau, which of the following is the default duration for animations?
Which of the following are the options to export the data used to build the view / visualisations?
You have a dashboard that shows car rental statistics by city, including a field named Car Dropoff City in the view. A URL action in the dashboard uses https://en.wikipedia.org/wiki/
When you click Salt Lake City in the view, to where will the URL action direct you?
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
You have a data set that builds a union between two tables. You need to extract the data set. What should you use to extract the data set?
In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.
Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?
Which of the following lets you group related dashboard items together so you can quickly position them?
Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?
Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State. Add a Linear trend line to the view. What is its R-squared value?
While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items.
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
For which of the following charts, does the Size option on the Marks card not work?
What are two use cases for creating hierarchies from the Data pane? Choose two.
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.
In which of the following scenarios would having a live connection be more beneficial than using an extract?
True or False: Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.
Which of the following are valid objects when creating a dashboard in Tableau? Choose 4.
Which statement accurately describes an extract when the Physical Tables option is selected?
Which of the following are valid Layout Container types when using Dashboards in Tableau?
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.
Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?
________________ can only create header. _______________ will create header and axis both.
Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.
You can create _______________ for members in a dimension so that their labels appear differently in the view.
______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.
To display data that has both negative and positive quantitative values, Tableau Desktop will display marks by using__________________as the default.
You want to update the font of an entire workbook.
What should you use to configure the default fonts?