Tableau-Daniel Lin

Which of the following fields will have AGG in front of it when you add it to the view? a. A calculated field with the formula SUM([Profit]) b. A measure called Profit c. A date field d. A calculated field with the formula 5 * [Profit]

A Calculated field with the formula SUM([Profit])

Which of the following is true? a. A dashboard cannot include a story, but a story can include a dashboard b. A dashboard can include a story, but a story cannot include a dashboard c. A dashboard can include a story, and a story can include a dashboard d. A dashboard cannot include a story, and a story cannot include a dashboard

A dashboard cannot include a story, but a story can include a dashboard

If you have bar chart with a single bar, but you want to subdivide that bar into multiple categories, what should you add to your view? a. A measure b. A dimension c. A discrete field d. A continuous field

A dimension

Which of the following can you use to create a calculated field that shows the change from the prior month total? a. An aggregate calculation b. A table calculation c. A basic calculation d. A subtraction calculation

A table calculation

You add two fields to your Tableau view, "Profit" and "Average Profit." When you add Profit to the view, you see a pill with the label, "SUM(Profit)" but when you add Average Profit to the view, you see a pill with the label, "AGG(Average Profit)." Why does one field have SUM and another AGG? a. Each field has default properties, including default aggregation. Profit had SUM set as its default aggregation, while Average Profit had AGG set as its default. b. AGG is applied by default to discrete fields, while SUM is applied to continuous fields. Average Profit was set to discrete, while Profit was set to continuous. c. AGG is applied by default to dimensions, while SUM is applied to measures. Average Profit is a dimension, while Profit is a measure. d. AGG indicates that the "Average Profit" already includes some type of aggregation. "Profit" does not include aggregation, so an aggregate function is applied when the field is added to the view.

AGG indicates that the "Average Profit" already includes some type of aggregation. "Profit" does not include aggregation, so an aggregate function is applied when the field is added to the view.

Which visualization always represents a measure using color? a. Pie chart b. Scatter plot c. Combo chart d. Highlight table

Highlight Table

If you are creating a geographic map with cities, but some of the locations are showing as ambiguous, how might you correct this? a. Add a field called "Street Name" to the view b. Add Latitude (generated) and Longitude (generated) to the view. c. Add a field called "State" to the view d. In the Edit Locations dialog box, click on one of the Ambiguous cells to match a known location to your unknown data. When you click on an unrecognized cell, a search box appears. As you begin typing in the search box, Tableau generates a list of possible locations. Select a location from the list

Add a list called "State" to the view

After setting up two data source connections, how can you create a blend? a. Add at least one field from the primary data source to your view. Then, in the Data pane, click the data source that you want to designate as the secondary data source and click the broken link icon. b. On the data sources pane, drag tables from both connections onto the canvas. Then click the venn diagram and select the blending fields. c. On the data source page, double-click New Blend to set up the blend. Drag a table from the left pane to the blend dialog box. d. Select Data, then Edit Relationships, then Select the secondary data source in the Secondary data source pane, select Custom in the relationships list, and then click the Add button.

Add at least on field from the primary data source to your view. Then, in the Data pane, click the data source you want to designate as the secondary source and click the broken link icon.

Which of the following will increase the granularity of the view? a. Adding a dimension to the marks area b. Adding a measure to the marks area c. Adding a dimension as a filter d. Adding a measures as a filter

Adding a dimension to the marks area

Which of the following will result in an error a. A calculation that includes more than one aggregation b. Aggregation on a field that is already aggregated c. A table calculation on a field that is already aggregated d. An aggregation on a level of detail expression

Aggregation on a field that is already aggregated

Which of the following mark types cannot be adjusted using the Size slider? a. Line b. Pie c. Bar d. Area

Area

A histogram must include which of the following? (select all that Apply) a. Bin b. Dimension c. Count d. Count Distinct

Bin Count

Which types of plots are most often used to visualize the distribution of a single continuous measure? (select all that apply) a. Scatter Plot b. Tree Maps c. Box Plot d. Histogram

Box Plot Histogram

Which of the following functions can be used on string to create a measure? a. SUM b. COUNTD c. + d. DATEDIFF

COUNTD

Which of the following will create a dashboard action? a. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter" b. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as Filters" and select the filter that you'd like to apply to the whole dashboard c. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as Filters" and select the filter that you'd like to apply to the whole dashboard. Then go to the filter menu, right click, and select "apply to all using this data source" d. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "action," add action, and Filter

Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter"

Your view has a histogram showing the distribution of Sales. You'd like to use a color gradient to shade the bars according to the value of Profit. You drag profit to the color mark. How would you adjust the colors so that all negative values are shown in one color and all positive values are shown in a second color? a. Click the colors mark, select edit colors, and check center on zero and switch the dropdown from continuous to discrete color gradient. b. Click on the quantitative legend and select format legend. Select a diverging palette and stepped color. c. Click the arrow on the colors mark, select edit colors, select a diverging palette from the dropdown and check stepped color with 2 steps and check center on zero. d. Click the colors mark, switch to a palette with two colors and check discrete color.

Click the arrow on the colors mark, select edit colors, select a diverging palette from the dropdown and check stepped color with 2 steps and check center on zero

You have a dashboard containing multiple worksheets. One of the worksheets in the dashboard has a scroll bar. Which of the following steps can you take to remove the scroll bar? a. Right click on the scroll bar and select remove. b. Click the more options arrow, select fit, and select fit height. c. Click the more options arrow, select font, and use the dropdown to decrease the font size to reduce the size of the worksheet. d. Right click on the worksheet name on the dashboard pane, select fit, and then select entire view.

Click the more options arrow, select fit, and select fit height

You would like to a view that displays a filter allowing you to select the state, and use a Set to displaying the top 5 products with the greatest total sales within the selected state. What type of filter should you use to filter on the state? a. Multiselect Filter b. Dimension Filter c. Context Filter d. Wildcard Filter

Context Filter

Bins can be created for which type of field? a. Dimension b. Discrete c. Continuous measure d. Date

Continuous Measure

Which of the following does Tableau automatically put into a hierarchy? a. Date fields (year > month > day) b. Geographic fields (country > city > state) c. Field with field name containing the keyword "sub-" (product category, product subcategory) d. Numeric fields (Millions > Thousands > Ones)

Date fields (year,, month, day)

Which of the following field types will create a color palette? a. Measure b. Dimension c. Continuous d. Discrete

Discrete

Which field types are more common? a. Discrete dimension, continuous measure b. Continuous dimension, continuous measure c. Discrete dimension, discrete measure d. Continuous dimension, discrete measure

Discrete dimension, continuous measure

When creating a union between tables, what will happen if the field names do not match? a. Tableau will return an error message, explaining that you must modify the tables so that all tables used in the union have the same field names. b. Tableau will automatically merge the fields, combining fields with similar field names. c. Fields in the union that do not have matching field names will contain null values. d. Fields with non-matching field names will be dropped, so that the union will contain only those fields with matching field names

Fields in the union that do not have matching field names will contain null values

You have a dashboard and you want to add a feature so that selecting an element on one of the worksheets on the dashboard causes a change on another worksheet in the same dashboard. What features will do this? (select all that apply) a. Filter Action b. Url Action c. Highlight Action d. Drilldown Action

Filter Action Highlight Action

In the Southern Region Superstore data, the Product Category, Product Subcategory, and Product Name might be combined using which of the following: a. Set b. Group c. Hierarchy d. Parameter

Hierarchy

You start with a blank worksheet and add a continuous field to the row shelf. How will this new field change your view? a. It will add a horizontal axis b. It will add a horizontal header c. It will add a vertical axis d. It will add a vertical header

It will add a vertical axis

This type of join will include all values from the left table: a. Inner b. Right c. Left d. Blend

Left

Which of the following should be used if, for security purposes, you'd like users to enter their database credentials in order to access the workbook: a. Live connection b. Extract c. Hyper d. Packaged data source

Live Connection

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])? a. Minutes of Delay b. ATTR([Minutes of Delay]) c. AGG([Minutes of Delay]) d. Minutes of Delay (bin)

Minutes of Delay

Which file type can include an extract? Select all that apply. a. Data Source (.tds) b. Packaged Data Source (.tdsx) c. Packaged Workbooks (.twbx) d. Workbooks (.twb)

Packaged Data Source (.tdsx) Packaged Workbooks (.twbx)

You would like the person using your dashboard to select the year, and based on the year to adjust the interest rate in some related calculated fields. You will like the year selection to limit the data in the view. What Tableau element should you to let the user select the interest rate? a. Dimension Filter b. Context Filter c. Parameter d. Change Set values Dashboard Action

Parameter

A bullet chart combines a bar chart with: a. Scatter plot b. Filled bubbles c. Reference lines d. Circle views

Reference Lines

How would you change the font color of the tooltip? (Select all that apply) a. Click on "color" in the marks area, select "tooltip" in the dropdown, and select the desired color. b. Right-click on the view, select "Format" and select the dropdown next to tooltip. Then select the color. c. Click on the tooltip button in the Marks area, highlight the text, and select the desired color using the dropdown d. Right-click on the view, select "Format" and you will see several tabs in the formatting menu - "Sheets," "Rows," Columns" and "Tooltip." Select the tootip tab and then use the formatting menu to select the color.

Right-click on the view, select "Format" and select the dropdown next to tooltip. The select color. Click on tooltip button in the Marks area, highlight the text, and select the desired color using the dropdown

Profit and Sales are continuous measures in the workbook. Order ID is a dimension. Which of the following will most likely not be aggregated when it is added to the view? a. {FIXED [Order ID] : max([Sales])} b. SUM([Sales]) c. [Sales] - [Profit] d. Year([Order Date])

SUM([Sales])

Which of the following fields is most likely to be a dimension? a. Unique Order Count b. Sales (bin) c. Sales d. Measure Values

Sales (bin)

Which chart type will best visualize the relationship between two continuous measures? a. Bar chart b. Scatter Plot c. Line Chart d. Stacked Bar

Scatter Plot

Which type of visualization is not typically effective in showing change over time? a. Bar Chart b. Line Chart c. Area Chart d. Scatter Plot

Scatter Plot

What steps should you take to add a phone view to a dashboard? a. Instruct the those viewing the dashboard on mobile to put "m." in front of the dashboard URL to get the mobile-friendly view. b. Select Layout, then adjust the dimensions until they are appropriate for a phone (750x1334) c. On the "Show Me" menu, click the Phone icon d. Select Device Preview, then select Phone for Device Type, then click the button labeled "Add Phone Layout"

Select Device Preview, then select Phone for Device Type, then click the button labeled "Add Phone Layout"

Which of the following is most likely to reduce the size of the extract? a. Selecting "Multiple Table" rather than "Single Tables" b. Using the incremental refresh option c. Materialize calculations with the "Compute Calculations Now" option d. Removing an filter

Selecting "Multiple Table" rather than "Single Tables"

You would like to divide your customers into two categories - those with sales above a certain threshold and those with sales below that threshold. Which of the following tools will allow you to do this? Select all that apply. a. Hierarchy b. Parameter c. Set d. Calculation

Set Calculation

Your data has a column which should be treated as a date, but when you change the data type to date you see a lot of null values or obviously incorrect dates like 12/30/1899. What can you do next since the date conversion did not work? a. Edit your computer's date settings to that they correspond to the format of the date you're trying to use in Tableau b. Instead of setting the field to Date, set to Date & Time c. Set the type back to string, then try date conversion functions like DateParse and Date d. Switch the metadata grid, then right click the field and select "date format settings"

Set the type back to string, then try date conversion functions like DateParse and Date

You have a scatter plot showing sales on the x-axis and profit on the y-axis, with each dot representing a different product subcategory. You want to show how the points on the scatter plot vary based on Net Profit, a third continuous variable. Which would be most appropriate? (Select all that apply) a. Tooltip b. Label c. Size d. Color

Size Color

Which type of filter usually works best with date fields? a. Slider filters b. List filters c. Checkboxes d. Text search

Slider filters

Which of the following is not a default property which can be set for a measure? a. Number Format b. Color c. Aggregation d. Sort

Sort

Which of the following is a table calculation? a. SUM b. TOTAL c. AVG d. STDEV

TOTAL

Your view has a numeric field set as a discrete measure and a dimension. Which of the following visualizations can you create with these fields? (select all that apply) a. Line chart b. Text tables c. Highlight table d. Histogram

Text Tables

A relative date filter works relative to: a. A parameter or field you select when creating the filter b. The anchor date c. The data the workbook was created or updated d. The current date when the workbook is viewed

The anchor date

A line chart is broken into separate sections by year. What does this indicate about the date used in the line chart? a. The date is a continuous dimension b. The date is a continuous measure c. The date is a discrete measure d. The date is a discrete dimension

The date is a discrete dimension

You connect Tableau to a Excel file which includes a column that has mostly numeric data, but has a few date and text values mixed in. Tableau set the data type for this field as Number. What happens to the date and text values when the data is imported to Tableau? a. The date and text values are both set to null b. The date and text values are both set to zero c. The date values are set to the number of days since 1/1/1900 and the text value is set to null. d. The date values are set to the number of days since 1/1/1900 and the text value is set to zero.

The date values are set to the number of days since 1/1/1900 and the text value is set to null

If a Tableau workbook does not include the fields Latitude (generated) and Longitude (generated) this indicates which of the following: a. The workbook does not include a map b. The workbook does not include any fields with a geographic role of state, city, country, or zip code c. The workbook does not include custom geocoding d. All locations are ambiguous or unknown

The workbook does not include any fields with a geographic role of state, city, country, or zip code

Editing the font at the worksheet level applies the changes you make to all text fields in view except for which of the following? (select all that apply) a. Header b. Axis c. Caption d. Tooltip

Tooltip

For which of the following is it not possible to adjust the size of the marks? a. Bar chart b. Tree map c. Pie chart d. Heat maps

Tree Map

The most important items on a dashboard should be positioned where? a. Center b. Upper Left c. Upper Right d. Bottom

Upper Left

Which of the following describes the Measure Names field (select all that apply) a. It is a Measure automatically created by Tableau b. When you create a view with multiple measures on a single continuous axis, Tableau will automatically add Measure Names to the view. c. When you add Measure Names to a view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a text table that shows multiple measures. d. Measure Names is a system generated field that contains the names of all the measures in your Tableau workbook, including the system generated measures such as Latitude and Longitude.

When you create a view with multiple measures on a single continuous axis, Tableau will automatically add Measure Names to the view When you add Measure Names to a view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a text table that shows multiple measures.

Which of the following is an example of metadata that can be managed in Tableau? Select all that apply. a. The data type of the data in the source database b. Which fields are hidden c. The number of rows in the data d. The default aggregation for a field

Which fields are hidden Default aggregation for a field

Which of the following is the best reason to create a saved data source as a .TDS file a. Those who wish to use the data do not have access to the underlying data. b. You want to save the default field properties such as number formats and sort order. c. You want to save a snapshot of the data that will not update even when the underlying data changes. d. You need to apply an aggregation that takes too long when using a live connection.

You want to save the default field properties such as number formats and sort order.

Which feature will allow you to show more relevant or descriptive dimension values in your view than what the original data provides? a. field renaming b. hierarchy c. alias d. group

alias

Which of the following uses a primary and secondary data source? a. Cross-database joins b. Unions c. Aggregation d. Blending

blending

A histogram shows the distribution of ________ data by creating bins that are _________. a. numeric, continuous b. discrete, continuous c. continuous, discrete d. date, discrete

continuous, discrete