CBDA Certification in Business Data Analytics (IIBA - CBDA) Questions and Answers
An analytics system is being developed by relying entirely on research questions that are framed using the results from benchmarking. Which research question is being asked?
A colleague proposes measuring job satisfaction by asking the question "What is your salary?". What is the concerning factor about this question?
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?
An analyst is looking at a particular dataset that includes the scores across all 8th grade students, across three schools. The analyst is trying to determine which type of statistics average to use to best represent the results. On looking through the dataset, the analyst has identified a few extreme outliers. As a result, the analyst was led to use the following type of average:
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 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?
An analytics team has been asked to answer the following question: "Given that you're a customer, would you work at our company?" The team is concerned about answering this question because it is:
Based on the results of a recently completed analytics initiative, the Human Resource department for a major department store implemented a change to its hiring practice to address the attrition rates of its sales associates. The new policy stated that candidates applying for sales positions must possess at least 3 years of relevant sales experience to be considered. After implementing the change, attrition rates are 10% higher and management is frustrated. Which of the following could result in this outcome?
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?
Collaborative games are used by a business analyst to identify the research questions to be explored within an analytics system.
Participants are asked to write down a research question on a sticky note, put the notes on the wall, and move them towards related research questions. What type of Collaborative game is being played?
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:
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 is using a Data Flow Diagram (DFD) to depict the flow of data across a data security company. Which of the following is true about DFDs?
The research question prompting the use of analytics is well-defined. The team obtains the results and determines that the source data did not provide reliable results. As a result of this finding, the team modifies the original question to one that can be answered by the data. What is a risk that could impact the value of this analysis?
A professor at a university has received a few complaints of the exams being too difficult. The professor is looking at exam performance results over the past 5 years to understand the normal tendency and outliers. Which chart should the professor use?
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?
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 new dataset describing employee salaries is received by a company. A colleague wonders whether a variable follows a Gaussian distribution. Which of the following plots would demonstrate this?
A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?
A job satisfaction survey is being developed. Half of the employees will be asked the question "Do you enjoy working in your workplace?" The other half will be asked "Do you like the current work benefits?". The business analyst raises concern over the survey. What is concerning to the business analyst?
The analytics team has completed their analytics work and have agreed on a set of five key recommendations. They are now discussing how best to communicate these recommendations to the finance, customer service, and marketing teams. Recognizing that this is a diverse set of stakeholders, the business analysis professional reminds the team:
An analyst is tasked with helping the sales team make better use of its data to support informed business decision making. The analyst creates the following research question 'How can shipping costs be lowered in the northeast to remain competitive?'. This question:
A financial institution is interested in leveraging analytics to address a recent surge in credit card fraud. The company has decided to invest in streaming analytics to obtain instant access to real-time data to stop fraudulent behavior before it occurs. Which practice will help the financial institution integrate the data as it is collected?
A large bank has recently revamped their website, adding additional features such as financial investment opportunities, spending activity, and supporting reports. Which question will add value when evaluating how the website is being used?
The results for a certification exam were revealed in percentage and percentile. How would you infer the results for an attendee at: 75%, 90th percentile?
An HR manager attended a conference where the topic of HR analytics was presented. The manager returned to the office feeling strongly that analytics could be used to guide hiring decisions in the future. Which of the following results would assist the HR team in making such decisions?
A fifty-year-old brick and mortar business is interested in determining the potential for selling their current products online. The sales director has asked the analytics team to predict future sales for their most popular product. A simple question is formed "Would you buy this product online?" The sales director would like to survey students from local colleges and universities within a 50km radius. As a result, the team will conclude:
What is the relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity regardless of whether an order was made?
A consumer product company has recently seen decline in sales in their athletic wear over the last 3 quarters. Along with a customer satisfaction survey on their athletic wear products, a study on the competitive market has been initiated. The analyst working has created a dashboard, integrating the results from the market study with customer feedback. On reviewing with the analytics manager, the feedback received was that the visuals were powerful, but the dashboard lacked narrative. What does the manager mean by this?
An analyst calculates the average, median, and mode values for a dataset. What type of analytics is the analyst performing?
The data analysis completed by the analytics team points to three potential options that could be recommended by the team each of which will help their organization meet their desired goal. Given that there is no significant difference in the results that each option would provide, the team will reach a final recommendation by determining value to be delivered to specific parts of the organization and:
A large number of text messages are received by Twitter each year making Twitter one example of Big Data. What data characteristic represents this large number of text messages?
There were 7 students enrolled in the Introduction to Artificial Intelligence course. The scores from the final exam were as follows: 64, 70. 80, 80, 90, 98, 100
What is the mean and median for the outlined scores?
A company wants to run a monthly promotion on batteries that cost 15 cents each and sells for 50 cents. At this price, they typically sell 1000 batteries and generate a profit of 35 cents per battery for a total profit of $350. The analytics team was asked to test two price points - 20% off (i.e. a sale price of 40 cents) and 40% off (i.e., a sale price of 30 cents). The survey data completed by 10000 participants was analyzed and showed that a 20% savings would result in sales of 1200 batteries and the 40% savings would result in 1800 batteries being sold. The team's initial recommendation was to recommend the 40% discount. Now that they are validating their recommendations, they decide to:
The Vice President at a commercial goods manufacturing company wants to create annual objectives for the team based on the company’s latest strategic goals. The Vice President has reached out to the business analytics team for data analysis that will help build SMART objectives. What type of analytics will help with creating these objectives?
A brainstorming session is conducted to identify the research questions to be explored within an analytics project. During the brainstorming activity which of the following should happen?
The finance manager has reported that customers are taking much longer to remit payments this year than last. They would like help in finding a solution to address the situation. One suggestion was to offer a 10% discount to entice customers to pay their invoices in full within the first 30 days. Before offering the discount, the finance manager would like the analytics team to do some research to determine if there is value in addressing the accounts receivable problem. Which of the following is a valid question to ask in this situation?
DIAGRAM
The following boxplot is produced from a dataset. From this boxplot which of the following conclusions can be drawn?

Year-over-Year Sales
300
200
An analyst is interested in determining whether their company is charging the right prices for their products. Before creating a research question to frame their data analysis, they review a research study provided by the sales department and review several competitor websites. Which statement is true about document analysis?
To ensure their recommendation can be acted upon, the business analysis professional on the analytics team helps the team complete financial analysis to support their recommendation. As part of the financial analysis that's completed, the cost-benefit analysis shows positive net benefits starting in the 2nd year. The team feels this is sufficient to proceed with their strong endorsement of the recommendation. The business analysis professional:
An analyst at an Insurance company has been asked to share results and provide insights into any impacts to the business since a new government regulation took effect. The analyst is in the process of reviewing the analyzed data to identify any patterns. When interpreting results, what would be one of the questions the analyst will be asking?
A marketing department has established an analytics team. The analytics practice is stand-alone and analysts have limited insights into corporate strategy. Which is an expected result for analytics practices operating at the business unit level?
