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

Question #1

DIAGRAM TAKEN

A. 3

B. 1

C. 4

D. 2

View answer

Correct Answer: C

Question #2

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 #3

The marketing department for a major restaurant chain is interested in testing a Kids Eat Freecampaign to determine if it will help to increase sales. They are interested in piloting the campaignto 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. Thesales data is collected and provided to a team for analysis. What concern might the analytics teamhave regarding data quality across cities?

A. ormality

B. eteroskedacity

C. inearity

D. ariation

View answer

Correct Answer: D

Question #4

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 #5

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 #6

A model is developed to communicate the correlation between two variables. Which diagram is produced?

A. Bar Chart

B. Box Plot

C. Scatter Plot

D. Pie Chart

View answer

Correct Answer: C

Question #7

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 #8

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 #9

The definition of data elements is different across various data sources. The organization is looking to improve the usability of data across the organization.Which practice would help address this problem?

A. Data governance

B. Data quality

C. Data architecture

D. Data ethics

View answer

Correct Answer: A

Question #10

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. It indicates that the company does not have to incur costs associated with retiring this product

D. Management will be pleased that the mature product can still contribute to revenue

View answer

Correct Answer: A

Question #11

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 #12

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 #13

An organization's customers are categorized based on the amount of purchases completed over the last 12 months. The analytics team would like to ensure the accuracy of their survey results and decide to randomly select 500 customers to participate in a survey from this large pool of customers.This is an example of:

A. Stratified sampling

B. Quota sampling

C. Purposive sampling

D. Snowball sampling

View answer

Correct Answer: A

Question #14

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 #15

A data scientist is performing statistical analysis and is interested in graphically depicting the data set according to the associated quartiles Minimum, First Quartile, Median, Second Quartile, Third Quartile. Which technique would allow for the display of this statistical five number summary?

A. AGaussian distribution

B. BScatter plot

C. CMultivariate histogram

D. DBox plot

View answer

Correct Answer: D

Question #16

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 #17

Results of the data analysis have been analyzed and the team was confident with the results but also quite surprised the outcome was not what was expected. In pondering the value of what can be gleaned from the data, the team has no feasible solution to put forth to address the business need. A logical next step would be to:

A. ARepeat the business analytics cycle with the formation of a new research question

B. BProvide the results to a 2nd analytics team to see if similar conclusions are drawn

C. CAnalyze the data again, to determine if any insights were overlooked

D. DCheck the quality of the data that was used for the analysis

View answer

Correct Answer: A

Question #18

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. hat is the average time for conversion?

B. hat is the total cost incurred per year?

C. hat is the number of customers retained over the past 3 years?

D. hat is the time to market the software?

View answer

Correct Answer: C

Question #19

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 #20

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. evelop a question that can be answered quickly regardless of alignment to strategy, just to get started

B. olve the biggest problem the organization has first to quickly grab the support and attention of senior management

C. evelop a meaningful question that can be answered with data the company already has in its possession

D. erform a market analysis to understand how competitors are using analytics and then launch a similar initiative

View answer

Correct Answer: C

Question #21

An analytics team completed their research to determine why customers are abandoning items in their online shopping cart. The team suggests improvements to the website to address the problem. The Director of Sales proclaims that the current website is fine and indicates that the problem materialized when the company increased its shipping rates. The solution proposed by the team seems misaligned. What has gone wrong?

A. This scenario cannot be addressed with analytics

B. The team has not agreed on the root cause of the problem

C. The team did not agree on the business problem

D. An insufficient amount of planning was performed

View answer

Correct Answer: C

Question #22

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 #23

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 #24

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 #25

An organization's customers are categorized based on the amount of purchases completed over the last 12 months. The analytics team would like to ensure the accuracy of their survey results and decide to randomly select 500 customers to participate in a survey from this large pool of customers.This is an example of:

A. Stratified sampling

B. Quota sampling

C. Purposive sampling

D. Snowball sampling

View answer

Correct Answer: A

Question #26

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 #27

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 #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

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 #30

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 #31

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 #32

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 #33

An analyst at a supermarket chain has been asked to extract data from multiple data sources to complete a study on customer spending habits. The analyst is going to query data from various databases.Which statement is true about database querying?

A. Querying can be used to create predictive data models

B. Irrespective of the querying language used, data results retrieved are always in a tabular format

C. A querying language is independent of the type of database being used

D. Querying is a structured way of searching, manipulating and managing data

View answer

Correct Answer: D

Question #34

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 #35

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 #36

A call center has requested to review their sales conversion data for the month. The analyst workingon this request is trying to identify the chart that will effectively present the data, which includes: thenumber of leads, the number of calls made, the number of calls completed, the number ofcustomers interested and the number of sales. What chart should the analyst use to show the valuesacross each stage of the pipeline?

A. ie chart

B. unnel chart

C. ar chart

D. ullet chart

View answer

Correct Answer: B

Question #37

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 #38

Operation managers are concerned about the increasing attrition rates in the call center. A series of interviews is being conducted with call center agents to collect information to better understand the problem.Interviewees will ask open and closed ended questions that are both quantitative and qualitative. Which of the following is considered a qualitative open-ended question?

A. ould morale improve if you could work 2 days per week from home?

B. ow does call volume contribute to job burnout?

C. o you receive more calls on Mondays or Fridays?

D. ow many calls on average do you service in an hour?

View answer

Correct Answer: B

Question #39

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 #40

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 #41

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 #42

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 #43

An analyst has just completed building a data model that shows the table structures including table names, table relationships with primary and foreign keys and column names with respective data types.What type of data model has the analyst just built?

A. Physical

B. Hierarchical

C. Conceptual

D. Logical

View answer

Correct Answer: A

Question #44

An analyst at a supermarket chain has been asked to extract data from multiple data sources to complete a study on customer spending habits. The analyst is going to query data from various databases. Which statement is true about database querying?

A. Querying can be used to create predictive data models

B. Irrespective of the querying language used, data results retrieved are always in a tabular format

C. A querying language is independent of the type of database being used

D. Querying is a structured way of searching, manipulating and managing data

View answer

Correct Answer: D

Question #45

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 #46

A large car manufacturer is interested in comparing the number of sales for a specific model of electric car across all 50 US states.The data analytics team sourced and acquired the data, and the business analyst created the model to compare sales across states.In a meeting to review the results, the feedback received included several complaints concerning an inability to distinguish the number of sales per state.What model would result in such confusion?

A. Bullet chart

B. Dual axis chart

C. Bar chart

D. Pie chart

View answer

Correct Answer: D

Question #47

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 #48

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 #49

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 #50

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. APrescriptive

B. BDescriptive and Predictive

C. CDescriptive

D. DDescriptive and Diagnostic

View answer

Correct Answer: D

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now

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

View The Updated IIBA Exam Questions

View Answers after Submission

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE Get Now

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

View The Updated IIBA Exam Questions

View Answers after Submission

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now