Tableau Desktop Specialist Exam graded A+ 2023

Tableau Desktop Specialist ExamWhat is a join? - correct answer you are combining the COLUMNS of two data sets what is a union? - correct answer you are merging the ROWS of two or more data sets 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? - 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 of the following field types will create a color palette? - correct answer Discrete! Which of the following is the best reason to create a saved data source as a .TDS file? - correct answer You want to save the default field properties such as number formats and sort order. 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 source that you want to designate as the secondary data source and click the broken link icon. Which of the following uses a primary and secondary data source? - correct answer Blending Which chart type will best visualize the relationship between two continuous measures? - correct answer Scatter Plot 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 Which of the following fields will have AGG in front of it when you add it to the view? A calculated field with the formula SUM([Profit]) A measure called Profit A date field A calculated field with the formula 5 * [Profit] - correct answer A calculated field with the formula SUM([Profit]) Which of the following functions can be used on string to create a measure? a. SUM b. COUNTD c. + d. DATEDIFF - correct answer COUNTD 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: - correct answer Live connection 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? - correct answer Set the type back to string, then try date conversion functions like DateParse and Date 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 Which type of filter usually works best with date fields? - correct answer Slider filters A relative date filter works relative to: - correct answer The anchor date Which of the following will create a dashboard action? - correct answer Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter" Which of the following action types can be used to create proportional brushing? - correct answer Set Action