exam questions

Exam TDA-C01 All Questions

View all questions & answers for the TDA-C01 exam

Exam TDA-C01 topic 1 question 138 discussion

Actual exam question from Tableau's TDA-C01
Question #: 138
Topic #: 1
[All TDA-C01 Questions]

A Data Analyst has a data source with row data for service calls and their activity log.



Which calculation allows the analyst to count the calls that have never had a technician assigned to them?

  • A. SUM( {INCLUDE [Activity Name]: COUNT(IF [Activity Name] <> 'Assign Technician’ THEN 1 END) } )
  • B. COUNTD( IF {INCLUDE [Activity Name]: NOT ’Assign Technician' } THEN [Call ID] END )
  • C. SUN( {FIXED [Call ID]: IF MAX( [Activity Name] = 'Assign Technician') THEN 0 ELSE 1 END } )
  • D. COUNT( {FIXED [Call ID]: IF [Activity Name] <> ’Assign Technician' THEN 1 ELSE 0 END } )
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
AmieM
2 months ago
Selected Answer: C
A is incorrect as it doesn't actually filter what we need, plus the logic inside is flawed. C is correct. MAX is used to determine if the 'Assign Technician' appeared in any instance for that Call ID.
upvoted 1 times
...
d98a23f
6 months, 3 weeks ago
Selected Answer: A
certainly not C
upvoted 3 times
...
Lakshmi2023
9 months, 4 weeks ago
Selected Answer: A
A is the right answer
upvoted 2 times
2ec454a
3 months, 4 weeks ago
Why A? it seems to sum up twice for every call Id for Open call and Close call
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...