Analytics-101

Salesforce Tableau Desktop Foundations (Analytics-101) practice exams

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

Exam at a glance

Analytics-101 practice exam settings
Practice tests 5
Questions in total 215
Questions per test About 45
Time limit per test 70 minutes
Pass mark 65%
Question types Single answer and multiple answer (21 multiple-answer questions)
Level Foundational
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

Analytics-101 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Connecting to and Preparing Data 23% 50
Exploring and Analyzing Data 37% 79
Sharing Insights 25% 53
Understanding Tableau Concepts 15% 33

Sample questions

Question 1 of 3

An extract of an append-only log table is refreshed every night. A full refresh takes hours. New rows always have a higher Log ID than existing rows. Which option reduces refresh time?

  1. A Switch the data source to a live connection and pause auto updates
  2. B Configure an incremental refresh using Log ID as the identifying column (correct answer)
  3. C Hide all unused fields and keep the existing full extract refresh schedule running nightly
  4. D Save the data source as a .tds so the extract refreshes faster
Why: Incremental refresh adds only rows whose identifying column is greater than the highest value already in the extract, which suits append-only data with an increasing key. Live connections avoid refreshes but can be slow and do not meet the extract requirement. Hiding fields helps a little but still rebuilds everything, and a .tds file does not change refresh behaviour.

Question 2 of 3

A workbook relates an Orders table to a Returns table using a relationship (noodle) on Order ID. Many orders have no return. What happens to orders without a return when a view uses only fields from the Orders table?

  1. A They are excluded, because relationships default to an inner join between Orders and Returns
  2. B They are duplicated once for each row in the Returns table
  3. C They are shown as Null for every Orders measure in the view
  4. D They are included, because only tables used by fields in the view are queried (correct answer)
Why: Relationships are context-aware: Tableau builds a query using only the tables whose fields are in the view, so all Orders rows are kept when no Returns fields are used. Relationships do not fix a join type up front, so there is no forced inner join. Rows are not duplicated by unrelated tables, and the Orders measures keep their real values rather than becoming Null.

Question 3 of 3

A view shows SUM(Sales) by Order Date month with a Region filter and a context filter on Category. The analyst also has a Top 5 Sub-Category filter by Sales. Users notice the top 5 list changes when Category changes, but not when Region changes. Why?

  1. A Context filters are applied before Top N filters, while regular dimension filters are applied after them (correct answer)
  2. B Region is a measure filter, which Tableau evaluates after table calculations
  3. C Top N filters are always applied after every other filter in the view, regardless of whether context is set
  4. D Regular dimension filters are applied before context filters, so Region is ignored
Why: In Tableau's order of operations, context filters run before Top N filters, so the top 5 is computed within the chosen Category, while regular dimension filters such as Region are applied after the Top N filter and only remove members from the already-ranked list. Regular dimension filters do not run before context filters, and Top N is not applied after every other filter. Region is a dimension, not a measure, and measure filters run before table calculations, not after them.

What your score report looks like

Example attempt, Analytics-101 practice test 3

78%

Passed
Pass mark 65%

Score by exam domain
DomainWeightYour score%
Connecting to and Preparing Data 23%
88
Exploring and Analyzing Data 37%
81
Sharing Insights 25%
76
Understanding Tableau Concepts 15%
58

Study next: Understanding Tableau Concepts. It is below the pass mark and carries 15% of the exam.

Domains and pass mark from our Analytics-101 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 Exploring and Analyzing Data and Sharing Insights, 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 Analytics-101 practice exams

Are these real Analytics-101 exam questions?
No. We write every question ourselves and map it to the published Analytics-101 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. Analytics-101 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
MSMDIMULESOFT-DEV-I Salesforce MuleSoft Developer I Salesforce Associate 300 120 $12.99
SCBASalesforce Certified Business Analyst Salesforce Associate 300 105 $12.99
SCPABSalesforce Certified Platform App Builder Salesforce Associate 300 105 $12.99
SCTDASalesforce Certified Tableau Data Analyst Salesforce Associate 300 105 $12.99
SJDISalesforce JavaScript Developer I Salesforce Associate 300 105 $12.99
SMCEASalesforce Marketing Cloud Engagement Administrator Salesforce Associate 300 105 $12.99