IIBA CBDA IIBA - CBDA Exam Practice Test Instant Access

Question 1

A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?

AThe layer of views created to summarize data or provide another perspective of certain data

BA model that depicts the actual design of the relational database

CAn abstraction of the conceptual data model that includes rules of normalization

DModelling that involves objects being defined at the schema level

Answer : C

A logical database model is a data model of a specific problem domain expressed independently of a particular database management product or storage technology. It describes data using notation that corresponds to a data organization used by a database management system, such as relational tables and columns. It also includes rules of normalization, which are the process of converting complex data structures into simple, stable data structures12 Reference: 1: Logical schema - Wikipedia 2: What Is a Data Model? | Coursera

Question 2

The analytics team is struggling with which recommendation to make. Their challenge is that they have five good options and this indecision is stopping them from moving forward. To help the team finalize their recommendation, the BA professional on the team recommends they complete:

ARoot cause analysis

BBusiness rules analysis

CData flow diagrams

DAcceptance and evaluation criteria

Answer : D

Acceptance and evaluation criteria are the techniques that the BA professional on the team should recommend they complete, because they are the standards or measures that are used to evaluate the suitability and value of each option. Acceptance and evaluation criteria can help the team compare the benefits, costs, risks, and impacts of each option, and determine which one best meets the needs and expectations of the stakeholders. Acceptance and evaluation criteria can also help the team communicate the rationale and evidence behind their recommendation, and ensure that the recommendation is aligned with the business goals and objectives. Reference:

* Business Analysis Certification in Data Analytics, CBDA | IIBA, CBDA Competencies, Domain 5: Use Results to Influence Business Decision Making

* Understanding the Guide to Business Data Analytics, page 9

* Acceptance and Evaluation Criteria | Business Analysis

Question 3

An organization's customers are categorized based on the amount of purchases completed over the last 12 months. The analytics team would like to ensure the accuracy of their survey results and decide to randomly select 500 customers to participate in a survey from this large pool of customers. This is an example of:

AStratified sampling

BQuota sampling

CPurposive sampling

DSnowball sampling

Answer : A

Stratified sampling is a technique that divides the population into homogeneous subgroups (strata) based on a relevant characteristic, such as the amount of purchases, and then randomly selects a proportional number of elements from each subgroup to form the sample. Stratified sampling ensures that the sample is representative of the population and reduces the sampling error and bias12. Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 312: Statistics for Business and Economics, David R. Anderson et al., 2014, p. 262.

Question 4

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?

AKeep some sections high-level, and some sections detailed

BKeep it detailed if there is a lot of good information to share

CKeep it high-level, summarizing key insights and metrics

DKeep it detailed so one dashboard can be shared to all levels of the organization

Answer : C

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

Question 5

Senior executives in a large organization receive numerous sales reports of every sale through a corporate dashboard on a weekly basis. The executives are considering budget increases for various functions but would like to know if they are obtaining good returns for current budget allocations. They ask the analytics team to research and answer: "How effective is our marketing

spend?" This question is:

AAlready answered in the sales data

BDifficult to analyze because its narrowly focused

CSufficient to begin initial analysis

DToo broadly scoped to be effectively answered

Answer : D

The question ''How effective is our marketing spend?'' is too broadly scoped to be effectively answered, because it is a vague and ambiguous question that does not specify the criteria, scope, or timeframe for measuring the effectiveness of the marketing spend. The question also does not define what constitutes marketing spend, or how it relates to the sales data or the budget allocations. The question needs to be refined and clarified to make it more focused, relevant, and feasible for the analytics team to answer. For example, the question could be rephrased as ''How does the marketing spend per channel affect the sales revenue and customer retention rate in the last quarter?'' Reference:

* Business Analysis Certification in Data Analytics, CBDA | IIBA, CBDA Competencies, Domain 1: Identify the Research Questions

* Understanding the Guide to Business Data Analytics, page 10-11

* CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA, page 8, CBDA Exam Sample Questions and Self-Assessment, Question 16

Question 6

A large number of text messages are received by Twitter each year making Twitter one example of Big Data. What data characteristic represents this large number of text messages?

AVeracity

BVelocity

CValue

DVariety

Answer : B

Velocity is one of the four V's of Big Data, along with Volume, Variety, and Veracity. Velocity refers to the speed at which data is generated, collected, and processed. A large number of text messages received by Twitter each year is an example of high-velocity data, as it requires real-time or near-real-time processing and analysis to extract insights and value from it. High-velocity data poses challenges and opportunities for business data analytics, as it requires efficient and scalable data infrastructure, streaming analytics, and timely decision-making.

Question 7

The results for a certification exam were revealed in percentage and percentile. The results for one of the attendees was: 75%, 90th percentile. What is the value in sharing the percentile score?

AThe percentile score provides value by assessing the attendee's score against the average
score for that exam

BWhile the exam score is an objective score, the percentile is a relative score that assesses
the attendee's score against the highest possible score

CBy ranking, it provided additional insight on how the attendee performed in comparison to
other attendees

DThe percentile score does not add any additional value in assessing the attendee's
performance

Answer : C

The percentile score provides value by ranking the attendee's score among all the scores of the exam takers. A percentile score of 90 means that the attendee scored higher than 90% of the exam takers, and only 10% scored higher than the attendee. This gives a relative measure of how the attendee performed in comparison to other attendees, and how competitive or exceptional the score is. The percentile score does not depend on the average or the highest possible score of the exam, but only on the distribution of the scores of the exam takers. 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 9

* What is a Percentile? - Statistics By Jim

IIBA Certification in Business Data Analytics CBDA IIBA - CBDA Exam Practice Test