DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

Free IIBA CBDA Practice Questions & Answers 2026 Part1 | Certification in Business Data Analytics

Are you preparing for the IIBA CBDA certification exam? SPOTO offers the IIBA CBDA Premium File; all questions are aligned with the latest exam content and come with expert-provided answers. Our question banks cover the latest question types, core concepts, and detailed explanations, helping you familiarize yourself with the exam format and difficulty level. Whether you are reviewing core concepts or simulating a real exam environment, these resources will rapidly boost your confidence and readiness.
For over two decades, SPOTO has successfully helped numerous IT professionals secure their ideal positions at Fortune 500 companies. Download now to start practicing efficiently and ensure a high score on the actual exam. Don't miss this opportunity to pass your certification exam with ease!
Take other online exams

Question #1
A call center has requested to review their sales conversion data for the month. The analyst working on this request is trying to identify the chart that will effectively present the data, which includes: the number of leads, the number of calls made, the number of calls completed, the number of customers interested and the number of sales.What chart should the analyst use to show the values across each stage of the pipeline?
A. Pie chart
B. Funnel chart
C. Bar chart
D. Bullet chart
View answer
Correct Answer: B
Question #2
The analytics team has been asked to determine if the organization should launch their highest revenue generating product into the North American market. To date, this has only been available in Eastern Europe. To answer this, the team formulates several research questions, including:
A. What product launch related costs can we expect?
B. How much revenue does the product generate in Eastern Europe?
C. Why does management need to know this?
D. Do existing customers really like the product?
View answer
Correct Answer: D
Question #3
An analytics team has completed some initial data analysis but is considering revising their research question based on their analysis findings. The team was concerned the original question was too broad.What outcome would lead the team to have this concern?
A. Data once analyzed had significant data quality issues
B. Data the team had planned to use was not available
C. Difficult to identify the KPIs to measure
D. The source data sets could not be merged
View answer
Correct Answer: C
Question #4
The analytics team scheduled a meeting with key stakeholders to present their recommendations. The team envisioned this as the final step of their work and fully expected complete acceptance of those recommendations, particularly given that very few questions were asked. They were surprised when they received word that the organization wasn't ready to move forward.What did they overlook?
A. Stakeholders need to hear the same information multiple times
B. Stakeholders never make quick decisions
C. Communicating information requires a written report
D. Communicating information is bi-directional and iterative
View answer
Correct Answer: D
Question #5
A business analyst is running a focus group to review the findings from a recent analytics project. The analyst would like to use the focus group to uncover opinions and attitudes about the results.Which of the following provides an example of a well-run focus group?
A. The subsequent report included areas of agreement and disagreement
B. The business analyst conducted a freeform discussion to gather a general sense of stakeholders’ opinions
C. The group selected a representative who spoke on behalf of the team
D. The stakeholders were delighted with the findings and no discussion is recorded as everyone is satisfied
View answer
Correct Answer: A
Question #6
What is the difference between supervised and unsupervised machine learning?
A. There is no difference between supervised and unsupervised learning
B. Unsupervised learning is used for classification tasks while supervised learning is used for clustering tasks
C. Supervised learning is used for clustering tasks while unsupervised learning is used for regression tasks
D. Unsupervised learning requires labeled data while supervised learning does not
E. Supervised learning requires labeled data while unsupervised learning does not
View answer
Correct Answer: E
Question #7
Insights based on the data collected indicate that a multi-national company could increase its sales of a mature product by reducing its price by 20% which would result in increased revenues of 2% over a 6-month period. The team recommends this as an appropriate goal for its organization.This is considered a good goal because:
A. It meets all the criteria for a well-defined objective
B. The organization can derive additional revenue from the product
C. Management will be pleased that the mature product can still contribute to revenue
D. It indicates that the company does not have to incur costs associated with retiring this product
View answer
Correct Answer: A
Question #8
To gain traction on online sales, a retailer initiated a marketing campaign using banner ads. The company has requested their analytics team to evaluate the performance of the campaign. During the presentation, the analyst confirmed that the campaign did bring in a large number of net new customers to the website and met the target sales conversion rate. They also noted that there was a high number of repeat visitors not completing a sale. What decision would help the retailer improve sales conversion rates for repeat visitors?
A. ncentivize customers to subscribe to promotional notifications
B. dd additional new products to attract customers
C. nsure the sales checkout process is streamlined
D. ncrease investment in banner ads
View answer
Correct Answer: C
Question #9
The marketing department for a major restaurant chain is interested in testing a Kids Eat Free campaign to determine if it will help to increase sales. They are interested in piloting the campaign to determine which day of the week will improve sales the most. The campaign is launched across 7 cities with each city promoting a different day of the week. The sales data is collected and provided to a team for analysis.What concern might the analytics team have regarding data quality across cities?
A. Normality
B. Heteroskedacity
C. Linearity
D. Variation
View answer
Correct Answer: D
Question #10
A manufacturing company, specializing in turf maintenance equipment, has recently seen a decline in their lawn mower sales. As a result, the analytics team is asked to review the latest customer satisfaction survey results. An analyst on this team creates a report for senior management with attractive visuals, supported by the KPI results. Upon reviewing the report, the analyst's manager mentions that the report is missing the narrative.What does this mean?
A. The data tables that support the visuals and help answer questions
B. A narrative that supports insights with additional context and draws correlations
C. Notes on assumptions and unavailable data for analysis
D. Commentary around why each graphic was selected to provide additional context
View answer
Correct Answer: B
Question #11
A restaurant chain is interested in deploying more efficient methods for servicing its customers. The sales manager has asked the analytics team to help answer the question ‘Will customers purchase less food if asked to use self-service features’?A predictive model is built to perform the research but the team is unsure of its mathematical accuracy in determining customer behavior.Which technique could the team use to validate the model for accuracy?
A. Forecasting
B. Simulation
C. Process modeling
D. Regression analysis
View answer
Correct Answer: B
Question #12
The results of the data analytics work led to some clear and strongly supported outcomes and the analytics team is very confident in their recommendations; particularly given that the payback on the required changes are a short 3 months. However, there is concern because the organization operates in a highly regulated environment and some new regulatory changes are being considered with announcements and implementation in the next 6 months. Under these conditions the team decides to:
A. Recommend no action be taken at this time and revisit in 6 months
B. Reassess their results to ensure their validity and then decide what to do
C. Identify and carefully document assumptions for their recommendation
D. Postpone recommendations for 6 months until the announcements are made
View answer
Correct Answer: C
Question #13
An insurance company has seen an upward trend in winter-related accidents over the past threeyears. The company has just completed an analytics study to better understand the primary reasonsfor these accidents and assess how many of the drivers were using winter tires. This analysis will helpthe company decide how to move forward with drivers not taking precautionary measures duringwinter. What type of analysis will help in determining the primary reasons and percentage of thosedrivers with winter tires?
A. rescriptive
B. escriptive and Predictive
C. escriptive
D. escriptive and Diagnostic
View answer
Correct Answer: D
Question #14
A financial software company has growth and expansion as one of their top strategic priorities for the year. The senior executive team would like to assess their sales performance over the last 3 years to help set sales objectives. In discussion with the business analytics manager, for a comprehensive sales report, the sales lead recommends looking into the number of contracts signed over the past 3 years and the dollar value for the signed contracts.Which other question is important to consider when evaluating sales performance?
A. What is the average time for conversion?
B. What is the total cost incurred per year?
C. What is the number of customers retained over the past 3 years?
D. What is the time to market the software?
View answer
Correct Answer: C
Question #15
Interested in experimenting with analytics, a manufacturing company hires an analyst to see how the capability can be developed within its organization. The analyst is getting started and recognizes the need to show value from the onset of their work to gain upper management's trust and future funding.What action will accomplish these objectives?
A. Solve the biggest problem the organization has first to quickly grab the support and attention of senior management
B. Develop a question that can be answered quickly regardless of alignment to strategy, just to get started
C. Develop a meaningful question that can be answered with data the company already has in its possession
D. Perform a market analysis to understand how competitors are using analytics and then launch a similar initiative
View answer
Correct Answer: C
Question #16
A call center has requested to review their sales conversion data for the month. The analyst working on this request is trying to identify the chart that will effectively present the data, which includes: the number of leads, the number of calls made, the number of calls completed, the number of customers interested and the number of sales.What chart should the analyst use to show the values across each stage of the pipeline?
A. Pie chart
B. Funnel chart
C. Bar chart
D. Bullet chart
View answer
Correct Answer: B
Question #17
A government agency is conducting a study on the performance of 12th grade students' in mathematics across the country. In particular, they want to understand if there is a relationship between intelligence and scores, as well as the difference in performance between various locations.Which combination of inferential statistics procedures should be used?
A. Range, standard deviation
B. Mean, median
C. Correlation co-efficient, analysis of variance
D. Frequency distribution, time-series
View answer
Correct Answer: C
Question #18
The analytics team is identifying research questions to address a business problem. The business analysis professional reminds the team that the most important dimension to consider is the:
A. Sources of data
B. Quality of the data
C. Timeframe of analysis
D. Measurement scale
View answer
Correct Answer: B
Question #19
The analytics team has completed analyzing a dataset and unfortunately the data didn't deliver the kinds of insights that the team was hoping for. After much contemplation, they decide to:
A. Summarize the results and indicate the outcome was inconclusive
B. Inform management that analytics could not derive insightful results
C. Wait a few weeks and rerun the analysis using refreshed data
D. Restart the work with formation of a new research question
View answer
Correct Answer: D
Question #20
A Human Resource manager recently learned that their competitor reduced employee attrition rates by 20% after implementing personality tests as part of their screening process. Intrigued by the idea, the manager suggests collecting data on personality tests and attrition rates over the next year. The data from this year is then analyzed to explore possible relationships.What type of analytics has the team been asked to perform?
A. Predictive
B. Descriptive
C. Prescriptive
D. Diagnostic
View answer
Correct Answer: B
Question #21
A lab is conducting a study on protein interactions. They have used the data to create a graph visualization. In graph visualization, what would a layout be?
A. A single data point
B. A link between two data points
C. A dedicated algorithm that calculates the node positions
D. A collection of data points and links
View answer
Correct Answer: C
Question #22
A lab is conducting a study on protein interactions. They have used the data to create a graph visualization. In graph visualization, what would a layout be?
A. AA single data point
B. BA link between two data points
C. CA dedicated algorithm that calculates the node positions
D. DA collection of data points and links
View answer
Correct Answer: C
Question #23
While creating a dataset for analysis, the analyst reviews the data collected and finds a large percentage of records are missing values.Which activity would the analyst perform in order to use this dataset?
A. Clustering
B. Scale validation
C. Weighting
D. Factor analysis
View answer
Correct Answer: C
Question #24
While creating a dataset for analysis, the analyst reviews the data collected and finds a large percentage of records are missing values.Which activity would the analyst perform in order to use this dataset?
A. Clustering
B. Scale validation
C. Weighting
D. Factor analysis
View answer
Correct Answer: C
Question #25
An insurance company has seen an upward trend in winter-related accidents over the past three years. The company has just completed an analytics study to better understand the primary reasons for these accidents and assess how many of the drivers were using winter tires. This analysis will help the company decide how to move forward with drivers not taking precautionary measures during winter.What type of analysis will help in determining the primary reasons and percentage of those drivers with winter tires?
A. Prescriptive
B. Descriptive and Predictive
C. Descriptive
D. Descriptive and Diagnostic
View answer
Correct Answer: D
Question #26
An analytics team has completed some initial data analysis but is considering revising their research question based on their analysis findings. The team was concerned the original question was too broad.What outcome would lead the team to have this concern?
A. Data once analyzed had significant data quality issues
B. Data the team had planned to use was not available
C. Difficult to identify the KPIs to measure
D. The source data sets could not be merged
View answer
Correct Answer: C
Question #27
The analytics team scheduled a meeting with key stakeholders to present their recommendations. The team envisioned this as the final step of their work and fully expected complete acceptance of those recommendations, particularly given that very few questions were asked. They were surprised when they received word that the organization wasn't ready to move forward.What did they overlook?
A. Stakeholders need to hear the same information multiple times
B. Stakeholders never make quick decisions
C. Communicating information requires a written report
D. Communicating information is bi-directional and iterative
View answer
Correct Answer: D
Question #28
The analytics team has completed analyzing a dataset and unfortunately the data didn't deliver the kinds of insights that the team was hoping for. After much contemplation, they decide to:
A. Summarize the results and indicate the outcome was inconclusive
B. Inform management that analytics could not derive insightful results
C. Wait a few weeks and rerun the analysis using refreshed data
D. Restart the work with formation of a new research question
View answer
Correct Answer: D
Question #29
As the team discusses how to utilize the results of their data analysis to put forth a business recommendation, an analyst on the team voices concern over the current organizational culture presenting a roadblock to their ability to influence business decision making.Which of the following would be a justifiable concern at this stage of the team’s efforts?
A. Finding data that creates value creating difficulties, as not all data helps a business make better decisions
B. Changing the mindsets of business stakeholders to trust insights gleaned from data over experience and intuition
C. Difficulty bringing business stakeholders to a shared understanding about value when sharing data assets across business domains
D. Applying a myopic view of data and establishing data silos which create roadblocks to exploring available data sources
View answer
Correct Answer: B
Question #30
An analytics team has completed some initial data analysis but is considering revising their research question based on their analysis findings. The team was concerned the original question was too broad.What outcome would lead the team to have this concern?
A. Data once analyzed had significant data quality issues
B. Data the team had planned to use was not available
C. Difficult to identify the KPIs to measure
D. The source data sets could not be merged
View answer
Correct Answer: C
Question #31
The CustomerOrder entity will include information on all customer orders. Applying database normalization rules, which set of attributes will need to be normalized to avoid redundancies?*Customerld*CustomerPhone*Orderld*OrderDate*ProductName*ProductQuantity*OrderTotal
A. ustomerldOrderDate
B. rderldProductName
C. roductNameProductQuantity
D. ustomerPhoneProductName
View answer
Correct Answer: C
Question #32
An analytics team has completed some initial data analysis but is considering revising their research question based on their analysis findings. The team was concerned the original question was too broad.What outcome would lead the team to have this concern?
A. Data once analyzed had significant data quality issues
B. Data the team had planned to use was not available
C. Difficult to identify the KPIs to measure
D. The source data sets could not be merged
View answer
Correct Answer: C
Question #33
A business analyst manager is planning budgets for the new year, and training opportunities for his team of business analysts. The manager sends out a survey to the team to obtain their top interests within the seven areas of training opportunities. The team results were compared against the manager's personal rating. What can be deduced from the following chart with regards to the survey results?
A. he team's top interests in training opportunities were aligned with the manager's, which included Negotiation & Conflict Resolution and Facilitation
B. he manager's rating did not match with the team's rating for any of the training areas
C. he team had equal interest across all training areas
D. he team's top interests in training opportunities were aligned with the manager's, which included Teamwork and Adaptability
View answer
Correct Answer: A
Question #34
When comparing two data sources for the same set of employees, an analyst found that one of the data sources had the format for the start date as dd/mm/yyyy, while the other data source had the format as dd-mm-yyyy.Which data quality dimension is being evaluated here?
A. Validity
B. Accuracy
C. Consistency
D. Uniqueness
View answer
Correct Answer: C
Question #35
A Human Resource manager recently learned that their competitor reduced employee attrition rates by 20% after implementing personality tests as part of their screening process. Intrigued by the idea, the manager suggests collecting data on personality tests and attrition rates over the next year. The data from this year is then analyzed to explore possible relationships. What type of analytics has the team been asked to perform?
A. Predictive
B. Descriptive
C. Prescriptive
D. Diagnostic
View answer
Correct Answer: B
Question #36
The analytics team scheduled a meeting with key stakeholders to present their recommendations. The team envisioned this as the final step of their work and fully expected complete acceptance of those recommendations, particularly given that very few questions were asked. They were surprised when they received word that the organization wasn't ready to move forward.What did they overlook?
A. Stakeholders need to hear the same information multiple times
B. Stakeholders never make quick decisions
C. Communicating information requires a written report
D. Communicating information is bi-directional and iterative
View answer
Correct Answer: D
Question #37
A marketing director has asked the question 'How many product purchases are expected this coming year given the current marketing campaign?".What type of analytics would be performed to answer this question?
A. Descriptive
B. Predictive
C. Diagnostic
D. Prescriptive
View answer
Correct Answer: B
Question #38
An analytics team has completed some initial data analysis but is considering revising their research question based on their analysis findings. The team was concerned the original question was too broad.What outcome would lead the team to have this concern?
A. Data once analyzed had significant data quality issues
B. Data the team had planned to use was not available
C. Difficult to identify the KPIs to measure
D. The source data sets could not be merged
View answer
Correct Answer: C
Question #39
Interested in experimenting with analytics, a manufacturing company hires an analyst to see how the capability can be developed within its organization. The analyst is getting started and recognizes the need to show value from the onset of their work to gain upper management's trust and future funding.What action will accomplish these objectives?
A. Develop a question that can be answered quickly regardless of alignment to strategy, just to get started
B. Solve the biggest problem the organization has first to quickly grab the support and attention of senior management
C. Develop a meaningful question that can be answered with data the company already has in its possession
D. Perform a market analysis to understand how competitors are using analytics and then launch a similar initiative
View answer
Correct Answer: C
Question #40
A large telecommunications company wants to increase their Average Revenue Per User per month by 5%, by end of year, to increase revenue in a highly competitive market. From a SMART target perspective, what is missing?
A. T - The increase should be seen sooner
B. A - It is too easy of a target to attain
C. R - Since competition is high, focus should be on increasing customer base and not on ARPU
D. S - There is no mention of which product group/line the target pertains to
View answer
Correct Answer: D
Question #41
The analytics team scheduled a meeting with key stakeholders to present their recommendations. The team envisioned this as the final step of their work and fully expected complete acceptance of those recommendations, particularly given that very few questions were asked. They were surprised when they received word that the organization wasn't ready to move forward.What did they overlook?
A. Stakeholders need to hear the same information multiple times
B. Stakeholders never make quick decisions
C. Communicating information requires a written report
D. Communicating information is bi-directional and iterative
View answer
Correct Answer: D
Question #42
While creating a dataset for analysis, the analyst reviews the data collected and finds a large percentage of records are missing values.Which activity would the analyst perform in order to use this dataset?
A. Clustering
B. Scale validation
C. Weighting
D. Factor analysis
View answer
Correct Answer: C
Question #43
A colleague proposes measuring job satisfaction by asking the question "What is your salary?". Whatis the concerning factor about this question?
A. alidity
B. larity
C. eproducibility
D. ubjectivity
View answer
Correct Answer: A
Question #44
A manufacturing company, specializing in turf maintenance equipment, has recently seen a decline in their lawn mower sales. As a result, the analytics team is asked to review the latest customer satisfaction survey results. An analyst on this team creates a report for senior management with attractive visuals, supported by the KPI results. Upon reviewing the report, the analyst's manager mentions that the report is missing the narrative.What does this mean?
A. The data tables that support the visuals and help answer questions
B. A narrative that supports insights with additional context and draws correlations
C. Notes on assumptions and unavailable data for analysis
D. Commentary around why each graphic was selected to provide additional context
View answer
Correct Answer: B
Question #45
An analytics team has completed some initial data analysis but is considering revising their research question based on their analysis findings. The team was concerned the original question was too broad.What outcome would lead the team to have this concern?
A. Data once analyzed had significant data quality issues
B. Data the team had planned to use was not available
C. Difficult to identify the KPIs to measure
D. The source data sets could not be merged
View answer
Correct Answer: C
Question #46
The analytics team has completed analyzing a dataset and unfortunately the data didn't deliver the kinds of insights that the team was hoping for. After much contemplation, they decide to:
A. Summarize the results and indicate the outcome was inconclusive
B. Inform management that analytics could not derive insightful results
C. Wait a few weeks and rerun the analysis using refreshed data
D. Restart the work with formation of a new research question
View answer
Correct Answer: D
Question #47
An online retailer has been successful utilizing analytics to guide decisions on product placement and marketing spend. Management has requested a task force be assembled to make recommendations on how to further develop their analytics capabilities. To begin this work, the task force builds a model to develop a shared understanding about customer segments, customer relationships, key partnerships, and the company’s value proposition.The team has leveraged the following model to facilitate this discussion?
A. CATWOE
B. Business model canvas
C. Balanced scorecard
D. Value chain analysis
View answer
Correct Answer: B
Question #48
The analytics team is identifying research questions to address a business problem. The business analysis professional reminds the team that the most important dimension to consider is the
A. Sources of data
B. Quality of the data
C. Timeframe of analysis
D. Measurement scale
View answer
Correct Answer: B
Question #49
The analytics team has completed analyzing a dataset and unfortunately the data didn't deliver the kinds of insights that the team was hoping for. After much contemplation, they decide to:
A. Summarize the results and indicate the outcome was inconclusive
B. Inform management that analytics could not derive insightful results
C. Wait a few weeks and rerun the analysis using refreshed data
D. Restart the work with formation of a new research question
View answer
Correct Answer: D
Question #50
An analytics team has completed some initial data analysis but is considering revising their research question based on their analysis findings. The team was concerned the original question was too broad.What outcome would lead the team to have this concern?
A. Data once analyzed had significant data quality issues
B. Data the team had planned to use was not available
C. Difficult to identify the KPIs to measure
D. The source data sets could not be merged
View answer
Correct Answer: C

View The Updated IIBA Exam Questions

SPOTO Provides 100% Real IIBA Exam Questions for You to Pass Your IIBA Exam!

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:
Contact Us