Search test library by skills or roles
⌘ K

Business Analyst IT Test

The Business Analyst IT Test uses scenario-based MCQs to evaluate candidates on their understanding of the role of a business analyst in IT projects, including requirements gathering, analysis, and documentation. The test assesses candidates on their knowledge of project management methodologies, such as Agile, Waterfall, and Scrum, as well as their ability to create user stories, use cases, process flows, and wireframes.

Get started for free
Preview questions

Screen candidates with a 50 mins test

Test duration:  50 mins
Difficulty level:  Moderate
Availability:  Ready to use
Questions:
  • 5 Business Analysis MCQs
  • 5 SQL MCQs
  • 5 Excel MCQs
  • 5 Data Interpretation MCQs
  • 5 Logical Reasoning MCQs
  • 5 Critical Thinking MCQs
Covered skills:
Analytical Thinking
SQL
Business Analysis
Requirements Gathering
Data Analysis
Process Improvement
System Design
Project Management
Critical Thinking
Communication
Problem Solving
Get started for free
Preview questions

Use Adaface tests trusted by recruitment teams globally

Adaface is used by 1500+ businesses in 80 countries.

Adaface skill assessments measure on-the-job skills of candidates, providing employers with an accurate tool for screening potential hires.

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte NCS Sokrati J&T Express Capegemini

Use the Business Analyst IT Assessment Test to shortlist qualified candidates

The Business Analyst IT Test helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates at the first step of the hiring process.

The test screens for the following skills that hiring managers look for in candidates:

  • Ability to gather and analyze business requirements
  • Proficiency in SQL for data querying and manipulation
  • Advanced knowledge of Excel for data analysis and reporting
  • Ability to interpret data and draw meaningful insights
  • Strong logical reasoning skills for problem-solving
  • Critical thinking and analysis for evaluating complex business situations
  • Ability to apply analytical thinking to identify process improvements
  • Understanding of system design principles
  • Project management skills for effective planning and execution of tasks
  • Excellent communication skills for effective collaboration and documentation
  • Strong problem-solving abilities to identify and address business challenges
Get started for free
Preview questions

Screen candidates with the highest quality questions

We have a very high focus on the quality of questions that test for on-the-job skills. Every question is non-googleable and we have a very high bar for the level of subject matter experts we onboard to create these questions. We have crawlers to check if any of the questions are leaked online. If/ when a question gets leaked, we get an alert. We change the question for you & let you know.

How we design questions

These are just a small sample from our library of 15,000+ questions. The actual questions on this Business Analyst IT Test will be non-googleable.

🧐 Question

Medium

PV of customer segments
Market Segmentation
ROI
CLV
Solve
A retail company is exploring new customer segments to increase sales. You are provided with the following data on three potential customer segments:

Segment A:

- Average annual revenue per customer: $500
- Average customer retention rate: 80%
- Average customer acquisition cost: $200
- Expected segment size: 2,000 customers

Segment B:

- Average annual revenue per customer: $750
- Average customer retention rate: 70%
- Average customer acquisition cost: $300
- Expected segment size: 1,500 customers

Segment C:

- Average annual revenue per customer: $1,000
- Average customer retention rate: 60%
- Average customer acquisition cost: $400
- Expected segment size: 1,000 customers
Assuming a 10% discount rate, which customer segment should the company target to maximize the return on investment? A target customer segment would have higher customer lifetime value (CLV). Note that CLV is calculated by using the following formula:

CLV = (Average Annual Revenue per Customer * Gross Margin %) * (Retention Rate / (1 + Discount Rate - Retention Rate)) - Customer Acquisition Cost

Easy

Supply Chain Management
Cost Reduction
Solve
A company is considering two options to optimize its supply chain and reduce costs. The following data has been provided for each option:

Option Alpha:

- Annual transportation cost reduction: $300,000
- Annual inventory carrying cost increase: $250,000
- One-time implementation cost: $100,000

Option Beta:

- Annual transportation cost reduction: $200,000
- Annual inventory carrying cost increase: $150,000
- One-time implementation cost: $50,000

As a business analyst, determine which option provides a higher net cost reduction over a 3-year period.
A: Option Alpha provides a higher net cost reduction.
B: Option Beta provides a higher net cost reduction.
C: Both options provide the same net cost reduction.
D: Neither option provides a net cost reduction.
E: The net cost reduction cannot be determined with the given data.

Medium

Multi Select
JOIN
GROUP BY
Solve
Consider the following SQL table:
 image
How many rows does the following SQL query return?
 image

Medium

nth highest sales
Nested queries
User Defined Functions
Solve
Consider the following SQL table:
 image
Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
 image

Medium

Select & IN
Nested queries
Solve
Consider the following SQL table:
 image
Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
 image

Medium

Sorting Ubers
Nested queries
Join
Comparison operators
Solve
Consider the following SQL table:
 image
What will be the first two tuples resulting from the following SQL command?
 image

Hard

With, AVG & SUM
MAX() MIN()
Aggregate functions
Solve
Consider the following SQL table:
 image
How many tuples does the following query return?
 image

Medium

MATCH INDEX LOOKUP
Solve
Some friends live in adjacent apartments in a building in Central Perk, New York. We want to write a function to search the apartment number by name. Which of the following functions should we use?
 image

Medium

Organization data
Data transformation
Solve
We have two Excel files with organization data. One file has Organization ID and Organization Name fields, whereas the second file has Organization ID, Organization Name and Country fields. We wrote a query to retrieve the data from both files. Here’s a sample of the data retrieved:
 image
We want to ensure Organization ID field is unique. Which of the following is the ideal solution that ensures Organization ID field is unique while retaining Country data?

A: Select the Organization ID and Country columns, and then click Keep Duplicates.
B: Select the Organization ID and Country columns, and then click Remove Duplicates.
C: Use Group BY function to group the rows by Organization ID. Specify output columns for Organization Name and Country using MAX operation.
D: Select Organization ID column and then click Remove Duplicates. Then specify output columns for Country using MAX operation.

Medium

Student scores
Data formatting
Solve
Here’s a sample Excel data source:
 image
Here’s the expected data format: 
 image
Which of the following is the correct way to transform the data from the query editor to achieve the result?

A: Columns to Select: Student Only
B: Columns to Select: Student and Student ID
C: Columns to Select: Primary and Secondary
D: Command to Use: Pivot Column
E: Command to Use: Reverse Rows
F: Command to Use: Unpivot Columns

Medium

VLOOKUP blood donor
Solve
We are looking to find the contact number of the only blood donor with blood group O-. Which function should we use to look up the correct contact number? Here's the documentation for VLOOKUP: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).
 image
A: =VLOOKUP("O-", A1:E10, 3, TRUE)
B: =VLOOKUP("O-", A1:E10, 3, FALSE)
C: =VLOOKUP("O-", D1:D10, 4)
D: =VLOOKUP("O-", D1:D10, 3)
E: =VLOOKUP("O-", A1:E10, 4, TRUE)
F: =VLOOKUP("O-", A1:E10, 4, FALSE)
G: =VLOOKUP("Kane", A1:E10, 4)

Medium

Dividends
Financial Analysis
Percentage and Average Calculations
Solve
Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?
 image
 image

Medium

Laptop Brands
Proportions and Percentages
Financial Reasoning
Solve
Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?
 image

Hard

Median
Trend Analysis
Statistical Reasoning
Solve
 Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.
 image

Medium

Tennis Players
Solve
A tennis coach was trying to put together a team of 4 players for a tennis championship out of 7 players. R, S, T are the male players, and W, X, Y, Z are the female players. Note that all players have equal ability, and the team needs to have atleast 2 male players. While selecting the team we need to keep in mind that all 4 players should be able to play with each other. 
 image
We also need to keep the following restrictions in mind:
- R cannot play with Y
- S cannot play with W
- T cannot play with Z
Which of the following are true:

A: S and Z cannot be in the team together.
B: T and Y cannot be in the team together.
C: T and X cannot be in the team together.

Hard

CID Agent
Logical Deduction
Pattern Recognition
Solve
A code ("EIG AUC REO RAI COG") was sent to the criminal office by a CID agent named Batra.  However, four of the five words are fake, with only one containing the information. They also included a clue in the form of a sentence: "If I tell you any character of the code word, you will be able to tell how many vowels there are in the code word." Are you able to figure out what the code word is?
A: RAI 
B: EIG
C: AUC
D: REO
E: COG
F: None

Medium

Positive correlation
Correlation vs. Causation
Solve
Myra is working on her thesis for which she created a scatter plot of the number of teachers and the number of college graduates for cities in Australia. She noticed a positive correlation. Which of these do you think is the probable explanation for this correlation?
A: Teachers encourage people to go to college, so an increase in the number of teachers leads to an increase in the number of college graduates. 

B: Some college graduates choose teaching as a profession after graduating, so an increase in the number of college graduates also leads to an increase in the number of teachers.

C: There are more college graduates and teachers in higher income cities, so income is a confounding variable here, make it difficult to prove causation between number of teachers and number of college graduates. 

D: Cities with a higher population have more teachers and more college graduates, so the correlation is due to a third variable (population of city).

E: The provided data is insufficient, so it is extremely difficult to establish the reason for the correlation.

F: Most college students choose non-teaching professions after graduating, which explains the correlation. 

G: In Australia, college students are encouraged by their teachers to choose teaching as a profession after graduating.

Medium

Claims for a new drug Xylanex
Critical Thinking
Evaluating Arguments
Identifying Assumptions
Solve
A pharmaceutical company claims that their new drug, Xylanex, is highly effective in treating a specific medical condition. They provide statistical data from a clinical trial to support their claim. However, a group of scientists has raised concerns about the validity of the study design and potential bias in the data collection process. They argue that the results may be inflated and not truly representative of the drug's effectiveness.

Which of the following assumptions is necessary to support the pharmaceutical company's claim?
A: The clinical trial participants were randomly selected and representative of the target population.
B: The scientists raising concerns have a conflict of interest and are biased against the pharmaceutical company.
C: The statistical analysis of the clinical trial data was conducted by independent experts.
D: The medical condition being treated by Xylanex is widespread and affects a large number of individuals.
E: The pharmaceutical company has a proven track record of developing effective drugs for similar medical conditions.

Medium

Emma's cafe business
Solve
Emma's cafe has been operating successfully for the last 6 years. Profits have been growing every year, with this year (2020) being their best year so far. As a thank you, Emma treated her staff to a meal at a Michelin star restaurant. 
 image
Below are 3 statements about Emma, her staff and her cafe. Can you help us decide whether the 3 statements are "True", "Probably True", "Insufficient Data to Say True or False", "Probably False", or "False".

1. Emma's staff members are happy.
2. Emma's cafe did well in 2016.
3. Emma is rich.

A: True
B: False
C: Probably True
D: Probably False
E: Insufficient Data

Medium

Ivory's new startup
Solve
Statement: Ivory started a new startup. We know for a fact that almost all startups fail within the first 2 years. 
Conclusion: Ivory's startup will fail.
Does the conclusion follow from the statement?
🧐 Question🔧 Skill

Medium

PV of customer segments
Market Segmentation
ROI
CLV

3 mins

Business Analysis
Solve

Easy

Supply Chain Management
Cost Reduction

2 mins

Business Analysis
Solve

Medium

Multi Select
JOIN
GROUP BY

2 mins

SQL
Solve

Medium

nth highest sales
Nested queries
User Defined Functions

3 mins

SQL
Solve

Medium

Select & IN
Nested queries

3 mins

SQL
Solve

Medium

Sorting Ubers
Nested queries
Join
Comparison operators

3 mins

SQL
Solve

Hard

With, AVG & SUM
MAX() MIN()
Aggregate functions

2 mins

SQL
Solve

Medium

MATCH INDEX LOOKUP

2 mins

Excel
Solve

Medium

Organization data
Data transformation

3 mins

Excel
Solve

Medium

Student scores
Data formatting

2 mins

Excel
Solve

Medium

VLOOKUP blood donor

2 mins

Excel
Solve

Medium

Dividends
Financial Analysis
Percentage and Average Calculations

3 mins

Data Interpretation
Solve

Medium

Laptop Brands
Proportions and Percentages
Financial Reasoning

2 mins

Data Interpretation
Solve

Hard

Median
Trend Analysis
Statistical Reasoning

3 mins

Data Interpretation
Solve

Medium

Tennis Players

3 mins

Logical Reasoning
Solve

Hard

CID Agent
Logical Deduction
Pattern Recognition

3 mins

Logical Reasoning
Solve

Medium

Positive correlation
Correlation vs. Causation

2 mins

Logical Reasoning
Solve

Medium

Claims for a new drug Xylanex
Critical Thinking
Evaluating Arguments
Identifying Assumptions

2 mins

Critical Thinking
Solve

Medium

Emma's cafe business

2 mins

Critical Thinking
Solve

Medium

Ivory's new startup

2 mins

Critical Thinking
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
PV of customer segments
Market Segmentation
ROI
CLV
Business Analysis
Medium3 mins
Solve
Supply Chain Management
Cost Reduction
Business Analysis
Easy2 mins
Solve
Multi Select
JOIN
GROUP BY
SQL
Medium2 mins
Solve
nth highest sales
Nested queries
User Defined Functions
SQL
Medium3 mins
Solve
Select & IN
Nested queries
SQL
Medium3 mins
Solve
Sorting Ubers
Nested queries
Join
Comparison operators
SQL
Medium3 mins
Solve
With, AVG & SUM
MAX() MIN()
Aggregate functions
SQL
Hard2 mins
Solve
MATCH INDEX LOOKUP
Excel
Medium2 mins
Solve
Organization data
Data transformation
Excel
Medium3 mins
Solve
Student scores
Data formatting
Excel
Medium2 mins
Solve
VLOOKUP blood donor
Excel
Medium2 mins
Solve
Dividends
Financial Analysis
Percentage and Average Calculations
Data Interpretation
Medium3 mins
Solve
Laptop Brands
Proportions and Percentages
Financial Reasoning
Data Interpretation
Medium2 mins
Solve
Median
Trend Analysis
Statistical Reasoning
Data Interpretation
Hard3 mins
Solve
Tennis Players
Logical Reasoning
Medium3 mins
Solve
CID Agent
Logical Deduction
Pattern Recognition
Logical Reasoning
Hard3 mins
Solve
Positive correlation
Correlation vs. Causation
Logical Reasoning
Medium2 mins
Solve
Claims for a new drug Xylanex
Critical Thinking
Evaluating Arguments
Identifying Assumptions
Critical Thinking
Medium2 mins
Solve
Emma's cafe business
Critical Thinking
Medium2 mins
Solve
Ivory's new startup
Critical Thinking
Medium2 mins
Solve

Test candidates on core Business Analyst IT Hiring Test topics

Analytical Thinking: Analytical Thinking is the ability to systematically break down complex problems or situations into smaller, more manageable components in order to understand them better and make informed decisions. This skill should be measured in this test to assess the candidate's ability to think critically, analyze data, and derive logical conclusions, which are vital for a Business Analyst role in IT.

SQL: SQL, or Structured Query Language, is a programming language used for managing and manipulating relational databases. It is a fundamental skill for a Business Analyst as it allows them to retrieve and analyze data efficiently, write complex queries, and generate reports. Measuring SQL knowledge in this test helps identify candidates who are proficient in database management and data analysis.

Business Analysis: Business Analysis involves evaluating and assessing an organization's business processes, systems, and objectives to identify opportunities for improvement and recommend solutions. This skill should be measured in the test to assess the candidate's understanding of business requirements, ability to analyze existing processes, and propose effective strategies for process optimization.

Requirements Gathering: Requirements Gathering is the process of identifying, documenting, and validating the needs and expectations of stakeholders regarding a system or project. It is an essential skill for a Business Analyst to ensure that the software or solution aligns with business goals and user requirements. Measuring this skill in the test helps evaluate the candidate's ability to gather and analyze requirements accurately.

Data Analysis: Data Analysis involves examining and interpreting complex data sets to uncover valuable insights and support decision-making. This skill is crucial for a Business Analyst to analyze business data, identify patterns, trends, and anomalies, and provide data-driven recommendations. Measuring data analysis proficiency in the test helps assess the candidate's ability to extract meaningful information from large datasets.

Process Improvement: Process Improvement refers to the identification and implementation of changes in existing systems, workflows, or procedures to optimize efficiency and effectiveness. This skill is important for a Business Analyst to identify bottlenecks, streamline processes, and suggest improvements to enhance productivity. Measuring this skill in the test helps evaluate the candidate's understanding of process analysis and their ability to propose practical improvements.

System Design: System Design involves creating a comprehensive plan and blueprint for the development and implementation of software systems or solutions. This skill is essential for a Business Analyst to translate business requirements into technical specifications and collaborate with developers and stakeholders. Measuring system design knowledge in the test helps assess the candidate's ability to design scalable and efficient solutions.

Project Management: Project Management encompasses planning, organizing, and overseeing the successful execution of projects within defined timelines and budgets. This skill is important for a Business Analyst to manage project deliverables, stakeholders, and resources effectively. Measuring project management skills in the test helps evaluate the candidate's ability to handle project complexities and ensure project success.

Critical Thinking: Critical Thinking involves objectively analyzing and evaluating information to form accurate and logical judgments or decisions. This skill is crucial for a Business Analyst to assess business problems, identify root causes, and propose effective solutions. Measuring critical thinking abilities in the test helps evaluate the candidate's capacity to think critically and make sound decisions in complex business scenarios.

Communication: Communication refers to the clear, concise, and effective exchange of ideas, information, and feedback between individuals or groups. This skill is essential for a Business Analyst to gather requirements, present findings, and collaborate with stakeholders from diverse backgrounds. Measuring communication skills in the test helps assess the candidate's ability to convey complex information to both technical and non-technical stakeholders.

Problem Solving: Problem Solving is the ability to identify, analyze, and resolve challenges or obstacles effectively. It is a critical skill for a Business Analyst to address issues, propose solutions, and mitigate risks. Measuring problem-solving skills in the test helps evaluate the candidate's ability to approach problems systematically, explore alternative solutions, and make well-informed decisions.

Get started for free
Preview questions

Make informed decisions with actionable reports and benchmarks

View sample scorecard

Screen candidates in 3 easy steps

Pick a test from over 500+ tests

The Adaface test library features 500+ tests to enable you to test candidates on all popular skills- everything from programming languages, software frameworks, devops, logical reasoning, abstract reasoning, critical thinking, fluid intelligence, content marketing, talent acquisition, customer service, accounting, product management, sales and more.

Invite your candidates with 2-clicks

Make informed hiring decisions

Get started for free
Preview questions

Try the most advanced candidate assessment platform

ChatGPT Protection

Non-googleable Questions

Web Proctoring

IP Proctoring

Webcam Proctoring

MCQ Questions

Coding Questions

Typing Questions

Personality Questions

Custom Questions

Ready-to-use Tests

Custom Tests

Custom Branding

Bulk Invites

Public Links

ATS Integrations

Multiple Question Sets

Custom API integrations

Role-based Access

Priority Support

GDPR Compliance


Pick a plan based on your hiring needs

The most advanced candidate screening platform.
14-day free trial. No credit card required.

From
$15
per month (paid annually)
love bonito

With Adaface, we were able to optimise our initial screening process by upwards of 75%, freeing up precious time for both hiring managers and our talent acquisition team alike!

Brandon Lee, Head of People, Love, Bonito

Brandon
love bonito

It's very easy to share assessments with candidates and for candidates to use. We get good feedback from candidates about completing the tests. Adaface are very responsive and friendly to deal with.

Kirsty Wood, Human Resources, WillyWeather

Brandon
love bonito

We were able to close 106 positions in a record time of 45 days! Adaface enables us to conduct aptitude and psychometric assessments seamlessly. My hiring managers have never been happier with the quality of candidates shortlisted.

Amit Kataria, CHRO, Hanu

Brandon
love bonito

We evaluated several of their competitors and found Adaface to be the most compelling. Great library of questions that are designed to test for fit rather than memorization of algorithms.

Swayam Narain, CTO, Affable

Brandon

Have questions about the Business Analyst IT Hiring Test?

What roles can I use the Business Analyst IT Assessment Test for?

Here are few roles for which we recommend this test:

  • Business Analyst
  • IT Analyst
  • Senior IT Business Analyst
  • Systems Analyst
  • Data Analyst
  • Business Systems Analyst
  • Quality Analyst
  • IT Consultant
Can I combine Business Analyst IT Test with SQL questions?

Yes, you can request a custom test that includes questions from both the Business Analyst IT Test and the SQL Online Test.

How to use Business Analyst IT Test in my hiring process?

Purchase the test and send it to candidates. Use it before or after resume screening. Get results immediately to make hiring decisions.

What are the main Business Analysis tests?
Do you have any anti-cheating or proctoring features in place?

We have the following anti-cheating features in place:

  • Non-googleable questions
  • IP proctoring
  • Screen proctoring
  • Web proctoring
  • Webcam proctoring
  • Plagiarism detection
  • Secure browser
  • Copy paste protection

Read more about the proctoring features.

What experience level can I use this test for?

Each Adaface assessment is customized to your job description/ ideal candidate persona (our subject matter experts will pick the right questions for your assessment from our library of 10000+ questions). This assessment can be customized for any experience level.

I'm a candidate. Can I try a practice test?

No. Unfortunately, we do not support practice tests at the moment. However, you can use our sample questions for practice.

Can I get a free trial?

Yes, you can sign up for free and preview this test.

What is Business Analyst IT Test?

The Business Analyst IT Test assesses the skills required for business analysis in IT. Companies use this test for hiring business analysts to evaluate their technical and analytical abilities.

What types of questions are included in the Business Analyst IT Test?

The test includes 5 MCQs each on business analysis, SQL, Excel, data interpretation, logical reasoning and critical thinking. Total duration is 50 minutes.

Can I test SQL and Business Analysis together in a test?

Yes, you can. We recommend using the C#, .NET & SQL Test which combines various skills including SQL.

Can I combine multiple skills into one custom assessment?

Yes, absolutely. Custom assessments are set up based on your job description, and will include questions on all must-have skills you specify. Here's a quick guide on how you can request a custom test.

How do I interpret test scores?

The primary thing to keep in mind is that an assessment is an elimination tool, not a selection tool. A skills assessment is optimized to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best candidate for the role. So the ideal way to use an assessment is to decide a threshold score (typically 55%, we help you benchmark) and invite all candidates who score above the threshold for the next rounds of interview.

Does every candidate get the same questions?

Yes, it makes it much easier for you to compare candidates. Options for MCQ questions and the order of questions are randomized. We have anti-cheating/ proctoring features in place. In our enterprise plan, we also have the option to create multiple versions of the same assessment with questions of similar difficulty levels.

What is the cost of using this test?

You can check out our pricing plans.

I just moved to a paid plan. How can I request a custom assessment?

Here is a quick guide on how to request a custom assessment on Adaface.

customers across world
Join 1500+ companies in 80+ countries.
Try the most candidate friendly skills assessment tool today.
g2 badges
Ready to use the Adaface Business Analyst IT Test?
Ready to use the Adaface Business Analyst IT Test?
logo
40 min tests.
No trick questions.
Accurate shortlisting.
Terms Privacy Trust Guide
ada
Ada
● Online
Previous
Score: NA
Next
✖️