You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?
What are three benefits of using an extract as compared to a live connection to a data source? Choose three.
As a general best practice, how many categories can a pie chart display effectively?
Which two types of aggregations can be applied to string fields? Choose two.
True or False: It is not possible to blend axes for multiple measures into a single axis
If you use a percent difference Quick Table Calculation, what value will be the first data value?
When creating an extract, what are three options for specifying how much data to extract? Choose three.
Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which of the following filter types should you apply on Region?
Which action describes the process for changing a measure so that it automatically aggregates an average instead of a sum?
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.
______________ refers to the level of detail for a piece of data, wherever you are looking.
How can you MANUALLY assign geographic roles to a dimension from the data pane?
You can use the __________________ in Tableau to clean / organise your data.
Which statement accurately describes an extract when the Physical Tables option is selected?
Which of the following are the options to export the data used to build the view / visualisations?
The View Data window displays as much of the data as possible by default, up to _______________ rows.
You have a workbook that contains one data source and you need to combine data from another database. What should you do first?
You create a visualization by first adding a measure to rows. Next, you add a dimension wilh 11 members to columns.
Assuming that all the dimensions have a non-zero value, how many marks are in the view before and after the dimension is added?
Which of the following are valid use-cases for the 'Manage Metadata' functionality?
If you are working with a huge dataset, which of the following are strong reasons to use a context filter?
What are two benefits of using a live connection to a data source as compared to an extract? Choose two.
Which aggregation is available without requiring a table calculation or calculated field?
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.
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.
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?
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?
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.
In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.
Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.
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?
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
Which of the following lets you group related dashboard items together so you can quickly position them?
What is created by a calculated field that has a formula of SUM(Sales)/SUM(Profit)?
Which two analytics options are available for a scatter plot view? Choose two.
Which of the following is NOT a valid official data source in Tableau Desktop?
When using a data source that has relationships, how can you add a join between two or more tables?
When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.
To customize links based on the data in your dashboard, you can automatically enter field values as _______________ in URLs
When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?
Which of the following URLÂ prefixes are permitted when creating a URLÂ Action in Tableau?
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?
If you see the following Filter, then you're working with _______________________
Larger image
For which of the following charts, does the Size option on the Marks card not work?
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?
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
To connect Tableau to a CSV data source what type of connection should you use?
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)
While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items.
________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do 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, adding groups, and so on.
True or False: You get different filtering options for categorical and quantitative data
Which statement accurately describes creating a group by selecting headers in a view?
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________
Which of the following calculations DO NOT need a quick table calculation?
Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?
You can create _______________ for members in a dimension so that their labels appear differently in the view.
Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?
When using Animations in a Tableau, which of the following is the default duration for animations?
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?
Which of the following charts types always includes bars sorted in descending order?
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
Given a map, which of the following fields can be placed in Size,Shape,Detail,Color