ExamGecko
Home Home / IIBA / CBDA

IIBA CBDA Practice Test - Questions Answers, Page 4

Question list
Search
Search

List of questions

Search

Related questions











An analyst has just completed building a data model that shows the table structures including table names, table relationships with primary and foreign keys and column names with respective data types. What type of data model has the analyst just built?

A.
Physical
A.
Physical
Answers
B.
Hierarchical
B.
Hierarchical
Answers
C.
Conceptual
C.
Conceptual
Answers
D.
Logical
D.
Logical
Answers
Suggested answer: A

Explanation:

A physical data model is the most detailed and specific type of data model, which shows how the data is stored, accessed, and manipulated in the database. It includes the table structures, column names, data types, primary and foreign keys, constraints, indexes, and other physical attributes of the data12.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 542: Data Modeling Essentials, Graeme Simsion and Graham Witt, 2005, p. 15.

The analytics team is identifying research questions to address a business problem. The business analysis professional reminds the team that the most important dimension to consider is the:

A.
Sources of data
A.
Sources of data
Answers
B.
Quality of the data
B.
Quality of the data
Answers
C.
Timeframe of analysis
C.
Timeframe of analysis
Answers
D.
Measurement scale
D.
Measurement scale
Answers
Suggested answer: B

Explanation:

The quality of the data is the most important dimension to consider when identifying research questions, as it affects the validity, reliability, and accuracy of the analysis and the results. Data quality refers to the degree to which the data meets the requirements and expectations of the stakeholders and the purpose of the analysis12. Poor data quality can lead to erroneous conclusions, ineffective decisions, and wasted resources3.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 282: Data Quality Assessment, Arkady Maydanchik, 2007, p. 33: Data Quality: The Field Guide, Thomas C. Redman, 2001, p. 1.

An analyst at a supermarket chain has been asked to extract data from multiple data sources to complete a study on customer spending habits. The analyst is going to query data from various databases. Which statement is true about database querying?

A.
Querying can be used to create predictive data models
A.
Querying can be used to create predictive data models
Answers
B.
Irrespective of the querying language used, data results retrieved are always in a tabular format
B.
Irrespective of the querying language used, data results retrieved are always in a tabular format
Answers
C.
A querying language is independent of the type of database being used
C.
A querying language is independent of the type of database being used
Answers
D.
Querying is a structured way of searching, manipulating and managing data
D.
Querying is a structured way of searching, manipulating and managing data
Answers
Suggested answer: D

Explanation:

Querying is a technique that allows analysts to access, filter, join, aggregate, and transform data from various databases using a specific syntax and logic1. Querying can be used for different purposes, such as data exploration, data preparation, data analysis, and data visualization2. Querying is not limited to creating predictive data models, nor does it always produce tabular results. Moreover, querying languages may vary depending on the type and structure of the database, such as relational, hierarchical, or document-based3.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 552: Data Analysis Using SQL and Excel, Gordon S. Linoff, 2016, p. 33: Database Systems: Design, Implementation, and Management, Carlos Coronel and Steven Morris, 2019, p. 17.

A lab is conducting a study on protein interactions. They have used the data to create a graph visualization. In graph visualization, what would a layout be?

A.
A single data point
A.
A single data point
Answers
B.
A link between two data points
B.
A link between two data points
Answers
C.
A dedicated algorithm that calculates the node positions
C.
A dedicated algorithm that calculates the node positions
Answers
D.
A collection of data points and links
D.
A collection of data points and links
Answers
Suggested answer: C

Explanation:

A layout is a way of arranging the nodes and links of a graph visualization to convey meaningful information about the data. A layout is determined by a dedicated algorithm that calculates the node positions based on certain criteria, such as minimizing edge crossings, maximizing node spacing, or emphasizing clusters12. A layout can also be influenced by user interaction, such as zooming, panning, or dragging3.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 642: Graph Drawing: Algorithms for the Visualization of Graphs, Giuseppe Di Battista et al., 1999, p. 33: Interactive Data Visualization: Foundations, Techniques, and Applications, Matthew O. Ward et al., 2015, p. 227.

An analyst at a bank is trying to identify research questions for an analytical study on top customer issues across branches. During an interview with a branch manager, the analyst asks the manager what their top customer concerns are relating to this branch?

After the manager's reply, the analyst asks a follow up question on how their top customer concerns compare against the top customer concerns across all branches? Was the analyst's follow-up question valid?

A.
No, there is no value comparing the results of a single branch with results across all branches
A.
No, there is no value comparing the results of a single branch with results across all branches
Answers
B.
Yes, it builds on the previous question and allows the analyst to identify branch-specific concerns
B.
Yes, it builds on the previous question and allows the analyst to identify branch-specific concerns
Answers
C.
No, the question is not valid in this particular scenario
C.
No, the question is not valid in this particular scenario
Answers
D.
Yes, only for the purpose of ensuring that the manager is aware of the company-wide reports
D.
Yes, only for the purpose of ensuring that the manager is aware of the company-wide reports
Answers
Suggested answer: B

Explanation:

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 bank12.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 212: Business Analysis for Practitioners: A Practice Guide, PMI, 2015, p. 43.

Interested in experimenting with analytics, a manufacturing company hires an analyst to see how the capability can be developed within its organization. The analyst is getting started and recognizes the need to show value from the onset of their work to gain upper management's trust and future funding. What action will accomplish these objectives?

A.
Solve the biggest problem the organization has first to quickly grab the support and attention of senior management
A.
Solve the biggest problem the organization has first to quickly grab the support and attention of senior management
Answers
B.
Develop a question that can be answered quickly regardless of alignment to strategy, just to get started
B.
Develop a question that can be answered quickly regardless of alignment to strategy, just to get started
Answers
C.
Develop a meaningful question that can be answered with data the company already has in its possession
C.
Develop a meaningful question that can be answered with data the company already has in its possession
Answers
D.
Perform a market analysis to understand how competitors are using analytics and then launch a similar initiative
D.
Perform a market analysis to understand how competitors are using analytics and then launch a similar initiative
Answers
Suggested answer: C

Explanation:

The best action for the analyst to show value from the onset of their work is to develop a meaningful question that can be answered with data the company already has in its possession. This way, the analyst can demonstrate the potential of analytics to solve relevant business problems, without spending too much time or resources on data collection or market research. The question should also be aligned with the organization's strategy and goals, and provide actionable insights for decision making12.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 202: Data Science for Business, Foster Provost and Tom Fawcett, 2013, p. 14.

A large car manufacturer is interested in comparing the number of sales for a specific model of electric car across all 50 US states.

The data analytics team sourced and acquired the data, and the business analyst created the model to compare sales across states.

In a meeting to review the results, the feedback received included several complaints concerning an inability to distinguish the number of sales per state. What model would result in such confusion?

A.
Bullet chart
A.
Bullet chart
Answers
B.
Dual axis chart
B.
Dual axis chart
Answers
C.
Bar chart
C.
Bar chart
Answers
D.
Pie chart
D.
Pie chart
Answers
Suggested answer: D

Explanation:

A pie chart is a circular chart that shows the proportion of each category in a whole by dividing the circle into slices. A pie chart would result in confusion when comparing the number of sales for a specific model of electric car across all 50 US states, because it is difficult to compare the angles and areas of the slices, especially when there are many categories with similar values. A pie chart also does not show the absolute values of each category, unless they are labeled or annotated12. A better alternative would be a bar chart, which can show the number of sales for each state along a common axis, making it easier to compare and rank the values3.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 652: Storytelling with Data, Cole Nussbaumer Knaflic, 2015, p. 673: The Visual Display of Quantitative Information, Edward R. Tufte, 2001, p. 178.

The definition of data elements is different across various data sources. The organization is looking to improve the usability of data across the organization. Which practice would help address this problem?

A.
Data governance
A.
Data governance
Answers
B.
Data quality
B.
Data quality
Answers
C.
Data architecture
C.
Data architecture
Answers
D.
Data ethics
D.
Data ethics
Answers
Suggested answer: A

Explanation:

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.

Reference: 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.

Insights based on the data collected indicate that a multi-national company could increase its sales of a mature product by reducing its price by 20% which would result in increased revenues of 2% over a 6-month period. The team recommends this as an appropriate goal for its organization. This is considered a good goal because:

A.
It meets all the criteria for a well-defined objective
A.
It meets all the criteria for a well-defined objective
Answers
B.
The organization can derive additional revenue from the product
B.
The organization can derive additional revenue from the product
Answers
C.
It indicates that the company does not have to incur costs associated with retiring this product
C.
It indicates that the company does not have to incur costs associated with retiring this product
Answers
D.
Management will be pleased that the mature product can still contribute to revenue
D.
Management will be pleased that the mature product can still contribute to revenue
Answers
Suggested answer: A

Explanation:

A well-defined objective is one that is specific, measurable, achievable, relevant, and time-bound (SMART)1. The goal of increasing sales of a mature product by reducing its price by 20% which would result in increased revenues of 2% over a 6-month period meets all these criteria, as it clearly states what the desired outcome is, how it will be measured, whether it is realistic and attainable, how it aligns with the organization's strategy, and when it will be achieved2.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 192: SMART Goals: How to Make Your Goals Achievable, MindTools, 2021, 1.

The marketing department for a major restaurant chain is interested in testing a Kids Eat Free campaign to determine if it will help to increase sales. They are interested in piloting the campaign to determine which day of the week will improve sales the most.

The campaign is launched across 7 cities with each city promoting a different day of the week. The sales data is collected and provided to a team for analysis. What concern might the analytics team have regarding data quality across cities?

A.
Normality
A.
Normality
Answers
B.
Heteroskedacity
B.
Heteroskedacity
Answers
C.
Linearity
C.
Linearity
Answers
D.
Variation
D.
Variation
Answers
Suggested answer: D

Explanation:

Variation is the degree to which the data values differ from each other or from a central tendency measure, such as the mean or median. Variation can affect the data quality across cities, as it can indicate the presence of outliers, errors, noise, or inconsistency in the data collection or processing methods. Variation can also influence the statistical analysis and interpretation of the results, as it can affect the significance, confidence, and validity of the findings12.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 302: Statistics for Business and Economics, David R. Anderson et al., 2014, p. 83.

Total 152 questions
Go to page: of 16