Download Tableau Desktop Certified Associate Exam and more Exams Technology in PDF only on Docsity!
Question 1. What is a primary advantage of using a data extract over a live connection in Tableau? A) Real-time data updates B) Improved performance and faster load times C) Automatic data refresh from the source D) Maintaining data security at the source Answer: B Explanation: Data extracts are stored locally and optimized for performance, resulting in faster load times compared to live connections, which query the data source directly. Question 2. Which file format is used by Tableau to save customized metadata properties for data sources? A) .TDS B) .TDSX C) .TWBX D) .TWB Answer: A Explanation: The .TDS (Tableau Data Source) file format saves metadata properties such as field aliases, default aggregations, and geographic roles.
Question 3. When should you prefer using relationships over joins in Tableau data modeling? A) When combining data from multiple sources with different levels of detail B) When merging two tables with identical structure C) When performing union operations D) When creating a static snapshot of data Answer: A Explanation: Relationships allow Tableau to maintain data granularity and perform joins dynamically based on the context, making them ideal for combining data from different sources with varying levels of detail. Question 4. How can you assign a geographic role to a data field in Tableau? A) By right-clicking the field and selecting "Geographic Role" B) By dragging the field onto the Rows shelf C) By creating a calculated field D) By applying a filter Answer: A Explanation: Assigning a geographic role involves right-clicking the field in the data pane and selecting "Geographic Role" to enable map visualizations. Question 5. Which type of join in Tableau combines all records from both tables, including unmatched rows?
B) Modifying the original data source C) Creating a calculated field D) Applying a filter to the field Answer: A Explanation: Renaming a data field involves changing its label within Tableau for better clarity without altering the original data source. Question 8. How can aliases be used in Tableau? A) To replace data values with more understandable labels B) To change the data type of a field C) To create a duplicate of a field D) To filter data based on specific criteria Answer: A Explanation: Aliases assign alternative, often more readable labels to data values, improving the clarity of visualizations. Question 9. What does assigning a geographic role to a data field enable in Tableau? A) Sorting data alphabetically B) Creating map visualizations C) Filtering data based on categories D) Connecting to external data sources
Answer: B Explanation: Assigning a geographic role like "Country" or "City" enables Tableau to interpret the field as spatial data for mapping. Question 10. Which chart type is best suited for visualizing the relationship between two measures? A) Bar chart B) Scatter plot C) Pie chart D) Histogram Answer: B Explanation: Scatter plots are ideal for examining the relationship, correlation, or pattern between two quantitative measures. Question 11. How can you create a combined axis chart in Tableau? A) Drag two measures onto the Rows or Columns shelf B) Use the Show Me panel C) Create two separate sheets D) Use a filter Answer: A Explanation: Dragging multiple measures onto the same axis allows them to be overlaid, creating a combined axis chart for comparison.
B) It displays only geographic boundaries C) It shows only categorical data D) It is used exclusively for demographic data Answer: A Explanation: Density maps analyze and visualize the concentration of data points, highlighting hotspots or areas with higher data density. Question 15. Which feature allows grouping of selected marks in Tableau? A) Creating a group B) Building a set C) Applying a filter D) Creating a hierarchy Answer: A Explanation: Creating a group consolidates selected marks into a single category, useful for simplified analysis and visualization. Question 16. What is a set in Tableau? A) A custom subset of data based on specific conditions or selections B) A type of join operation C) A static data source D) A filter applied to all sheets Answer: A
Explanation: Sets define custom groups of data based on criteria or selections, enabling focused analysis. Question 17. How are hierarchies used in Tableau? A) To organize data into drill-down levels B) To perform joins between tables C) To create calculated fields D) To assign geographic roles Answer: A Explanation: Hierarchies group related dimensions, allowing users to drill down or roll up data for detailed or summarized views. Question 18. Which feature adds interactivity to a Tableau dashboard by enabling users to filter data dynamically? A) Filters B) Actions C) Annotations D) Annotations and comments Answer: A Explanation: Filters allow users to select specific data subsets interactively within dashboards.
C) Difference D) Rank Answer: A Explanation: The Running Total calculation cumulatively sums values across a specified dimension, useful for trend analysis. Question 22. How do bins help in data analysis in Tableau? A) They group continuous data into discrete intervals B) They filter data to a specific subset C) They create geographic regions D) They perform data joins Answer: A Explanation: Bins partition continuous measures into ranges, enabling distribution and frequency analysis. Question 23. Which function is used to create a calculated field that concatenates two strings? A) + (plus) B) CONCAT() C) & D) Both B and C Answer: D
Explanation: Both CONCAT() function and the & operator can concatenate strings in Tableau calculated fields. Question 24. What is the primary purpose of parameters in Tableau? A) To enable user input and dynamic control over calculations or filters B) To assign geographic roles C) To create static filters D) To replace data sources Answer: A Explanation: Parameters allow users to input or select values that dynamically influence calculations, filters, or other aspects of a worksheet. Question 25. How do you display totals in Tableau? A) Use the Show Totals option in the Analysis menu B) Add a reference line C) Create a calculated field D) Use the Filter shelf Answer: A Explanation: The Show Totals feature aggregates data and displays subtotals or grand totals in tables and views. Question 26. Which chart type is best suited for visualizing trends over time?
D) Creates a new calculated field Answer: A Explanation: Filters restrict the data shown in a worksheet according to user- selected conditions, aiding focused analysis. Question 29. Which type of filter allows for selecting specific dates or date ranges? A) Date filter B) Numeric filter C) Relative date filter D) All of the above Answer: D Explanation: Tableau offers various date filters, including specific date selections, ranges, and relative date options. Question 30. How does a manual sort differ from a computed sort in Tableau? A) Manual sort is user-defined, computed sort is based on calculations B) Manual sort is automatic C) Computed sort requires coding D) They are the same Answer: A
Explanation: Manual sorting involves dragging and arranging items directly, while computed sorts order data based on formulas or calculations. Question 31. Which method can be used to highlight specific data points in Tableau? A) Create highlight actions B) Use reference lines C) Apply filters D) All of the above Answer: D Explanation: Highlight actions, reference lines, and filters all can draw attention to particular data points or ranges. Question 32. How do you create a histogram in Tableau? A) Use the bin feature on a measure B) Create a bar chart with categories C) Use a scatter plot D) Use the density map Answer: A Explanation: Creating bins on a measure transforms continuous data into discrete intervals, forming a histogram.
C) Use the Show Me panel D) Create a calculated field Answer: A Explanation: Parameters are created by right-clicking in the Data pane and choosing "Create Parameter," allowing user input. Question 36. Which chart type is most effective for visualizing distributions of data? A) Histogram B) Bar chart C) Line chart D) Map Answer: A Explanation: Histograms display the distribution and frequency of continuous data across intervals. Question 37. How do reference lines help in data analysis? A) They highlight specific values or thresholds on axes B) They filter data C) They create geographic boundaries D) They are used for layout purposes only Answer: A
Explanation: Reference lines mark important values or thresholds, aiding in interpretation of the data's key points. Question 38. How does a dual-axis chart improve data comparison? A) By overlaying two different measures with different scales B) By creating a map C) By combining categories D) By filtering data dynamically Answer: A Explanation: Dual axes enable side-by-side comparison of measures that have different units or scales within the same visualization. Question 39. Which feature allows users to switch between different views or perspectives in a dashboard? A) Actions B) Filters C) Parameters D) Annotations Answer: A Explanation: Actions can be set up to allow users to interactively change views, such as filtering or highlighting across dashboards.
C) CSV
D) TWBX
Answer: A Explanation: PNG is an image format suitable for exporting static visuals from Tableau. Question 43. How can you share an entire workbook's data with others? A) Export the underlying data B) Save as a PDF C) Publish to Tableau Server D) All of the above Answer: D Explanation: Each method allows sharing data or visualizations; exporting underlying data shares raw data, while publishing makes the workbook accessible online. Question 44. Which concept explains how discrete fields influence Tableau's visualization? A) Discrete fields create headers and categorical axes B) They are used only for geographic data C) Discrete fields are always numeric D) Discrete fields cannot be used in filters
Answer: A Explanation: Discrete fields generate headers and categorical axes, segmenting data into distinct groups. Question 45. How do continuous fields impact the visualization in Tableau? A) They create axes with a range of values B) They only work with date data C) They are used for geographic roles D) They cannot be aggregated Answer: A Explanation: Continuous fields produce axes with a continuous range of values, suitable for trend lines and distributions. Question 46. Why is understanding the difference between discrete and continuous fields important in Tableau? A) It affects how data is displayed and aggregated B) It determines data source connection C) It controls access permissions D) It is only relevant for geographic data Answer: A Explanation: Knowing whether a field is discrete or continuous influences visualization types, axes, and aggregation methods.
