Alteryx Server Admin study plan
Alteryx Server Admin · Give each week a clear focus.
8 weeks · About 7 hours per week
Server Architecture and Components
Diagram the Server topology (Controller, Worker nodes, Gallery, Mongo, persistence layer) from memory and label every component's role
Explain how the Controller schedules and dispatches work versus how a Worker executes it, in writing
List which components are stateless versus stateful and note the implications for scaling
Identify the ports and services each component depends on and build a reference table
Your checkpoint
A one-page annotated architecture diagram plus a component/port reference table covering all major Server services
Server Architecture and Components & Workflow Scheduling, Execution, and Worker Management
Trace the full lifecycle of a scheduled workflow from trigger to output and annotate each handoff point
Describe how the Scheduler queue, worker assignment, and concurrency settings interact
Compare worker types and runtime settings and record when each is appropriate
Map which architecture components are involved in execution versus content storage
Your checkpoint
A written end-to-end execution trace (trigger to output) with a queue/concurrency cheat sheet
Installation, Configuration, and Upgrades
Write a pre-installation checklist covering host requirements, service accounts, and prerequisites
Sequence the installation steps for a multi-node deployment and note the order dependencies
Document the upgrade path and the pre-upgrade backup/validation steps required before patching
List the configuration files and settings that must be reviewed post-install
Your checkpoint
A reusable install-and-upgrade runbook with ordered steps, checkpoints, and rollback notes
Authentication, Authorization, and Security
Compare supported authentication methods and select the right one for three stated scenarios
Configure role-based permissions in a lab and verify each role's effective access
Explain how authentication and authorization differ in the Server and where each is enforced
Identify security hardening steps for transport, service accounts, and API access
Your checkpoint
A permissions matrix mapping roles to capabilities, validated against a hands-on lab configuration
Workflow Scheduling, Execution, and Worker Management & Content Management, Curated Collections, and Permissions
Create and troubleshoot scheduled workflows, including dependency and failure-handling behavior
Diagnose a stuck or failed job by inspecting queue state and worker health
Distinguish the sharing/permission models for workflows, collections, and curated content
Set up a curated collection and verify visibility for different user roles
Your checkpoint
A troubleshooting decision tree for failed or stuck jobs plus a validated sharing/permissions scenario write-up
Monitoring, Logging, and Troubleshooting
Locate and interpret the primary log sources and correlate entries across components
Build a monitoring checklist covering service health, queue depth, and worker availability
Practice root-causing three simulated failure scenarios using logs only
Identify which metrics warrant alerting and set thresholds
Your checkpoint
A log-source map with a triage checklist and three worked root-cause examples
Backup, Recovery, and High Availability
Define what must be backed up (Mongo, settings, content) and how each is restored
Design an HA approach addressing single points of failure in the architecture
Write and test a recovery procedure for a simulated node loss
Document RTO/RPO assumptions and validate them against the backup strategy
Your checkpoint
A backup-and-recovery runbook with a tested restore procedure and an HA gap analysis
Data Connections, Credentials, and Connectivity & Authentication, Authorization, and Security
Configure and validate a data connection and explain how credentials are stored and referenced
Compare credential-handling options and select the appropriate one for given requirements
Troubleshoot a connectivity failure by isolating network, driver, and credential causes
Run a full-length practice exam and review every missed item against its domain
Your checkpoint
A data-connection and credential configuration guide plus a scored practice-exam review log by domain
Milestones
Week 2: Can explain the full execution path and component roles without notes
Week 4: Install/upgrade runbook complete and permissions matrix validated in lab
Week 6: Can root-cause a simulated job failure using logs within 15 minutes
Week 8: Practice exam score at or above target with all weak domains logged and reviewed