CBDA Exam Dumps - IIBA Business Data Analytics Questions and Answers

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 References: 1: Balancing Data Integrity and Performance: Normalization vs … 2: Normalization Process in DBMS - GeeksforGeeks

A research question is a clear and focused question that guides the data analytics process and defines the expected outcome or value of the analysis1. A research question that is too broad may lead to the concern of being difficult to identify the key performance indicators (KPIs) to measure, as KPIs are specific, quantifiable, and relevant metrics that indicate the progress and success of the analysis in relation to the research question23. A broad research question may also result in too much or too little data, unclear or conflicting objectives, or irrelevant or ambiguous results4. References: 1: Guide to Business Data Analytics, IIBA, 2020, p. 202: Guide to Business Data Analytics, IIBA, 2020, p. 233: Key Performance Indicators: Developing, Implementing, and Using Winning KPIs, David Parmenter, 2015, p. 34: How to Write a Good Research Question, ThoughtCo, 2021, 1.

The relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity only if they have made an order, is a zero-to-one relationship. This means that for each record in the Order entity, there can be either zero or one record in the Customer entity that is related to it. This implies that the Order entity is optional for the Customer entity, and the Customer entity is mandatory for the Order entity12 References: 1: A Guide to the Entity Relationship Diagram (ERD) - Database Star 2: Developing an Application - Oracle

The data scientist is encouraging using the Gestalt Principle of Similarity with regards to data visualization. This principle states that the brain groups objects together that are similar in appearance, such as color, shape, size, or orientation. By using color to group objects needing to be associated, the data scientist is suggesting a way to reduce the complexity in the model and make it easier for the viewers to perceive the patterns and relationships among the data12 References: 1: Gestalt Principles For Data Visualization - Topcoder 2: Introduction to Data Visualization: Gestalt Principles

The risk that could impact the value of this analysis is that the objective of the original research may not be met, because the team modified the research question to fit the data, rather than finding the data that fits the research question. This could lead to a loss of alignment between the research question and the business problem, stakeholder needs, or analytical methods. The team may end up answering a different or less relevant question than the one they intended to answer, and thus provide less valuable insights or recommendations. References:

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 1: Identify the Research Questions

•Understanding the Guide to Business Data Analytics, page 10-11

•CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA®, page 8, CBDA Exam Sample Questions and Self-Assessment, Question 10

Exploratory analysis is the approach that the analytics team should use as the next step, because it is a technique that allows them to examine the quality, structure, and characteristics of the data, without making any assumptions or hypotheses. Exploratory analysis can help the team identify any issues or anomalies in the data, such as missing values, outliers, or errors, and decide how to handle them. Exploratory analysis can also help the team discover any patterns, trends, or relationships in the data, and generate new research questions or hypotheses for further analysis. References:

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 3: Analyze Data

•Understanding the Guide to Business Data Analytics, page 16

•CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA®, page 8, CBDA Exam Sample Questions and Self-Assessment, Question 8

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

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 2: Source Data

•Guide to Business Data Analytics - Iiba - Google Books, page 14

•Business Data Analytics (IIBA®-CBDA Exam preparation) | Udemy, Section 2: Source Data, Lecture 8: Meta Data Management

Factor analysis is the technique that, if used, would achieve the objective of producing a single score of sustainability, because it is a technique that reduces the dimensionality of a data set by identifying the underlying factors or latent variables that explain the variation and correlation among the observed variables. Factor analysis can help the analytics team combine the 10 measures of workplace sustainability into a smaller number of factors, and then derive a composite score of sustainability based on the factor loadings and weights. Factor analysis can also help the analytics team simplify and interpret the data, and identify the key drivers of sustainability. References:

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 3: Analyze Data

•Understanding the Guide to Business Data Analytics, page 17

•Business Data Analytics (IIBA®-CBDA Exam preparation) | Udemy, Section 3: Analyze Data, Lecture 15: Factor Analysis

The sampling frame is the term that describes the list of all employees present on March 25th, because it is a technique that defines the set of elements from which a sample is drawn. The sampling frame should ideally match the population of interest, which is the group of elements that the researcher wants to study or make inferences about. In this case, the population of interest is the employees of the company, and the sampling frame is the subset of employees who were at work on a specific day. The survey sample is the technique that selects a portion of the sampling frame to participate in the survey. The sample weights are the technique that assigns different values or importance to each element in the sample, based on their representation in the population. References:

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 2: Source Data

•Understanding the Guide to Business Data Analytics, page 14

•CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA®, page 8, CBDA Exam Sample Questions and Self-Assessment, Question 14

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 References: 1: Developing Key Messages for Effective Communication - MSKTC 2: 11 Ways Highly Successful Leaders Support Their Team - Redbooth