I85PREP
⌘ K
Alteryx Designer Cloud Core study materials
Alteryx Designer Cloud Core study resources

Alteryx Designer Cloud Core practice questions

One question at a time. Build your Alteryx Designer Cloud Core understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Data Connectivity and Input/Output

In Designer Cloud, which input connector is designed to read a delimited text file stored in a cloud object store such as Amazon S3?

  1. Text Input tool
  2. Directory tool
  3. File Input with an S3 connection Correct answer.
  4. JSON Parse tool

Explanation

Cloud object stores are reached through a configured connection attached to a File Input tool, which handles remote paths and credentials. The other tools either type data manually, list files, or transform already-loaded data.

Question 2Data Connectivity and Input/Output

A workflow must combine two inputs that have identical field names and compatible data types. Which tool stacks the records from both inputs into a single stream?

  1. Append Fields
  2. Union Correct answer.
  3. Summarize
  4. Join

Explanation

Union concatenates rows from multiple inputs, aligning fields by name or by position depending on configuration. Join matches records on keys, Append adds columns, and Summarize aggregates.

Question 3Data Connectivity and Input/Output

Which file format stores data as a schema-embedded, columnar file that is commonly used for large analytic datasets in cloud storage?

  1. CSV
  2. Parquet Correct answer.
  3. XML
  4. YAML

Explanation

Parquet is a columnar format that carries its own schema and compresses well, making it common for analytic workloads. CSV is row-oriented text without enforced schema, and XML and YAML are markup-style text formats.

Question 4Data Connectivity and Input/Output

An analyst needs to read every CSV file inside a cloud folder and process them as one dataset. Which approach accomplishes this with a single input?

  1. Use the Text Input tool with the folder name
  2. Create one File Input tool per file and join them
  3. Use a wildcard or folder path in the File Input tool Correct answer.
  4. Use the Directory tool alone

Explanation

File Input supports wildcard and folder-based paths so multiple matching files are read and combined in one step. Manually adding tools per file is brittle and does not scale, and the other tools do not read file contents.

Question 5Data Connectivity and Input/Output

Which output option writes results back to a cloud data warehouse table for downstream reporting?

  1. Output Data through a configured warehouse connection Correct answer.
  2. Output Data to a local file path
  3. Browse tool
  4. Text Input tool

Explanation

Writing to a warehouse requires an Output Data tool configured with a warehouse connection and target table. Local file output stays on the machine, and Browse and Text Input are not output destinations.

Question 6Data Connectivity and Input/Output

When reading a CSV where the first row contains column headers, which File Input setting ensures those values become field names instead of data?

  1. Set the delimiter to a comma
  2. Enable the first row as headers option Correct answer.
  3. Enable the skip empty lines option
  4. Set the field type to String

Explanation

The header option tells the parser to treat the first row as field names. Delimiter selection only separates values, and type and empty-line settings do not affect header handling.

Question 7Data Connectivity and Input/Output

Which connection type is required before a workflow can read from or write to a cloud data warehouse?

  1. A CSV staging file
  2. A scheduled workflow
  3. A local ODBC driver installed per user
  4. A saved connection with stored credentials Correct answer.

Explanation

Warehouse access in Designer Cloud is mediated by a saved connection that holds the endpoint and credentials. Local drivers, staging files, and schedules are not substitutes for a configured connection.

Question 8Data Connectivity and Input/Output

What does the Output Data tool do when configured to overwrite an existing table?

  1. Creates a view instead of a table
  2. Replaces the table contents with the new results Correct answer.
  3. Writes only the schema
  4. Appends new rows to the existing table

Explanation

Overwrite mode drops or truncates the target and writes the new result set. Append mode adds rows, and creating a view or schema-only output are separate behaviors.

Question 9Data Connectivity and Input/Output

A source file uses a semicolon as its field separator. What must be configured on the input so fields parse correctly?

  1. Set the delimiter to semicolon Correct answer.
  2. Enable the header option
  3. Set the encoding to UTF-8
  4. Change the field type to V_String

Explanation

The delimiter setting tells the parser which character separates values. Field type, header handling, and encoding affect other aspects of parsing but not value splitting.

Question 10Data Connectivity and Input/Output

Which tool would you use to read a JSON document and convert its nested objects into tabular fields?

  1. JSON Parse Correct answer.
  2. Select
  3. Sample
  4. Filter

Explanation

JSON Parse flattens JSON structures into fields usable downstream. Select manages columns, Filter splits rows by condition, and Sample limits row counts.

Question 11Data Connectivity and Input/Output

An analyst wants to preview the first 100 records from an input to verify parsing before building the rest of the workflow. Which approach is most appropriate?

  1. Delete the input and re-add it
  2. Add a Browse tool after the input Correct answer.
  3. Add an Output Data tool after the input
  4. Add a Summarize tool after the input

Explanation

Browse displays records so parsing can be validated without persisting anything. Summarize aggregates, Output writes data, and re-adding the input does not preview records.

Question 12Data Connectivity and Input/Output

A workflow reads a file where numeric values arrive with thousands separators and currency symbols. Which step best prepares those values for arithmetic?

  1. Union the field with a numeric field
  2. Sort the field ascending
  3. Clean the characters, then convert the field to a numeric type Correct answer.
  4. Change the field to a numeric type directly

Explanation

Type conversion fails when non-numeric characters remain, so those characters must be removed first. Union and Sort do not alter the underlying values.

Question 13Data Connectivity and Input/Output

Which scenario requires the Append Fields tool rather than a Join?

  1. Matching customer records on an ID
  2. Filtering records by region
  3. Stacking monthly files into one stream
  4. Adding a single company name column to every record Correct answer.

Explanation

Append Fields adds columns from one input to every row of another without a key, which suits broadcasting a constant value. Join needs matching keys, Union stacks rows, and Filter removes rows.

Question 14Data Connectivity and Input/Output

What is the effect of selecting a specific sheet when configuring an Excel file input?

  1. The sheet is renamed
  2. Only that worksheet's data is read Correct answer.
  3. All sheets are merged automatically
  4. The file is converted to CSV

Explanation

Excel inputs target a chosen worksheet, so only that sheet's cells are read. Merging sheets, renaming, and format conversion are not implied by sheet selection.

Question 15Data Connectivity and Input/Output

A dataset contains a date field stored as text in a nonstandard format. What is the recommended sequence to make it usable for date calculations?

  1. Convert to DateTime, then format as text
  2. Parse the text into a date type, then use date functions Correct answer.
  3. Sort the field, then convert to numeric
  4. Union it with a date field

Explanation

Date calculations require an actual date type, so text must be parsed into one first. Formatting back to text, sorting, or unioning does not produce a usable date type.

Question 16Data Connectivity and Input/Output

Which consideration is most important when reading a very large cloud file into Designer Cloud?

  1. Selecting only needed columns and filtering early Correct answer.
  2. Renaming every field
  3. Converting all fields to text
  4. Adding a Browse tool after each tool

Explanation

Reducing columns and rows early limits data movement and processing cost. Renaming, extra Browse tools, and converting everything to text add overhead without improving efficiency.

Question 17Data Connectivity and Input/Output

What does the Directory tool return when pointed at a folder?

  1. A connection string
  2. A list of files with metadata such as name and path Correct answer.
  3. The parsed contents of each file
  4. A single merged dataset

Explanation

Directory enumerates files and their metadata, which can then feed a dynamic input. It does not parse file contents, merge data, or produce connection strings.

Question 18Data Connectivity and Input/Output

A workflow must read files whose names change daily. Which technique adapts the input path without manual edits?

  1. Convert the input to a macro
  2. Add a Filter before the input
  3. Use a dynamic path built from a field or wildcard Correct answer.
  4. Hard-code the full path

Explanation

Dynamic paths or wildcards let the input resolve to whatever file matches at run time. Hard-coding breaks when names change, and Filter and macros do not resolve file paths.

Question 19Data Connectivity and Input/Output

Which output setting is appropriate when new rows must be added to an existing warehouse table without removing prior records?

  1. Overwrite
  2. Create new table
  3. Truncate
  4. Append Correct answer.

Explanation

Append mode inserts new rows while preserving existing data. Overwrite and truncate remove prior records, and creating a new table does not target the existing one.

Question 20Data Connectivity and Input/Output

An input returns nulls for a numeric field even though the source values look like numbers. Which cause is most likely?

  1. The encoding is UTF-8
  2. The field type is set to numeric but values contain non-numeric characters Correct answer.
  3. The delimiter is a comma
  4. The header option is enabled

Explanation

Type conversion yields nulls when characters such as commas or symbols remain in the values. Delimiter, header, and encoding settings do not by themselves cause numeric conversion failures.

Question 21Data Connectivity and Input/Output

A workflow must join two large cloud datasets, but only a small subset of columns is needed downstream. Which approach best reduces processing cost?

  1. Select needed columns before the join, then join Correct answer.
  2. Sort both datasets, then join
  3. Join first, then select columns
  4. Union the datasets, then join

Explanation

Pruning columns before the join reduces the data shuffled and processed during the join. Joining first carries unnecessary columns through, and Union or Sort do not reduce column volume.

Question 22Data Connectivity and Input/Output

When configuring a cloud connection for a warehouse, which practice best supports secure and repeatable access?

  1. Disabling authentication for speed
  2. Embedding credentials in each workflow
  3. Storing credentials in a saved connection Correct answer.
  4. Sharing a single personal login across the team

Explanation

Saved connections centralize and secure credentials so workflows reuse them without exposing secrets. Embedding credentials, sharing personal logins, and disabling authentication all weaken security and repeatability.

Question 23Data Connectivity and Input/Output

A JSON input contains an array of nested objects that must become individual rows. Which approach is most appropriate?

  1. Convert the whole document to a single string
  2. Union the JSON with a CSV
  3. Filter out the array field
  4. Parse the JSON and split the array into rows Correct answer.

Explanation

Parsing JSON and splitting array elements produces one row per element, which is needed for tabular analysis. Union, Filter, and string conversion do not expand nested arrays into rows.

Question 24Data Connectivity and Input/Output

A daily workflow reads a folder where some files arrive late. Which design keeps the workflow correct without reprocessing files already loaded?

  1. Track processed file names and read only new ones Correct answer.
  2. Read a single hard-coded file
  3. Read all files each run and overwrite the target
  4. Delete the folder after each run

Explanation

Tracking processed files lets the workflow ingest only new arrivals, avoiding duplicate loads. Overwriting loses history, deleting the folder is destructive, and a hard-coded file ignores new data.

Question 25Data Connectivity and Input/Output

Which combination correctly describes reading a compressed cloud file and writing results to a warehouse?

  1. Text Input, then Browse
  2. JSON Parse, then Sample
  3. File Input with the compressed file, then Output Data to a warehouse connection Correct answer.
  4. Directory tool, then Filter

Explanation

A compressed cloud file is read through File Input, and results are written to the warehouse through Output Data with a connection. The other combinations neither ingest the file nor persist to the warehouse.

Question 26Data Connectivity and Input/Output

Which component in Designer Cloud stores the credentials and endpoint details needed to read from a cloud data source?

  1. A workflow variable
  2. An output template
  3. A field schema
  4. A saved connection Correct answer.

Explanation

Connections bundle authentication and endpoint information so tools can reference the source without re-entering credentials. Workflows then select a connection when configuring an input.

Question 27Data Connectivity and Input/Output

What is the primary purpose of the Output Data tool when writing results to a cloud file location?

  1. To persist the final workflow results to a chosen destination Correct answer.
  2. To cache intermediate data between tools
  3. To validate field types before processing
  4. To preview sample records during development

Explanation

The Output Data tool writes the incoming stream to a configured destination such as a cloud file or table. It is the terminal step that materializes results outside the workflow.

Question 28Data Connectivity and Input/Output

An analyst must combine two inputs side by side so that every row from the first input appears once, matched positionally with rows from the second input. Which tool fits this requirement?

  1. Union
  2. Join
  3. Append Fields Correct answer.
  4. Fuzzy Match

Explanation

Append Fields places fields from one input alongside records of another without requiring a key, producing a positional side-by-side combination. Key-based matching is handled by Join, and stacking of rows is handled by Union.

Question 29Data Connectivity and Input/Output

A workflow reads a cloud file whose schema occasionally gains new columns. Which input configuration best keeps the workflow resilient to those additions?

  1. Convert all incoming fields to string before parsing
  2. Hard-code the expected column list and reject any file that differs
  3. Reduce the input to the first ten columns by position
  4. Allow the input to resolve fields dynamically rather than locking a fixed field list Correct answer.

Explanation

Dynamic field resolution lets the input adapt when the source schema changes, so new columns do not break parsing. A locked field list fails as soon as the file's columns differ from expectations.

Question 30Data Connectivity and Input/Output

A workflow must read a cloud file that is delivered as a compressed archive containing several member files, then write the combined result to a warehouse table. Which sequence is correct?

  1. Write the compressed archive directly to the warehouse and decompress it with a downstream query
  2. Configure the input to read the compressed source, combine the parsed records, then write to the warehouse via an output connection Correct answer.
  3. Decompress the archive manually, load each member into separate tables, then join the tables in the warehouse
  4. Read only the first member file, write it to the warehouse, and rely on scheduled reruns to cover the rest

Explanation

The input can be configured to read compressed sources and parse their member files into a single stream, which is then written through a warehouse output connection. This keeps extraction and loading inside the workflow.

Question 31Data Preparation and Cleansing

In Alteryx Designer Cloud, which tool is used to split a single column containing delimited values into multiple separate columns?

  1. RegEx
  2. Formula
  3. Select
  4. Text to Columns Correct answer.

Explanation

The Text to Columns tool parses a delimited field and distributes the resulting pieces into new columns based on a chosen delimiter. It is purpose-built for this splitting operation, whereas the other tools do not split one field into many columns.

Question 32Data Preparation and Cleansing

A dataset has a numeric column stored as text with values like "1,234.50". Which approach best converts it into a usable numeric field?

  1. Use a Sort tool on the field
  2. Apply a Select tool type change to Double Correct answer.
  3. Use a Sample tool to keep the first rows
  4. Use a Unique tool to deduplicate

Explanation

Changing the field type to a numeric type in the Select tool converts text to numbers, and Designer Cloud handles common numeric formatting such as thousands separators during conversion. The other tools do not perform type conversion.

Question 33Data Preparation and Cleansing

Which tool removes rows where a specified field contains a null or empty value?

  1. Transpose
  2. Filter Correct answer.
  3. Join
  4. Summarize

Explanation

The Filter tool evaluates a condition and routes rows that fail it to a separate output, so a condition like 'Is not null' or 'Is not empty' removes those rows. The other tools do not route rows by a null condition.

Question 34Data Preparation and Cleansing

Which tool is designed to identify and separate duplicate records based on one or more key fields?

  1. Unique Correct answer.
  2. Select
  3. Formula
  4. Append Fields

Explanation

The Unique tool splits input into unique records and duplicate records based on the selected key fields. The other tools do not perform deduplication.

Question 35Data Preparation and Cleansing

What is the primary purpose of the Data Cleansing tool?

  1. To join two datasets on a common key
  2. To pivot rows into columns
  3. To generate random samples
  4. To standardize and clean values such as trimming whitespace and fixing case Correct answer.

Explanation

The Data Cleansing tool performs common cleanup operations like trimming whitespace, changing case, removing nulls, and replacing punctuation. The other options describe different tools entirely.

Question 36Data Preparation and Cleansing

Which tool changes the data type, name, and order of fields without altering the values themselves?

  1. Filter
  2. Select Correct answer.
  3. Union
  4. Summarize

Explanation

The Select tool manages field metadata: it can rename fields, change types, reorder, and deselect fields. The other tools transform data rather than field metadata.

Question 37Data Preparation and Cleansing

Which tool converts columns into rows, turning a wide dataset into a tall one?

  1. Sort
  2. Transpose Correct answer.
  3. Join
  4. Cross Tab

Explanation

The Transpose tool rotates columns into rows, producing key/value pairs. Cross Tab does the opposite, and Join and Sort do not reshape data.

Question 38Data Preparation and Cleansing

A user wants to replace all null values in a field with the text "Unknown". Which tool is most appropriate?

  1. Formula with a null-handling expression Correct answer.
  2. Sort
  3. Union
  4. Sample

Explanation

The Formula tool can evaluate whether a value is null and substitute a default, making it the right choice for replacing nulls. The other tools do not compute replacement values.

Question 39Data Preparation and Cleansing

Which function in an expression returns the number of characters in a string field?

  1. Length Correct answer.
  2. Replace
  3. Upper
  4. Trim

Explanation

The Length function returns the character count of a string. Trim removes whitespace, Upper changes case, and Replace substitutes substrings.

Question 40Data Preparation and Cleansing

A field contains values with inconsistent casing such as "new york" and "New York". Which operation best standardizes these for grouping?

  1. Round numeric values
  2. Change the field to a numeric type
  3. Sort descending
  4. Convert all values to a consistent case Correct answer.

Explanation

Standardizing case ensures values that differ only by capitalization are treated as the same value during grouping or joining. The other operations do not address case inconsistency.

Question 41Data Preparation and Cleansing

What does the Trim function do to a string value?

  1. Extracts the first five characters
  2. Converts the string to lowercase
  3. Replaces internal spaces with underscores
  4. Removes leading and trailing whitespace Correct answer.

Explanation

Trim strips whitespace from the start and end of a string, which helps match values that differ only by stray spaces. It does not change case or extract characters.

Question 42Data Preparation and Cleansing

Which tool is used to combine two datasets by stacking their records vertically, matching fields by name or position?

  1. Append Fields
  2. Join
  3. Union Correct answer.
  4. Find Replace

Explanation

The Union tool stacks records from multiple inputs vertically, aligning fields by name or position. Join and Append Fields combine datasets horizontally, and Find Replace looks up values.

Question 43Data Preparation and Cleansing

A user needs to match records across two datasets where keys may differ slightly, such as "Acme Inc." versus "Acme Incorporated". Which tool is designed for fuzzy matching?

  1. Summarize
  2. Join
  3. Unique
  4. Fuzzy Match Correct answer.

Explanation

The Fuzzy Match tool compares strings using similarity algorithms to match records that are not exact matches. An exact Join would miss near-matches, and the other tools do not perform fuzzy comparison.

Question 44Data Preparation and Cleansing

Which tool replaces values in one field based on a lookup table from a second input?

  1. Transpose
  2. Find Replace Correct answer.
  3. Sort
  4. Filter

Explanation

The Find Replace tool searches a field for values and replaces them using a lookup input. The other tools do not perform lookup-based substitution.

Question 45Data Preparation and Cleansing

Which tool aggregates records by grouping fields and computing metrics such as sum, count, or average?

  1. Summarize Correct answer.
  2. Formula
  3. Select
  4. Sample

Explanation

The Summarize tool groups records by chosen fields and computes aggregate actions like Sum, Count, and Average. The other tools do not perform grouped aggregation.

Question 46Data Preparation and Cleansing

A column contains dates stored as text in the format "2024-03-15". Which action prepares the field for date arithmetic?

  1. Change the field to Boolean
  2. Apply a Sort tool ascending
  3. Use a Unique tool on the field
  4. Convert the field to a Date type Correct answer.

Explanation

Date arithmetic requires the field to be a proper Date type so the engine interprets and computes on it correctly. Sorting, deduplication, and Boolean conversion do not enable date calculations.

Question 47Data Preparation and Cleansing

What is the effect of the Cross Tab tool?

  1. It joins two datasets on a key
  2. It converts columns into rows
  3. It converts rows into columns by pivoting on a field's values Correct answer.
  4. It removes duplicate records

Explanation

Cross Tab pivots data so that distinct values in a field become new columns, the inverse of Transpose. The other options describe different tools.

Question 48Data Preparation and Cleansing

A user wants to keep only the top 10 records after sorting by revenue descending. Which sequence accomplishes this?

  1. Sort by revenue descending, then use Sample to keep the first 10 records Correct answer.
  2. Use Summarize with Count, then Union
  3. Use Transpose, then Filter
  4. Use Unique, then Sort ascending

Explanation

Sorting establishes the desired order and the Sample tool then limits the output to the first N records, yielding the top 10. The other sequences do not order by revenue and then limit row count.

Question 49Data Preparation and Cleansing

Which tool splits a single stream into True and False outputs based on a custom expression?

  1. Select
  2. Join
  3. Formula
  4. Filter Correct answer.

Explanation

The Filter tool evaluates an expression and produces two outputs: records that satisfy the condition and records that do not. The other tools do not split a stream into two conditional outputs.

Question 50Data Preparation and Cleansing

A field contains phone numbers with parentheses and dashes, such as "(555) 123-4567". Which approach best extracts only the digits?

  1. Apply the Unique tool
  2. Use a RegEx or replace operation to remove non-digit characters Correct answer.
  3. Sort the field descending
  4. Change the field type to Boolean

Explanation

Removing non-digit characters via a regular expression or replace function normalizes the value to digits only. The other operations do not strip punctuation from strings.