Free IIBA-CBDA Exam Braindumps
Certification in Business Data Analytics Questions 51–55 (page: 12)

Updated On: 10-Feb-2026

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?

  1. T-Testing
  2. Simulation
  3. Visioning
  4. Storyboarding

Answer(s): D

Explanation:

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



A database analyst is modelling a database for a large toy manufacturer.
Which statement describes a logical database model?

  1. The layer of views created to summarize data or provide another perspective of certain data
  2. A model that depicts the actual design of the relational database
  3. An abstraction of the conceptual data model that includes rules of normalization
  4. Modelling that involves objects being defined at the schema level

Answer(s): C

Explanation:

A logical database model is a data model of a specific problem domain expressed independently of a particular database management product or storage technology. It describes data using notation that corresponds to a data organization used by a database management system, such as relational tables and columns. It also includes rules of normalization, which are the process of converting complex data structures into simple, stable data structures12


Reference:

1: Logical schema - Wikipedia 2:
What Is a Data Model? | Coursera



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:

  1. Untrained learning
  2. Supervised learning
  3. Trained learning
  4. Unsupervised learning

Answer(s): D

Explanation:

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 customers. For example, the professional association can use unsupervised learning to identify the characteristics of customers who are likely to cancel their subscription after their first 5- year term ends, and then design strategies to retain them12


Reference:

1: What is Unsupervised Learning? - IBM 2: Unsupervised Learning - IIBA BABOK Guide v3



Which attributes from the Order entity will need to be normalized to avoid redundancies? . Orderld
. OrderDate
. Itemld
. ItemName
. Quantity
. ItemPrice

  1. OrderDate
    ItemPrice
  2. ItemName
    ItemPrice
  3. OrderDate
    ItemName
  4. Item Name
    Quantity

Answer(s): B

Explanation:

The attributes ItemName and ItemPrice need to be normalized to avoid redundancies because they depend on the attribute ItemId, which is not part of the primary key of the Order entity. This is a case of partial dependency, which violates the second normal form (2NF) of database normalization. To achieve 2NF, the Order entity should be split into two entities: Order and Item, where Item contains the attributes ItemId, ItemName, and ItemPrice, and Order contains the attributes OrderId, OrderDate, ItemId, and Quantity. This way, the ItemName and ItemPrice are stored only once for each ItemId, and the Order entity references them through a foreign key12


Reference:

1: Balancing

Data Integrity and Performance: Normalization vs ... 2: Normalization Process in DBMS - GeeksforGeeks



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?

  1. Identifying one key stakeholder, who can make final decisions about which sources to relate/merge
  2. Evaluating the completeness, validity, and reliability of the data from source systems
  3. Ensuring stakeholders always have clear insight into the final requirements at all times
  4. Enforcing master data management principles and practices

Answer(s): D

Explanation:

Providing `one source of the truth' means ensuring that there is a single, consistent, and authoritative source of data that can be used for analytics and decision making across the organization. This objective can be achieved by enforcing master data management principles and practices, which involve defining, governing, and maintaining the quality and integrity of the core data entities that are shared by multiple systems and processes. Master data management helps to eliminate data silos, reduce data duplication and inconsistency, and improve data accuracy and reliability12


Reference:

1: What is Master Data Management (MDM)? - Informatica 2: Master Data Management - IIBA BABOK Guide v3



Viewing page 12 of 32
Viewing questions 56 - 60 out of 152 questions


Post your Comments and Discuss IIBA IIBA-CBDA exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!