Download Tableau desktop specialist exam and more Exams Advanced Education in PDF only on Docsity!
Tableau desktop specialist exam
- Which steps can be followed to create a tds file? Answer Provided: - correct answer On Data pane, right-click the data source, and then select Add to Saved Data Sources Which of the following is an example of metadata that can be managed in Tableau? Select all that apply - correct answer Which fields are hidden.The default aggregation for a field Which of the following is most likely to reduce the size of the extract? - correct answer Selecting the Physical Tables Data Storage option If a Tableau workbook does not include the fields Latitude (generated) and Longitude (generated) this indicates which of the following: - correct answer The workbook does not include any fields with a geographic role such as state, city, country, or zip code What is required to combine columns from an Excel worksheet with columns from a database table? - correct answer two connections and one data source Which chart type is best for viewing the distribution of a measure? - correct answer Histograms Which of the following is automatically organized in a hierarchy? - correct answer Date fields (year > month > day) Which visualization always represents a measure using color? - correct answer Highlight table 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. - correct answer Set/ Calculation
Which of the following can you use to create a calculated field that shows the change from the prior month total? [Select all that apply] - correct answer A table calculation If you are creating a geographic map with cities, but some of the locations are showing as ambiguous, how might you correct this? - correct answer Add a field called "State" to the view 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? - correct answer Click the arrow on the colors mark, select edit colors, select a diverging palette from the dropdown and check stepped color with two steps and check center on zero Editing the font at the worksheet level applies the changes you make to all text fields in view except for which of the following? - correct answer Tooltip Which of the following are options for the scope of a reference line? [select two] - correct answer Entire Table.Per Pane Which of the following will increase the granularity of the view? - correct answer Adding a dimension to the marks area 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? - correct answer Text tables After modifying an existing story point, which option creates a new story point with the modifications, while preserving the existing story point before modifications? - correct answer Selecting "Save as New" on the existing story point Which of the following can be configured when creating an extract? [select three] a. Whether to store logical or physical tables b. Whether the extract should be refreshed on a schedule
Which of the following are dashboard actions? [select two] a. Change Group b. Change Set Values c. Change Bin d. Change Parameter e. Change Map Zoom Area - correct answer B,D Which field types are more common? - correct answer Discrete dimension, continuous measure You connect Tableau to an 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? - correct answer The date values are set to the number of days since 1/1/1900 and the text value is set to null. Which field types are more common? - correct answer Discrete dimension, continuous measure You connect Tableau to an 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? - correct answer The date values are set to the number of days since 1/1/1900 and the text value is set to null. 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? - correct answer 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 of the following describes the Measure Names field (select all that apply) - correct answer 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 action types can be used to create proportional brushing? - correct answer Set Action 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. - correct answer B,C Which of the following mark types cannot be adjusted using the Size slider? - correct answer Area Which of the following can use anchor dates? - correct answer Filters Which type of filter usually works best with date fields? - correct answer Slider filters How would you add the overall sales for all segments to the text table shown below?
- correct answer Select Analysis on the toolbar, select Totals, then show Column Grand Totals 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? - correct answer Parameter
Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart?
- correct answer By dragging another dimension to Color on the Marks card What is a story point in Tableau? - correct answer A single worksheet or dashboard 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. - correct answer diverging Which of the following can help us focus on specific data without removing data in the visualization? - correct answer Highlighters If you have a dashboard and are displaying its filter, how can you rearrange it? -By clicking anywhere inside the filter and dragging it. -By clicking on the dropdown and dragging the filter -By clicking on the filter title and dragging it. -By clicking on the 2 lines on top and dragging the filter. - correct answer By clicking on the 2 lines on top and dragging the filter. Which of the following describes the best way to change the formatting at a workbook level? -Click on Text in the Marks card, choose format, and then specify the formatting in the new Format workbook pane. -It is only possible to specify formatting at a worksheet level, not at the workbook level. -Choose Format from the menu on top and then specify the formatting in the new Format workbook pane.
-Right click anywhere in the view, choose format, and then specify the formatting in the new Format workbook pane. - correct answer Choose Format from the menu on top and then specify the formatting in the new Format workbook pane. Which of the following are true about dimensions? A)Dates are mostly placed in dimensions by default for relational data sources B)They contain contain numeric, quantitative values C)They contain qualitative values (such as names, dates, or geographical data) D)They affect the level of detail in the view - correct answer A/C/D While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items. - correct answer padding In which of the following situations would an outer join be preferred to a blend? - correct answer when you need to include all rows from both tables, even when the join or blend criteria is not met Which of the following can be renamed? - correct answer Field names.Parameters.Sets Which of the following can have an alias? - correct answer Values of a discrete dimension Which of the following are default properties which can be assigned to a dimension?
- correct answer Shape.Color.Sort You have a scatter plot showing sales and profit by product sub-category. You wish to create a set from a cluster of high values sub-categories. What steps should you take? - correct answer Click and hold down the mouse, drawing a rectangle to select the sub-categories of interest. Right click and select 'create set'
Which of the following describes the relationship between the default dashboard layout and device-specific layouts? - correct answer -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 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? - correct answer -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 A relationship is most similar to which type of join? - correct answer Outer Join Default formatting can be set for which of the following [select two] - correct answer Numbers.Dates
