Tableau Specialist Exam practice

Tableau Specialist Exam practiceWhich of the following is the best reason to create a saved data source as a .TDS file? - correct answer Correct answer is B. -TDS files save the data source metadata, such as the connection information, default field formatting, and sort order. -They do not save the data source itself, and hence you should use this format if everyone who will use the data source has access to the underlying file or database defined in the connection information. When creating a union between tables, what will happen if the field names do not match? - correct answer Correct answer is C - if the field names do not match, the fields will be included in the UNION but will contain null values for the rows from the table that is missing the field. After setting up two data source connections, how can you create a blend? - correct answer -Add at least one field from the primary data source to your view. Then, in the Data pane, click the data -Editing the relationship will not by itself establish a blend Which of the following uses a primary and secondary data source? - correct answer -Blending -Data Blending involves a primary and secondary data source In the ______ data set, the Product Category, Product Subcategory, and Product Name might be combined using which of the following... - correct answer Hierarchy -Hierarchies allow you to combine similar fields while groups and sets combine values within a field. Parameters allow the user to change a value, which can then be used in calculations, filters, and reference lines. Which chart type will best visualize the relationship between two continuous measures? - correct answer Scatter Plot -Scatter plots to visualize relationships between numerical variables. -Bar charts to compare data across categories. --Line charts compare numeric data over time. ----Stacked bar charts compare numeric data over two dimensions. Which of the following is a table calculation? A. SUM B. TOTAL C. AVG D. STDEV - correct answer B. Total 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? - correct answer -Context Filter -You would like to filter on the state, and then select the top 5 products with the greatest sales from within the selected state. Therefore, you need a filter which will execute before the Set. Dimension filters execute after sets, so they are the wrong choice. If you make the filter on the state a context filter, Tableau will filter on the state, and then the set will determine the top 5 products by sales within the selected state. Bins can be created for which type of field? - correct answer Continuous measure -A bin can be created on a continuous measure or numeric dimension The most important items on a dashboard should be positioned where? - correct answer Upper Left.