MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

Overall MCQs for Reference

1. Which filter is applied first in Tableau’s data pipeline?
   a. Context filter
   b. Data source filter
   c. Extract filter
   d. Measure filter
   Answer: c. Extract filtergyansetu+1​
2. What is the primary purpose of an extract filter in Tableau?
   a. To sort data
   b. To filter a snapshot of data
   c. To format views
   d. To refresh live connections
   Answer: b. To filter a snapshot of datathedataschool+1​
3. When are extract filters applied when creating a Tableau extract?
   a. Before importing fields
   b. After visualization
   c. During extract creation
   d. After data blending
   Answer: c. During extract creationscribd+1​
4. What happens if you add an extract filter during the extract process?
   a. Only filtered data is extracted
   b. The entire data source is extracted
   c. Filters can be toggled only in dashboard
   d. No effect
   Answer: a. Only filtered data is extractedtableau+1​
5. How does an extract filter affect query performance?
   a. Slows down query
   b. No effect
   c. Improves query performance
   d. Converts to live connection
   Answer: c. Improves query performanceshiksha+1​
6. Extract filters are used with which Tableau connection type?
   a. Live
   b. Published
   c. Joined
   d. Extract
   Answer: d. Extracttableau+1​
7. Where can you add an extract filter in Tableau?
   a. Data source tab
   b. Worksheet tab
   c. Story tab
   d. Format tab
   Answer: a. Data source tabthedataschool+1​
8. Which field types can be used as extract filters?
   a. Only numeric
   b. Any field
   c. Only dates
   d. Only strings
   Answer: b. Any fieldscribd+1​
9. After applying extract filters, what is stored on disk?
   a. An empty file
   b. Only filtered data subset
   c. All raw data
   d. Data summary
   Answer: b. Only filtered data subsettableau+1​
10. Extract filters help to:
    a. Automate reports
    b. Reduce extract file size
    c. Beautify dashboards
    d. Duplicate data
    Answer: b. Reduce extract file sizedata.ucsf+1​
11. What is NOT a benefit of extract filters?
    a. Faster refresh
    b. Smaller extracts
    c. Unlimited dashboard export
    d. Improved performance
    Answer: c. Unlimited dashboard exportscribd+1​
12. Can extract filters be edited after extract creation?
    a. Yes, by recreating the extract
    b. No, never
    c. Yes, by using edit on worksheet
    d. Only in Tableau Public
    Answer: a. Yes, by recreating the extracttableau+1​
13. You need to extract only UK customer data. What should you use?
    a. Data blending
    b. Extract filter
    c. Context filter
    d. Page shelf
    Answer: b. Extract filtershiksha+1​
14. Extract filters operate at which level?
    a. Worksheet
    b. Data source
    c. Dashboard
    d. Story
    Answer: b. Data sourcetableau+1​
15. The “Top N rows” option in extract creation is an example of:
    a. Sampling filter
    b. Dimension filter
    c. Visualization filter
    d. Action filter
    Answer: a. Sampling filterdata.ucsf+1​
16. Can you use multiple extract filters in Tableau?
    a. Yes
    b. No
    c. Only one
    d. Only if using cloud data
    Answer: a. Yesscribd+1​
17. What is a possible result if extract filters are not used?
    a. Larger extract file
    b. Data aggregation
    c. Hidden fields
    d. Real-time data
    Answer: a. Larger extract fileshiksha+1​
18. Extract filters are especially useful when:
    a. Working with very small datasets
    b. Visualizing historical trends
    c. Large and complex datasets
    d. Building story points
    Answer: c. Large and complex datasetsthedataschool+1​
19. What happens if you hide unused fields before creating an extract?
    a. All fields are included
    b. Only fields in use are kept
    c. Live data remains
    d. Extract fails
    Answer: b. Only fields in use are keptdata.ucsf+1​
20. Which of the following supports extract filtering during connection?
    a. Excel only
    b. All supported data sources
    c. Only databases
    d. CSV only
    Answer: b. All supported data sourcestableau+1​
21. To apply a filter that reduces extract size, you:
    a. Add calculated field
    b. Use extract filter
    c. Apply measure filter after visualization
    d. Export as PDF
    Answer: b. Use extract filterscribd+1​
22. To include data of only “last 3 months” in extract, use:
    a. Date filter as extract filter
    b. Parameter
    c. Context filter
    d. Top N filter
    Answer: a. Date filter as extract filterthedataschool+1​
23. What effect does changing extract filter criteria have?
    a. Instant effect
    b. No change until new extract is created
    c. Deletes the worksheet
    d. Publishes dashboard
    Answer: b. No change until new extract is createdtableau+1​
24. Where are extract filters managed?
    a. On Tableau Server
    b. Extract Data window
    c. Worksheet toolbar
    d. Dashboard title
    Answer: b. Extract Data windowshiksha+1​
25. Can extracts be scheduled to reflect updated extract filter conditions?
    a. Yes, with automatic refresh
    b. No, only manual
    c. Only via email
    d. Not possible
    Answer: a. Yes, with automatic refreshtableau+1​
26. If you want to filter data at the earliest stage, use:
    a. Data source filter
    b. Extract filter
    c. Sheet filter
    d. Context filter
    Answer: b. Extract filterthedataschool+1​
27. Once an extract filter is set and extract is made, Tableau:
    a. Connects live to the data source
    b. Works with the filtered data in-memory
    c. Removes all filters
    d. Reverts to unfiltered
    Answer: b. Works with the filtered data in-memorytableau+1​
28. An extract filter works independently of:
    a. Data source filter
    b. Context filter
    c. Both
    d. None
    Answer: b. Context filterscribd+1​
29. The correct method to apply extract filtering to multiple fields is by:
    a. Using “Add” for each field during extract setup
    b. Applying to one field only
    c. Editing after saving
    d. Using groups
    Answer: a. Using “Add” for each field during extract setupshiksha+1​
30. Which sequence does Tableau’s order of filter operations follow?
    a. Extract > Data source > Context > Dimension
    b. Data source > Extract > Dimension > Context
    c. Context > Extract > Data source
    d. Dimension > Extract > Context > Data source
    Answer: a. Extract > Data source > Context > Dimensionsimplilearn+1​
31. To filter multiple segments at extract creation, use:
    a. “Add” for each segment in Extract Filter dialog
    b. Multiple parameters
    c. Group filter in worksheet
    d. Action filter
    Answer: a. “Add” for each segment in Extract Filter dialogthedataschool+1​
32. Hiding unused fields before extraction results in:
    a. More data in extract
    b. Only visible fields in extract
    c. Slower performance
    d. Creates live connection
    Answer: b. Only visible fields in extractdata.ucsf+1​
33. The main use case of extract filters is to:
    a. Subset data during extraction
    b. Filter worksheets
    c. Change workbook theme
    d. Duplicate dashboards
    Answer: a. Subset data during extractionshiksha+1​
34. Are extract filters mandatory when creating Tableau extracts?
    a. No
    b. Yes, always
    c. Mandatory only for cloud data
    d. Mandatory for all sources
    Answer: a. Notableau+1​
35. Which file format stores Tableau extracts?
    a. .csv
    b. .hyper
    c. .xlsx
    d. .pdf
    Answer: b. .hypercedar.princeton+1​
36. Can you change the extract filter field after extract creation?
    a. Only with a new extract
    b. Always editable
    c. Never
    d. Only for dimensions
    Answer: a. Only with a new extracttableau+1​
37. What happens if you change source data after creating an extract with filters?
    a. Extract remains until refreshed
    b. Extract updates automatically
    c. All filters are removed
    d. Data source is lost
    Answer: a. Extract remains until refreshedtableau+1​
38. When working with sensitive data, extract filters can:
    a. Restrict sensitive data from being extracted
    b. Encrypt extracts
    c. Hide dashboards
    d. Delete users
    Answer: a. Restrict sensitive data from being extractedthedataschool+1​
39. Extract filters are especially suited for which environment?
    a. Large datasets stored on cloud
    b. Local small datasets
    c. Only on Tableau Reader
    d. Only in Tableau Prep
    Answer: a. Large datasets stored on cloudtableau+1​
40. After applying extract filters and finishing extraction, you:
    a. Can only analyze filtered subset
    b. Can go back to full dataset anytime
    c. Need to fetch live data for all queries
    d. Lose the original data source
    Answer: a. Can only analyze filtered subsettableau+1​
41. The main distinction between data source and extract filters is:
    a. Timing of application in the pipeline
    b. Applied only to numeric fields
    c. Extract filters cannot work on string fields
    d. Data source filters must be global
    Answer: a. Timing of application in the pipelinetableau+1​
42. To include only categories “A”, “B”, and “C” in an extract, do:
    a. Multi-select in extract filter dialog
    b. Parameter on worksheet
    c. Manual SQL query
    d. Export to Excel
    Answer: a. Multi-select in extract filter dialogscribd+1​
43. What type of filter limits data before even a worksheet is created?
    a. Extract filter
    b. Measure filter
    c. Parameter
    d. Action filter
    Answer: a. Extract filtertableau+1​
44. Extract filters primarily affect:
    a. The extract stored on disk
    b. Visualization color schemes
    c. Story point annotations
    d. Dashboard layout
    Answer: a. The extract stored on diskshiksha+1​
45. Best practice before finalizing an extract with filters:
    a. Review fields and filter choices
    b. Add dashboard actions
    c. Reformat captions
    d. None needed
    Answer: a. Review fields and filter choicesdata.ucsf+1​
46. Can extracts support incremental refresh with extract filters?
    a. Yes
    b. No
    c. Only for numeric data
    d. Only in Tableau Online
    Answer: a. Yestableau+1​
47. Removing extract filters and re-extracting will:
    a. Include more data in new extract
    b. Remove all fields
    c. Break all dashboards
    d. Delete calculated fields
    Answer: a. Include more data in new extractthedataschool+1​
48. To optimize extract speed, what should you consider?
    a. Use efficient extract filters
    b. Always use live connection
    c. Disable sampling
    d. Duplicate extracts
    Answer: a. Use efficient extract filtersdata.ucsf+1​
49. A new extract will NOT apply changes in extract filters unless:
    a. Extract is rebuilt
    b. Worksheet is duplicated
    c. Dashboard is published
    d. Fields are conditionally formatted
    Answer: a. Extract is rebuilttableau+1​
50. Key advantage of using extract filters in regulated industries is:
    a. Compliance with data minimization
    b. Enhanced dashboard coloring
    c. Unlimited worksheet creation
    d. Offline dashboard use
    Answer: a. Compliance with data minimizationshiksha+1​

1. https://www.gyansetu.in/blog/75-tableau-mcq-quiz-questions-with-answers-interview/
2. https://www.thedataschool.co.uk/nitesh-shrestha/tableau-filters/
3. https://www.shiksha.com/online-courses/articles/extract-and-data-source-filter-in-tableau/
4. https://www.scribd.com/document/487346185/Tableau-Filters-33
5. https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm
6. https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm
7. https://www.scribd.com/document/716391073/Lesson-09-Filter-and-Analytics-in-Tableau
8. https://www.tableau.com/blog/understanding-tableau-data-extracts
9. https://data.ucsf.edu/ssa/step-7.2-best-practices-building-tableau-extracts
10. https://www.simplilearn.com/tableau-interview-questions-and-answers-article
11. https://cedar.princeton.edu/sites/g/files/toruqf1076/files/media/introduction_to_tableau_training_0.pdf
12. https://www.sanfoundry.com/tableau-mcq-multiple-choice-questions/
13. https://www.scribd.com/document/866492236/Tableau-MCQs-by-Topic-TCS-Wings1
14. https://www.tutorialspoint.com/tableau/quiz_on_tableau_condition_filters.htm
15. https://www.studocu.com/in/document/anna-university/data-visualization/mcq1-tableau-mcq/43072461
16. https://analyticstraininghub.com/tableau-mcq-assessments/
17. https://www.youtube.com/watch?v=aT02XijlfdI
18. https://www.scribd.com/document/854657870/Tableau-MCQ-Questions-and-Answer-PDF
19. https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
20. https://community.tableau.com/s/question/0D54T00000C5fjVSAR/how-do-data-source-filters-affect-extracts