CBDA Exam Dumps (V9.02) of DumpsBase – Your Way to Achieve Success in Certification in Business Data Analytics (IIBA – CBDA) Exam

1. 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:

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

3. 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:

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

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

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

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

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

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?

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:

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

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

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

14. 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:

15. 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:

16. A colleague proposes measuring job satisfaction by asking the question "What is your salary?".

What is the concerning factor about this question?

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

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

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

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

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

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

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

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?

25. 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:

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

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

28. A real estate broker is tracking monthly sales between two of its teams. The results have been visualized.

What insights can be drawn from the chart?

29. The analytics team has been asked to assess sales data from their company's website with the hopes of providing insights to help increase online sales. It's the first time the team is looking at this specific data and they are concerned about the quality of data that has been captured.

They decide to use the following approach as the next step:

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

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

32. An online retailer of men's athletic apparel is seeking to become the market leader in the industry. To deliver on this strategy, the analytics team continuously collects data on the prices of competitor products and uses this information to adjust the retailer's prices.

What type of analytics is the retailer using to maintain their pricing structure?

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

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

35. The analytics team has established two equally strong potential recommendations which will deliver the desired outcomes with similar benefits to be derived from each one. On the surface there is no discernable difference in costs or schedule for either option.

To help the analytics team reach a recommendation the business analysis professional recommends the team:

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

37. A company wants to gauge the thoughts of their employees towards a new company product. On the 25th of March the interviewer makes a list of all employees who were at work on that day and then chooses a subset of those employees to interview.

Which term describes the list of all employees present on March 25th?

38. A Data Dictionary is being developed for an employee database. When reviewing the data dictionary, the analyst recommends adding another primitive data element.

Which element would be suggested?

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

40. Senior executives in a large organization receive numerous sales reports of every sale through a corporate dashboard on a weekly basis. The executives are considering budget increases for various functions but would like to know if they are obtaining good returns for current budget allocations. They ask the analytics team to research and answer: "How effective is our marketing spend?" This question is:

41. The analytics team is struggling with which recommendation to make. Their challenge is that they have five good options and this indecision is stopping them from moving forward.

To help the team finalize their recommendation, the BA professional on the team recommends they complete:

42. The analytics team is assessing the results of their analysis. They are surprised to find that their data indicates two events seem to be strongly related even though the general belief in the organization is that they are independent of each other. Knowing that this information will be used for decision making, they are concerned about presenting this data.

At an impasse, the business analysis professional reminds them that the data can be presented as long as the team has:

43. 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:

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

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

46. While sourcing data, an analyst runs into a situation where different business units are using different names to refer to the same data element. This lack of standardization is resulting in confusion and additional time required to properly prepare data for analysis.

Which practice, if implemented would address this situation and mature the organization's business analytics practice?

47. A dataset contains 10 measures of workplace sustainability. The analytics team is in need of producing a single score of sustainability.

Which of the following techniques if used would achieve this objective?

48. 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:

49. A software company launched a new product in late 2016. The product manager is reviewing a Box and Whisker plot used to compare year-over-year sales, from 2017 to 2018.

What is the conclusion he can make from this chart?

50. The interplay between enterprise systems and data analytics can be envisioned at various layers.

The layer that connects the business processes to data analytics is the:

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

52. A database analyst is modelling a database for a large toy manufacturer.

Which statement describes a logical database model?

53. A professional association is funded by membership fees. The membership renewal occurs every 5 years. Although, they have a strong subscription rate each year, their renewal rate is low. They are working with an external firm specializing in Business Analytics to identify the groups of customers that have a high likelihood of cancelling their subscription after their first 5-year term ends.

This type of study is called:

54. Which attributes from the Order entity will need to be normalized to avoid redundancies?

. Orderld

. OrderDate

. Itemld

. ItemName

. Quantity

. ItemPrice

55. The architecture team puts forth a solution architecture that integrates multiple data sources from within and outside the organization. The architecture provides the foundation to source a new analytics program.

If one of the objectives of the analytics team was to provide 'one source of the truth', this objective would be referring to which of the following?

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

57. An analytics team is interested in reviewing the results of a public opinion poll that is going to be conducted at the end of the month. One of the factors the team is interested in, is ensuring the result set is statistically significant.

Why would this factor be important to the team?

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

59. The analytics team has been asked to provide an estimate of the number of customers they expect to have in 12 months. They debated how accurate that figure needs to be and determined that based on the availability of good data, they could predict within + or - 10%.

This is an example of a:

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