CBDA Online Practice Questions and Answers

Correct Answer: D

Correct Answer: D

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 satisfaction

Correct Answer: B

The analyst's follow-up question is valid because it helps to refine the scope and context of the research questions for the analytical study. By comparing the top customer concerns across branches, the analyst can identify the common and unique issues that affect customer satisfaction and loyalty. This can also help to prioritize the most critical or urgent problems that need to be addressed by the bank

Correct Answer: C

Before investing in an enterprise analytics practice, the decision makers should have a clear understanding of the expected value and benefits of such a practice. This requires conducting an up-front analysis that identifies the business problems or opportunities that can be addressed by analytics, the data sources and technologies that are needed, the analytical models and methods that are appropriate, and the metrics and indicators that will measure the impact and outcomes of the analytics solutions12. This analysis will help to define the scope, objectives, and requirements of the enterprise analytics practice, as well as the resources, roles, and governance structures that are necessary to support it34. An up-front analysis will also help to prioritize the analytics initiatives based on their feasibility, alignment with the business strategy, and potential value creation

Correct Answer: B

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 key

Correct Answer: D

Developing the narrative is the process of creating a clear, concise, and compelling story that communicates the key insights, findings, and recommendations from the data analysis to the stakeholders1. Developing the narrative is an important step after completing the research study, the data analysis, and the high impact visuals, as it helps to bridge the gap between the data and the decision-making, to engage and persuade the audience, and to drive action and change2. Developing the narrative involves defining the purpose, audience, and message of the story, choosing the best format and medium to deliver the story, and using effective storytelling techniques, such as structure, context, emotion, and call to action3.

Presenting the results to stakeholders is the process of delivering the data story to the intended audience, using the appropriate communication channels, methods, and tools4. Presenting the results to stakeholders is a subsequent step after developing the narrative, as it requires a well-crafted and well-prepared data story to be effective and impactful. Presenting the results to stakeholders involves planning and rehearsing the presentation, adapting to the feedback and questions, and evaluating the outcomes and impacts of the presentation5.

Validating regression analysis is the process of checking the assumptions, accuracy, and suitability of a statistical model that estimates the relationship between one or more independent variables and a dependent variable. Validating regression analysis is a part of the data analysis step, not a step after completing the data analysis. Validating regression analysis involves testing the significance, fit, and residuals of the model, and comparing the model with alternative models or methods.

Curating the data is the process of organizing, annotating, and preserving the data for future use, reuse, or sharing. Curating the data is a part of the data management step, not a step after completing the data analysis. Curating the data involves applying the data policies, standards, and best practices of the organization, and ensuring the quality, integrity, security, and accessibility of the data.

Correct Answer: A

Unstructured data is data that does not have a predefined format, structure, or schema, and that cannot be easily stored, processed, or analyzed by traditional databases or tools1. Unstructured data may include text, images, audio, video, or other types of data that are rich in information but complex and diverse in nature2. In the Customerissues entity, the ComplaintNotes attribute would be categorized as unstructured data, as it may contain free-form text that captures the details, sentiments, or emotions of the customers' complaints, and that may vary in length, language, tone, or style. The ComplaintNotes attribute would require special techniques, such as natural language processing, text mining, or sentiment analysis, to extract meaningful insights from the unstructured data3.

The other attributes in the Customerissues entity would be categorized as structured data, as they have a predefined format, structure, or schema, and that can be easily stored, processed, or analyzed by traditional databases or tools4. Structured data may include numbers, dates, codes, categories, or other types of data that are simple and consistent in nature5. In the Customerissues entity, the CustomerlD, ConcernCategory, ConcernSubCategory, AgentID, and lssueResolved(Y/N) attributes would be categorized as structured data, as they may contain numeric, alphanumeric, or binary values that represent the identifiers, classifications, or statuses of the customers' issues, and that may have fixed lengths, ranges, or domains.

Correct Answer: D

SMART is an acronym that stands for Specific, Measurable, Achievable, Relevant, and Time-bound, which are criteria for setting effective and realistic goals1. From a SMART target perspective, what is missing in this scenario is the time-frame by which the target must be met. A time-bound target specifies the deadline or the duration for achieving the target, which helps to create a sense of urgency, motivation, and accountability2. Without a time-frame, the target is vague and indefinite, and it is difficult to monitor and evaluate the progress and the results. For example, a time-bound target could be to improve the average transaction time per order by 10% within the next six months.

The other options are not correct explanations of what is missing. The target is attainable, as it is realistic and feasible, and it does not depend on factors that are beyond the control of the organization, such as weather conditions. The target is specific, as it provides a clear and precise description of what needs to be achieved, and it does not need to provide a target for each supplier, as that would make the target too complex and cumbersome. The target is relevant, as it is aligned with the goal of improving supplier relations, and it does not assume that supplier relations is only dependent on quality of deliveries, as transaction time is also an important factor that affects the efficiency, satisfaction, and trust of the suppliers.

Correct Answer: D

Descriptive analytics is the type of analytics that summarizes and visualizes data to provide an overview of what has happened or is happening. Descriptive analytics uses techniques such as statistics, charts, graphs, and dashboards to display data in an understandable and meaningful way. Descriptive analytics can help analysts explore data, identify patterns, and communicate insights. Calculating theaverage, median, and mode values for a dataset is an example of descriptive analytics, as it provides a measure of central tendency for the data distribution.

Correct Answer: C

According to the Introduction to Business Data Analytics: An Organizational View, one of the critical success factors for creating an enterprise analytics program is to have a management team that thinks analytically and fosters a culture where data science thrives. This means that the management team should understand the potential value and impact of data science, promote a data-driven mindset and decision-making process, encourage innovation and experimentation, and support collaboration and learning among the data science team and other stakeholders. A management team that thinks analytically and fosters a culture where data science thrives can help create a strategic vision, align the goals and objectives, allocate the resources and investments, and overcome the challenges and barriers for the enterprise analytics program.