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?
What is created by a calculated field that has a formula of SUM(Sales)/SUM(Profit)?
You have the following legend.
What occurs when you click the icon to the right of Air Ticketing Cabin Type Name?
You create a crosstab that shows a list of 100 hotel chains alongside their average nightly cost. You also create two groups showing, respectively, the top 10 and bottom 10 hotel chains by cost, with subtotals.
What should you do to improve the crosstab and compare the two groups to all the remaining hotel chains?
Which of the following are valid ways to add Totals to a view?
Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?
Which of the following is the correct way to calculate Profit Ratio in Tableau?
Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?
When field names in the Union do not match, then:
You want to provide additional information when hovering over a field in the Data pane as shown in the following exhibit.
What should you configure for the field?
At a minimum, what do you need to create a simple scatter plot?
You need to access options to change a dimension's color palette.
In addition to the Marks card, what else can you use?
Which of the following are interactive elements that can be added to a dashboard for users?
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.
With the Marks card drop-down menu set to Automatic, a line chart will be created whenever you place what on the Rows shelf and the Columns shelf?
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
What are two use cases for creating hierarchies from the Data pane? Choose two.
Which aggregation is available without requiring a table calculation or calculated field?
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a ______________ to colour creates a gradient
You may create a context filter to:
Which of the following are valid objects when creating a dashboard in Tableau? Choose 4.
What term is used to describe the following picture?
Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?
A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.
Which one of the following is a dimension?
Which of the following points are True about Viz Animations?
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.
Which of the following are valid Layout Container types when using Dashboards in Tableau?
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
Most viewers scan content starting at the _____________ of a page.
Which of the following are valid ways to make the font more readable in Tableau?
True or False: All rows from both tables are returned in an INNER JOIN
True or False: Context Filters are executed after Data Source filters
True or False: When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible.
Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1)
ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark. (Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)
True or False : Bins can be created on dimensions
You just added this field to the Columns shelf.
What will this create?
Which of the following are valid options to define the scope of a reference line? Choose 3.
You create the following visualization.
What is the first step to create the visual grouping of the 10 marks shown in blue?
You want to update the font of an entire workbook.
What should you use to configure the default fonts?
You have a continuous numeric measure named Sales.
Which chart type is created when you double-click the Sales measure?
If you see a Blue field, generally it will add _____________ to the view
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.
What is a Tableau story point?
When creating a histogram in Tableau, to what does bin size refer?
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system’s web browser?
Which of the following are required to create a trend line?
Which of the following are valid ways to Bold the Tooltip content in Tableau?
When creating a date filter in Tableau, to what does Anchor refer?
Are animations enabled by default in Tableau?
What does the box in a box plot represent?
How can you create a packaged data source?
What allows you to drill up or down in the level of detail (LOD)?
True or False: Tableau can create worksheet-specific filters
What statement correctly describes a requirement to create a reference line in Tableau?
Which two filter modes can you use with continuous filters? Choose two.
For Bullet Graphs we need at least ____________ measures
When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.
What are two benefits of using a live connection to a data source as compared to an extract? Choose two.
What are two correct methods for creating a visual group? Choose two.
True or False: It is not possible to blend axes for multiple measures into a single axis
What is a story point in Tableau?
What are three ways to access bolding options for the text in a tooltip? Choose three.
True or False: We get different colour pallete options if we drop a discrete field on "Color" in the marks card compared to if we drop a continous field on Color.
Which of the following are valid ways to trigger actions for a Dashboard?
You need to uniformly change the size for all marks in a view.
What should you do?
Which of the following are valid use-cases for the 'Manage Metadata' functionality?
For a relative date filter, the default anchor is _________________
How does Tableau know at which level to aggregate values?
The icon associated with the field that has been grouped is a ______________
Data blending simulates a traditional _________________ Join
What does the following marker/icon do in Tableau?
True or False: When relating tables, the fields that define the relationships must have the same data type.
What is the default behavior of Tableau when you add a measure to the view?
The row and column shelves contain ___________________
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?
True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity
Which chart type uses automatically generated sizes that cannot be resized by using the Marks card?
________________ is hosted by Tableau to share our visualisations publically with the world.
Which of the following are True for Measure Names?
Which statement accurately describes an extract when the Physical Tables option is selected?
Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?
What is the minimum amount of RAM recommended for any production use of Tableau Server?
You need to invert the color intensity of a quantitative range. Which option should you use?
What are two methods for renaming a field in a visualization? Choose two.
In which of the following scenarios would having a live connection be more beneficial than using an extract?
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.
What are two ways to share a dashboard as an image file? Choose two.
How can you format numbers in Tableau as currency?
Which two functionalities can you provide to consumers by adding a parameter to a visualization? Choose two.
_________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
When should you use a relationship instead of a join for two data sets?
In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.
Which of the following can you use to create a Histogram?