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

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:

The results of the data analytics work led to some clear and strongly supported outcomes and theanalytics team is very confident in their recommendations; particularly given that the payback on therequired changes are a short 3 months. However, there is concern because the organization operatesin a highly regulated environment and some new regulatory changes are being considered withannouncements and implementation in the next 6 months. Under these conditions the team decidesto:

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 scientist at a consumer goods company, has been asked to do a detailed analysis on customer profiles.The Data Scientist has identified an external data source that carries valuable additional information on their customers. The data scientist also identifies the address column as the most reliable column to join the internal data source with the external data source. Addresses may appear in different formats for example:File A = "13 Smith St"File B = "Unit 7, 13 Smith Street"Which of the following techniques would be useful in this situation?

A large telecommunications company wants to increase their Average Revenue Per User per monthby 5%, by end of year, to increase revenue in a highly competitive market. From a SMART targetperspective, what is missing?

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 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 consumer goods manufacturer has recently completed an analytics study to understand how to improve its operational excellence. From the top highlights, online sales outperformed other channels in sales growth and there was a direct relationship between positive customer reviews and increased internet sales. Which strategic business decision may be logically derived from these results?

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?

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?

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? Weighting is a technique that assigns different values or weights to different records or variables in a dataset, based on their importance or relevance. Weighting can be used to handle missing values by giving them a lower weight or imputing them with a weighted average of other values. Weighting can also help to adjust for sampling bias or non-response bias in the data collection process. Reference: * Understanding the Guide to Business Data Analytics, page 16 * Business Analysis Certification in Data Analytics, CBDA | IIBA, CBDA Competencies, Domain 3: Analyze Data * CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA, page 8, CBDA Exam Sample Questions and Self-Assessment, Question 4

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?

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?

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 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 colleague proposes measuring job satisfaction by asking the question "What is your salary?".What is the concerning factor about this question?

A business analyst constructs a model they would like to review with key business stakeholders but decides to review the model first with the data scientist who has performed the data analysis. The data scientist provides some suggestions on how to reduce the complexity in the model. One suggestion is to use color to group objects needing to be associated. The data scientist is encouraging using which Gestalt Principle of Perception with regards to data visualization?

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?

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?

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:

An analyst at a bank is trying to identify research questions for an analytical study on top customer issues across branches. During an interview with a branch manager, the analyst asks the manager what their top customer concerns are relating to this branch? After the manager's reply, the analyst asks a follow up question on how their top customer concerns compare against the top customer concerns across all branches?Was the analyst's follow-up question valid?

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:

As the organization looks to advance its analytics practices, the topic of provisioning access to executive dashboards and visualizations is under discussion. Establishing standards and implementing role based logins to executive dashboards will address:

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?

An analyst at a bank is trying to identify research questions for an analytical study on top customer issues across branches. During an interview with a branch manager, the analyst asks the manager what their top customer concerns are relating to this branch? After the manager's reply, the analyst asks a follow up question on how their top customer concerns compare against the top customer concerns across all branches?Was the analyst's follow-up question valid?

The results for a certification exam were revealed in percentage and percentile. The results for one of the attendees was: 75%, 90th percentile.What is the value in sharing the percentile score?

The team has completed their analysis on a vast amount of collected data and agree on their recommendations for action. However, they are having difficulty in developing the appropriate messages to support their recommendations. The business analysis professional suggests which technique to assist the team? Storyboarding is a technique that helps the team to develop the appropriate messages to support their recommendations by creating a visual sequence of the main points, evidence, and actions. Storyboarding helps the team to organize their thoughts, identify gaps, and communicate their findings in a clear and compelling way12 Reference: 1: Developing Key Messages for Effective Communication - MSKTC 2: 11 Ways Highly Successful Leaders Support Their Team - Redbooth

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?

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:

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?

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 business analyst is conducting a series of interviews to understand the research questions that will be explored within a new analytics project. Which of the following is true about interviews?

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

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

The outcome from an analytics initiative has resulted in key stakeholders wanting to move forward with a project to redesign the company’s website. The business analyst has called a meeting to work on drafting a plan to assess the level of effort required to complete this work. Many of the invited participants redesigned the website before and were invited so they could provide estimates using their knowledge and experience from the past.The business analyst is using which method to estimate this work?

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?

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

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?

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?

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?

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

Within a public health dataset, 96% of the observations describe 35-year-old men. Which inference is a valid statement?

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?

Which attribute in the Customerissues entity would be categorized as unstructured data?* CustomerlD* ConcernCategory* ConcernSubCategory* AgentID* ComplaintNotes* lssueResolved(Y/N)

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?

With the recent departure of two of its employees, an IT helpdesk team is now understaffed and finding it difficult to keep up with the current workload. The number of tickets being received has increased as well as the number of days to resolve the tickets. The IT manager has set up a meeting with the IT director to request funding for two new helpdesk agents. To prepare for the meeting, the manager is interested in showing the tickets processed against ticket volume over the past year.What type of chart should the manager use to effectively show the change in processing rate over time?

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?