What are two outcomes when you drag a continuous date value to the Rows shelf? Choose two,
As a general best practice, how many categories can a pie chart display effectively?
You can create _______________ for members in a dimension so that their labels appear differently in the view.
Which of the following would you use to connect to multiple tables in a single data source at once?
What are two requirements to combine two tables by using a union? Choose two.
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 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?
What are two benefits of using a live connection to a data source as compared to an extract? Choose two.
Which of the following are interactive elements that can be added to a dashboard for users?
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)
If you see the following Filter, then you're working with _______________________
Larger image
If you have a dashboard and are displaying its filter, how can you rearrange it?
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
Which of the following charts types always includes bars sorted in descending order?
Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?
DOWNLOAD THE DATASET FROM - https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven 't already from the test instructions page! )
How many different countries are present in the dataset?
_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don’t allow relationships or joins
True or False: It is not possible to blend axes for multiple measures into a single axis
The icon associated with the field that has been grouped is a ______________
In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.
______________ 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.
Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?
Which aggregation is available without requiring a table calculation or calculated field?
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 three elements are included in a packaged workbook (.twbx)? Choose three.
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 valid ways to italicize Tooltip content in Tableau?
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.
How can you MANUALLY assign geographic roles to a dimension from the data pane?
True or False: It is possible to change the Geographic Role of a dimension
You have a continuous numeric measure named Sales.
Which chart type is created when you double-click the Sales measure?
What are three benefits of using an extract as compared to a live connection to a data source? Choose three.
You have the following visualization.
Where should you place a field named Region to show multiple distinct lines on the same axis?
You create the following visualization.
What is the first step to create the visual grouping of the 10 marks shown in blue?
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?
What are two use cases for creating hierarchies from the Data pane? Choose two.
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.
Which chart type uses automatically generated sizes that cannot be resized by using the Marks card?
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?
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?
Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing
Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?
What statement correctly describes a requirement to create a reference line in Tableau?
While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items.
DOWNLOAD THE DATASET FROM: https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already)
Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?
In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.
Which two functionalities can you provide to consumers by adding a parameter to a visualization? Choose two.
When viewing quick table calculations, such as Percent Difference From, that use a value in the previous column, what will be the first data value in the visualization?
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?
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a ______________ to colour creates a gradient
To customize links based on the data in your dashboard, you can automatically enter field values as _______________ in URLs
You need to display the complete list of potential data connections when you connect to a server. What action should you perform?
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?
Which of the following is the correct way to calculate Profit Ratio in Tableau?
Which of the following describes the best way to change the formatting at a workbook level?
In order to avoid any confusions, what should you do after creating a Dual-axis chart?
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?
What are three ways to access bolding options for the text in a tooltip? Choose three.
What are three geographic roles that you can assign to a field? Choose three.
Which of the following are valid ways to show Mark Labels in the visualisation?
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________
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?
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.