Search test library by skills or roles
⌘ K

About the 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.

Covered skills:

  • Analytical Thinking
  • IT Business models
  • IT Business processes
  • various tools and techniques required for analysis
See all covered skills

9 reasons why
9 reasons why

Adaface 业务分析师IT测试 is the most accurate way to shortlist Business Analysts



Reason #1

Tests for on-the-job skills

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.

The Adaface Business Analyst IT Test screens candidates for the typical skills recruiters look for IT Business Analyst roles:

  • Degree in computer engineering, business administration, or related field
  • Experience in IT management position (for senior roles)
  • Experience in in a technology-driven role
  • Excellent problem-solving skills
  • Strong Analytical skills
  • Exceptional interpersonal skills
  • Excellent written and verbal communication skills
  • Attention to detail

The insights generated from this assessment can be used by recruiters and hiring managers to identify the best candidates for the IT Business Analyst roles. Anti-cheating features enable you to be comfortable with conducting assessments online. The Business Analyst IT Test is ideal for helping recruiters identify which candidates have the skills to do well on the job.

Reason #2

No trick questions

no trick questions

Traditional assessment tools use trick questions and puzzles for the screening, which creates a lot of frustration among candidates about having to go through irrelevant screening assessments.

The main reason we started Adaface is that traditional pre-employment assessment platforms are not a fair way for companies to evaluate candidates. At Adaface, our mission is to help companies find great candidates by assessing on-the-job skills required for a role.

Why we started Adaface ->
Reason #3

Non-googleable 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.

这些只是我们库中有10,000多个问题的一个小样本。关于此的实际问题 Business Analyst IT Test 将是不可行的.

🧐 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
Line Charts
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
Missing data
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
Percentages
median
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
Coding Decoding
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
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
Line Charts
3 mins
Data Interpretation
Solve

Medium

Laptop Brands
Missing data
2 mins
Data Interpretation
Solve

Hard

Median
Percentages
median
3 mins
Data Interpretation
Solve

Medium

Tennis Players
3 mins
Logical Reasoning
Solve

Hard

CID Agent
Coding Decoding
3 mins
Logical Reasoning
Solve

Medium

Positive correlation
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
Line Charts
Data Interpretation
Medium3 mins
Solve
Laptop Brands
Missing data
Data Interpretation
Medium2 mins
Solve
Median
Percentages
median
Data Interpretation
Hard3 mins
Solve
Tennis Players
Logical Reasoning
Medium3 mins
Solve
CID Agent
Coding Decoding
Logical Reasoning
Hard3 mins
Solve
Positive correlation
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
Reason #4

1200+ customers in 75 countries

customers in 75 countries
Brandon

借助Adaface,我们能够优化我们的初始筛查过程超过75%,从而为招聘经理和我们的人才获取团队提供了宝贵的时间!


Brandon Lee, 人头, Love, Bonito

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment Business Analyst IT Test in your hiring process is that it is an elimination tool, not a selection tool. In other words: you want to use the test to eliminate the candidates who do poorly on the test, not to select the candidates who come out at the top. While they are super valuable, pre-employment tests do not paint the entire picture of a candidate’s abilities, knowledge, and motivations. Multiple easy questions are more predictive of a candidate's ability than fewer hard questions. Harder questions are often "trick" based questions, which do not provide any meaningful signal about the candidate's skillset.

Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the Business Analyst IT Test from your dashboard by entering their email address.

Public link: You can create a public link for each test that you can share with candidates.

API or integrations: You can invite candidates directly from your ATS by using our pre-built integrations with popular ATS systems or building a custom integration with your in-house ATS.

invite candidates
Reason #7

Detailed scorecards & benchmarks

Reason #8

High completion rate

Adaface tests are conversational, low-stress, and take just 25-40 mins to complete.

This is why Adaface has the highest test-completion rate (86%), which is more than 2x better than traditional assessments.

test completion rate
Reason #9

Advanced Proctoring


About IT Business Analyst Roles

The IT Business Analyst Test evaluates candidates' ability to fulfil the tasks of an IT business analyst. This test aid employers in selecting candidates who assist their businesses improve goods and services through data analysis.

IT business analysts are professionals in both business administration and information technology. Their key responsibilities include mediating between IT and the executive branch, enhancing the quality of IT services, and analysing business needs.

Typical IT Business Analyst responsibilities include:

  • Interacting with the IT department and the executive branch
  • Serving as a source of information and a conduit for communication between corporate units
  • Understanding key business needs and growth strategies
  • Improving the quality of information technology products and services
  • Analyzing technological system and business model design
  • Using IT data to gain business insights
  • Analyzing business requirements
  • Identifying and deploying new business technology
  • Identifying technical answers to corporate problems
  • Reporting on application development and implementation
  • Analyzing data and running A/B tests
  • Data analysis to inform business decisions

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

  • Business Analyst
  • IT Analyst
  • Senior IT Business Analyst
  • Systems Analyst
  • Data Analyst
  • Business Systems Analyst
  • Quality Analyst
  • IT Consultant

What topics are covered in the 业务分析师IT测试?

Analytical Thinking
IT Business Processes
IT Business Models
Various Tools And Techniques Required For Analysis
Time Management
Communication
Active Listening
Cognitive Competencies
Problem-Solving
Data Interpretation
Risk Management
MS Office Suite
Google Docs
Database Knowledge
ERP systems
SQL
Oral Skills
Interpersonal Skills
Facilitation Skills
Detail-Oriented
Organizational skills
Business Structure
Stakeholder Analysis
Engineering Requirements
Costs Benefit Analysis
Processes Modeling
Networks
Consultative Skills
Accuracy
Databases
Singapore government logo

招聘经理认为,通过小组访谈中他们提出的技术问题,他们能够分辨哪些候选人的得分更好,并且与未得分的人有区别。他们是 非常满意 随着候选人的质量入围了Adaface筛选。


85%
减少筛查时间

常见问题解答

我可以将多个技能结合在一起,为一个自定义评估吗?

是的,一点没错。自定义评估是根据您的职位描述进行的,并将包括有关您指定的所有必备技能的问题。

您是否有任何反交换或策略功能?

我们具有以下反交易功能:

  • 不可解决的问题
  • IP策略
  • Web Protoring
  • 网络摄像头Proctoring
  • 窃检测
  • 安全浏览器

阅读有关[Proctoring功能](https://www.adaface.com/proctoring)的更多信息。

如何解释考试成绩?

要记住的主要问题是评估是消除工具,而不是选择工具。优化了技能评估,以帮助您消除在技术上没有资格担任该角色的候选人,它没有进行优化以帮助您找到该角色的最佳候选人。因此,使用评估的理想方法是确定阈值分数(通常为55%,我们为您提供基准测试),并邀请所有在下一轮面试中得分高于门槛的候选人。

我可以使用该测试的经验水平?

每个ADAFACE评估都是为您的职位描述/理想候选角色定制的(我们的主题专家将从我们的10000多个问题的图书馆中选择正确的问题)。可以为任何经验级别定制此评估。

每个候选人都会得到同样的问题吗?

是的,这使您比较候选人变得容易得多。 MCQ问题的选项和问题顺序是随机的。我们有[抗欺骗/策略](https://www.adaface.com/proctoring)功能。在我们的企业计划中,我们还可以选择使用类似难度级别的问题创建多个版本的相同评估。

我是候选人。我可以尝试练习测试吗?

不,不幸的是,我们目前不支持实践测试。但是,您可以使用我们的[示例问题](https://www.adaface.com/questions)进行练习。

使用此测试的成本是多少?

您可以查看我们的[定价计划](https://www.adaface.com/pricing/)。

我可以免费试用吗?

我刚刚搬到了一个付费计划。我如何要求自定义评估?

customers across world
Join 1200+ companies in 75+ countries.
立即尝试最候选的友好技能评估工具。
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.
术语 隐私 信任指南

🌎选择您的语言

English Norsk Dansk Deutsche Nederlands Svenska Français Español Chinese (简体中文) Italiano Japanese (日本語) Polskie Português Russian (русский)
ada
Ada
● Online
Previous
Score: NA
Next
✖️