Tableau Review

3. 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

A

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

A. C will create a context filter, not a filter action. D is not the right choice because there is no action option in the "More Options" menu.

4. 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

B

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

B

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.

B

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

B

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)

B & C

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.

B & C A is incorrect because Measure Name is a Dimension, not a value. D is incorrect because Measure Names does not include Latitude and Longitude.

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

B & D

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

B - Relative date filters work relative to the anchor date. By default this will be the current date, but this can be changed:

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.

C

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

C & D

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

C. A histogram uses bins to subdivide a continuous measure into a discrete bins.

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

D

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.

a

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

a

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

b

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.

b

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.

c

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

c

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"

c

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

c & d

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

c. A parameter will allow the user to set a value which you can then use in a calculated field. You can also use a parameter in a calculation, and then use that calculated field in a filter to limit the data in the view.

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"

d

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

d

You want to create a line chart showing the daily "Open" and "Close" values for a stock. The y-axis shows the opening stock price and the x-axis shows the date. What steps should you take? a. Drag and drop the field "Close" to the x-axis. b. Drag and drop the field "Close" to the y-axis. c. Drag the field "Close" to the path mark. d. Drag the field "Close" to the row shelf, then select the dual axis on the worksheet menu.

d

10. 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

d. Scatter Plot