IIBA IIBA Certifications CBDA Questions & Answers

• Question 81:

  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?

  A. Street address

  B. First name

  C. Customer name

  D. Work phone number

  Correct Answer: A

  A street address is a primitive data element, because it is a basic unit of data that cannot be further decomposed into smaller components. A primitive data element has a distinct name, definition, format, and value domain. A street address can be used to identify the location of an employee or a customer, and it can be stored as a string or a combination of numbers and characters. Options B, C, and D are not primitive data elements, because they can be further broken down into smaller components. For example, a first name can be divided into a prefix, a given name, and a suffix. A customer name can be composed of a first name and a last name. A work phone number can be split into a country code, an area code, and a local number.

• Question 82:

  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. How does call volume contribute to job burnout?

  B. Would morale improve if you could work 2 days per week from home?

  C. How many calls on average do you service in an hour?

  D. Do you receive more calls on Mondays or Fridays?

  Correct Answer: A

  A qualitative open-ended question is a question that allows the respondent to express their thoughts, feelings, or opinions in their own words, without being constrained by predefined options or categories. A qualitative open-ended question can help the interviewer explore the underlying reasons, motivations, or perceptions of the respondent. Option A is a qualitative open-ended question, because it asks the respondent to explain how call volume affects their job satisfaction and well-being, which may vary from person to person and require elaboration. Options B, C, and D are not qualitative open-ended questions, because they ask the respondent to choose between two alternatives (B and D) or provide a numerical value ? which are quantitative and closed-ended responses.

• Question 83:

  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:

  A. Untrained learning

  B. Supervised learning

  C. Trained learning

  D. Unsupervised learning

  Correct Answer: D

  Unsupervised learning is a type of study that involves finding patterns or clusters in data without any predefined labels or outcomes. It is useful for exploring data and discovering hidden structures or groups of

• Question 84:

  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:

  A. Root cause analysis

  B. Business rules analysis

  C. Data flow diagrams

  D. Acceptance and evaluation criteria

  Correct Answer: D

  Acceptance and evaluation criteria are the techniques that the BA professional on the team should recommend they complete, because they are the standards or measures that are used to evaluate the suitability and value of each option. Acceptance and evaluation criteria can help the team compare the benefits, costs, risks, and impacts of each option, and determine which one best meets the needs and expectations of the stakeholders. Acceptance and evaluation criteria can also help the team communicate the rationale and evidence behind their recommendation, and ensure that the recommendation is aligned with the business goals and objectives.

• Question 85:

  A business analyst manager is planning budgets for the new year, and training opportunities for his team of business analysts. The manager sends out a survey to the team to obtain their top interests within the seven areas of training opportunities. The team results were compared against the manager's personal rating. What can be deduced from the following chart with regards to the survey results?

  A. The team's top interests in training opportunities were aligned with the manager's, which included Negotiation and Conflict Resolution and Facilitation

  B. The team's top interests in training opportunities were aligned with the manager's, which included Teamwork and Adaptability

  C. The manager's rating did not match with the team's rating for any of the training areas

  D. The team had equal interest across all training areas

  Correct Answer: A

  The chart shows the personal rating of the manager and the average team rating on different areas of training opportunities. Both the manager and the team rated "Negotiation and Conflict Resolution" and "Facilitation" highly, indicating a shared interest in these areas. These areas are also relevant for business analysts, as they involve skills such as communication, collaboration, problem-solving, and stakeholder management

• Question 86:

  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?

  A. TThe increase should be seen sooner

  B. AIt is too easy of a target to attain

  C. RSince competition is high, focus should be on increasing customer base and not on ARPU

  D. SThere is no mention of which product group/line the target pertains to

  Correct Answer: D

  A SMART target is one that is specific, measurable, achievable, relevant, and time-bound1. The target of increasing the Average Revenue Per User (ARPU) per month by 5%, by end of year, to increase revenue in a highly competitive market is missing the specificity criterion, as it does not mention which product group or line the target applies to. The target should be more specific and clear about the scope and context of the desired outcome, such as which segment, region, or service the target relates to

• Question 87:

  While sourcing data, an analyst runs into a situation where different business units are usingdifferent 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?

  A. Data quality management

  B. Database operations management

  C. Data warehousing

  D. Meta data management

  Correct Answer: D

  Meta data management is the practice that, if implemented, would address the situation and mature the organization's business analytics practice, because it is a technique that involves defining, documenting, and maintaining the information about the data elements, such as their names, definitions, formats, sources, and relationships. Meta data management can help the analyst resolve the inconsistencies and ambiguities in the data element names, and ensure that the data is standardized, consistent, and understandable across different business units. Meta data management can also help the analyst improve the data quality, accessibility, and usability for the analysis.

• Question 88:

  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

  Correct Answer: A

  Data governance is the practice of establishing and enforcing policies, standards, roles, and responsibilities for the management and use of data across the organization. Data governance helps to address the problem of inconsistent data definitions across various data sources by ensuring that data is properly defined, documented, classified, and aligned with the business objectives and requirements

• Question 89:

  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?

  A. To make sure the criteria for the target audience is met

  B. Guarantee that the objectives of the poll are met

  C. Improve the likelihood of receiving a response rate of 100%

  D. Ensure that results are not biased or random

  Correct Answer: D

  Ensuring the result set is statistically significant is important to the team because it means that the difference or relationship observed in the data is unlikely to be due to chance or sampling error. Statistical significance helps the team to assess the validity and reliability of their findings, and to draw meaningful conclusions and recommendations from the data. Statistical significance also helps the team to communicate their results with confidence and credibility to the stakeholders and decision makers

• Question 90:

  After analyzing sales data, the analytics team finds that the older the customer, the more expensive the neckties purchased. The team felt this was a breakthrough insight but on closer analysis realized that other factors could account for this relationship. This is a clear indication that:

  A. Correlation between variables implies causation

  B. Causation has no relationship with correlation

  C. Causation between variables does not imply correlation

  D. Correlation between variables does not imply causation

  Correct Answer: D

  The analytics team found a correlation between the age of the customer and the price of the neckties purchased, meaning that as one variable changes, the other tends to change in the same direction. However, this correlation does not imply causation, meaning that one variable does not necessarily cause the other to change. There could be other factors, such as income, preference, or quality, that affect both variables and create a spurious relationship. Therefore, the team realized that they need to investigate further to determine if there is a causal link between the variables, or if the correlation is coincidental