You need to create a calculation that returns a customer name followed by a comma, a space, and then the customer's age (for example: John Doe, 32). What should you include in the calculation?
Correct Answer: D
According to the Tableau Desktop Specialist Exam Readiness, to create a calculation that returns a customer name followed by a comma, a space, and then the customer's age, you should use the formula [Customer Name] + "," + STR([Age]). This is because you need to concatenate strings using the + operator, and convert the numeric field [Age] to a string using the STR() function.
Question 22
When creating a date filter in Tableau, to what does Anchor refer?
Correct Answer: B
When creating a date filter in Tableau, anchor refers to the date in a relative-date filter to which you anchor a unit of time. A relative-date filter is a type of filter that allows you to dynamically filter data based on a range of time relative to the current date or a specific date. For example, you can use a relative-date filter to show data for the last 7 days, the next 3 months, or the current quarter1 To create a relative-date filter, you need to specify the following options: The date field that you want to filter. The unit of time that you want to use for the filter, such as days, weeks, months, quarters, or years. The range of time that you want to show relative to the anchor date, such as last, next, this, or to date. The anchor date that you want to use as the reference point for the filter. You can use the current date or a custom date as the anchor date1 For example, if you want to create a relative-date filter that shows data for the last 3 months from January 1st, 2022, you would select the following options: Date field: Order Date Unit of time: Months Range of time: Last 3 Anchor date: Custom (01/01/2022) 1 The other options are not valid definitions of anchor when creating a date filter in Tableau. The mid-point in the range of displayed dates is not related to the anchor date, but rather to the center of the axis that represents the date field. The date in a range-of-dates filter to which you anchor units of time is not correct, because a range-of-dates filter does not use an anchor date, but rather a start and end date that can be fixed or dynamic. The latest date in the data source that can be found is not related to the anchor date, but rather to the maximum value of the date field in the data source2
Question 23
DOWNLOAD THE DATASET FROM - https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?
Correct Answer: B
To reach the correct answer, follow these steps: 1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop - 147 marks! 2) Or, you can simply go to Data Source -> Country Tab -> Describe As you can see, 147 members exist in this Country column!
Question 24
Which of the following are required to create a trend line?
Correct Answer: A
To create a trend line, we need: Graphical user interface, application Description automatically generated
Question 25
True or False: To concatenate fields, they must be of same data type
Correct Answer: A
Explanation Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use - Type casting. See below: Here, State and City are Strings, but Postal Code? Nope. It's an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!
