Tab Exam
Numbers. Dates
Default formatting can be set for which of the followin
Sales Tax
Which of the following would most likely be a measure?
a
1. What steps should be taken to change a vertical bar chart to horizontal? a) Drag the measure to the columns shelf and the dimension to the row shelf b) Drag the measure to the rows shelf and the dimension to the column shelf c) Drag the measure to both the row shelf and the columns shelf d) Drag the dimension to both the rows shelf and the column shelf
A B D
14. Which of the following are applicable for nested sort in Tableau? - [Select all that Apply] a) Nested sort considers each pane independently and sorts the rows per pane b) Nested sorts look correct within the context of the pane, but don't convey the aggregated information about how the values compare overall c) Sorting from an axis does not give a nested sort by default d) While creating a nested sort, the sort is inherited when we drill down through the dimensions
b) Percent of total c) Rank d) Percentile
15. Which of the following quick table calculations are available in Tableau? - [Select all that Apply a) Z-score b) Percent of total c) Rank d) Percentile
a) In the Data pane right-click a measure -> select Create > Bins -> Create Bins dialog box accept the proposed New field name or specify a different name for the new field -> Mention the size of bins -> Ok.
16. How do you create a Binned Dimension in Tableau?
a) Basic calculations b) Level of Detail (LOD) expressions d) Table calculations
17. The main types of calculations you can use to create calculated fields in Tableau: - [Select all that Apply] a) Basic calculations b) Level of Detail (LOD) expressions c) Statistic Calculations d) Table calculations
Continuous field values
Add axes to the view
a) The default field returns null. c) The default field is in a data source that's not yet connected. d) The user cancels the query to the data source while Tableau is attempting to connect.
18. Which of the following can prevent a refresh for a refreshable list of parameter values? [select all that apply] a) The default field returns null. b) The default field does not return a single value c) The default field is in a data source that's not yet connected. d) The user cancels the query to the data source while Tableau is attempting to connect.
Click the Analytics pane -> In the Analytics pane under Summarize drag Totals into the Add Totals dialog -> drop it over Subtotals
19. How can subtotals be added to a visualization?
b) Make it easier to analyse data across multiple tables at different levels of granularity d) Tables are only queried when fields from the tables are added to the viz.
Advantages to using relationships to combine tables: [select all that apply]
Click the Add link to the right of the Connections heading in the Left pane. Switch between data connections in the Left pane, then drag out the desired table to the canvas and release it.
After adding one table to the canvas, what steps should you follow to create a relationship with a second table located on a different database?
b) Continuous dimension c) Measures d) Dates
Aliases cannot be created for the following - [select all that apply]
Measures
Can be aggregated
A
Choose the correct path to add a default comment for a field- a) Right click a field in the Data pane-> Default Properties-> Comment b) Right click a field in the Data pane-> Aggregation -> Default Properties-> Comment c) Right click a field in the Data pane -> Comment d) Right click a field in the Data pane-> Describe-> Comment
a) Data source type b) Groups, sets, calculated fields, bins c) Connection information specified on the data source page; for example, database server address, port, location of local files, tables d) Default field properties; for example, number formats, aggregation, and sort order
Data Source (.tds) contains only the information we need to connect to the data source, including the following: [select all that apply]
b) Wildcard c) Condition d) Top
Filter dialog box offers the following tabs for filtering - [Select all that Apply]
Add measure values to color legend and select use separate legends option
How can separate color legends be displayed for multiple measure in a viz?
a) Select a Data Source on Data Menu -> Extract b) Select a Data Source on Data Menu -> Extract -> Refresh c) Sign in to Tableau Server -> Click Tasks at the top of the page -> Under Extract Refreshes select the workbook or data source -> On the Actions menu click Run now.
How can the users refresh an extract immediately in Tableau desktop?
Select the Analytics Pane. Drag totals into the view. Release the mouse on the type of total you'd like to add. On the Analysis tab of the toolbar, select Totals. Then select the type of total you'd like to add.
How can totals be added to crosstab view?
After creating any chart go to Marks card -> Select the size -> Move the slider to the right or left to increase or decrease the size of the chart
How can we change the size of marks in Tableau?
Go to Format -> Choose Animations -> Select On from Animations Tab
How can we enable the option of Animation in Tableau?
Blue
In Tableau, a discrete field is shown in which color?
It is not required to define a join type in a relationship
In a Relationship we need to define the following Join type -
Data Menu -> Select a Data source -> Edit Data Source
Select the correct pathway to edit the data source -
Data source filters
Which of the following occur earlier in the order of operations than context filters?
a) Live allows real-time data while extracts are kind of batch which needs to be refreshed from time to time to get the updated data. b) Live Connection takes more time to load data than Extract Connection.
What is the difference between Live and Extract connections? [select all that apply]
Dual axis chart creates two independent axes while a combined axis chart merges two or more measures into a single axis.
What is the difference between a dual axis chart and a combined axis chart?
Set the scope to be "Per Pane" and the Value to be SUM(Sales) using Average
What reference line options should you use so that the showing the average sum of sales per sub-category for each category?
Drag the date field to the filters area. Select Relative Dates. Then select Months and This Month.
What steps should you take to place a filter on an Order Date field so that one of the worksheets in the workbook shows only orders placed in the current month when the viz is opened?
A continuous measure. A continuous dimension
Which of the following will create an axes when it is added to the row or column shelf? [select two]
Parameter
Which term best describes [Year] in the calculation show below? (Text color is purple)
Scatter Chart
Which type of chart would be most appropriate for showing the relationship between two measures?
Latitude and Longitude.
While assigning geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:
a) The table names will be different b) The extract cannot be refreshed c) The data model and relationships will be lost.
Why the direct connection to the extract is not recommended? [select all that apply]
Discrete field values
add header to the views
Measures
contain numeric, quantitative values that you can measure.
Dimensions
contain qualitative values (such as names, dates, or geographical data)
horizontal
continuous field in the column shelf
vertical axis
continuous field in the rows shelf
green
continuous measures and dimensions are
blue
discrete measures and dimensions are
Linear Logarithmic Polynomial
2. What types of trend lines are available in Tableau?
Union
2. Which of the following can be used to combine the rows from one table with the rows from a second table?
Choose any two measures and drag them to columns and rows -> select any dimension and drag it to the color of Marks card -> select any dimension/measure and drag it to the shape of the Marks card
3. How can we change the shape of the marks for a chart in Tableau?
C
3. What steps should be taken to create a geographical hierarchy? a) In the Analytics pane right-click the geographic field -> Create Hierarchy b) In the Analytics pane right-click the create Hierarchy -> Select Hierarchy -> Ok c) In the Data pane right-click the geographic field-> Hierarchy -> Create Hierarchy d) In the Data pane right-click the geographic field-> Transform -> select Hierarchy -> Create Hierarchy
Measures contain quantitative values whereas Dimensions contain names, dates or Geographical data Dimensions increase the level of detail in the view while measures are aggregated when added to the view.
3. Which of the following are the differences between dimensions and measures? - [Select all that Apply]Add description here! Measures contain quantitative values whereas Dimensions contain names, dates or Geographical data Measures contain continuous values with green pills whereas dimensions contain discrete values with blue pills. Dimensions contain numeric, quantitative values whereas Measures can be used to categorize, segment, and reveal the details in the data Dimensions are aggregated when added to the view, while measures increase the level of detail in the view. Dimensions increase the level of detail in the view while measures are aggregated when added to the view.
Discrete date part color is Blue whereas the Continuous date part color is Green Discrete date creates labels whereas the Continuous date creates axes Discrete date aggregates data at the selected unit whereas the Continuous date uses individual date values
5. What are the differences between discrete date and continuous date values? [Select all that Apply] Discrete date part color is Blue whereas the Continuous date part color is Green Discrete date creates labels whereas the Continuous date creates axes Discrete date aggregates data at the selected unit whereas the Continuous date uses individual date values Continuous date part color is Blue whereas the Discrete date part color is Green
A & C
5. What steps will create a dual axis chart? [Select All that Apply] a) Drag one dimension to Column and drag two measures to Row -> In the Rows right click any of the measure -> Select Dual axes -> Go to marks type of any of the measure and choose the chart type as Bar b) Drag two dimensions to Column and drag one measures to Row -> Go to marks type of any of the measure and choose the chart type as Bar c) Drag one dimension to Column and drag one measures to Row -> drag another measure to the chart itself and as the rectangle shape appears drop it -> Go to marks type of any of the measure and choose the chart type as Bar d) Drag one dimension to Column and drag one measure to Row -> Go to marks type of any of the measure and choose the chart type as Bar
For any visualization Go to Analysis -> Uncheck the Aggregate Measures
6. How can we disaggregate data in Tableau?
For any visualization right click on the measure -> Go to Measure -> Select any of the desired aggregate for that measure
7. How can we change the aggregation of a measure in Tableau?
A C D
7. Which of the following applies for Density map in Tableau - [Select All that Apply] a) To create a density map, the data source should contain Latitude and Longitude coordinates or location names b) Tableau cannot recognize location names and create a density map using the point locations assigned to Tableau geocoding locations c) Density maps are most effective when the location data is very precise, such as location coordinates in a limited space d) Density marks work best where the specific locations change continuously and smoothly across space, rather than values constrained to discrete locations like borough or neighbourhood.
a) Drag one or more dimensions on the Columns shelf and one or more dimensions on the Rows shelf -> place a measure of interest on the Colour shelf -> Select Square as the mark type
8. How to create Highlight Table or Heat Map in Tableau
a) In the Data pane right-click a field -> select Create -> In the Create Group dialog box select the members that needs to be grouped -> Group -> Ok.
9. How to create a group from a field in the Data pane?
Left Join
A blend is most similar to which type of join?
Continuous measure
A color gradient is used for which of the following
Select Hover Menu All of the above
A dashboard action can be triggered by which of the following?
Outer
A relationship is most similar to which type of join?
b
Choose the correct path to change the data type for a field in the view - a) Right click the field in the Data pane -> Change Data Type -> Data Types -> Choose the appropriate data type b) Right click the field in the Data pane -> Change Data Type -> Choose the appropriate data type c) Right click the field in the Data pane -> Data Types -> Choose the appropriate data type d) Right click the field in the Data pane -> Choose the appropriate data type
If the workbook is created in Tableau Desktop then we can use any font installed on the computer in the workbook. If the workbook is published to Tableau Server any custom font must be installed on all server nodes. If the font is not installed on Tableau Server, the uninstall font will be replaced with a substitute font upon publishing.
Choose which of the following are true for using fonts in Tableau for visualization?
Continuous date, MONTH(DATE)
You are creating a line chart showing the number of bugs fixed per month. The labels on the bottom of the graph are too crowded, so you would like to see only one label for every three months. What type of date field should you use?
Go to dashboard and select New Dashboard -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width -> Ok Select the New Dashboard option -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width -> Ok
How can we create a dashboard in Tableau?
Click the New Story tab -> In the lower-left corner of the screen, choose a size for the story -> Double click on any sheet or dashboard to put inside the story -> By default the story name gets its title from the worksheet -> Click Add a caption to summarize the story point.
How can we create a story in Tableau?
Select Worksheet > Export> Image -> In the Export Image dialog box, select the elements we want to include in the image. If the view contains a legend, under Image Options, select the legend layout -> Click Save -> In the Save Image dialog box, specify a file location, name, and format. Then click Save
How can we export a view as an image file in Tableau?
Open a dashboard -> On the Dashboard tab on the left, click Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode
How can we manually add separate device layout in Tableau?
Open the desired workbook for publish. Go to File. Click on Save to Tableau Public As. Sign in to the server. Name the workbook for publish. Ok
How can we publish a workbook for Tableau?
Correct Answer: Use a set to identify the top 10 customers with the highest sales, and create a context filter on corporate segment.
How can you identify the top ten customers with the highest sales where the customers are in the corporate segment?
Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Marks card -> Select insert and select the target worksheet Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Worksheets tab -> Select insert and select the target worksheet
How do you create a viz in tooltip in Tableau?
2
How many data sources can we blend in Tableau?
Drag a date field to the filter shelf -> Select a time unit -> Define the date period -> Ok
How to create Relative Date Filters
a) In Data pane drag a field and drop on top of another field -> enter a name of the hierarchy -> ok
How to create a Hierarchy in Tableau?
Add state to the worksheet
If you add cities to a worksheet and find that you have a map with many unknown locations, which of the following steps may help resolve the problem?
Full Outer
Which of the following join will always include all rows from both tables?
Use as Filter
Which option creates a dashboard action?
Aggregate
Which option leads to adjusting the granularity of data in Tableau?
Right-click the Category pill in the data pane. Select "Rename" then change the text form "Category" to "Product Category"
What steps will change "Category" to "Product Category"?
To interactively display information from the web inside a dashboard, you can use a URL action with a web page object. A dashboard can have multiple Web page objects.
Which are all true about dashboard Web page objects?
[Tax] + [Sales Price]
Which calculation will add the Tax field to the Sales Price field?
Ordered from greatest to least
Which describes a descending sort?
State. City Country/Region
Which fields shown in the data pane below, when included in a map, will cause the system generated latitude and longitude fields to be added to the view?
.tdsx
Which file type saves both the connection information (for example the database server address), calculations and groups that you've added, along with an extract of the data?
URL Actions. Highlight Actions. Filter Actions
Which interactive elements can you add to a dashboard? [select three]
"Aggregate data to visible dimensions" option. Select the "Hide All Unused Fields"
Which of the following are most likely to reduce the size of an extract [select two]
b) Dynamic set c) Fixed set
Which of the following are the types of sets in Tableau?
A URL action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau We can use URL actions to create an email We can use URL actions to link to additional information about the data
Which of the following are true for URL actions in Tableau?
Blend Relationship
Which of the following can be used to combine tables at different levels of granularity without duplicating data?
Stories but not dashboards
Which of the following can include multiple version of the same worksheet?
Histogram
Which of the following chart types is most likely to include a bin?
Line chart
Which of the following chart types requires at date field?
Right-click the pill for the dimension you'd like to sort. Select Sort, then Manual. Use the arrows to manually sort and click okay.. Click a header and drag it to the new location
Which of the following describe the steps needed to do a manual sort?
Items on the default dashboard layout need not be included on the device-specific layouts. Items on the device-specific layouts must also be present on the default layout
Which of the following describes the relationship between the default dashboard layout and device-specific layouts? [select two]
You need to refresh the data as often as possible.
Which of the following is the best reason to use a live connection instead of an extract
When dragged to the color of Marks Card, Tableau displays both the categorical palette and a legend with a color for each value of the field.
Which of the following is true about the display of Discrete Field while dragged to Color in Marks Card?
Measures contain numeric, quantitative values Measures can be aggregated
Which of the following is true for Measures in Tableau?
If your data source is a database, you will need to enter credentials to access the data.
Which of the following is true of a live connection?
Dimensions
You can use _______ to categorize, segment, and reveal the details in your data and can affect the level of detail in the view
Minutes of Delay
You have SUM([Minutes of Delay]) in your view. If aggregate measures is unchecked, what will the view show instead of SUM([Minutes of Delay])?
Create a group
You have a bar chart showing monthly revenue by store. What should you do to combine the bars for two of the stores?
Add a measure filter on the listing price
You have a crosstab view showing the average listing prices for homes by zipcode. What would be the best way to update the view to remove zip-codes with average listing prices about 300,000?
The number of lines on the chart will increase. The heights of the lines will decrease.
You have a line chart showing the number of motor vehicle accidents per month. You drag the "accident type" dimension to the color measure. How does this change the line chart?
On the Marks card, select Bar from the drop-down list. On the Show Me menu, select horizontal bars.
You have a line chart showing total sales by year. How can you change this to a bar chart?
Trend Line
You have a scatter plot showing the quantity sold and the profit by product name. Which of the following would help determine the relationship between quantity sold and profit?
Click the Shapes mark, then select bookcases and the square shape. Click Okay. In the data pane, select default properties then Shape. In the menu that appears, select bookcases and the square shape. Click Okay.
You have a scatter plot that uses different symbols to represent different product sub-categories. What steps should you take to replace the symbol for Bookcases with a square?
Drag the pill for the Quantity Sold field to the Size card. Drag the pill for Quanitity Sold field into the center of the chart and release the mouse
You have a scatter plots of products with Sales on the X-axis and Profit on the Y-axis. What should you do so that the points on the plot are larger depending on the total quantity sold?
On the toolbar, select Map and then Map Layers. Check the box next to Cities in the Map Layer pane.
You have created a polygon map and would like to be able to see all major cities shown on the map. How should you show these?
Hierarchy
You wish to organize related dimensions into a series of different levels. Which feature should you use?
Stories Only
You'd like to add the same worksheet multiple times, but with different filters selected. Which feature will support this?
With a parameter
You've created a bar chart showing Sales by Category, but you'd like the user to be able to choose to have other measures shown in the same format. How could this be achieved?
Select Worksheet > Export > Crosstab to Excel
You've created a crosstab view with dimensions and an aggregated measure. What steps should you take to export the crosstab to Excel?
Hierarchy
Your view has the dimensions "Product Category," "Product Sub-category" and "Product Name." Which of the following would combine these dimensions to enable drill down?
Select the "All using this data source" option for the filter
Your workbook has two different data sources, both sharing a field called "Business Name." How can a single filter be used to filter both data sources on this field?