I85PREP
⌘ K
Alteryx Server Admin study materials
Alteryx Server Admin study resources

Alteryx Server Admin practice questions

One question at a time. Build your Alteryx Server Admin 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 1Server Architecture and Components

In an Alteryx Server deployment, which component is responsible for storing workflows, schedules, and user credentials in a PostgreSQL repository?

  1. Alteryx Designer
  2. The Alteryx Gallery API
  3. The Controller (server) node Correct answer.
  4. The Worker node

Explanation

The Controller node hosts the AlteryxService and the MongoDB/PostgreSQL persistence layer that stores workflows, schedules, users, and results. Worker nodes execute jobs but do not own the primary repository. Designer is the desktop client and does not host the Server repository.

Question 2Server Architecture and Components

Which Alteryx Server component actually executes a scheduled workflow when the schedule fires?

  1. The load balancer
  2. The MongoDB instance
  3. The Controller node
  4. The Worker node Correct answer.

Explanation

The Controller queues the job, but a Worker node picks it up and runs the Alteryx Engine to execute the workflow. Workers are the compute tier of a Server deployment.

Question 3Server Architecture and Components

A single-machine Alteryx Server installation runs the Controller and Worker roles on one host. Which statement best describes this configuration?

  1. It cannot run scheduled workflows
  2. It requires a separate database server
  3. It disables the Gallery
  4. It combines the Controller and Worker roles on one machine Correct answer.

Explanation

A single-node installation puts the Controller and Worker roles on the same machine, which is common for smaller deployments. Scheduled workflows still run because the local Worker executes jobs the Controller queues.

Question 4Server Architecture and Components

Which Alteryx Server component provides the web interface where users browse, run, and share workflows?

  1. The Gallery Correct answer.
  2. AlteryxService
  3. MongoDB
  4. The Alteryx Engine

Explanation

The Gallery is the web front end of Alteryx Server, providing the user-facing portal for publishing, running, and sharing workflows and apps. AlteryxService is the background service, the Engine executes workflows, and MongoDB is a data store.

Question 5Server Architecture and Components

In a multi-node Alteryx Server environment, what is the primary purpose of the Controller node?

  1. Hosting only the embedded SQLite database
  2. Rendering charts for reports
  3. Coordinating job queues and managing the repository Correct answer.
  4. Compiling Alteryx workflows into executables

Explanation

The Controller coordinates job scheduling and queueing and manages the persistence layer that stores workflows, schedules, and users. Worker nodes handle execution. The Controller is the orchestration and data tier.

Question 6Server Architecture and Components

Which service account requirement applies to the AlteryxService on a Worker node?

  1. It must run as the LocalSystem account
  2. It must run under a domain or service account with access to the Controller Correct answer.
  3. It must run as an interactive desktop user
  4. It must run without any network access

Explanation

The AlteryxService on Workers must run under an account that can authenticate to and communicate with the Controller and access shared resources. LocalSystem typically lacks the required domain access in multi-node deployments.

Question 7Server Architecture and Components

What role does MongoDB play in an Alteryx Server deployment?

  1. It stores the Alteryx license keys
  2. It provides the HTTPS certificate
  3. It stores workflow metadata, results, and Gallery content Correct answer.
  4. It executes the Alteryx Engine

Explanation

MongoDB is used by Alteryx Server to persist metadata such as workflow definitions, results, and Gallery-related content. It does not execute workflows or manage TLS certificates.

Question 8Server Architecture and Components

Which Alteryx Server component is responsible for running the Alteryx Engine to process a workflow?

  1. The Worker Correct answer.
  2. The Gallery
  3. The Controller
  4. The message queue

Explanation

The Worker node hosts the Alteryx Engine and performs the actual workflow execution. The Controller queues jobs and the Gallery provides the interface, but execution happens on Workers.

Question 9Server Architecture and Components

An administrator wants scheduled jobs to continue running even if the Gallery web front end is temporarily unavailable. Which architecture supports this?

  1. A deployment with only a Controller node
  2. A deployment with only Worker nodes
  3. A multi-node deployment with separate Controller and Worker nodes Correct answer.
  4. A single node where Gallery and Controller share one host

Explanation

Separating the Controller and Worker roles means job scheduling and execution can continue independently of the Gallery web front end. In a single-node setup, an outage on the host affects all roles together.

Question 10Server Architecture and Components

A company needs to scale workflow execution capacity as demand grows. Which change best achieves this in Alteryx Server?

  1. Increase the Gallery memory allocation
  2. Add more Worker nodes to the environment Correct answer.
  3. Increase the MongoDB storage size
  4. Add a second Controller node

Explanation

Execution capacity scales by adding Worker nodes, which increases the number of workflows that can run concurrently. The Controller coordinates but does not execute, so adding Controllers does not add compute for jobs.

Question 11Server Architecture and Components

Which statement accurately describes how the Controller and Worker communicate in a distributed Alteryx Server environment?

  1. Workers poll the Controller over configured ports to receive and report jobs Correct answer.
  2. Workers connect directly to MongoDB to read job definitions
  3. The Gallery pushes workflows to Workers over FTP
  4. Workers share a single file system mounted from the Controller

Explanation

Workers communicate with the Controller over network ports to receive queued jobs and report status. They do not connect directly to MongoDB for job pickup, and FTP or shared filesystems are not the coordination mechanism.

Question 12Server Architecture and Components

An administrator is designing a highly available Alteryx Server deployment. Which component is typically configured with redundancy to avoid a single point of failure for the repository?

  1. The Gallery theme
  2. The Alteryx CLI
  3. The Alteryx Engine
  4. The MongoDB replica set Correct answer.

Explanation

MongoDB is commonly configured as a replica set to provide redundancy for the persistence layer. The Engine, Gallery theme, and CLI are not the repository and do not provide repository redundancy.

Question 13Server Architecture and Components

Which Alteryx Server role hosts the persistence layer that stores users, schedules, and workflow metadata?

  1. The Controller node Correct answer.
  2. The load balancer
  3. The Designer client
  4. The Worker node

Explanation

The Controller node hosts the persistence layer (MongoDB and the repository) that stores users, schedules, and workflow metadata. Workers execute jobs, Designer is the client, and a load balancer distributes traffic.

Question 14Server Architecture and Components

A workflow is published to the Gallery and configured to run on a schedule. Where does the scheduled execution actually take place?

  1. On the database server
  2. Inside the user's browser
  3. On the Controller node's Engine
  4. On a Worker node's Engine Correct answer.

Explanation

Scheduled executions are queued by the Controller and run by the Alteryx Engine on a Worker node. The browser and database server do not execute workflows.

Question 15Server Architecture and Components

Which component must be installed on every machine that will execute workflows in a multi-node Alteryx Server deployment?

  1. Alteryx Designer
  2. The Alteryx Engine with the Worker role Correct answer.
  3. The MongoDB replica set
  4. The Gallery web front end

Explanation

Each Worker node requires the Alteryx Engine and the Worker role to execute workflows. Designer is a client, the Gallery is the web front end, and MongoDB is the persistence layer, none of which are required on every execution machine.

Question 16Server Architecture and Components

An administrator needs to ensure the AlteryxService can start automatically after a server reboot. Which configuration addresses this?

  1. Add the service to the Gallery favorites
  2. Configure the MongoDB replica set
  3. Set the AlteryxService startup type to Automatic Correct answer.
  4. Enable the Alteryx CLI in the PATH

Explanation

Setting the AlteryxService startup type to Automatic ensures the service starts when the host boots. The other options do not affect service startup behavior.

Question 17Server Architecture and Components

Which statement best describes the relationship between the Gallery and the Controller in Alteryx Server?

  1. The Gallery is the web front end that communicates with the Controller for scheduling and data Correct answer.
  2. The Gallery stores all workflow results independently of the Controller
  3. The Gallery executes workflows directly
  4. The Gallery replaces the Controller for job scheduling

Explanation

The Gallery is the web front end that interacts with the Controller for scheduling, persistence, and job management. It does not replace the Controller, store results independently, or execute workflows itself.

Question 18Server Architecture and Components

A deployment uses a load balancer in front of multiple Gallery nodes. What is the primary benefit?

  1. It increases the number of Worker execution slots
  2. It replaces the need for a Controller
  3. It stores the workflow repository
  4. It distributes user web traffic across Gallery nodes for availability Correct answer.

Explanation

A load balancer distributes incoming user web traffic across multiple Gallery nodes, improving availability and responsiveness. It does not add execution slots, replace the Controller, or store the repository.

Question 19Server Architecture and Components

Which Alteryx Server component is responsible for enforcing authentication and authorization for Gallery users?

  1. The Worker node
  2. The Alteryx CLI
  3. The Alteryx Engine
  4. The Controller's user and permissions layer Correct answer.

Explanation

User authentication and authorization are managed by the Controller's user and permissions layer, which the Gallery consults. The Engine and Workers execute workflows, and the CLI is a tool for administration.

Question 20Server Architecture and Components

An organization wants to isolate workflow execution from the web-facing Gallery for security reasons. Which architecture achieves this?

  1. Separate the Gallery/Controller tier from the Worker tier on different hosts Correct answer.
  2. Remove the Controller from the deployment
  3. Run all roles on a single host
  4. Place the Gallery on the same host as the Workers

Explanation

Separating the web-facing Gallery and Controller tier from the Worker tier on different hosts isolates execution from the web front end. Co-locating roles or removing the Controller defeats the isolation goal.

Question 21Server Architecture and Components

A Worker node repeatedly fails to pick up jobs while the Controller shows the queue growing. Which architectural cause is most plausible?

  1. MongoDB has too much free space
  2. The Worker cannot communicate with the Controller over the required ports Correct answer.
  3. The Gallery theme is misconfigured
  4. The Alteryx Engine is not installed on the Controller

Explanation

If Workers cannot reach the Controller over the required ports, they cannot receive queued jobs, causing the queue to grow. Gallery themes and free disk space are unrelated, and the Engine is not required on the Controller for execution.

Question 22Server Architecture and Components

Which design consideration is most important when sizing the Controller node in a large multi-node deployment?

  1. The color scheme of the Gallery
  2. The number of Gallery themes installed
  3. The number of concurrent Worker connections and metadata operations Correct answer.
  4. The number of Alteryx CLI shortcuts

Explanation

Controller sizing depends on the volume of concurrent Worker connections and metadata operations it must coordinate. Cosmetic and CLI considerations do not affect Controller sizing.

Question 23Server Architecture and Components

In a deployment with multiple Workers, how does the Controller decide which Worker runs a given queued job?

  1. It lets the user choose the Worker in the Gallery
  2. It always assigns jobs to the first Worker in alphabetical order
  3. It assigns the job to the Controller itself
  4. It assigns the job to the Worker with the most available capacity based on its scheduling logic Correct answer.

Explanation

The Controller dispatches queued jobs to available Workers according to its scheduling logic, which considers Worker availability. It does not use alphabetical ordering, user selection, or execute jobs itself.

Question 24Server Architecture and Components

An administrator must verify that a newly added Worker is properly registered with the Controller before it receives jobs. Which architectural element confirms registration?

  1. The Worker appears in the Controller's list of registered Workers Correct answer.
  2. The Worker appears in the Gallery favorites
  3. The Worker's Gallery theme is applied
  4. The Worker's MongoDB replica set is healthy

Explanation

A Worker is confirmed as registered when it appears in the Controller's list of registered Workers, indicating it can receive jobs. Gallery favorites, replica set health, and themes do not confirm Worker registration.

Question 25Server Architecture and Components

Which statement best explains why the Controller and Worker roles are separated in a production Alteryx Server deployment?

  1. To allow independent scaling of execution capacity and to isolate the persistence tier Correct answer.
  2. To allow workflows to run without the Alteryx Engine
  3. To reduce the number of licenses required
  4. To eliminate the need for MongoDB

Explanation

Separating the roles lets execution capacity scale independently by adding Workers while isolating the persistence and coordination tier on the Controller. It does not reduce licensing, remove MongoDB, or eliminate the Engine.

Question 26Server Architecture and Components

In a standard Alteryx Server deployment, which component provides the browser-based interface where users publish and share workflows?

  1. The AlteryxService
  2. The Worker
  3. The Controller
  4. The Gallery Correct answer.

Explanation

The Gallery is the web application through which users access the server, publish workflows, and share results. The other roles handle scheduling, coordination, and execution rather than the user-facing web interface.

Question 27Server Architecture and Components

Which two components must be present for a machine to participate as a Worker node in an Alteryx Server environment?

  1. The AlteryxService and the Alteryx Engine Correct answer.
  2. The persistence layer and the message broker
  3. The Controller and the load balancer
  4. The Gallery and MongoDB

Explanation

A Worker runs the AlteryxService, which receives jobs from the Controller, and the Alteryx Engine, which actually executes the workflows. The Gallery and Controller are separate roles not required on every Worker.

Question 28Server Architecture and Components

An administrator notices that the Gallery is reachable and users can browse workflows, but newly submitted jobs stay queued and never start. Which architectural component should be investigated first?

  1. The MongoDB replica set read preference
  2. The Controller service and its connection to the Workers Correct answer.
  3. The Gallery's SSL certificate configuration
  4. The web browser cache on the user's machine

Explanation

The Controller is responsible for accepting queued jobs and dispatching them to available Workers, so a queue that never drains points to the Controller or its Worker connections. The Gallery being reachable confirms the web tier is functioning.

Question 29Server Architecture and Components

A company wants the Gallery web tier and the workflow execution tier to be upgraded independently without taking the whole environment offline at once. Which architectural characteristic of Alteryx Server supports this?

  1. Reliance on a shared MongoDB instance for all roles
  2. Separation of the Gallery role from the Controller and Worker roles Correct answer.
  3. Mandatory installation of the Alteryx Engine on the Gallery node
  4. Use of a single monolithic server installation

Explanation

Because the Gallery, Controller, and Worker are distinct roles, they can be deployed on separate machines and maintained on different schedules. A monolithic install couples the tiers and forces simultaneous downtime.

Question 30Server Architecture and Components

An administrator is planning a multi-machine Alteryx Server deployment and must decide where the persistence layer should run. Which placement is architecturally appropriate?

  1. On the Gallery node only, isolated from the Controller
  2. On every Worker node so each execution has local metadata access
  3. On a user's workstation that submits the scheduled workflows
  4. On the machine hosting the Controller role, alongside the other Controller-side services Correct answer.

Explanation

The persistence layer (MongoDB) belongs with the Controller-side components, since the Controller reads and writes scheduling and metadata there. Workers do not host the persistence layer, and it must not depend on an end-user workstation.

Question 31Installation, Configuration, and Upgrades

Which component of an Alteryx Server deployment is responsible for running workflows submitted by users?

  1. The Controller
  2. The Worker Correct answer.
  3. The Gallery
  4. The MongoDB database

Explanation

Workers are the execution nodes that run workflows; the Controller coordinates and dispatches work to them. Gallery is the web front end, and MongoDB stores metadata.

Question 32Installation, Configuration, and Upgrades

What is the default port used by the Alteryx Server Controller's communication service?

  1. 8080
  2. 27017
  3. 443
  4. 51828 Correct answer.

Explanation

The Controller service communicates with Workers over port 51828 by default. Port 27017 is MongoDB, 8080 is commonly the Gallery web port, and 443 is HTTPS.

Question 33Installation, Configuration, and Upgrades

Which database does Alteryx Server use to store its metadata, such as users, schedules, and workflow definitions?

  1. MongoDB Correct answer.
  2. Microsoft SQL Server
  3. PostgreSQL
  4. SQLite

Explanation

Alteryx Server uses MongoDB as its primary metadata store. It holds users, schedules, and workflow documents. The other databases are not the server's internal metadata store.

Question 34Installation, Configuration, and Upgrades

A company wants a single machine to both host the Gallery and execute workflows for a small team. Which server role configuration satisfies this requirement?

  1. A combined Controller and Worker node Correct answer.
  2. A Controller-only node with no Workers
  3. A Gallery-only node with an external database
  4. A Worker-only node connected to a remote Controller

Explanation

Installing the Controller and Worker roles on the same machine lets that single node coordinate and run workflows. A Controller-only node cannot execute workflows, and a Worker-only node needs a separate Controller.

Question 35Installation, Configuration, and Upgrades

Which file holds the primary configuration settings for an Alteryx Server component such as the Controller or Worker?

  1. SystemSettings.xml Correct answer.
  2. RuntimeSettings.xml
  3. AlteryxServer.conf
  4. GallerySettings.json

Explanation

SystemSettings.xml stores the core configuration for Server components like the Controller and Worker. Administrators edit it to adjust service behavior and connection settings.

Question 36Installation, Configuration, and Upgrades

During a fresh Server install, which account type should be used to run the Alteryx Service for a production deployment?

  1. The built-in LocalSystem account
  2. The personal account of the installing administrator
  3. A local user account without a password
  4. A dedicated domain service account with required permissions Correct answer.

Explanation

Production deployments should run the Alteryx Service under a dedicated domain service account with the necessary log-on and folder permissions. Using built-in or personal accounts creates security and stability risks.

Question 37Installation, Configuration, and Upgrades

Which prerequisite must be satisfied on the machine before installing Alteryx Server?

  1. MongoDB must be installed and reachable
  2. A licensed copy of Alteryx Designer must be installed
  3. A supported version of the .NET Framework must be present Correct answer.
  4. Docker must be running

Explanation

Alteryx Server requires a supported .NET Framework version among its prerequisites. Designer is not required on the server, MongoDB is typically installed by the Server installer, and Docker is not a requirement.

Question 38Installation, Configuration, and Upgrades

An administrator is preparing to upgrade an Alteryx Server environment. What should be done first?

  1. Delete the MongoDB data directory to clear old metadata
  2. Back up the MongoDB database and configuration files Correct answer.
  3. Disable all schedules permanently
  4. Uninstall the previous version before taking any backup

Explanation

A verified backup of MongoDB and the configuration files must be taken before upgrading so the environment can be restored if the upgrade fails. Deleting data or uninstalling first risks permanent loss.

Question 39Installation, Configuration, and Upgrades

What is the recommended order when upgrading a multi-node Alteryx Server deployment?

  1. Upgrade all nodes simultaneously
  2. Upgrade the Gallery database before any node
  3. Upgrade the Controller first, then the Workers Correct answer.
  4. Upgrade Workers first, then the Controller

Explanation

The Controller should be upgraded before the Workers so the coordination layer is on the new version before execution nodes join it. Simultaneous upgrades can leave nodes in incompatible states.

Question 40Installation, Configuration, and Upgrades

Which tool is used to move an Alteryx Server installation's metadata and settings to a new machine?

  1. MongoDB Compass export wizard
  2. Alteryx Server Migration Utility Correct answer.
  3. Windows Server Backup
  4. Alteryx Designer Save As dialog

Explanation

The Alteryx Server Migration Utility is designed to export and import Server metadata and settings when relocating an installation. Generic backup or database tools do not handle the full Server migration workflow.

Question 41Installation, Configuration, and Upgrades

After installing Alteryx Server, which step confirms that the Controller and Worker are communicating correctly?

  1. Reboot the machine and assume success
  2. Open Designer and run a workflow locally
  3. Delete the MongoDB logs
  4. Check the Server's worker status in the Admin interface or logs Correct answer.

Explanation

The Admin interface or service logs report whether Workers have registered with the Controller. This verifies the Controller-Worker connection after installation.

Question 42Installation, Configuration, and Upgrades

Which setting controls the maximum number of workflows a Worker can run concurrently?

  1. The Gallery session timeout
  2. The MongoDB connection pool size
  3. The Controller's license key
  4. The Worker's execution concurrency setting Correct answer.

Explanation

Each Worker has a configurable concurrency limit that caps how many workflows it runs at once. This governs throughput and resource use on that node.

Question 43Installation, Configuration, and Upgrades

An administrator needs to change the port the Gallery listens on. Where is this configured?

  1. In the Alteryx Designer user settings
  2. In the Server configuration settings for the Gallery Correct answer.
  3. In the MongoDB connection string
  4. In the Windows Firewall rules only

Explanation

The Gallery listening port is defined in the Server configuration settings, after which services are restarted and firewall rules updated. Firewall rules alone do not change the port the service binds to.

Question 44Installation, Configuration, and Upgrades

Which service must be running for the Alteryx Server Gallery website to be available to users?

  1. The Windows Print Spooler
  2. The MongoDB service only
  3. The Alteryx Service Correct answer.
  4. The Alteryx Engine service only

Explanation

The Alteryx Service hosts the Server components, including the Gallery, so it must be running for the site to be available. MongoDB supports metadata but does not serve the website by itself.

Question 45Installation, Configuration, and Upgrades

A new Server deployment must use HTTPS for the Gallery. Which action accomplishes this?

  1. Change the MongoDB port to 443
  2. Set the Worker concurrency to zero
  3. Bind the Gallery to a certificate and enable SSL in the configuration Correct answer.
  4. Disable the Controller service

Explanation

Enabling HTTPS requires configuring the Gallery with a valid certificate and turning on SSL in the Server settings. Changing unrelated ports or services does not provide TLS.

Question 46Installation, Configuration, and Upgrades

Which Alteryx Server component stores the results and output data produced by workflow runs?

  1. The Worker
  2. The Controller
  3. MongoDB Correct answer.
  4. The Gallery cache

Explanation

MongoDB persists Server metadata and workflow result data referenced by the Gallery. The Controller and Worker orchestrate and execute but do not serve as the persistent result store.

Question 47Installation, Configuration, and Upgrades

When installing a multi-node Server, which component should be installed first?

  1. The Controller node Correct answer.
  2. The MongoDB replica set on every node
  3. The Gallery on each Worker
  4. The Worker nodes

Explanation

The Controller should be installed and configured first so Workers have a coordination endpoint to join. Installing Workers first leaves them without a Controller to connect to.

Question 48Installation, Configuration, and Upgrades

Which log location would an administrator check to troubleshoot a failed Server service startup?

  1. The Alteryx Server logs directory Correct answer.
  2. The Windows Prefetch folder
  3. The Designer Samples folder
  4. The MongoDB journal only

Explanation

Server component logs in the Alteryx logs directory record startup errors and service events. These logs are the primary troubleshooting source for service startup failures.

Question 49Installation, Configuration, and Upgrades

An administrator must ensure the Alteryx Service starts automatically after a server reboot. What should be configured?

  1. The Alteryx Service startup type set to Automatic Correct answer.
  2. A MongoDB cron job
  3. A scheduled task that starts Designer
  4. A logon script for the administrator

Explanation

Setting the Alteryx Service startup type to Automatic ensures it starts when Windows boots. Scheduled tasks or logon scripts are not the correct mechanism for the service itself.

Question 50Installation, Configuration, and Upgrades

What is the purpose of the Alteryx Server license key during installation?

  1. It activates the Server edition and its entitlements Correct answer.
  2. It encrypts the MongoDB database
  3. It sets the Gallery port number
  4. It defines the Worker concurrency limit

Explanation

The license key activates the Server product and determines which features and capacity are entitled. It does not control ports, encryption, or concurrency settings.