IIBA Updated CBDA Exam Questions and Answers by kitty

The business analyst is concerned about the validity of the survey. Validity is the extent to which a survey measures what it intends to measure. In this case, the survey is supposed to measure job satisfaction, but the two questions asked to different groups of employees are not equivalent or relevant to this construct. The question “Do you enjoy working in your workplace?” is more directly related to job satisfaction than the question “Do you like the current work benefits?”. The latter question may capture only one aspect of job satisfaction, and may not reflect the overall level of contentment or happiness with the job. Therefore, the survey results may not be valid or accurate in measuring job satisfaction12 References: 1: Survey and questionnaires in business analysis - The Functional BA 2: Job Satisfaction Survey - Paul Spector

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 makers12 References: 1: An Easy Introduction to Statistical Significance (With Examples) - Scribbr 2: Statistical Significance in Experimentation and Data Analysis - All About Circuits

The analytics team overlooked the fact that communicating information is not a one-way or one-time process, but rather a bi-directional and iterative one. This means that the team should not only present their recommendations, but also solicit feedback, address concerns, clarify doubts, and confirm understanding from the stakeholders. By doing so, the team can ensure that the stakeholders are fully engaged, informed, and aligned with the recommendations, and that any potential barriers or risks are identified and mitigated before moving forward. References:

•Understanding the Guide to Business Data Analytics, page 9

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 4: Interpret and Report Results

•CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA®, page 5, Step 3 – Schedule and Take The Exam

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