All IIBA exams

Free IIBA-CBDA practice test: 30 questions with answers

30 original questions for Certification in Business Data Analytics (IIBA-CBDA), drawn from every topic area. Answer each one to see whether you got it right and why. No sign-up.

Free questions
30
Full bank
112 questions
Real exam
75 questions, 120 min

IIBA-CBDA exam guide: topics, cost and format

All 30 IIBA-CBDA questions with answers

The same questions as the test above, grouped by exam topic. Open any question to see the answer and explanation.

Identify the Research Questions (5 questions)

  1. Question 1

    A regional airline's operations director says the team needs to look into why flights are late. Before any data is gathered, which revision of this request is best suited to guide the analysis?

    1. AFind out everything we can about flight delays across the network this year.
    2. BAre our flights more punctual than those of competitors on every route we currently serve?
    3. CCan we reduce delays by hiring additional ground crew at the busiest airports before the summer schedule begins?
    4. DWhich airports and aircraft types have the most late arrivals, and what changed in the last two quarters?
    Show answer and explanation
    Correct answer: D

    B is a specific, measurable question that names the dimensions to examine and the time frame, so it can guide data gathering. A is too broad to act on, C assumes a solution before any analysis, and D compares against competitors whose data the operations team is unlikely to have.

  2. Question 2

    Which characteristic best distinguishes a well-formed research question for a business data analytics effort?

    1. AIs the outcome framed around a measurable result and the business decision that the answer will inform?
    2. BWhich software tools and visualization libraries should the analysts plan to use for the final output?
    3. CWill the sponsor agree that the new scheduling tool is the right choice once the analysis is complete?
    4. DIs it broad enough that the team can explore whatever patterns the available data happens to reveal?
    Show answer and explanation
    Correct answer: A

    A well-formed research question is measurable and tied to the decision it will inform. Sponsor agreement is approval rather than evidence, tool choice is a method decision rather than part of the question, and open-ended exploration lacks focus.

  3. Question 3

    Which two elements should be defined before an analyst starts gathering data for a research question? (Choose two.)

    1. AThe business objective that the analysis is meant to support
    2. BThe chart template that the final report will use
    3. CThe success measures that will indicate an answer to the question
    4. DThe database vendor that the organization licenses for its reporting
    5. EThe number of slides that the executive presentation will contain
    Show answer and explanation
    Correct answer: A, C

    The business objective sets the purpose of the analysis, and agreed success measures define what counts as an answer. Chart templates, vendor licences and slide counts are presentation or procurement details that do not determine what data is needed.

  4. Question 4

    A telecom company wants to know whether a new loyalty program is working. The analyst proposes comparing loyalty members with non-members. What is the most important concern with this proposed comparison before the analysis begins?

    1. AComparisons of this kind are only valid when the data is stored in a data warehouse rather than a data lake.
    2. BNon-members may differ systematically from members, so observed gaps could reflect who joined rather than the program itself.
    3. CBoth groups must contain exactly the same number of customers, so members must be removed until the counts match.
    4. DCustomer records created before the program launched cannot be used, because older records are never reliable.
    Show answer and explanation
    Correct answer: B

    The main concern is selection bias: people who join a program often differ from those who do not, so any gap may not be caused by the program. The other options describe requirements that do not exist, since storage type, older records and equal group sizes are not prerequisites for a comparison.

  5. Question 5

    In the context of a business analytics project, what is the main purpose of stating a hypothesis before the analysis begins?

    1. ATo replace the research question by stating the expected answer in place of a question.
    2. BTo guarantee that the data will support the sponsor's preferred conclusion before the analysis starts.
    3. CTo give a testable statement that the data can either support or reject as the analysis proceeds.
    4. DTo list every variable that the analysts plan to record in the enterprise data warehouse.
    Show answer and explanation
    Correct answer: C

    A hypothesis is a testable statement that evidence can confirm or reject. It does not guarantee a result, it complements rather than replaces the research question, and it is not an inventory of variables.

Interpret and Report Results (5 questions)

  1. Question 6

    A regression analysis shows that ice cream sales and drowning incidents rise together across months. What is the most appropriate interpretation?

    1. AThe correlation proves that the two measures have no relationship and can be analyzed separately.
    2. BIce cream sales cause the drowning incidents, so the sales of ice cream should be limited in summer.
    3. CDrowning incidents cause ice cream sales, because people buy ice cream after they finish swimming.
    4. DThe two measures move together, but a shared driver such as hot weather may explain both patterns.
    Show answer and explanation
    Correct answer: D

    Correlation shows that two variables move together but not that one causes the other, and a common driver such as weather often explains both. The other options assert causation in the wrong direction or wrongly claim that correlation proves independence.

  2. Question 7

    A marketing test reports a statistically significant lift in click-through rate. Leadership wants to know whether to roll out the change. What should the analyst highlight?

    1. AThat the result proves the change will raise revenue by the same amount in every market and customer segment.
    2. BThat a significant result means the test is complete and no further testing or monitoring is needed.
    3. CWhether a lift this size is worth its cost, because statistical significance alone does not show business value.
    4. DThat the sample size is irrelevant once a result is significant, so smaller tests are always reliable.
    Show answer and explanation
    Correct answer: C

    Statistical significance indicates that a difference is unlikely to be chance, but it does not show that the difference is large enough to matter for the business. The other options overstate what significance proves about revenue, completeness, or sample size.

  3. Question 8

    Which two practices make a data visualization easier for a business audience to read accurately? (Choose two.)

    1. AUsing a consistent scale and clearly labeled axes on every chart in the report
    2. BUsing a 3D pie chart so that small differences between slices appear more visible
    3. CUsing a line chart to show how a measure changes across consecutive time periods
    4. DUsing many unrelated colors with no legend so that the chart looks more attractive
    5. ETruncating a bar chart's axis without a note so that the gaps look much larger
    Show answer and explanation
    Correct answer: A, C

    Consistent scales and labeled axes let readers compare values accurately, and line charts show change over time clearly. 3D pie charts distort proportions, unlabeled color schemes confuse, and undisclosed axis truncation exaggerates differences.

  4. Question 9

    When preparing an executive summary of an analytics study, which element should appear first?

    1. AThe key findings and the recommended action that they support, stated in plain business language.
    2. BThe complete statistical output tables from every model that was run during the project's lifetime.
    3. CThe names of every software tool and library that the analysts used during the project.
    4. DThe full list of data cleansing steps and the order in which each transformation was applied.
    Show answer and explanation
    Correct answer: A

    Executives need the answer and the decision it supports first, with detail available in supporting sections. Cleansing steps, full output tables and tool names belong in the appendix or methods section, not the opening summary.

  5. Question 10

    An analyst reports that a fraud detection model is 97% accurate, but fraud cases make up only about 3% of transactions. What is the best concern to raise before the result is presented?

    1. AThe model must be retrained every time the number of transactions doubles, so the result is out of date.
    2. BThe result cannot be shared with stakeholders because transaction data is always confidential by nature.
    3. CThe percentage is too high to be credible, so the analyst should rerun the model with fewer input variables.
    4. DThe model may simply predict the common class most of the time, so accuracy alone can hide missed fraud cases.
    Show answer and explanation
    Correct answer: D

    When fraud is rare, a model that rarely flags fraud can still score high accuracy, so the analyst should check measures focused on the rare class. Retraining on volume growth, rerunning with fewer variables, and blanket confidentiality claims do not address the risk of misleading accuracy.

Use Results to Influence Business Decision Making (5 questions)

  1. Question 11

    A product team wants to know whether a new checkout design increases conversions. The analyst proposes randomly showing half of visitors the new design and half the current design. What is this approach, and why is it valuable?

    1. AA descriptive survey, which records what customers say they think about the design in their own words.
    2. BA forecasting exercise, which predicts future conversion rates from the past trend in visitor numbers.
    3. CA data cleansing step, which removes unusual visitor sessions before the conversion rates are computed.
    4. DA controlled experiment such as an A/B test, where randomization helps isolate the effect of the design.
    Show answer and explanation
    Correct answer: D

    Random assignment to two versions creates comparable groups, so differences in conversion can be attributed to the design. A survey, forecast, or cleansing step does not isolate the design's effect on behaviour.

  2. Question 12

    What is the main purpose of piloting a recommended change in a limited area before a full rollout?

    1. ATo avoid the need for any stakeholder approval by proceeding without a formal decision.
    2. BTo collect data that replaces the need for a business case when the rollout is approved later.
    3. CTo make sure the change is always more profitable than the original process it replaces.
    4. DTo test assumptions and measure the impact on a small scale before committing full resources.
    Show answer and explanation
    Correct answer: D

    A pilot tests assumptions and shows real impact at limited cost and risk before a full rollout. It does not remove the need for approval, guarantee profit, or replace a business case.

  3. Question 13

    A logistics analysis recommends consolidating two warehouses, but the operations manager is resistant. Which action is most likely to help the recommendation influence the decision?

    1. ASending the full statistical appendix and asking the manager to interpret the results independently.
    2. BPresenting the trade-offs and risks of each option in terms of the manager's own operational goals.
    3. CHolding back all results until the manager formally asks for them during a scheduled review meeting.
    4. DRepeating the recommendation with more technical terms so that it appears more rigorous to the manager.
    Show answer and explanation
    Correct answer: B

    Framing options and trade-offs around the manager's goals helps the findings influence the decision. Sending raw appendices, adding jargon, or withholding results makes the analysis harder to use.

  4. Question 14

    Why should a business analyst state assumptions and limitations alongside analytical results?

    1. ASo the results can be circulated without a sponsor's approval, since the limits are already disclosed.
    2. BSo the analysis is excused from later review, because the stated limits cover any future problems.
    3. CSo decision makers can judge how much confidence the results deserve and where they might not hold.
    4. DSo that the data no longer needs to be checked by a second analyst before the findings are used.
    Show answer and explanation
    Correct answer: C

    Stated assumptions and limitations let decision makers weigh the evidence appropriately. Disclosure does not excuse later review, approval, or independent checking of the data.

  5. Question 15

    During a pricing analysis, the sample excluded the largest customer segment. The sponsor says they like the answer and asks the analyst to write it up as proof. What should the analyst do?

    1. ADisclose the excluded segment and its likely effect on the conclusion before the findings are used for the decision.
    2. BWrite up the findings as requested, since the sponsor holds final authority over what the analysis reports.
    3. CRemove the sponsor's comment from the project record and proceed with the write-up as originally planned.
    4. DAdd more colorful charts to the report so that the missing segment is less noticeable to the readers.
    Show answer and explanation
    Correct answer: A

    Analysts must be transparent about known limitations that could change the conclusion, even when the sponsor prefers the result. Writing it up without disclosure, deleting the record, or disguising the gap all compromise the decision.

Analyze Data (5 questions)

  1. Question 16

    Which type of analytics answers the question of what is likely to happen next quarter?

    1. APredictive analytics, which estimates likely future outcomes from historical patterns
    2. BDiagnostic analytics, which examines the reasons a particular outcome occurred
    3. CDescriptive analytics, which summarizes what has already happened in a given period
    4. DPrescriptive analytics, which recommends actions to take given a set of possible scenarios
    Show answer and explanation
    Correct answer: A

    Predictive analytics uses historical patterns to estimate what is likely to happen next. Descriptive analytics summarizes the past, diagnostic analytics explains causes, and prescriptive analytics recommends actions.

  2. Question 17

    An analyst builds a loan default model that scores very well on the training data but much worse on new applications. What is the most likely explanation?

    1. AThe model used descriptive statistics, which can only summarize past events rather than support predictions.
    2. BThe model is overfitted to noise in the training data and does not generalize to new applications well.
    3. CThe training data was stored in a data warehouse rather than in a data lake, which changes model accuracy.
    4. DThe model's outputs were not visualized in a dashboard for stakeholders to review before decisions.
    Show answer and explanation
    Correct answer: B

    A model that scores well on training data but poorly on new cases is overfitted and has learned noise rather than general patterns. The other options do not explain a drop in accuracy on new data, since the statistic type, storage choice and dashboards do not cause it.

  3. Question 18

    Which validation approach best reduces the risk of overfitting when evaluating a predictive model?

    1. AHolding out a separate test set or using cross-validation so performance is judged on unseen data.
    2. BAdding more input variables until the training accuracy is as high as possible for the model.
    3. CRemoving all outliers from the test set so the scores look more stable before the model is scored.
    4. DMeasuring accuracy only on the same records that were used to train the model during its development.
    Show answer and explanation
    Correct answer: A

    Testing on data the model has not seen estimates how it will perform on new cases. Scoring on training records gives optimistic results, adding variables to maximize training accuracy tends to increase overfitting, and removing outliers from the test set biases the evaluation.

  4. Question 19

    A sales dataset includes a few transactions that are far larger than typical. Before deciding how to treat them, what should the analyst do?

    1. ADelete the unusual transactions immediately so that the averages look representative of typical sales.
    2. BInvestigate whether the values are entry errors, rare but valid events, or a separate business process.
    3. CReplace the unusual transactions with the mean value of the whole dataset before any further review.
    4. DConvert the unusual transactions into percentages of the total so that they are no longer visible.
    Show answer and explanation
    Correct answer: B

    The right response is to find out why the values are extreme before deciding how to handle them. Deleting, replacing or hiding them without investigation can remove real business activity or hide data errors.

  5. Question 20

    A dataset of customer incomes is strongly skewed by a small number of very high earners. Which summary measure best represents a typical customer?

    1. AThe median, because it is less affected by a small number of extreme values in the distribution.
    2. BThe range, because it shows the full spread between the smallest and largest values in the data.
    3. CThe mean, because it uses every value in the dataset to produce the most typical customer income.
    4. DThe mode, because it is always the most accurate average for any dataset with skewed values.
    Show answer and explanation
    Correct answer: A

    With a skewed distribution, a few very large values pull the mean upward, so the median better represents a typical customer. The range describes spread rather than typical values, and the mode is not always the most accurate average.

Source Data (5 questions)

  1. Question 21

    A manufacturer wants to combine machine sensor logs, maintenance tickets, and supplier spreadsheets to analyze equipment failures. The sensor logs record timestamps in one time zone, while the tickets use local time. What is the best first step?

    1. ADelete every ticket that was created outside the main plant's time zone so that all records line up.
    2. BStandardize the timestamps to one common time zone and record the conversion rule in the data dictionary.
    3. CAnalyze each source separately and avoid joining the sensor logs with the maintenance tickets at all.
    4. DAsk the sensor vendor to regenerate all historical logs in a new format before any analysis is attempted.
    Show answer and explanation
    Correct answer: B

    Aligning timestamps to one time zone and documenting the rule keeps the joined data accurate and traceable. Deleting records loses valid data, avoiding the join prevents the failure analysis from using both sources, and waiting on the vendor is unnecessary.

  2. Question 22

    What is the main difference between a data warehouse and a data lake?

    1. AA lake can hold only text files, while a warehouse can store images, audio, and video recordings.
    2. BA warehouse holds structured, processed data for reporting, while a lake stores large volumes of raw data.
    3. CA warehouse stores raw data in its native formats, while a lake holds only processed and summarized tables.
    4. DA warehouse always runs in the cloud, while a lake must be hosted on local servers within the company.
    Show answer and explanation
    Correct answer: B

    A data warehouse holds structured, processed data for reporting and analysis, while a data lake stores large volumes of raw data in native formats. The reversed description, the claim that only text fits in a lake, and the hosting claim are all inaccurate.

  3. Question 23

    Which two actions help an analyst assess whether a secondary data source is fit for a business analysis? (Choose two.)

    1. AReviewing its metadata and data dictionary to confirm how each field is defined
    2. BConfirming how, when, and by whom the data was originally collected
    3. CAssuming the data is accurate because another department maintains the source
    4. DChoosing the source that produces the most visually attractive dashboard output
    5. ERemoving every record with a blank field without first reviewing the pattern
    Show answer and explanation
    Correct answer: A, B

    Metadata and data dictionaries show what each field means, and knowing how and when data was collected reveals its limits and bias. Assuming accuracy from ownership, choosing sources for visual appeal, or deleting blank records without review are poor practices.

  4. Question 24

    A customer database contains many records with missing postal codes. Before deciding how to handle them, what should the analyst determine first?

    1. AWhether records with missing postal codes can be removed without any further checks on the cause.
    2. BWhether every missing postal code can be replaced with the most common postal code found in the file.
    3. CWhether the missing values follow a pattern linked to a region, sales channel, or collection process.
    4. DWhether the postal code field should be dropped from all future data collection forms and reports.
    Show answer and explanation
    Correct answer: C

    The cause of missing data determines whether it is safe to impute, remove, or fix the collection process. Filling values with a common code or deleting records without checks can bias results, and dropping the field is premature without understanding the cause.

  5. Question 25

    Which sampling approach gives every member of a population a known chance of selection, which supports general conclusions about that population?

    1. ARandom sampling, which selects records so that every member of the population has a known chance of selection.
    2. BConvenience sampling, which uses whichever records are easiest to extract from the existing system without a selection plan.
    3. CJudgmental sampling, which picks the cases the analyst considers the most typical of the whole population.
    4. DVolunteer sampling, which uses only the customers who choose to respond to an optional survey invitation.
    Show answer and explanation
    Correct answer: A

    Random sampling gives each member a known chance of selection, which supports general conclusions about the population. Convenience, judgmental, and volunteer samples introduce selection bias, so their results may not represent the population.

Guide Organization-level Strategy for Business Analytics (5 questions)

  1. Question 26

    Which description best fits a centre of excellence for business analytics?

    1. AOne analyst in each business unit who works separately from other teams to keep work independent.
    2. BA vendor-managed service that replaces all internal analytics staff with outside consultants.
    3. CA central team that sets standards, shares practices, and supports analysts across the business units.
    4. DA project team that is dissolved as soon as the first dashboard is released to the business.
    Show answer and explanation
    Correct answer: C

    A centre of excellence provides shared standards, practices, and support across the organization. Isolated analysts, full outsourcing, and temporary project teams do not build a lasting organization-level capability.

  2. Question 27

    An executive wants the organization to become more data-driven, but departments use different definitions for the same key metrics. What should be the first organization-level step?

    1. APurchase the most advanced predictive modelling tool on the market before agreeing on any definitions.
    2. BLaunch a company-wide dashboard now, since definitions can be refined later once users give feedback.
    3. CRequire each department to create its own metric definitions so that teams can move at their own pace.
    4. DEstablish a data governance structure with agreed metric definitions and named owners for key data.
    Show answer and explanation
    Correct answer: D

    Shared, owned definitions for key metrics are a prerequisite for consistent, data-driven decisions across departments. Tools, dashboards, or separate definitions built before governance tend to produce conflicting answers.

  3. Question 28

    A leadership team must decide how to fund analytics investments across the organization. Which approach best prioritizes these investments?

    1. ARanking initiatives by strategic value, expected benefit, and the readiness of data and skills to deliver them.
    2. BFunding every department's analytics request equally, so that budgets look fair across the whole organization.
    3. CChoosing the newest analytics technology platform first, because the most modern tools tend to deliver results faster.
    4. DFunding only the projects that carry no data risks, so that the investment is always protected from failure.
    Show answer and explanation
    Correct answer: A

    Ranking by strategic value, expected benefit, and readiness directs investment where it will matter and where it can succeed. Equal funding, technology-first choices, and avoiding all data risk do not link investment to strategic outcomes.

  4. Question 29

    Which two elements should an organization-level analytics strategy include? (Choose two.)

    1. AA roadmap that links analytics initiatives to the organization's strategic objectives and priorities.
    2. BA complete inventory of every spreadsheet that staff currently use in their day-to-day work.
    3. CA data literacy development plan so that business users can interpret and question analytical results.
    4. DA fixed list of chart types that every team must use in every report, regardless of the audience.
    5. EA plan to replace all analysts with automated dashboards so that routine questions no longer need staff.
    Show answer and explanation
    Correct answer: A, C

    An analytics strategy connects initiatives to business objectives and builds the skills needed to use the results. Spreadsheet inventories can be useful operationally but are not strategy, while fixed chart rules and replacing analysts are not sound strategic elements.

  5. Question 30

    What is a typical trade-off between a centralized and a decentralized analytics operating model?

    1. AA centralized model offers faster responses to every business unit, while a decentralized model enforces stronger standards.
    2. BA decentralized model removes the need for any data governance at all, while a centralized model requires a much larger budget.
    3. CA centralized model gives consistency and shared standards, while a decentralized model is closer to business needs.
    4. DA centralized model eliminates the need for analysts, while a decentralized model depends entirely on outside consultants.
    Show answer and explanation
    Correct answer: C

    Centralized teams create consistency and shared standards but can be slower to respond to individual units, whereas decentralized analysts sit closer to the business. Reversing these strengths or claiming that either model removes governance and analysts is incorrect.