SCTDA

Salesforce Certified Tableau Data Analyst (SCTDA) practice exams

290 questions in 5 timed practice tests. Each test has about 60 questions and a 105-minute limit. The pass mark is 65%. Results are split across the 4 exam domains.

Exam at a glance

SCTDA practice exam settings
Practice tests 5
Questions in total 290
Questions per test About 60
Time limit per test 105 minutes
Pass mark 65%
Question types Single answer and multiple answer (28 multiple-answer questions)
Level Associate
Category Business Platforms

These are the settings of our practice tests. Check the official Salesforce exam page for the current exam format before you book.

Domains and weights

SCTDA exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Connect to and Transform Data 24% 70
Explore and Analyze Data 41% 119
Create Content 26% 75
Publish and Manage Content on Tableau Server and Tableau Cloud 9% 26

Sample questions

Question 1 of 3, choose 2

An extract built from a 400-million-row fact table is slow to refresh. Analysts only ever look at the last 24 months and do not need row-level detail below the day. Which two extract settings reduce the extract size while still supporting this analysis? (Choose two.)

  1. A Add an extract filter on Order Date for the last 24 months (correct answer)
  2. B Switch the connection from Extract to Live so Tableau stores no rows locally
  3. C Hide all unused fields only after the extract has already been created
  4. D Add a context filter on Order Date to the worksheets that use the extract
  5. E Enable Aggregate data for visible dimensions with dates rolled up to Day (correct answer)
Why: An extract filter limits which rows are written into the extract, and aggregating for visible dimensions with dates rolled to Day stores pre-summarised rows, so both shrink the extract. A context filter acts at query time in a worksheet and does not change what is stored in the extract. Switching to Live removes the extract instead of optimising it, and hiding fields only reduces size if done before the extract is created or followed by a full re-creation, so doing it afterward on its own does not help.

Question 2 of 3

An analyst connects to an Orders table and a Returns table in Tableau Desktop. Not every order has a return, and the analyst wants Tableau to choose the join type automatically per visualization without duplicating order-level measures. What should the analyst do in the Data Source page?

  1. A Create a full outer join between the two tables on Order ID in the physical layer
  2. B Add Returns to the logical layer canvas and relate it to Orders on Order ID (correct answer)
  3. C Add Returns as a separate data source and blend it as the secondary source linked on Order ID
  4. D Open Orders in the physical layer and create a left join to Returns on Order ID
Why: A relationship in the logical layer lets Tableau build the right join per viz at query time and keeps each table at its native level of detail, so Orders measures are not duplicated. A left or full outer join in the physical layer fixes one join type for every sheet and can repeat order rows when there are several returns. Blending also works across sources but is a per-sheet, aggregated technique and is not needed when both tables are in one connection.

Question 3 of 3

An analyst writes the calculation [Profit] / [Sales] and drags it to a view by Region. The ratio values look much too large. Which calculation returns the correct profit ratio per region?

  1. A ATTR([Profit]) / ATTR([Sales])
  2. B SUM([Profit]) / SUM([Sales]) (correct answer)
  3. C SUM([Profit] / [Sales])
  4. D [Profit] / SUM([Sales])
Why: Aggregating numerator and denominator separately, SUM(Profit)/SUM(Sales), computes the ratio at the level of the view. A row-level ratio that is then summed adds up thousands of individual ratios, which explains the inflated numbers. ATTR returns a value only when every row shares it, so across many orders it returns an asterisk instead of a ratio, and mixing a row-level field with an aggregate in one expression is not allowed and returns an error.

What your score report looks like

Example attempt, SCTDA practice test 3

79%

Passed
Pass mark 65%

Score by exam domain
DomainWeightYour score%
Connect to and Transform Data 24%
88
Explore and Analyze Data 41%
81
Create Content 26%
76
Publish and Manage Content on Tableau Server and Tableau Cloud 9%
58

Study next: Publish and Manage Content on Tableau Server and Tableau Cloud. It is below the pass mark and carries 9% of the exam.

Domains and pass mark from our SCTDA practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Explore and Analyze Data and Create Content, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the SCTDA practice exams

Are these real SCTDA exam questions?
No. We write every question ourselves and map it to the published SCTDA exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Salesforce. SCTDA and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
PDIIPDII Salesforce Platform Developer II Salesforce Professional 300 120 $14.99
SAASalesforce Advanced Administrator Salesforce Professional 300 105 $14.99
SASCSalesforce Agentforce Sales Consultant Salesforce Professional 300 105 $14.99
SASCSalesforce Agentforce Service Consultant Salesforce Professional 300 105 $14.99
SCDCSalesforce Certified Data 360 Consultant Salesforce Professional 300 105 $14.99
SDASalesforce Data Architect Salesforce Professional 300 105 $14.99