ExamGecko
Home Home / IIBA / CBDA

IIBA CBDA Practice Test - Questions Answers, Page 12

Question list
Search
Search

List of questions

Search

Related questions











A fashion retailer is developing a new line of luxury handbags and would like to evaluate their target market and pricing. After an extensive evaluation based on product features, their target market, and pricing of competitor products, the analytics team has come up with a pricing proposal. On presenting the results, the management team is of the opinion that additional analysis was required before making a decision. What type of additional analysis will help the management team make a decision on pricing?

A.
How diverse are the competitors- product portfolios?
A.
How diverse are the competitors- product portfolios?
Answers
B.
How can we broaden the target market?
B.
How can we broaden the target market?
Answers
C.
How can costs be reduced to improve the profit margin?
C.
How can costs be reduced to improve the profit margin?
Answers
D.
What is the breakeven point before profits are generated?
D.
What is the breakeven point before profits are generated?
Answers
Suggested answer: D

Explanation:

Explanation: According to the Introduction to Business Data Analytics: A Practitioner View, the breakeven point is the point at which the total revenue equals the total cost of a product or service. The breakeven point indicates the minimum sales volume or price required to cover the fixed and variable costs and to start making a profit. The breakeven point can help the management team make a decision on pricing by showing them how sensitive the profitability is to the price changes and how much margin of safety they have. The breakeven point can also help the management team evaluate the feasibility and risk of the pricing proposal and compare it with alternative scenarios.

The analytics team has completed their analytics work and have agreed on a set of five key recommendations. They are now discussing how best to communicate these recommendations to the finance, customer service, and marketing teams. Recognizing that this is a diverse set of stakeholders, the business analysis professional reminds the team:

A.
All stakeholders should receive information about the recommendation in the same way
A.
All stakeholders should receive information about the recommendation in the same way
Answers
B.
Stakeholders only have the ability to understand summarized recommendations
B.
Stakeholders only have the ability to understand summarized recommendations
Answers
C.
Recommendations are important and must be communicated with as much detail as possible
C.
Recommendations are important and must be communicated with as much detail as possible
Answers
D.
The recommendation should be communicated in different ways for different stakeholders
D.
The recommendation should be communicated in different ways for different stakeholders
Answers
Suggested answer: D

Explanation:

Explanation: According to the Guide to Business Data Analytics, the recommendation is the output of the data analysis that provides suggestions or guidance for actions or decisions based on the data insights. The recommendation should be communicated in different ways for different stakeholders, depending on their needs, preferences, and expectations. The communication should consider the following factors: The level of detail and complexity: Some stakeholders may require more or less detail and complexity in the recommendation, depending on their role, responsibility, and involvement in the data analysis project. For example, the finance team may need more detail and complexity than the customer service team, as they are more concerned with the financial implications and feasibility of the recommendation. The format and medium: Some stakeholders may prefer different formats and mediums for receiving the recommendation, depending on their availability, accessibility, and learning style. For example, the marketing team may prefer a visual and interactive format, such as a dashboard or a presentation, than a textual and static format, such as a report or a document. The tone and language: Some stakeholders may respond better to different tones and languages for the recommendation, depending on their culture, background, and personality. For example, some stakeholders may appreciate a formal and professional tone and language, while others may prefer a casual and friendly tone and language. The communication should also follow the principles of clarity, accuracy, relevance, and timeliness, as well as adhere to the ethical and legal standards for data privacy and security.

An operations manager for a new hotel is in need of determining the optimum number of vans to purchase to shuttle guests to/from the airport. It will be necessary to determine the most efficient routes and schedule to follow to ensure guests do not experience excessive delays. Which business analytics technique would lend itself to supporting these types of business decisions?

A.
Linear programming
A.
Linear programming
Answers
B.
Factor analysis
B.
Factor analysis
Answers
C.
Regression
C.
Regression
Answers
D.
K-means Clustering
D.
K-means Clustering
Answers
Suggested answer: A

Explanation:

Explanation: Linear programming is a business analytics technique that can lend itself to supporting these types of business decisions.Linear programming is a mathematical method that optimizes the allocation of limited resources to achieve a desired objective, subject to a set of constraints1.Linear programming can help the operations manager to determine the optimum number of vans to purchase, the most efficient routes and schedule to follow, and the minimum cost or time to shuttle guests to/from the airport, by formulating a linear objective function and a system of linear inequalities that represent the relevant variables, parameters, and restrictions2. The other options are not correct business analytics techniques for these types of business decisions.Factor analysis is a statistical method that reduces the dimensionality of a large set of correlated variables into a smaller set of uncorrelated factors that explain the underlying structure or patterns of the data3. Factor analysis can help the operations manager to identify the key factors that influence the guest satisfaction or loyalty, but it cannot help to optimize the resource allocation or efficiency. Regression is a statistical method that estimates the relationship between one or more independent variables and a dependent variable. Regression can help the operations manager to predict the demand or revenue of the hotel based on the variables such as season, price, or location, but it cannot help to optimize the resource allocation or efficiency. K-means clustering is a machine learning method that partitions a set of data points into a predefined number of clusters based on the similarity or distance between the data points.K-means clustering can help the operations manager to segment the guests into different groups based on their characteristics or preferences, but it cannot help to optimize the resource allocation or efficiency.

An analyst supporting the Marketing department for a specialty retailer has been asked to look through past sales data to help guide product decisions. The business sponsor for this initiative would first like to know 'What is the most profitable product line?'. What type of analytics is the analyst going to perform to address this question?

A.
Predictive
A.
Predictive
Answers
B.
Diagnostic
B.
Diagnostic
Answers
C.
Descriptive
C.
Descriptive
Answers
D.
Prescriptive
D.
Prescriptive
Answers
Suggested answer: C

Explanation:

Explanation: According to the Guide to Business Data Analytics, descriptive analytics is a type of analytics that summarizes and presents data in a meaningful way. Descriptive analytics uses techniques such as statistics, charts, tables, and dashboards to provide an overview of what has happened or is happening in the dat a. Descriptive analytics can help answer questions such as who, what, when, where, and how. In this situation, the analyst has been asked to look through past sales data to help guide product decisions. The business sponsor for this initiative would first like to know 'What is the most profitable product line?'. This is a descriptive analytics question, as it involves summarizing and presenting the past sales data by product line and calculating the profit margin for each product line.

A data dictionary is being developed for a dataset describing a company's customer base. Within the data dictionary, which of the following represents a composite data element?

A.
Street address
A.
Street address
Answers
B.
First name
B.
First name
Answers
C.
Total sale
C.
Total sale
Answers
D.
Birthdate
D.
Birthdate
Answers
Suggested answer: A

Explanation:

A composite data element is a data element that is made up of smaller units called sub-elements, which are separated by a sub-element separator character, such as a colon (:). For example, ITEMNO is a composite data element that consists of three sub-elements: part number, aisle number, and bin number. A street address is also a composite data element that can consist of sub-elements such as street number, street name, city, state, and zip code. First name, total sale, and birthdate are simple data elements that do not have sub-elements.

An organization has a customer database of 3000 customers and has accumulated 5 years of sales data. They want to make decisions about which products to retire and which to continue to offer. Management has turned to the analytics team to analyze the data and provide recommendations. The analytics team develops a survey to send to randomly selected customers. This is an example of:

A.
Data Wrangling
A.
Data Wrangling
Answers
B.
Data Manipulation
B.
Data Manipulation
Answers
C.
Data Grouping
C.
Data Grouping
Answers
D.
Data Sampling
D.
Data Sampling
Answers
Suggested answer: D

Explanation:

Data sampling is the process of selecting a subset of data from a larger population to represent the characteristics of the whole population. Data sampling is often used when the population is too large or costly to collect data from every individual. Data sampling can help reduce the time, cost, and complexity of data analysis, while maintaining the validity and reliability of the results. Data sampling can also help avoid biases and errors that may arise from collecting data from the entire population. Data sampling can be done using various methods, such as random sampling, stratified sampling, cluster sampling, or convenience sampling, depending on the research objectives and the availability of data. In this example, the analytics team develops a survey to send to randomly selected customers, which is a form of data sampling. The survey aims to collect data from a representative sample of customers that can reflect the preferences and opinions of the entire customer population. The survey data can then be used to analyze the performance and demand of different products, and provide recommendations to management.Reference:

[Business Data Analytics: A Practitioner's Guide], Chapter 4: Data Analysis, Section 4.2: Data Sampling, pp. 69-72.

[A Guide to the Business Analysis Body of Knowledge (BABOK Guide)], Version 3, Chapter 6: Solution Evaluation, Section 6.2: Analyze Performance Measures, pp. 152-153.

A 3rd party is marketing an application for financial institutions to use for credit scoring. This application is an example of what type of analytics?

A.
Descriptive analytics
A.
Descriptive analytics
Answers
B.
Prescriptive analytics
B.
Prescriptive analytics
Answers
C.
Exploratory
C.
Exploratory
Answers
D.
Inferential
D.
Inferential
Answers
Suggested answer: B

Explanation:

Explanation: Prescriptive analytics is the type of analytics that provides recommendations or suggestions for optimal actions or decisions based on data analysis. Prescriptive analytics uses techniques such as optimization, simulation, and decision analysis to generate and evaluate various scenarios and outcomes. Prescriptive analytics can help financial institutions to use credit scoring to determine the best loan offers, interest rates, and repayment terms for their customers, as well as to manage risk and compliance. Prescriptive analytics is the most advanced and complex type of analytics, as it requires a high level of data quality, integration, and modeling, as well as human judgment and domain expertise.Reference: Certification in Business Data Analytics (IIBA - CBDA), IIBA, accessed on January 20, 2024. Business Data Analytics Certification - CBDA Competencies | IIBA, IIBA, accessed on January 20, 2024. Guide to Business Data Analytics, IIBA, 2020, p. 15-16.

There were 7 students enrolled in the Introduction to Artificial Intelligence course. These were the student's scores from the final exam: 64, 70, 80, 80, 90, 98, 100

What is the mean and mode for the outlined scores?

A.
83.14, 80
A.
83.14, 80
Answers
B.
79.84, 81.40
B.
79.84, 81.40
Answers
C.
80,80
C.
80,80
Answers
D.
80, 83.14
D.
80, 83.14
Answers
Suggested answer: A

Explanation:

The mean is the average of all the scores, which is found by adding them up and dividing by the number of scores. The mode is the most frequent score, which is the one that occurs the most times. To find the mean and mode for the outlined scores, we can use the following steps:

* Arrange the scores in ascending order: 64, 70, 80, 80, 90, 98, 100

* Add up the scores: 64 + 70 + 80 + 80 + 90 + 98 + 100 = 582

* Divide the sum by the number of scores: 582 / 7 = 83.14

* The mean is 83.14

* Count how many times each score occurs: 64 occurs once, 70 occurs once, 80 occurs twice, 90 occurs once, 98 occurs once, 100 occurs once

* The score that occurs the most times is 80

* The mode is 80

Therefore, the mean and mode for the outlined scores are 83.14 and 80, respectively12

Reference: 1: Mean, median, and mode review (article) | Khan Academy 2: Mean, Median, and Mode: Measures of Central Tendency - Statistics By Jim

An analyst at a phone manufacturing company is preparing a dashboard for Senior Executives that will cover past year's performance. It will be used in the upcoming senior leadership team meeting to make strategic decisions for the new year. While analyzing the data, the analyst found a lot of interesting revelations related to performance. What should the analyst keep in mind when preparing the Executive dashboard?

A.
Keep some sections high-level, and some sections detailed
A.
Keep some sections high-level, and some sections detailed
Answers
B.
Keep it detailed if there is a lot of good information to share
B.
Keep it detailed if there is a lot of good information to share
Answers
C.
Keep it high-level, summarizing key insights and metrics
C.
Keep it high-level, summarizing key insights and metrics
Answers
D.
Keep it detailed so one dashboard can be shared to all levels of the organization
D.
Keep it detailed so one dashboard can be shared to all levels of the organization
Answers
Suggested answer: C

Explanation:

When preparing an executive dashboard, the analyst should keep in mind that the purpose of the dashboard is to provide a quick and clear overview of the past year's performance and to support strategic decision making for the new year. Therefore, the analyst should keep the dashboard high-level, summarizing the key insights and metrics that are relevant and meaningful for the senior executives. The analyst should avoid cluttering the dashboard with too much detail or information that is not essential for the executives. The analyst should also use visual features, such as charts, graphs, and colors, to display the data in an organized and appealing way12

Reference: 1: Executive Dashboards: 10 Reporting Tips and Examples [2023] * Asana 2: How to Create Executive Dashboard & Reports - Ubiq BI

A research marketer is interested in collecting information about the spending habits of families in North America. Concerned about the volume of data required to conduct the research, they choose to use sampling. The dataset is sourced using all credit card transactions from a leading North American credit card company for Quarter 1 of the prior year. The sample used is:

A.
Statistically representative
A.
Statistically representative
Answers
B.
Not relevant
B.
Not relevant
Answers
C.
Too large to be helpful
C.
Too large to be helpful
Answers
D.
Biased
D.
Biased
Answers
Suggested answer: D

Explanation:

The sample used in this case is biased, meaning that it is not representative of the population of interest. The population of interest is the families in North America, but the sample is drawn from only one source of data: the credit card transactions from a leading North American credit card company. This sample excludes the families who do not use credit cards, or who use other credit card companies, or who use other payment methods. Therefore, the sample is not random or fair, and it may introduce sampling bias into the research results12

Reference: 1: Sampling Methods | Types, Techniques & Examples 2: Sampling Bias - an overview | ScienceDirect Topics

Total 152 questions
Go to page: of 16