Tableau Desktop Specialist exam fully solved graded A+ 2023

Tableau Desktop Specialist exam What is the difference between Live and Extract connections? [select all that apply] - correct answer a) Live allows real-time data while extracts are kind of batch which needs to be refreshed from time to time to get the updated data. b) Live Connection takes more time to load data than Extract Connection. Why the direct connection to the extract is not recommended? [select all that apply] - correct answer a) The table names will be different b) The extract cannot be refreshed c) The data model and relationships will be lost. How many data sources can we blend in Tableau? - correct answer a) Two In a Relationship we need to define the following Join type - - correct answer d) It is not required to define a join type in a relationship Which option leads to adjusting the granularity of data in Tableau? - correct answer a) Aggregate Advantages to using relationships to combine tables: [select all that apply] - correct answer b) Make it easier to analyse data across multiple tables at different levels of granularity Choose the correct path to change the data type for a field in the view - - correct answer b) Right click the field in the Data pane - Change Data Type - Choose the appropriate data type Choose the correct path to add a default comment for a field- - correct answer a) Right click a field in the Data pane- Default Properties- Comment What steps should be taken to change a vertical bar chart to horizontal? - correct answer a) Drag the measure to the columns shelf and the dimension to the row shelf What steps should be taken to create a geographical hierarchy? - correct answer c) In the Data pane right-click the geographic field- Hierarchy - Create Hierarchy What steps will create a dual axis chart? [Select All that Apply] - correct answer a) Drag one dimension to Column and drag two measures to Row - In the Rows right click any of the measure - Select Dual axes - Go to marks type of any of the measure and choose the chart type as Bar c) Drag one dimension to Column and drag one measures to Row - drag another measure to the chart itself and as the rectangle shape appears drop it - Go to marks type of any of the measure and choose the chart type as Bar How to create a stacked bar chart while using a separate bar for each measure? - [Select All that Apply] - correct answer a) Drag a dimension to Color - Drag Measure Names to Columns and drag Measure Values to Rows - On the Columns shelf right-click Measure Names - select Filter - select the check boxes for the measures to display - Ok How to create Highlight Table in Tableau - - correct answer a) Drag one or more dimensions on the Columns shelf and one or more dimensions on the Rows shelf - place a measure of interest on the Color shelf - Select Square as the mark type How to create a group from a field in the Data pane? - - correct answer a) In the Data pane right-click a field - select Create - In the Create Group dialog box select the members that needs to be grouped - Group - Ok. How to create a Hierarchy in Tableau? - - correct answer a) In Data pane drag a field and drop on top of another field - enter a name of the hierarchy - ok