Knowledge Based Questions Flashcards
To connect to multiple tables in a single data source at one time, what must be specified?
A join
Tableau can create worksheet-specific filters
True
What does the box in a box plot represent
The range of the middle half of the data points
The interquartile range is the difference between the 2nd and 3rd quantiles
False
The median is the number separating the lower half of the data from the higher half. It is the same as the 50th percentile or the 2nd quartile.
True
The calculation [ship date] - [order date] will return
Number of days between them
What is wrong with this if statement:
IF Sales > 100 AND “Delivery Truck” THEN 0 END
There should be a clause for “Delivery Truck” e.g.
[shipping mode] = “Delivery Truck”
What will the function LEFT(3, “Tableau”) return?
Error
All rows from both tables are returned in an INNER JOIN
False
LEFT JOIN returns all rows from the left table, with the matching rows in the right table
True
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.
True
The term “addressing” refers to the direction of a calculation
True
SUM is a table calculation
False
The benefits of creating a Tableau data extract include improving performance and allowing offline access to the data
True
The metadata grid displays the fields in your data source in columns
False
______ is a technique in Tableau which will identify marks with similar characteristics
Clustering
Which of the following is used to assess trend line significance
p-value
If you would like your Top N or Bottom N set to change depending on what filter choices are changed, what type of filter should use?
Context filters
Sorts can break the dimension hierarchy. In other words, Tableau will rearrange any the headers of the fields that appear to the left of the sorted field.
False
Which of the following are generated fields in Tableau?
Number of Records, Measure Names, Measure Values, Longitude & Latitude
Pareto charts combine the following element
…
Bullet graphs combine bar charts and reference lines
True
You want to email a packaged workbook containing a Tableau dashboard to a coworker who does not have a license for Tableau Desktop. Which application will allow her to view the dashboard you send via email?
Tableau reader
A visual best practice is that if you are using a colour gradient to represent a continuous variable which can be negative or positive, you could use a single colour range
False
The AVG function does nit treat null values as zeros. Rather, the AVG function ignores null values.
TRUE
An aggregated calculation can be multiplied by a non-aggregated constant
True
When using a ____ join the result is a table that contains all values from the LEFT table and corresponding matches from the right table.
LEFT JOIN
If you see duplicate data after doing a join you may be able to eliminate the duplication by which of the following?
Change the join condition
______ is a tendency to increase or decrease over time
Trend
Which of the following graph types provide information on the distribution of a continuous measure?
Box Plot
Positive Skewness means the extreme values are to the right, while negative skewness means the extreme values are to the left.
True
When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field.
False
Context filters are executed after data source filters
True
Tableau displays an axis when you drop this onto the Rows or Columns shelf.
Continuous field, Measure values
Gantt charts are useful for
Displaying duration of events or activities over time
Bins acts as a containers that summarise data for a specific range of values. Without using a calculated field, Tableau’s bin feature allows you to create variable sized bins.
False
You can combine multiple worksheets in a single dashboard
True
If a dashboard is difficult to view on a smartphone, you can use the ____ designer to create a phone-specific view of your dashboard
Device designer
A ____ action allows Tableau to open a page on an external website
URL
To connect to multiple tables in a single data source at one time, what must be specified.
A JOIN
What is the use of data interpreter option in Tableau
To structure the unstructured data
While using custom SQL option during data connection, which options get disable/removed from data page?
Data Interpreter and Union
When to use extract option in Tableau
When you want to embed data inside Tableau file AND when you want to share the file without sharing the data connection information
To add cross data source join _____ must be specified
Primary and foreign key
If I changed the layout of worksheet from standard to fit entire view and next I changed the chart using show me, what will be the layout of the worksheet?
Standard
What is the correct way to calculate price of a product?
SUM(sales/quantity)
Which columns you cannot delete in Tableau
Measure Names and Measure Values
You cannot change a dimension to continuous
True
You cannot create bins of measures
False
Latitude and longitude are Tableau generated fields
True
We can use measure names in creating custom column
False
For bullet graph, you need ____ dimensions
0 or more
For creating line chart, what is required
Continuous field
What is the colour of attribute in Tableau?
Blue
In shelf calculated columns are ______
Worksheet specific
What is the colour tick mark on primary and secondary data source
Blue, orange
A dimension is a field that typically holds
Discrete qualitative data
Dates are typically treated as ____
Dimensions
The globe icon next to a field means that field is _____
Geographic
Which of the following charts types always includes bars sorted in descending order?
Pareto Chart
Which of the following charts uses binned data?
Histogram
If a field has a blue background, that means that the field is ____
Discrete
When might you want to use a context filter?
First apply a filter and then show the Top N or Bottom N elements
This type level of detail expression computes total sales for the region, regardless of what dimensions are shown in the view
{ FIXED [Region] : SUM([Sales])}
Adding a dimension to the row or column shelf will filter your data
False
Suppose that your data has a dimension called “Product Category”, which has the values “Furniture”, “Office Supplies”, and “Technology.” Which of the following should you use to combine Furniture and Office Supplies into a single category?
Hierarchy
All rows from both tables are returned in an INNER JOIN
False
LEFT JOIN returns all rows from the left table, with the matching rows in the right table
True
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.
True
What is the colour of Discrete Measures in Tableau
Blue
For Bullet Graphs we need at least _____ times
2
Which graph is the best to show comparison between Actual and Target measure
Bullet Graph
Which Aggregate Function is used to calculate Distinct Count?
COUNTD()
Which is an LOD function
INCLUDE, EXCLUDE, FIXED
Which is not an action out of below?
Tooltip
______ is used to distribute these interactive workbooks and/or reports to the right audience
Tableau Desktop
Tableau 10 new feature can Join data from ______ data source(s) and can connect to ______
different, Google sheet
Which is not a new feature in Tableau 10
Now you can blend data from different data sources
Below is an example of continuous field (by default)
Date
Which is a false statement about Parameters
Parameters can’t be used in calculation
Which is not a filter
Tooltip filter
Parameters can be used in
Tooltip
Which language does Tableau support for data manipulation while importing the dataset
SQL
Which of the following returns an Absolute value of a given number
ABS()
How is data stored in a .tde file?
Column wise
If blending is applied, then is it necessary to drop common field in a view containing fields of two different data sources on which blending is applied
False
If we drop 2 measures in rows/columns, what will be the output
Axis
Link to data is shown in which tab
Data source page
Null values are counted along with other items in a column while using the COUNT function
False
Which chart is used to show the interquartile range in Tableau
Box chart
Sorting can be done at the following levels
Data source order, alphabetic, field, and manual
How to use parameter value to filter the view in worksheet?
Calculated Field