Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Palo Alto Networks
Salesforce
SAP
All Vendors
  1. Home
  2. IIBA
  3. CBDA

IIBA CBDA Exam (page: 1)
IIBA Certification in Business Data Analytics
Updated on: 11-Aug-2025

Viewing Page 1 of 32
CBDA PDF 150 Questions

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:

  1. What product launch related costs can we expect?
  2. How much revenue does the product generate in Eastern Europe?
  3. Why does management need to know this?
  4. Do existing customers really like the product?

Answer(s): D

Explanation:

One of the steps in identifying the research questions for business data analytics is to assess the feasibility and desirability of the proposed solution or change1. This involves understanding the needs, preferences, and satisfaction of the existing and potential customers. Therefore, asking whether the existing customers really like the product is a relevant research question for the analytics team.


Reference:

1: Guide to Business Data Analytics, IIBA, 2020, p. 22.



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?

  1. Physical
  2. Hierarchical
  3. Conceptual
  4. Logical

Answer(s): A

Explanation:

A physical data model is the most detailed and specific type of data model, which shows how the data is stored, accessed, and manipulated in the database. It includes the table structures, column names, data types, primary and foreign keys, constraints, indexes, and other physical attributes of the data12.


Reference:

1: Guide to Business Data Analytics, IIBA, 2020, p. 542: Data Modeling Essentials, Graeme Simsion and Graham Witt, 2005, p. 15.



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:

  1. Sources of data
  2. Quality of the data
  3. Timeframe of analysis
  4. Measurement scale

Answer(s): B

Explanation:

The quality of the data is the most important dimension to consider when identifying research questions, as it affects the validity, reliability, and accuracy of the analysis and the results. Data quality refers to the degree to which the data meets the requirements and expectations of the stakeholders and the purpose of the analysis12. Poor data quality can lead to erroneous conclusions, ineffective decisions, and wasted resources3.


Reference:

1: Guide to Business Data Analytics, IIBA, 2020, p. 282: Data Quality Assessment, Arkady Maydanchik, 2007, p. 33: Data Quality: The Field Guide, Thomas C. Redman, 2001, p. 1.



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?

  1. Querying can be used to create predictive data models
  2. Irrespective of the querying language used, data results retrieved are always in a tabular format
  3. A querying language is independent of the type of database being used
  4. Querying is a structured way of searching, manipulating and managing data

Answer(s): D

Explanation:

Querying is a technique that allows analysts to access, filter, join, aggregate, and transform data from various databases using a specific syntax and logic1. Querying can be used for different purposes, such as data exploration, data preparation, data analysis, and data visualization2. Querying is not limited to creating predictive data models, nor does it always produce tabular results. Moreover, querying languages may vary depending on the type and structure of the database, such as relational, hierarchical, or document-based3.


Reference:

1: Guide to Business Data Analytics, IIBA, 2020, p. 552: Data Analysis Using SQL and Excel, Gordon S. Linoff, 2016, p. 33: Database Systems:
Design, Implementation, and Management, Carlos Coronel and Steven Morris, 2019, p. 17.



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?

  1. A single data point
  2. A link between two data points
  3. A dedicated algorithm that calculates the node positions
  4. A collection of data points and links

Answer(s): C

Explanation:

A layout is a way of arranging the nodes and links of a graph visualization to convey meaningful information about the data. A layout is determined by a dedicated algorithm that calculates the node positions based on certain criteria, such as minimizing edge crossings, maximizing node spacing, or emphasizing clusters12. A layout can also be influenced by user interaction, such as zooming, panning, or dragging3.


Reference:

1: Guide to Business Data Analytics, IIBA, 2020, p. 642: Graph Drawing: Algorithms for the Visualization of Graphs, Giuseppe Di Battista et al., 1999, p. 33:

Interactive Data Visualization: Foundations, Techniques, and Applications, Matthew O. Ward et al., 2015, p. 227.



Viewing Page 1 of 32



Share your comments for IIBA CBDA exam with other users:

SPriyak 3/17/2025 11:08:37 AM

can you please provide the CBDA latest test preparation
UNITED STATES