CCBA CCBA Information Architecture & Data Analysis 2 — Questions and Answers
Question 1: A business analyst is asked to analyze trends in customer purchasing behavior using historical data. Which analytical technique is MOST appropriate?
- Root Cause Analysis
- Data Mining (Correct answer)
- Gap Analysis
- RACI Matrix
Correct answer: Data Mining
Data mining involves analyzing large datasets to discover patterns, correlations, and trends that can inform business decisions.
Question 2: Which type of data model focuses on how data is physically stored and accessed within a database system?
- Conceptual data model
- Logical data model
- Physical data model (Correct answer)
- Semantic data model
Correct answer: Physical data model
A physical data model represents how data is actually stored in a database, including tables, columns, data types, indexes, and storage specifications.
Question 3: When a business analyst creates a 'conceptual data model,' the primary audience is:
- Database administrators who will implement the schema
- Business stakeholders who need to understand key business concepts and their relationships (Correct answer)
- System architects designing the technical infrastructure
- QA testers validating data integrity rules
Correct answer: Business stakeholders who need to understand key business concepts and their relationships
Conceptual data models use simple, non-technical language to communicate key business entities and relationships to business stakeholders.
Question 4: A CCBA practitioner is reviewing a report that shows data lineage. What does data lineage describe?
- The age of data records in a database
- The origin of data and how it flows and transforms through systems (Correct answer)
- The security classification of sensitive data fields
- The frequency with which data is updated
Correct answer: The origin of data and how it flows and transforms through systems
Data lineage tracks where data originates, how it moves through systems, and how it is transformed along the way.
Question 5: A business analyst identifies that two departments in a US company use different definitions for 'active customer.' This is primarily a:
- Process documentation gap
- Data standardization issue (Correct answer)
- Requirements traceability failure
- Stakeholder alignment problem
Correct answer: Data standardization issue
When different parts of an organization define the same data term differently, it is a data standardization issue requiring a common definition to be established.
Question 6: In BABOK v3, which of the following is an example of a non-functional requirement related to data?
- The system shall display customer purchase history
- Customer records must be retained for 7 years per US regulatory requirements (Correct answer)
- Users can filter reports by date range
- The system shall generate invoices automatically
Correct answer: Customer records must be retained for 7 years per US regulatory requirements
Data retention policies driven by regulatory requirements are non-functional requirements that constrain how data is managed rather than what the system does functionally.
CCBA CCBA Information Architecture & Data Analysis 2
A business analyst is asked to analyze trends in customer purchasing behavior using historical data.
Which analytical technique is MOST appropriate?