Free IIBA CBDA Practice Exam with Questions & Answers | Set: 5

The most financially feasible option is the one that maximizes the return on investment (ROI), the present value (PV), and the net present value (NPV), and minimizes the payback period. ROI measures the annual percentage return of an investment, PV measures the current value of future cash flows, NPV measures the difference between the PV and the initial cost of an investment, and payback period measures the time it takes to recover the initial cost of an investment. A higher ROI, PV, and NPV indicate a more profitable and valuable investment, while a lower payback period indicates a faster recovery and lower risk of an investment

Data governance is the practice of establishing and enforcing policies, standards, roles, and responsibilities for the management and use of data across the organization. Data governance helps to address the problem of inconsistent data definitions across various data sources by ensuring that data is properly defined, documented, classified, and aligned with the business objectives and requirements12. References: 1: Guide to Business Data Analytics, IIBA, 2020, p. 292: Data Governance: How to Design, Deploy and Sustain an Effective Data Governance Program, John Ladley, 2012, p. 3.

Stratified sampling is a technique that divides the population into homogeneous subgroups (strata) based on a relevant characteristic, such as the amount of purchases, and then randomly selects a proportional number of elements from each subgroup to form the sample. Stratified sampling ensures that the sample is representative of the population and reduces the sampling error and bias12. References: 1: Guide to Business Data Analytics, IIBA, 2020, p. 312: Statistics for Business and Economics, David R. Anderson et al., 2014, p. 262.

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

The question “How effective is our marketing spend?” is too broadly scoped to be effectively answered, because it is a vague and ambiguous question that does not specify the criteria, scope, or timeframe for measuring the effectiveness of the marketing spend. The question also does not define what constitutes marketing spend, or how it relates to the sales data or the budget allocations. The question needs to be refined and clarified to make it more focused, relevant, and feasible for the analytics team to answer. For example, the question could be rephrased as “How does the marketing spend per channel affect the sales revenue and customer retention rate in the last quarter?” 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 16