- All Exams Instant Download
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.A . TrueB . FalseView AnswerAnswer: A Explanation: Joins combine tables by adding more columns...
True or False: Context Filters are executed after Data Source filters
True or False: Context Filters are executed after Data Source filtersA . TrueB . FalseView AnswerAnswer: A Explanation: THIS IS A VERY IMPORTANT QUESTION To answer this question, you need to understand Tableau's Order of Operations. See below and remember this always: Reference: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm
True or False: To concatenate fields, they must be of same data type
True or False: To concatenate fields, they must be of same data typeA . TrueB . FalseView AnswerAnswer: 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...
True or False: A reference line cannot be added from the Analytics Pane
True or False: A reference line cannot be added from the Analytics PaneA . TrueB . FalseView AnswerAnswer: B Explanation: You can add a reference line to any continuous axis in the view. To add a reference line: Drag Reference Line from the Analytics pane into the view. Tableau shows...
For a relative date filter, the default anchor is _________________
For a relative date filter, the default anchor is _________________A . The current timeB . Today's dateC . The target dateD . The date we specifyView AnswerAnswer: B Explanation: Relative date filters dynamically update to show a time period relative to when you open the view, such as the current...
Which of the following are the options to export the data used to build the view / visualisations?
Which of the following are the options to export the data used to build the view / visualisations?A . CSV fileB . PDF FileC . JSON formatD . MS Access DatabaseView AnswerAnswer: AD Explanation: You can export the data in a Tableau data source, including all or part of the...
Given a map, which of the following fields can be placed in Size,Shape,Detail,Color
Given a map, which of the following fields can be placed in Size,Shape,Detail,ColorA . Profit, State, Number of Records, SalesB . Region, Country, Profit, StateC . Longitude, Country, State, SalesD . Sales, State, Country, ProfitView AnswerAnswer: D Explanation: Since Sales is a measure, it can easily be depicted via size....
Which of the following is a good reason for using a bullet graph?
Which of the following is a good reason for using a bullet graph?A . Comparing the actual sales against the target salesB . Analysing the trend over a given time periodC . Forecasting future salesD . Displaying the year-on-year growth in salesView AnswerAnswer: A Explanation: A bullet graph is a...
Is SUM a table calculation?
Is SUM a table calculation?A . YesB . NoView AnswerAnswer: B Explanation: SUM is an aggregate function, not a table calculation! A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data...
What is the Average In-Stock percentage for the Color Red?
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.A . 96.46%B . 95.12%C . 97.12%D . 99.46%View AnswerAnswer: C Explanation: Not too tough. Follow along...
