To make your preparation easier for the Salesforce Analytics-Con-301 exam, we strongly recommend you to use our Premium Salesforce Tableau Consultant Certification Practice Exam. According to our survey with certified candidates, you can easily score more than 85% in your actual Salesforce Certified Tableau Consultant exam if you score 100% in our premium certification practice exams.
01. A bank's data team builds a new risk-reporting data model based only on today's regulatory reporting requirements, without discussing with compliance stakeholders whether those requirements are expected to change. Six months after delivery, a new regulatory rule requires an additional exposure metric broken out by a dimension (counterparty legal-entity type) that was never captured anywhere in the delivered model.
What does this outcome most directly illustrate about the current/future-state mapping step in discovery?
a) The compliance stakeholders should have been left out of the discovery sessions, since their requirements kept changing
b) Failing to discuss anticipated future requirements left the model unable to absorb a foreseeable regulatory change
c) Regulatory requirements are generally too unpredictable for any discovery process to meaningfully plan for in advance
d) The model's fact-table grain, rather than its current/future-state scope, was the true underlying cause of this gap
02. A hospital operations team is deciding whether to certify a bed-occupancy data source used by several published dashboards.
Which two statements correctly describe what certifying this data source will and will not do?
(Choose two.)
a) It will flag the data source in the catalog as the vetted, trustworthy version for bed-occupancy reporting.
b) It will trigger a full extract refresh on a fixed nightly schedule as part of certifying it.
c) It will move the data source into a locked project as part of the certification process.
d) It will not, by itself, change which projects or users are permitted to connect to or edit the data source.
e) It will prevent the data source from being embedded in any new workbook without administrator approval.
03. A subscription-SaaS analyst wants to show, for each month, the cumulative percentage of the year's total revenue reached by each plan tier through that month — i.e., a running accumulation of each tier's monthly share of total revenue.
Which approach correctly produces this cumulative-percentage view?
a) Apply only a Percent of Total calculation to the view, without any additional nesting step.
b) Apply a FIXED [Month] LOD expression that is partitioned by plan tier across the year.
c) Nest a running total (such as RUNNING_SUM) around a Percent of Total calculation, both addressed along Month.
d) Replace both calculations with a single EXCLUDE [Month] LOD expression instead of using any table calculation nesting.
04. A manufacturing quality dataset stores one row per production batch, with a separate column for each of six test stations (Station1 through Station6) holding that station's pass/fail reading. An analyst wants to build a view that shows results by station as a dimension, so a single "Station" field and a single "Reading" field are needed instead of six separate columns.
Which transformation should the analyst apply to reshape the data this way?
a) A join between the batch table and itself, matching each row to its six station values.
b) A pivot, to convert the six station columns into two fields — a Station name field and a Reading value field.
c) A union, to stack the six separate station columns together into one long, combined table.
d) A relationship, so that each of the six station columns is treated as its own separate native grain during analysis.
05. A bank's risk-reporting team is designing row-level security so that each regional risk officer sees only exposures booked to their own region. The data source will be reused across dozens of workbooks built by different teams over the next two years, and the mapping of officers to regions changes periodically as staff rotate.
Which RLS design best satisfies both the reuse requirement and the need to update officer-region mappings without editing every workbook?
a) Build a workbook-level user filter in the first workbook created, and instruct future workbook authors to copy that same filter into their own workbooks.
b) Hardcode each officer's region as a separate calculated field per officer, added directly into each new workbook as it's built.
c) Ask each individual risk officer to manually apply the correct regional filter every single time they open a workbook.
d) Maintain an entitlements table mapping officers to regions, joined into the published data source and filtered by a user function.
06. A nonprofit's donor-development office is choosing between a subscription and a data-driven alert to notify the development team about a "Major Gift Pipeline" workbook.
Which two statements correctly distinguish a data-driven alert from a subscription for this workbook?
(Choose two.)
a) An alert emails every member of the project by default, while a subscription emails only the specific user who originally created it.
b) A subscription can only ever be configured by a site administrator, while an alert can be configured by any user who merely has view access.
c) An alert fires only when the value crosses a defined threshold, while a subscription delivers on a fixed schedule regardless of the value.
d) A subscription requires the underlying workbook to be formally certified first by the governance team, while an alert carries no such certification requirement at all.
e) An alert is tied to a specific mark or measure meeting a condition, while a subscription just captures and sends a view's current state.
07. A consumer-electronics retail chain shows quarterly revenue by product category: Category A = $40,000, Category B = $35,000, Category C = $25,000, for a total of $100,000. A Percent of Total table calculation is applied across the three categories.
What value does Percent of Total display for Category B?
a) 35%, Category B's share of the $100,000 total.
b) 33.3%, an equal one-third split across the three categories.
c) 40%, matching Category A's share.
d) 60%, the combined share of Category A and Category B together.
08. A logistics KPI workbook reports "Total Shipments" by connecting a Shipments table to a Carrier Events table using a join on shipment ID, because analysts also wanted carrier event details visible in the same view. Each shipment has multiple carrier events (pickup, in-transit, delivered), and after building the workbook, the Total Shipments count on the summary dashboard is far higher than the count in the source system.
What is the most likely cause of the inflated shipment count?
a) The workbook is using a live connection instead of an extract, so Tableau recalculates the shipment count on every interaction and displays a running total.
b) The join was defined on the wrong field, so no rows are actually matching and Tableau is falling back to a full cross join of both tables.
c) The Carrier Events table uses a different date format than the Shipments table, causing Tableau to double-count rows that fail to parse.
d) The join's cardinality is one-to-many from Shipments to Carrier Events, so each shipment row is duplicated once per matching carrier event.
09. A retail sales workbook consultant runs Performance Recorder against a dashboard that recently started loading slowly, then reviews the output with the store operations team.
Which two statements correctly describe what the Performance Recorder output shows?
(Choose two.)
a) A recommended fix that Tableau applies to the workbook on the team's behalf for whichever event took the longest.
b) A timeline of individual events in the session — queries, layout computation, geocoding — each with its own duration.
c) A cumulative log of every viewer's session against the dashboard, retained without any option to clear it.
d) The exact SQL text and full execution plan sent to the underlying database for every single query event recorded in that session.
e) A ranked view of events by duration, making it possible to see which specific event consumed the most time in that session.
10. A university enrollment-analytics workbook needs to show advisors data only for the academic programs their advising group is responsible for, based on Tableau Server group membership rather than an individual username.
Which function is best suited to checking group membership in the row-level security calculation?
a) ISMEMBEROF(), because it evaluates whether the current viewer belongs to a specified group.
b) USERDOMAIN(), because it returns which specific advising group a user was originally assigned to at the time of hire.
c) A parameter control, because it lets the advisor select their own advising group from a list.
d) USERNAME(), because it returns the current viewer's group membership list.
Equip yourself with the best resources and practice exams to ace your Salesforce Certified Tableau Consultant exam. Explore our comprehensive study materials and take the first step towards certification success.