Analytics-Con-301 — Salesforce Certified Tableau Consultant

Full question text, answer options, and explanations for this practice set — a spoiler-free alternative is the interactive quiz above for scored, shuffled practice.

1. 1. A customer's business unit currently distributes analytics through static PDF exports emailed weekly, and wants to move to a self-service model where stakeholders can explore data on demand. Which activity should the consultant perform first to lead this transition?

   • A. Map the business needs to Tableau capabilities to identify what self-service functionality actually solves the stated pain points(correct)
   • B. Immediately begin building dashboards using the same layout as the existing PDFs
   • C. Recommend Tableau Server over Tableau Cloud without further discussion
   • D. Skip requirements gathering since PDF exports are inherently outdated

   Explanation: Mapping business needs to Tableau capabilities is the first documented step in evaluating current state, ensuring the future analytics solution is grounded in what stakeholders actually require rather than replicating an existing format. Jumping straight to building dashboards (B) skips validating requirements. Recommending a platform (C) before understanding needs is premature. Skipping requirements gathering entirely (D) risks delivering a solution that doesn't solve the real problem.

2. 2. A consultant is evaluating whether a customer's requirement for occasional advanced formatting features and offline installation control is better served by Tableau Server versus Tableau Cloud. The customer also mentions they have no in-house infrastructure team. What should the consultant recommend and why?

   • A. Tableau Cloud, since the customer lacks infrastructure resources to manage patching, upgrades, and server maintenance themselves(correct)
   • B. Tableau Server, because it always has more features than Tableau Cloud
   • C. A hybrid deployment using two separate on-premises data centers
   • D. Neither platform, since neither supports advanced formatting

   Explanation: Recommending whether to use Tableau Server or Tableau Cloud is an explicit exam objective, and a customer without infrastructure resources to manage ongoing patching and maintenance is better served by the fully managed Tableau Cloud offering. Tableau Server does not categorically have more features than Cloud (B). A dual on-premises hybrid (C) adds infrastructure burden the customer explicitly lacks resources for. Both platforms support advanced formatting (D), making that option incorrect.

3. 3. A customer running Tableau Server 2018.2 on Windows wants to move to a current supported release. Which consideration is most relevant when the consultant plans this specific upgrade?

   • A. The documented upgrade path and compatibility considerations for upgrading from that specific legacy version on Windows(correct)
   • B. The number of dashboard color themes currently in use
   • C. Whether users have favorited any views
   • D. The size of the company's logo file used in email subscriptions

   Explanation: Recommending and planning a Tableau Server upgrade requires understanding the documented upgrade path and compatibility considerations specific to the version being upgraded from, since older releases can have distinct migration steps. Color themes, favorited views, and logo file size have no bearing on upgrade planning.

4. 4. A consultant is auditing a customer's existing sales data model, which was originally designed for a single regional report but is now used as the foundation for company-wide executive dashboards. Which two evaluations should the consultant perform on the existing data structure? (Choose 2)

   • A. Evaluate whether the existing data supports the broader company-wide business needs it is now being asked to serve(correct)
   • B. Evaluate the lineage of the existing data structure to understand its origin and dependencies(correct)
   • C. Change the corporate branding colors used across all dashboards
   • D. Disable all filters on every existing dashboard

   Explanation: Evaluating whether existing data supports current business needs, and evaluating the lineage of existing data structures, are both explicit documented activities for assessing whether a data foundation originally built for a narrower purpose can support its expanded use. Branding colors (C) and disabling filters (D) are unrelated to data structure evaluation.

5. 5. During a data structure evaluation, a consultant discovers a published data source that uses a complex live join across five large tables, resulting in slow dashboard load times. What is the most appropriate finding to document in this evaluation?

   • A. The existing data structure has performance risks stemming from the multi-table live join, along with enhancement opportunities such as restructuring or extracting(correct)
   • B. The dashboard's color palette is the root cause of the slow load times
   • C. The customer's internet connection speed is definitely the cause
   • D. No further action is needed since the data source is already published

   Explanation: Evaluating existing data structures for performance risks and enhancement opportunities is an explicit documented objective, and a complex multi-table live join is a well-known example of both a risk and an opportunity for restructuring. Color palette (B) and internet connection speed (C) are not substantiated causes based on the described symptom. Being already published (D) does not mean a structure is free of performance risk.

6. 6. A customer describes wanting 'more advanced analytics' but cannot articulate specific requirements. What is the most appropriate first step for the consultant?

   • A. Translate the customer's vague analytical requirements into specific Tableau context by applying best practices for requirements discovery(correct)
   • B. Purchase the maximum number of Creator licenses available
   • C. Build a dashboard immediately using default sample data
   • D. Tell the customer that Tableau cannot help without clearer requirements

   Explanation: Translating analytical requirements into Tableau context using best practices is an explicit documented consultant activity for exactly this kind of ambiguous request, guiding the customer toward concrete, actionable requirements. Buying maximum licenses (B) and building with sample data (C) skip proper discovery. Refusing to engage (D) is not a productive consulting approach.

7. 7. A finance team needs dashboard values that always reflect the exact granularity of the source transactional ledger, with no rounding or pre-aggregation, since auditors require line-item traceability. What should the consultant specify when planning the data transformation?

   • A. The minimum level of granularity required, ensuring the data source preserves line-item-level detail(correct)
   • B. An aggregation strategy that rolls all transactions up to the monthly level
   • C. A sampling strategy that includes only 10% of records for performance
   • D. A data source that only includes summary totals

   Explanation: Specifying the requirements for minimum level of granularity is an explicit documented activity in planning data transformation, and an audit requirement for line-item traceability directly demands preserving that granularity. Monthly aggregation (B), sampling (C), and summary-only totals (D) would all break the auditors' traceability requirement.

8. 8. A customer needs row-level security so that regional managers only see data for their own region, and wants to compare implementation approaches before committing. Which two activities should the consultant perform? (Choose 2)

   • A. Compare available RLS approaches to determine which best fits the customer's data model and governance needs(correct)
   • B. Implement RLS using an entitlement table and identify whether group functions or user functions are appropriate(correct)
   • C. Disable all filters on the workbook to simplify the view
   • D. Grant every regional manager the Creator role regardless of need

   Explanation: Comparing RLS approaches, and implementing RLS with an entitlement table while identifying group versus user functions, are both explicit documented activities for designing a row-level security data structure. Disabling filters (C) removes needed interactivity and does not implement security. Granting Creator roles broadly (D) is a licensing decision unrelated to RLS design and violates least-privilege principles.

9. 9. A customer's proprietary on-premises database has no native Tableau connector, but exposes a documented HTTP/JSON interface. What is the most appropriate connection method for the consultant to recommend?

   • A. A Web Data Connector built against the documented HTTP/JSON interface(correct)
   • B. Custom SQL against a connector that does not exist
   • C. Tableau Bridge configured with no underlying data source
   • D. Manually re-typing the data into a spreadsheet each day

   Explanation: Recommending an appropriate method to connect to data — including Web Data Connectors — for a system exposing an HTTP/JSON interface without a native connector is exactly the documented use case for that method. Custom SQL (B) requires an existing database connector, which doesn't apply here. Tableau Bridge (C) still requires an underlying data source to connect through, and manual re-entry (D) does not scale and is error-prone.

10. 10. A customer's data source is hosted on an internal network with no direct route to Tableau Cloud, but the customer wants scheduled extract refreshes to work without manual intervention. What should the consultant recommend?

    • A. Create a connection using Tableau Bridge to enable scheduled refreshes against the on-premises data(correct)
    • B. Manually export the data to a USB drive weekly
    • C. Move the on-premises database to a public unsecured server
    • D. Disable extract refreshes entirely and rely on live connections only

    Explanation: Creating connections by using Tableau Bridge is the explicit documented method for enabling scheduled refreshes against on-premises data that Tableau Cloud cannot otherwise reach directly. Manual USB exports (B) don't scale or automate. Exposing the database publicly (C) is a serious security risk. Relying only on live connections (D) doesn't address the stated need for scheduled refreshes and may not even be reachable without Bridge.

11. 11. A customer's data source spans Tableau Prep, Tableau Desktop, and Tableau Cloud in its lifecycle, and the consultant needs to decide at which stage aggregation should happen to minimize downstream performance issues. What should the consultant specify?

    • A. The appropriate aggregation level and strategy at each relevant stage across the Tableau products involved(correct)
    • B. No aggregation strategy at all, since Tableau Cloud always aggregates automatically
    • C. Aggregation only within email subscriptions
    • D. A single aggregation level applied only after publishing, regardless of upstream tools

    Explanation: Specifying aggregation level and strategy for data sources across Tableau products (Desktop, Prep, Cloud, Server) is an explicit documented planning activity, since choosing the right stage for aggregation materially affects downstream performance. Tableau Cloud does not automatically determine aggregation for you (B). Aggregation isn't limited to email subscriptions (C), and ignoring upstream tooling options (D) misses opportunities to move aggregation earlier in the pipeline for better performance.

12. 12. A customer wants to visualize the flow of customers moving between subscription tiers over time, showing volume and direction of transitions clearly. Which advanced chart type should the consultant recommend?

    • A. A Sankey chart(correct)
    • B. A tile map
    • C. Small multiples
    • D. A standard bar chart

    Explanation: A Sankey chart is specifically designed to visualize flow and volume of transitions between categories over time or stages, matching this exact scenario. A tile map (B) is for geographic data at a regular grid. Small multiples (C) repeat the same chart across a dimension rather than showing flow. A standard bar chart (D) cannot represent directional flow between states.

13. 13. A calculated field that filters on a measure produces unexpected results because the filter appears to be evaluated before an aggregation the consultant expected to run first. What is the most likely explanation?

    • A. The Tableau order of operations is affecting when the filter and aggregation are evaluated relative to each other(correct)
    • B. The workbook file has become corrupted and must be rebuilt from scratch
    • C. The data source connection has silently changed to a different table
    • D. Tableau does not support filtering on calculated fields under any circumstances

    Explanation: Identifying the effect of the Tableau order of operations on calculations, and troubleshooting issues caused by that order, is an explicit documented exam objective — filter and aggregation evaluation order is a classic source of this exact kind of unexpected result. Workbook corruption (B) and a silently changed connection (C) are not the documented explanation for this symptom, and Tableau does support filtering on calculated fields (D), making that option factually incorrect.

14. 14. A customer wants a dashboard where clicking a bar in one chart both filters a related chart and dynamically updates a URL to an external system with context-specific parameters. Which two Tableau interactivity techniques should the consultant implement? (Choose 2)

    • A. A dynamic URL action that passes field values as parameters(correct)
    • B. A filter action to update the related chart based on the selection(correct)
    • C. Disabling all tooltips across the dashboard
    • D. Removing all worksheets except one

    Explanation: Dynamic URL actions and filter actions are both explicit documented advanced interactivity techniques for building the described behavior — passing selection-based parameters to an external URL and filtering a related view based on a selection. Disabling tooltips (C) and removing worksheets (D) do not implement either requested interaction.

15. 15. A dashboard hosted on Tableau Server is queried repeatedly by hundreds of users viewing the exact same filter state each morning. What should the consultant recommend to reduce redundant query load?

    • A. Maximize caching for Tableau Server so repeated identical queries can be served from cache(correct)
    • B. Add more filters to the dashboard to increase specificity
    • C. Convert the dashboard to use only string comparison calculations
    • D. Remove all images from the dashboard

    Explanation: Maximizing caching for Tableau Server is the explicit documented recommendation for reducing redundant load when many users repeatedly request the same query results. Adding filters (B) doesn't address caching or redundant load. String comparison calculations (C) are actually a documented performance risk, not a fix. Removing images (D) may help marginally with load time but doesn't address the described redundant query pattern.

16. 16. A workbook uses several nested IF THEN statements and heavy string comparisons within row-level calculations, and performance has degraded as data volume grew. What should the consultant investigate first?

    • A. Whether performance issues are caused by the calculations themselves, such as string comparisons and IF THEN statements, and whether they can be simplified or moved upstream(correct)
    • B. Whether the dashboard's font size is too large
    • C. Whether the customer's monitor resolution is too low
    • D. Whether the workbook has too many favorited views

    Explanation: Identifying and resolving performance issues caused by calculations such as string comparisons, IF THEN statements, and LOD expressions is an explicit documented objective, and recommending calculations be moved upstream of Tableau is a related documented mitigation. Font size (B), monitor resolution (C), and favorited views (D) have no bearing on calculation-driven performance degradation.

17. 17. A customer reports that a specific dashboard is slow, but the consultant is unsure whether the bottleneck is the query, the rendering, or the number of filters. Which documented tool should the consultant use to diagnose the issue?

    • A. A performance recording, interpreted to isolate the specific bottleneck(correct)
    • B. The dashboard's revision history only
    • C. A manual stopwatch timing of page loads
    • D. The color legend editor

    Explanation: Interpreting and resolving issues by using performance recordings is the explicit documented tool for isolating specific bottlenecks such as query execution, rendering, or layout computation within a slow dashboard. Revision history (B) tracks content changes, not performance data. A manual stopwatch (C) gives no diagnostic detail on where time is spent. The color legend editor (D) is unrelated to performance diagnostics.

18. 18. A dashboard contains 40 sheets, 25 filters, and several large uncompressed images, and users report slow load times. What is the most likely documented cause the consultant should investigate?

    • A. Performance issues caused by design elements such as number of sheets, number of filters, and image size(correct)
    • B. The user's choice of web browser bookmark folder
    • C. The dashboard's title font family
    • D. The number of times the dashboard has been favorited

    Explanation: Identifying and resolving performance issues caused by design elements such as number of sheets, number of filters, and image size is an explicit documented objective, and this scenario describes exactly that combination of design-driven performance risks. Bookmark folders (B), font family (C), and favorite counts (D) have no bearing on dashboard load performance.

19. 19. A customer needs a calculation that computes each region's sales as a percentage of the grand total, but the percentage must recalculate correctly even as users apply filters to individual regions. Which calculation type should the consultant implement?

    • A. An advanced table calculation, such as a percent-of-total window calculation configured with the appropriate addressing and partitioning(correct)
    • B. A simple SUM aggregation with no table calculation logic
    • C. A string concatenation of region names
    • D. A hardcoded static percentage value

    Explanation: Implementing advanced table calculations, such as window calculations, is the explicit documented technique for building dynamic percent-of-total logic that responds correctly to filtering and view-level context. A simple SUM (B) cannot express relative percentage logic. String concatenation (C) is unrelated to numeric computation, and a hardcoded value (D) would not update dynamically as filters change.

20. 20. A retailer operates on a fiscal calendar that begins in February rather than January, and needs all date-based calculations and filters to align with this fiscal year. What should the consultant implement?

    • A. Advanced date functions configured for the customer's fiscal calendar(correct)
    • B. A standard calendar-year date field with no customization
    • C. A manually maintained spreadsheet of date labels
    • D. A string field that stores dates as unformatted text

    Explanation: Implementing advanced date functions, such as fiscal calendars, is the explicit documented technique for aligning calculations and filters to a non-standard fiscal year start. A standard calendar-year field (B) would misalign with the retailer's fiscal periods. A manually maintained spreadsheet (C) doesn't scale or stay synchronized with the live data source, and storing dates as unformatted text (D) breaks native date-based calculations entirely.

21. 21. A workbook needs to compute a customer's average order value at the customer level, nested within a calculation that also computes a company-wide benchmark for comparison, all within a single visualization. What calculation technique should the consultant use?

    • A. Nested Level of Detail (LOD) expressions to compute the customer-level and company-wide aggregations independently of the view's level of detail(correct)
    • B. A single SUM aggregation with no LOD expression
    • C. A filter that removes all customers except one
    • D. A text annotation manually typed for each customer

    Explanation: Implementing advanced LODs, such as nested LODs, is the explicit documented technique for computing multiple levels of aggregation (customer-level and company-wide) independently of the visualization's own level of detail, within a single calculation. A plain SUM (B) cannot separate these two distinct aggregation levels. Filtering to one customer (C) eliminates the comparison entirely, and manual annotations (D) do not scale or update dynamically.

22. 22. A customer's compliance team requires that certain published data sources be clearly marked as the single source of truth, and that duplicate copies of the same data source are minimized across the site. What governance strategy should the consultant recommend?

    • A. A strategy for ensuring data quality, including certifying data sources and minimizing data proliferation(correct)
    • B. Allowing every user to freely duplicate any published data source without restriction
    • C. Removing all published data sources from the site entirely
    • D. Disabling the ability to publish any new content

    Explanation: Recommending a strategy for ensuring data quality, including certifying data sources and minimizing data proliferation, is the explicit documented governance objective matching this exact requirement. Allowing unrestricted duplication (B) directly worsens proliferation. Removing all data sources (C) or disabling publishing (D) eliminates the analytics capability entirely rather than governing it appropriately.

23. 23. An administrator wants to understand which users have published the most content and which projects have grown the fastest over the past quarter. What should the consultant recommend leveraging?

    • A. The appropriate administrative views and data sources suited to this specific insight(correct)
    • B. A manual headcount survey of every department
    • C. The dashboard's tooltip configuration
    • D. A single static screenshot from six months ago

    Explanation: Recommending the appropriate administrative views and data sources for a given scenario is an explicit documented objective, and publishing activity and project growth are exactly the kind of insight administrative views are designed to surface. A manual survey (B), tooltip configuration (C), and an outdated screenshot (D) do not provide this kind of ongoing, queryable operational insight.

24. 24. A customer wants a clear plan for how new workbooks move from initial build through testing, deployment, ongoing distribution, and eventual retirement. What should the consultant recommend developing?

    • A. An approach for the workbook lifecycle, including building, testing, deployment, distribution, and maintenance(correct)
    • B. A single rule that all workbooks must be deleted after 30 days regardless of use
    • C. A policy banning any workbook updates after initial publish
    • D. A requirement that only one person in the company may ever publish content

    Explanation: Recommending an approach for the workbook lifecycle — covering building, testing, deployment, distribution, and maintenance — is the explicit documented governance objective for exactly this need. Automatically deleting workbooks after a fixed period (B) ignores actual usage and business value. Banning updates (C) prevents necessary maintenance, and restricting publishing to a single person (D) does not address lifecycle management and creates an operational bottleneck.

25. 25. A customer's legal and security teams require that only specific groups can view sensitive HR dashboards, while broader company dashboards remain open to all employees. What should the consultant recommend as part of the overall governance strategy?

    • A. Mapping the organization's governance requirements to Tableau features and capabilities, including a strategy for securing access to content(correct)
    • B. Giving every employee the same permission level across all content
    • C. Publishing all HR dashboards without any project-level or permission restrictions
    • D. Removing HR dashboards from Tableau entirely and reverting to spreadsheets

    Explanation: Mapping governance requirements to Tableau features and capabilities, along with recommending a strategy for securing access to content, is the explicit documented governance objective matching this differentiated access requirement. Giving every employee equal access (B) or publishing without restrictions (C) directly violates the stated security requirement. Reverting to spreadsheets (D) abandons the platform rather than solving the access control need.