IIBA CBDA IIBA - CBDA Exam Questions Instant Access

Question 1

With the recent departure of two of its employees, an IT helpdesk team is now understaffed and finding it difficult to keep up with the current workload. The number of tickets being received has increased as well as the number of days to resolve the tickets. The IT manager has set up a meeting with the IT director to request funding for two new helpdesk agents. To prepare for the

meeting, the manager is interested in showing the tickets processed against ticket volume over the past year. What type of chart should the manager use to effectively show the change in processing rate over time?

AA pie chart to compare the number of tickets coming in versus tickets being processed
each month, over the past year

BA column chart to compare the number of tickets coming in versus tickets being processed
each month, since June

CA line chart to show the widening gap between the number of tickets being processed
against the number coming over the past year

DA waterfall chart to show the number of tickets coming in are a lot higher than those being
processed as of year to date

Answer : C

A line chart is the type of chart that the manager should use to effectively show the change in processing rate over time, because it is a technique that displays data as a series of points connected by straight lines. A line chart can help the manager visualize the trends and patterns in the ticket volume and processing rate over the past year, and highlight the widening gap between them. A line chart can also show the seasonal variations and fluctuations in the data, and compare the performance of different categories or groups. Options A, B, and D are not suitable for showing the change in processing rate over time, because they are techniques that display data as proportions (A), comparisons (B), or accumulations (D) of different categories or groups at a single point in time or over a fixed period. Reference:

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

* Understanding the Guide to Business Data Analytics, page 18

* 16 Best Types of Charts and Graphs for Data Visualization [+ Guide]

Question 2

The analytics team has been asked to determine if the organization should launch their highest revenue generating product into the North American market. To date, this has only been available in Eastern Europe. To answer this, the team formulates several research questions, including:

AWhat product launch related costs can we expect?

BHow much revenue does the product generate in Eastern Europe?

CWhy does management need to know this?

DDo existing customers really like the product?

Answer : D

One of the steps in identifying the research questions for business data analytics is to assess the feasibility and desirability of the proposed solution or change1. This involves understanding the needs, preferences, and satisfaction of the existing and potential customers. Therefore, asking whether the existing customers really like the product is a relevant research question for the analytics team. Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 22.

Question 3

The outcome from an analytics initiative has resulted in key stakeholders wanting to move forward with a project to redesign the company's website. The business analyst has called a meeting to work on drafting a plan to assess the level of effort required to complete this work. Many of the invited participants redesigned the website before and were invited so they could provide estimates using their knowledge and experience from the past. The business analyst is using which method to estimate this work?

ARolling wave

BPERT

CParametric

DRough order of magnitude

Answer : D

The business analyst is using the rough order of magnitude method to estimate this work. This method is based on expert opinion or experience from past projects, and it provides a quick and approximate estimate of the cost, time, or effort required for a project or a task. This method is useful when there is limited information or data available, or when a high-level estimate is needed for planning or budgeting purposes. However, this method also has a high degree of uncertainty and variability, and it should be refined as more details become available12 Reference: 1: Project Estimation Techniques Business Analysts Should Know About 2: Estimation techniques for business analysts -- The Functional BA

Question 4

A grocery store chain has requested help in determining how customer preferences are changing with regards to home delivery. An analytics team has completed researching the number of online orders received requesting home delivery versus in-store pickup. The business analyst has selected a model to enable a quick comparison between curbside pick-up, in-store pickup, and home delivery for the last 3 years. Which model has the business analyst chosen?

APie chart

BFunnel chart

CScatter plot

DBar chart
Explanation:
A bar chart is a graphical representation of data that uses rectangular bars of different heights or lengths to show the values of one or more variables1. A bar chart is suitable for comparing the number of online orders received requesting different types of delivery options for the last 3 years, as it can show the frequency or proportion of each category across time.A bar chart can also help identify trends, patterns, or outliers in the data2.
A pie chart is a circular chart that shows the relative sizes of data points in a whole by using different-sized and colored slices3. A pie chart is not suitable for comparing the number of online orders received requesting different types of delivery options for the last 3 years, as it can only show the distribution of one variable at a time, and it does not show the changes over time.A pie chart can also be misleading or confusing if there are too many categories or if the slices are too similar in size4.
A funnel chart is a type of chart that shows the stages of a process and the amount of data that passes through each stage5. A funnel chart is not suitable for comparing the number of online orders received requesting different types of delivery options for the last 3 years, as it does not show the categories of delivery options, but rather the progression of customers through a sales or marketing funnel.A funnel chart can help visualize the conversion rates, drop-off rates, or bottlenecks in a process6.
A scatter plot is a type of chart that shows the relationship between two numerical variables by using dots to represent the values of each pair of data points. A scatter plot is not suitable for comparing the number of online orders received requesting different types of delivery options for the last 3 years, as it does not show the categories of delivery options, but rather the correlation or association between two continuous variables.A scatter plot can help identify the direction, strength, and shape of the relationship, as well as any outliers or clusters in the data.

Answer : D

Question 5

An analytics team employed at a leading credit card company is utilizing data analytics to identify unusual credit card purchases.

They have created the following visual. How many extreme outliers exists in this dataset?

Answer : C

According to the Business Data Analytics (IIBA- CBDA) principles, extreme outliers in a dataset can be identified visually on a scatter plot as points that are distinctly separate from the bulk of the data. In this visual, there are three points that are significantly higher on the y-axis (credit card expense) relative to their position on the x-axis (household income), indicating unusual credit card purchases. Reference: The identification and interpretation of outliers is a standard practice in data analytics and is covered under the Business Data Analytics (IIBA- CBDA) learning resources.

Question 6

The CustomerOrder entity will include information on all customer orders. Applying database normalization rules, which set of attributes will need to be normalized to avoid redundancies?

* Customerld

* CustomerPhone

* Orderld

* OrderDate

* ProductName

* ProductQuantity

* OrderTotal

ACustomerPhone
ProductName

BProductName
ProductQuantity

COrderld
ProductName

DCustomerld
OrderDate

Answer : B

Database normalization is the process of organizing the data in a database to reduce redundancy and improve integrity, consistency, and performance1.Database normalization rules are based on the concept of normal forms, which are levels of database design that meet certain criteria2.One of the most common normal forms is the third normal form (3NF), which states that a table should not have any transitive dependencies, meaning that a non-key attribute should not depend on another non-key attribute3. In the CustomerOrder entity, the set of attributes that will need to be normalized to avoid redundancies are ProductName and ProductQuantity, as they are non-key attributes that depend on another non-key attribute, Orderld. This means that the same product information may be repeated for different orders, which could lead to data inconsistency, duplication, or update anomalies. To normalize this set of attributes, a separate table should be created for the OrderDetails entity, which would have Orderld, ProductName, and ProductQuantity as its attributes, and Orderld and ProductName as its composite primary key.

The other sets of attributes do not need to be normalized to avoid redundancies, as they do not violate the 3NF. CustomerPhone and ProductName are non-key attributes that depend on the primary key, Customerld and Orderld respectively, which is allowed by the 3NF. Orderld and ProductName are part of the composite primary key of the OrderDetails entity, which is also allowed by the 3NF.Customerld and OrderDate are both primary keys of the Customer and Order entities respectively, which are also allowed by the 3NF.

Question 7

An analyst is tasked with helping the sales team make better use of its data to support informed business decision making. The analyst creates the following research question 'How can shipping costs be lowered in the northeast to remain competitive?'. This question:

AIs sufficient to begin analytics work and can be revised after analysis

BIs adequately stated and scopes the analytics initiative

CNeeds to be further defined before mathematical modeling can begin

DNeeds to be more broadly focused to frame the research
Explanation:
According to the Guide to Business Data Analytics, a research question is a clear, concise, and specific question that guides the analytics work1.The research question should be SMART: Specific, Measurable, Achievable, Relevant, and Time-bound2. The question 'How can shipping costs be lowered in the northeast to remain competitive?' is not SMART, as it lacks some important details, such as:
What is the current shipping cost and the target cost reduction?
What are the criteria for measuring competitiveness?
What is the time frame for achieving the cost reduction and competitiveness?
What are the factors that influence the shipping cost and competitiveness?
What are the assumptions and constraints of the analysis? Therefore, the question needs to be further defined before mathematical modeling can begin, as the modeling requires clear and precise inputs and outputs.The other options are not correct, as they imply that the question is either too vague or too narrow, which is not the case.

Answer : C

IIBA Certification in Business Data Analytics CBDA IIBA - CBDA Exam Questions