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

What is Tableau Prep primarily used for?
a. Data visualization
b. Data cleaning and preparation
c. Predictive modeling
d. Video editing
Answer: b. Data cleaning and preparationcyntexa+1
Which two main components make up Tableau Prep?
a. Tableau Predictive Tools and Data Filters
b. Tableau Prep Builder and Tableau Prep Conductor
c. Tableau Desktop and Tableau Server
d. Tableau Charts and Tableau Images
Answer: b. Tableau Prep Builder and Tableau Prep Conductorsanfoundry
What is the function of Tableau Prep Conductor?
a. Visualization of dashboards
b. Scheduling and automating flows
c. Developing machine learning models
d. Connecting to Google Drive
Answer: b. Scheduling and automating flowstableau
Which file types can you output from Tableau Prep?
a. .hyper, .csv, and database tables
b. .doc, .ppt, and .xls
c. .jpg, .png, and .tiff
d. .mp4, .avi, and .mov
Answer: a. .hyper, .csv, and database tablestrailhead.salesforce
What is the primary advantage of Tableau Prep’s graphical interface?
a. Requires no scripting
b. Only works on Linux
c. Needs advanced coding
d. Outputs only PDF files
Answer: a. Requires no scriptingtrailhead.salesforce+1
Which step in Tableau Prep allows you to clean, filter, or transform your data?
a. Output
b. Clean
c. Connect
d. Parameterize
Answer: b. Cleancodecademy+1
What can you do in a Join step within Tableau Prep?
a. Visualize charts
b. Merge multiple data sources
c. Export to video
d. Encrypt files
Answer: b. Merge multiple data sourcescodecademy+1
How does Tableau Prep display the results of data manipulations?
a. On a timeline only
b. Though three coordinated views
c. Via static images only
d. Through code screens
Answer: b. Through three coordinated viewstrailhead.salesforce
Which best describes a Tableau Prep “flow”?
a. Sequence of operations to analyze data
b. Series of steps to prepare data
c. Collection of saved dashboards
d. Automated script
Answer: b. Series of steps to prepare datacyntexa
Why should filters be applied early in a Tableau Prep workflow?
a. Reduce computational load
b. Prevent file corruption
c. Limit options in the dashboard
d. Maximize visual quality
Answer: a. Reduce computational loaddatacamp
Which format is not directly exportable from Tableau Prep?
a. .csv
b. .hyper
c. .pdf
d. Database table
Answer: c. .pdftrailhead.salesforce
What operation allows you to combine datasets stacked vertically?
a. Join
b. Union
c. Pivot
d. Aggregate
Answer: b. Uniontrailhead.salesforce
What is a key feature of the Profile Pane in Tableau Prep?
a. Data visualization in maps
b. Summarization of each field’s values
c. Video playback
d. Image editing
Answer: b. Summarization of each field’s valuestableau
What is the main purpose of the Clean Step?
a. Export data
b. Rename fields, correct values, and filter records
c. Encrypt data
d. Run SQL queries
Answer: b. Rename fields, correct values, and filter recordscodecademy+1
Which action is not supported by Tableau Prep’s Clean Step?
a. Remove punctuation
b. Run regression models
c. Trim spaces
d. Fuzzy-match data
Answer: b. Run regression modelstrailhead.salesforce
What does “pivot” operation do in Tableau Prep?
a. Replaces missing values
b. Converts columns to rows or vice versa
c. Concatenates text fields
d. Sends emails
Answer: b. Converts columns to rows or vice versacyntexa+1
How can you schedule a Tableau Prep flow?
a. Prep Scheduler
b. Tableau Prep Conductor
c. Prep Executor
d. Data Loader
Answer: b. Tableau Prep Conductortableau
Which data role feature in Tableau Prep helps in error detection?
a. Parameterization
b. Assigning data roles
c. Adding sparkle effects
d. Predictive scoring
Answer: b. Assigning data rolescodecademy
What is the benefit of using parameters in Tableau Prep?
a. Static data values only
b. Dynamic control of input and outputs
c. File formatting
d. Sound alerts
Answer: b. Dynamic control of input and outputscodecademy
Which Tableau Prep output is best for Tableau visualization?
a. .pdf file
b. .csv file
c. .hyper file
d. .docx file
Answer: c. .hyper filetrailhead.salesforce
What operation in Tableau Prep can deduplicate data?
a. Join
b. Clean step with removing duplicates
c. Connect step
d. Save as .xls
Answer: b. Clean step with removing duplicatescyntexa
Which step enables you to create calculated fields in Tableau Prep?
a. Output
b. Edit Calculation
c. Aggregate
d. Join
Answer: b. Edit Calculationcodecademy
How does Tableau Prep facilitate collaboration?
a. By sending emails
b. Through shared data sources and published flows
c. Only through screenshots
d. Only with Tableau Public
Answer: b. Through shared data sources and published flowsdatacamp
What is meant by “sampling” in Tableau Prep?
a. Taking photos of data
b. Working with a row subset for faster performance
c. Enlarging the data visualization
d. Encrypting rows
Answer: b. Working with a row subset for faster performancedatacamp
Where can flows created in Tableau Prep be published for sharing and automation?
a. Tableau Server or Tableau Cloud
b. Google Drive
c. YouTube
d. Dropbox
Answer: a. Tableau Server or Tableau Cloudtableau+1
What does the Data Grid in Tableau Prep display?
a. Formulas only
b. Row-level view of the dataset after each step
c. Network diagrams
d. Flowcharts
Answer: b. Row-level view of the dataset after each steptableau
Which view in Tableau Prep allows for spotting anomalies and outliers?
a. Tree Map
b. Mini Map
c. Story Map
d. Heat Map
Answer: b. Mini Maptableau
How does Prep’s smart SQL pushdown feature help performance?
a. Optimizes execution strategies in-database
b. Compresses images
c. Encrypts outputs
d. Creates videos
Answer: a. Optimizes execution strategies in-databasetrailhead.salesforce
What step follows after data preparation in Tableau Prep?
a. Modifying filters
b. Publishing data for analysis
c. Exporting logs only
d. Encrypting dashboards
Answer: b. Publishing data for analysiscyntexa+1
Which statement describes the connection capabilities of Tableau Prep?
a. Can only connect to .csv files
b. Connects to various sources like databases, spreadsheets, and cloud services
c. Only works offline
d. Can only connect to websites
Answer: b. Connects to various sources like databases, spreadsheets, and cloud servicescodecademy+1
Which operation combines data horizontally based on matching values?
a. Union
b. Join
c. Clean
d. Export
Answer: b. Joincodecademy+1
What visual tool in Tableau Prep shows the flow structure and sequence?
a. Flow diagram
b. Gantt chart
c. Bar chart
d. Timeline by default
Answer: a. Flow diagramcyntexa+1
Which smart feature can correct spelling errors in Tableau Prep?
a. AutoJoin
b. Fuzzy-match algorithms
c. DataRoleCheck
d. Typecasting
Answer: b. Fuzzy-match algorithmstrailhead.salesforce
What is a benefit of publishing flows to Tableau Cloud?
a. Increased data discoverability
b. Real-time video analytics
c. Image compression
d. File encryption
Answer: a. Increased data discoverabilitytrailhead.salesforce
A Tableau Prep published data source is most useful for:
a. Standalone dashboards
b. Ad-hoc visualizations in Tableau
c. Publishing books
d. Creating slideshows
Answer: b. Ad-hoc visualizations in Tableautableau+1
Which function is not supported by Tableau Prep?
a. Data blending
b. Creating advanced visualizations
c. Joining different sources
d. Filtering records
Answer: b. Creating advanced visualizationstableau+1
Which component tracks run history and alerts on flow failures?
a. Prep Monitor
b. Prep Conductor
c. Flow Watch
d. Data Guard
Answer: b. Prep Conductortableau
What is essential for understanding data dependencies in Tableau Prep?
a. Knowing data structure and relationships
b. Only looking at the column names
c. Ignoring field types
d. Analyzing at random
Answer: a. Knowing data structure and relationshipstableau
Which of the following is true about Tableau Prep flows?
a. Require programming skills
b. Are built with drag-and-drop steps
c. Only display code logic
d. Only support one data source
Answer: b. Are built with drag-and-drop stepscyntexa+1
Where is data cleaning typically performed in Tableau Prep?
a. Output step
b. Clean step
c. Connect step
d. Export step
Answer: b. Clean stepcyntexa+1
What does Tableau Prep recommend to keep flows manageable and efficient?
a. Plan and simplify the workflow
b. Add all columns always
c. Load entire datasets by default
d. Use minimal annotation
Answer: a. Plan and simplify the workflowdatacamp
Which operation formats values (such as converting lowercase to uppercase) in Tableau Prep?
a. Mapping step
b. Clean step
c. Script step
d. Output step
Answer: b. Clean stepcyntexa
How do you shape data in Tableau Prep for further analysis?
a. Pivot, aggregate, join, or union
b. Export without transformation
c. Encode images
d. Save as video
Answer: a. Pivot, aggregate, join, or unioncodecademy+1
What is highlighted when you click a field in the Profile Pane?
a. Related values across fields
b. File metadata
c. Visual themes
d. Codebase
Answer: a. Related values across fieldstableau
For tracking changes made by others in a workflow, Tableau Prep supports:
a. Versioning and shared flows
b. Only single-user editing
c. Read-only modes
d. Script logs only
Answer: a. Versioning and shared flowsdatacamp
Tableau Prep works best when columns are limited to:
a. 50
b. 30
c. 10
d. 100
Answer: c. 10datacamp
Which step can you use to group similar members in a dimension?
a. Group Step
b. Clean Step
c. Output Step
d. Execute Step
Answer: a. Group Stepinterviewbit
How can run history benefit Tableau Prep users?
a. Allows monitoring and diagnostics
b. Encrypts dashboards
c. Provides more chart options
d. Reduces visualizations
Answer: a. Allows monitoring and diagnosticstableau
When publishing outputs for automation, which Tableau feature is used?
a. Tableau Prep Conductor
b. Tableau Desktop
c. Prep Manager
d. Data Builder
Answer: a. Tableau Prep Conductortableau
What feature makes Tableau Prep especially user-friendly for beginners?
a. Text-based programming
b. Visual, drag-and-drop interface
c. Command-line only
d. Extensive scripting required
Answer: b. Visual, drag-and-drop interfacecyntexa+1

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info