Download Tableau Data Visualization Certificate Practice Exam and more Exams Technology in PDF only on Docsity!
Certificate Practice Exam
Question 1. What does the “data‑ink ratio” refer to in data visualization? A) The proportion of ink used for decorative elements B) The amount of ink devoted to data representation vs. non‑data elements C) The ratio of color to grayscale in a chart D) The percentage of chart area occupied by legends Answer: B Explanation: A high data‑ink ratio means most ink is used to display data, minimizing chart junk. Question 2. Which Gestalt principle helps viewers perceive bars that are close together as a group? A) Continuity B) Proximity C) Similarity D) Closure Answer: B Explanation: Proximity groups elements that are near each other, making adjacent bars appear related. Question 3. Which pre‑attentive attribute is most effective for highlighting a single outlier in a scatter plot? A) Shape B) Size C) Orientation D) Texture Answer: B Explanation: Larger size draws the eye instantly, making an outlier stand out. Question 4. When should you choose a line chart over a bar chart? A) To compare categories B) To show part‑to‑whole C) To display trends over time D) To illustrate distribution Answer: C Explanation: Line charts excel at showing continuous trends across a time dimension. Question 5. Which color palette is best for representing low‑medium‑high temperature ranges? A) Categorical B) Sequential C) Diverging D) Qualitative Answer: B Explanation: Sequential palettes vary light‑to‑dark, suitable for ordered numeric scales like temperature.
Certificate Practice Exam
Question 6. What is a key consideration for color‑blind accessibility? A) Use only red and green B) Avoid using any colors C) Use high‑contrast palettes with color‑blind safe hues D) Rely on gradients only Answer: C Explanation: High‑contrast, color‑blind safe palettes ensure all viewers can differentiate data points. Question 7. Which factor most contributes to cognitive load in a dashboard? A) Use of tooltips B) Overcrowding with many charts C) Consistent font size D) Clear titles Answer: B Explanation: Too many visual elements overwhelm the viewer’s processing capacity. Question 8. In Tableau, which file type cannot be directly connected as a data source? A) Excel B) CSV C) JSON D) PDF Answer: D Explanation: Tableau does not read data from PDF files without conversion. Question 9. What is the main advantage of using a live connection versus an extract? A) Faster performance B) Real‑time data C) Smaller file size D) Easier publishing Answer: B Explanation: Live connections query the source in real time, reflecting current data. Question 10. Which join type returns all records from the left table and matching records from the right table? A) Inner B) Left C) Right D) Full Outer Answer: B Explanation: A left join keeps all left‑table rows, adding right‑table data where matches exist.
Certificate Practice Exam
Question 15. In Tableau, what color indicates a discrete (categorical) field? A) Green B) Blue C) Red D) Orange Answer: B Explanation: Discrete fields appear as blue pills, while continuous fields are green. Question 16. Which aggregation is applied by default to a newly added numeric measure? A) AVG B) SUM C) MIN D) COUNT Answer: B Explanation: Tableau defaults to SUM for numeric measures unless changed. Question 17. If you place a date dimension on the Columns shelf and a sales measure on Rows, what determines the level of detail? A) The order of fields B) The date hierarchy level (Year, Quarter, etc.) C) The number of rows D) The filter context Answer: B Explanation: The hierarchy level of the date (e.g., Year vs. Month) sets the granularity of the view. Question 18. Which sorting option allows you to order bars based on a measure’s value rather than alphabetically? A) Manual B) Alphabetical C) By Field D) By Data Source Answer: C Explanation: “By Field” sorts using the numeric values of a selected measure. Question 19. What does the “Find Clusters” feature do? A) Creates groups based on geographic proximity B) Automatically clusters similar data points for analysis C) Generates a hierarchical tree D) Merges duplicate records Answer: B Explanation: Find Clusters applies statistical clustering to group similar observations.
Certificate Practice Exam
Question 20. Which Tableau object is used to create drill‑down navigation through Region → State → City? A) Parameter B) Set C) Hierarchy D) Calculated Field Answer: C Explanation: Hierarchies let users expand or collapse levels of geographic detail. Question 21. Which chart type is most appropriate for displaying market share percentages of four product categories? A) Bar Chart B) Line Chart C) Pie Chart D) Scatter Plot Answer: C Explanation: Pie charts effectively show parts of a whole when categories are few. Question 22. What feature adds a background map layer to a Tableau worksheet? A) Symbol Map B) Gantt Bar C) Heat Map D) Histogram Answer: A Explanation: Symbol maps overlay points onto a geographic map background. Question 23. Which map type uses color‑filled regions to represent values? A) Symbol Map B) Heat Map C) Choropleth Map D) Flow Map Answer: C Explanation: Choropleth (filled) maps shade areas based on data intensity. Question 24. How can you display two different measures on the same map with separate legends? A) Use a dual‑axis map B) Add a reference line C) Create a calculated field D) Apply a filter action Answer: A Explanation: Dual‑axis maps let you layer two measures, each with its own legend.
Certificate Practice Exam
Question 30. What does the ZN() function do? A) Returns zero if the argument is null B) Rounds a number to the nearest integer C) Converts a string to a number D) Returns the current timestamp Answer: A Explanation: ZN replaces nulls with zero, useful for calculations. Question 31. Which Level of Detail (LOD) expression fixes the calculation at the State level regardless of view granularity? A) { INCLUDE [State] : SUM([Sales]) } B) { FIXED [State] : SUM([Sales]) } C) { EXCLUDE [State] : SUM([Sales]) } D) { FIXED : SUM([Sales]) } Answer: B Explanation: FIXED locks the aggregation to the specified dimension(s). Question 32. What does a “Running Total” table calculation compute? A) Cumulative sum across the partition B) Percent of total C) Rank of each value D) Difference between consecutive rows Answer: A Explanation: Running Total adds each row’s value to the sum of all preceding rows. Question 33. Which parameter type allows users to select from a predefined list of values? A) Integer B) Float C) String D) List (Dropdown) Answer: D Explanation: A dropdown list parameter presents selectable options. Question 34. How can a parameter be used to dynamically change a reference line’s threshold? A) By creating a calculated field that references the parameter B) By editing the data source C) By applying a filter D) By changing the axis title Answer: A
Certificate Practice Exam
Explanation: The reference line can reference a calculated field that incorporates the parameter value. Question 35. In Tableau’s filter order of operations, which filter is applied first? A) Context Filter B) Dimension Filter C) Measure Filter D) Table Calculation Filter Answer: B Explanation: Dimension filters are evaluated before context, measure, and table calculation filters. Question 36. What is the purpose of a “Context Filter”? A) To speed up performance by reducing the data set for subsequent filters B) To format numbers C) To create a calculated field D) To change the data source type Answer: A Explanation: Context filters create a subset of data that other filters act upon, improving efficiency. Question 37. Which dashboard layout option allows objects to be placed anywhere on the canvas? A) Tiled B) Floating C) Fixed D) Grid Answer: B Explanation: Floating objects can be positioned freely, overlapping other elements. Question 38. What does a “Filter Action” do in a dashboard? A) Opens a URL B) Highlights selected marks C) Sends a filter from one sheet to another D) Changes the sheet’s data source Answer: C Explanation: Filter actions let a selection in one view filter the data shown in another view. Question 39. Which action type would you use to open a web page when a user clicks a mark? A) Filter Action B) Highlight Action C) URL Action D) Parameter Action
Certificate Practice Exam
Answer: B Explanation: Tableau’s default forecasting method is exponential smoothing. Question 45. Which color palette should you use for a diverging metric with a neutral midpoint? A) Sequential B) Categorical C) Diverging D) Qualitative Answer: C Explanation: Diverging palettes show two extremes from a central neutral value. Question 46. What does the “Pages” shelf allow you to do? A) Create a multi‑page PDF B) Animate a view across a dimension C) Add a legend D) Set a filter context Answer: B Explanation: Pages break a view into a series of frames, enabling animation over a field. Question 47. Which option in the Data pane lets you change a field’s default aggregation? A) Rename B) Convert to Dimension C) Default Properties > Aggregation D) Duplicate Answer: C Explanation: Default Properties > Aggregation sets how the field aggregates when added to a view. Question 48. What is the effect of unpivoting data in Tableau? A) Turns rows into columns B) Turns columns into rows C) Merges duplicate records D) Splits a string field Answer: B Explanation: Unpivot (or melt) transforms wide columns into a tall, normalized format. Question 49. Which function would you use to concatenate first and last name fields? A) CONCATENATE([First],[Last]) B) [First] + [Last] C) [First] + " " + [Last] D) STRING([First],[Last]) Answer: C
Certificate Practice Exam
Explanation: Using the + operator with a space string joins the two fields. Question 50. When should you use a “Fixed LOD” instead of a regular aggregation? A) To calculate a value at a different granularity than the view B) To improve performance C) To create a parameter D) To change the data source type Answer: A Explanation: FIXED LOD lets you compute metrics independent of the current level of detail. Question 51. Which chart type is best for visualizing the distribution of order values across many bins? A) Bar Chart B) Histogram C) Line Chart D) Scatter Plot Answer: B Explanation: Histograms show frequency across value intervals (bins). Question 52. What does the “Fit Width” option do to a dashboard on a mobile device? A) Stretches the view to fill height B) Scales the width to the device while allowing vertical scrolling C) Hides all filters D) Locks the aspect ratio Answer: B Explanation: Fit Width fits the dashboard horizontally, enabling vertical scrolling for overflow. Question 53. Which field type would you use for a geographic region that Tableau does not recognize automatically? A) String B) Integer C) Geographic Role D) Boolean Answer: C Explanation: Assigning a Geographic Role tells Tableau how to map the field. Question 54. What is the primary purpose of a “Set” in Tableau? A) To filter data permanently B) To define a custom grouping of members for analysis C) To change data types D) To create a calculated field Answer: B
Certificate Practice Exam
Explanation: A range parameter displays a slider for numeric input. Question 60. What is the effect of setting a filter’s “Apply to Context” option? A) It becomes a quick filter B) It runs after all other filters C) It creates a temporary table that other filters reference D) It disables the filter Answer: C Explanation: Context filters generate a subset that subsequent filters evaluate against. Question 61. Which visualization best shows hierarchical relationships with size proportional to sales? A) Tree Map B) Pie Chart C) Line Chart D) Scatter Plot Answer: A Explanation: Tree maps display hierarchy and size simultaneously. Question 62. What does the “Analytics Pane” provide? A) Data source connections B) Pre‑built statistical objects like trend lines and forecasts C) Dashboard layout tools D) Color palette options Answer: B Explanation: The Analytics Pane contains quick analytical elements. Question 63. Which field type is automatically aggregated when placed on the Rows shelf? A) Dimension B) Measure C) Parameter D) Set Answer: B Explanation: Measures are aggregated (e.g., SUM) unless set to Discrete. Question 64. What is the default behavior when you drag a geographic field onto the view? A) Tableau creates a bar chart B) Tableau generates a map C) Tableau shows a text table D) Tableau prompts for a join Answer: B
Certificate Practice Exam
Explanation: Geographic fields trigger automatic map creation. Question 65. Which function returns the first character of a string? A) LEFT([String],1) B) RIGHT([String],1) C) MID([String],1,1) D) SUBSTR([String],1) Answer: A Explanation: LEFT extracts the leftmost characters; specifying 1 returns the first character. Question 66. When would you use a “Parameter Control” instead of a filter? A) To let users choose a dynamic threshold that affects calculations B) To permanently exclude data C) To change data source D) To sort alphabetically Answer: A Explanation: Parameters allow user input that can drive calculations, not just filtering. Question 67. What does the “Include” keyword do in an LOD expression? A) Removes the specified dimension from the view B) Adds the dimension to the level of detail of the calculation C) Fixes the calculation at the dataset level D) Excludes null values Answer: B Explanation: INCLUDE adds extra dimensions to the aggregation beyond those in the view. Question 68. Which chart type can be used to compare multiple KPI values against targets in a compact form? A) Bullet Graph B) Pie Chart C) Heat Map D) Gantt Bar Answer: A Explanation: Bullet graphs display actual vs. target and qualitative ranges. Question 69. What is the purpose of the “Data Interpreter” when connecting to Excel? A) It creates a live connection B) It cleans and structures the data automatically C) It generates a color palette D) It adds geographic roles Answer: B
Certificate Practice Exam
Explanation: Device Designer lets you create layouts optimized for specific device types. Question 75. What does a “Reference Line” represent? A) A static value such as average or median B) A trend line C) A distribution band D) A filter action Answer: A Explanation: Reference lines display constant values (e.g., mean) across the view. Question 76. Which calculation type is evaluated after the view’s aggregation? A) Row‑level calculation B) LOD FIXED C) Table Calculation D) Parameter Answer: C Explanation: Table calculations run on the aggregated result set. Question 77. When creating a map, which data type must be assigned to a field to enable latitude/longitude plotting? A) String B) Integer C) Geographic Role – Latitude/Longitude D) Boolean Answer: C Explanation: Assigning the Geographic Role tells Tableau the field contains coordinate data. Question 78. What is the effect of “Hide Unused Fields” in the data source tab? A) Deletes fields from the source B) Removes them from the Data pane view C) Converts them to parameters D) Renames them Answer: B Explanation: Hiding unused fields declutters the Data pane without deleting them. Question 79. Which function returns the week number of a date, assuming weeks start on Monday? A) DATEPART('week', [Date]) B) DATEPART('iso-week', [Date]) C) WEEK([Date]) D) DATEPART('weekday', [Date]) Answer: B
Certificate Practice Exam
Explanation: ‘iso-week’ follows ISO‑8601, where weeks start on Monday. Question 80. What does the “Mark Type” dropdown control? A) Data source connection B) Visual encoding of marks (e.g., Bar, Circle) C) Filter order D) Sheet name Answer: B Explanation: Mark Type determines how data points are rendered. Question 81. Which chart is most appropriate for showing market share changes over time for several products? A) Stacked Area Chart B) Scatter Plot C) Bar Chart D) Pie Chart Answer: A Explanation: Stacked area charts display part‑to‑whole trends across time. Question 82. When you set a field to “Continuous” in Tableau, what happens? A) It becomes a dimension B) It is displayed as a green pill and can be used on axes C) It is hidden D) It turns into a parameter Answer: B Explanation: Continuous fields are quantitative and appear as green pills. Question 83. Which feature lets you embed a live Tableau view into a web page? A) Export to PDF B) URL Action C) Tableau Public embed code D) Data Extract Answer: C Explanation: Tableau Public (or Server) provides embed HTML code for live views. Question 84. What does the “Explain Data” button analyze? A) Data source metadata B) Statistical reasons for a selected mark’s value C) Layout performance D) Color palette suitability Answer: B Explanation: Explain Data uses machine learning to suggest explanations for outliers.
Certificate Practice Exam
Answer: A Explanation: Fit All expands the map to include all plotted marks. Question 90. Which function can be used to replace null values with the string “N/A”? A) IFNULL([Field], "N/A") B) ZN([Field]) C) ISNULL([Field]) D) NULL([Field]) Answer: A Explanation: IFNULL substitutes a specified value when the field is null. Question 91. What is the effect of setting a worksheet’s “Show Header” option to off? A) Removes the field from the data source B) Hides axis titles and headers C) Disables filters D) Changes the mark type Answer: B Explanation: Hiding the header removes axis labels from the view. Question 92. Which analytic object adds a shaded region that represents the distribution of data points? A) Trend Line B) Reference Band C) Distribution Band D) Forecast Band Answer: C Explanation: Distribution Bands display the density spread of the data. Question 93. When creating a calculated field, which operator is used for logical AND? A) && B) || C) AND D) + Answer: A Explanation: In Tableau, && represents logical AND. Question 94. Which option allows you to export a dashboard as an image file? A) Save As… B) Export > Image C) Download Data D) Publish to Server Answer: B
Certificate Practice Exam
Explanation: Export > Image creates a static picture of the dashboard. Question 95. What does the “Data Model” in Tableau refer to? A) The physical database schema B) Logical relationships between tables defined in Tableau C) The extracted data file D) The color palette configuration Answer: B Explanation: The Data Model lets you define relationships without physically joining tables. Question 96. Which function calculates the percentile rank of a value within a partition? A) PERCENT_RANK() B) RANK_PERCENTILE() C) PERCENTILE([Field],0.5) D) INDEX() Answer: A Explanation: PERCENT_RANK returns the relative position of a value. Question 97. What is the primary benefit of using a “Parameter” in a calculated field? A) It permanently changes the data source B) It allows end‑users to modify the calculation at runtime C) It speeds up query performance D) It creates a new dimension automatically Answer: B Explanation: Parameters provide dynamic input that can alter calculations on the fly. Question 98. Which chart type can effectively display the proportion of a whole while also showing hierarchical levels? A) Pie Chart B) Stacked Bar C) Sunburst (Radial Treemap) D) Line Chart Answer: C Explanation: A sunburst visualizes hierarchical parts of a whole. Question 99. When you set a filter to “Only Relevant Values,” what happens? A) All values remain visible B) Values are limited to those present in the current view C) The filter is removed D) The data source is refreshed
