2019 Tableau Specialist Exam fully solved upgraded to pass

2019 Tableau Specialist ExamWhich of the following is the best reason to use an extract instead of a live connection? a. Your data source only supports a live connection via ODBC. b. You need the freshest possible data at all times. c. You need to apply an aggregation that takes too long when using a live connection. d. You need to join tables that are in the data source. - correct answer c. You need to apply an aggregation that takes too long when using a live connection. You created a group by selecting field labels in a view. How can you remove members from the group? a. In the view, right-click the group members you want to remove and select Exclude. b. In the Data pane, right-click the group and select Edit Group. c. In the view, right-click the group members you want to remove and select Format. d. On a color legend, right-click a member you want to remove and select Format legends. - correct answer b. In the Data pane, right-click the group and select Edit Group. Which of the following can you use to create a calculated field that returns data independent of the data granularity in a view? a. An INCLUDE LOD calculation b. A table calculation c. A basic calculation d. A FIXED LOD calculation - correct answer d. A FIXED LOD calculation 4. Interactive elements that you can add to a dashboard for users include ______. (Select all that apply.) a. URL actions b. edit tooltip options c. filter actions d. hide and unhide all sheet options - correct answer a. URL actions c. filter actions A field that shows average home values for the United States in 2016 is most likely: a. A discrete date part dimension b. A continuous date value dimension c. A geographical dimension d. An aggregated measure - correct answer d. An aggregated measure A Reference Band cannot be based on two fixed points. False True - correct answer False A Reference Distribution plot cannot be along a continuous axis. True False - correct answer False, A Reference Distribution plot can be along a continuous axis. Which of the following is not a Trend Line model Linear Trend Line Exponential Trend Line Binomial Trend Line Logarithmic Trend Line - correct answer Binomial Trend Line The aggregation function attr() returns a * when __________________. There is a single value for all rows in the group. It is a null value.