IIBA CBDA Practice Test - Questions Answers, Page 4
List of questions
Related questions
Question 31
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?
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.
Question 32
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:
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.
Question 33
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?
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.
Question 34
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?
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.
Question 35
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?
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.
Question 36
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?
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.
Question 37
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?
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.
Question 38
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?
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.
Question 39
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:
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.
Question 40
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?
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.
Question