Dataford
Top 41
Company roadmap
Updated weekly · Last refresh Aug 30

a B&A Interview Questions

The questions to prepare for a B&A interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

41questions
~5htotal time
Track your progressSign up free to work through all 41 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 12 questions · ~96 min
Legacy Integration with PeopleSoftMedium

Tests experience integrating legacy enterprise platforms into modern architectures.

legacy systemsintegrationa B&A
Balancing Performance and SecurityMedium

Tests ability to make pragmatic engineering trade-offs across performance and security.

Trade-offsperformanceSecuritya B&A
Edge-Case Testing for Mission WorkflowsHard

Tests your ability to design robust edge-case coverage for critical, high-throughput processes.

workflowedge casesa B&A
Disaster Recovery and FailoverHard

Tests resilience planning and distributed system reliability practices.

distributed systemsdisaster recoverya B&A
Immediate Response to BottlenecksHard

Tests incident triage, performance diagnostics, and safe remediation planning in production.

productiona B&A
More Execution questions with a free account
2
Behavioral & Leadership27 questions · ~216 min
Explaining Technical Issues to ExecutivesEasy

Tests communication and influence: can you translate technical complexity into business decisions, align stakeholders, and drive action?

Influence Without AuthorityStakeholder ManagementCommunicationa B&A
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
High Availability and IntegrityMedium

Tests database design skills for reliability and correctness in B&A enterprise environments.

high availabilitydatabase designdata integritya B&A
Scalable High-Concurrency System DesignHard

Tests system design depth for scalability, concurrency, and reliability.

system designa B&A

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
SQL Duplicate Record DetectionEasy
Practice
Practice drill

Find duplicate American Institutes for Research assessment submissions using a CTE, GROUP BY, HAVING, and joins.

deduplicationsqldata integrityAmerican Institutes for ResearchMacy's
Pivot Lucid Campaign Performance by MonthMedium
Practice
Practice drill

Use joins, a CTE, CASE expressions, and monthly pivoting to compare Lucid campaign performance across channels.

pivot tablesnull handlingData WranglingLucid Motors
Unify Campaign Performance SourcesMedium
Practice
Practice drill

Use CTEs, joins, aggregations, and CASE logic to combine Salesforce, Marketo, and Google Analytics into one monthly campaign report.

Data WranglingperformanceReconciliationPalo Alto Networks
The finish line: interview-readyComplete all 41 questions plus 3 hands-on drills to finish this plan.