New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

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

Page: 1 / 15
Total 150 questions

Certification in Business Data Analytics (IIBA - CBDA) Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Question 1

A Data Dictionary is being developed for an employee database. When reviewing the data dictionary, the analyst recommends adding another primitive data element. Which element would be suggested?

Options:

A.

Street address

B.

First name

C.

Customer name

D.

Work phone number

Question 2

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:

Options:

A.

It meets all the criteria for a well-defined objective

B.

The organization can derive additional revenue from the product

C.

It indicates that the company does not have to incur costs associated with retiring this

product

D.

Management will be pleased that the mature product can still contribute to revenue

Question 3

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?

Options:

A.

A single data point

B.

A link between two data points

C.

A dedicated algorithm that calculates the node positions

D.

A collection of data points and links

Question 4

The analytics team scheduled a meeting with key stakeholders to present their recommendations. The team envisioned this as the final step of their work and fully expected complete acceptance of those recommendations, particularly given that very few questions were asked. They were surprised when they received word that the organization wasn't ready to move forward. What did they overlook?

Options:

A.

Stakeholders need to hear the same information multiple times

B.

Stakeholders never make quick decisions

C.

Communicating information requires a written report

D.

Communicating information is bi-directional and iterative

Question 5

A dataset contains 10 measures of workplace sustainability. The analytics team is in need of producing a single score of sustainability. Which of the following techniques if used would achieve this objective?

Options:

A.

Logistic regression

B.

Linkage algorithms

C.

Factor analysis

D.

K means clustering

Question 6

A professional association is funded by membership fees. The membership renewal occurs every 5 years. Although, they have a strong subscription rate each year, their renewal rate is low. They are working with an external firm specializing in Business Analytics to identify the groups of customers that have a high likelihood of cancelling their subscription after their first 5-year

term ends. This type of study is called:

Options:

A.

Untrained learning

B.

Supervised learning

C.

Trained learning

D.

Unsupervised learning

Question 7

A business analyst constructs a model they would like to review with key business stakeholders but decides to review the model first with the data scientist who has performed the data analysis. The data scientist provides some suggestions on how to reduce the complexity in the model. One suggestion is to use color to group objects needing to be associated. The data scientist is

encouraging using which Gestalt Principle of Perception with regards to data visualization?

Options:

A.

Connection

B.

Proximity

C.

Similarity

D.

Enclosure

Question 8

An analytics system is being developed by relying entirely on research questions that are framed using the results from benchmarking. Which research question is being asked?

Options:

A.

Which customers provide the greatest profit to the company?

B.

How efficient is the company compared to its competitors?

C.

Will more profit be made if we increase or decrease our sales price?

D.

Which employees are we in danger of losing?

Question 9

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?

Options:

A.

The percentile score provides value by assessing the attendee's score against the average

score for that exam

B.

While the exam score is an objective score, the percentile is a relative score that assesses

the attendee's score against the highest possible score

C.

By ranking, it provided additional insight on how the attendee performed in comparison to

other attendees

D.

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

performance

Question 10

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

Options:

A.

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

B.

A model that depicts the actual design of the relational database

C.

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

D.

Modelling that involves objects being defined at the schema level

Question 11

A software company launched a new product in late 2016. The product manager is reviewing a Box and Whisker plot used to compare year-over-year sales, from 2017 to 2018. What is the conclusion he can make from this chart?

Options:

A.

2017 minimum and maximum sales are higher than 2018, and the 2017 median result is

higher than the 2018 median result

B.

2017 minimum and maximum sales are higher than 2018, but the 2017 median result is

lower than 2018 1st quartile result

C.

2018 minimum and maximum sales are higher than 2017, and the 2018 quartile results are

higher than 2017 quartile results

D.

2018 minimum and maximum sales are higher than 2017, and the 2018 1st quartile is

higher than 2017 median result

Question 12

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:

Options:

A.

Sources of data

B.

Quality of the data

C.

Timeframe of analysis

D.

Measurement scale

Question 13

The research question prompting the use of analytics is well-defined. The team obtains the results and determines that the source data did not provide reliable results. As a result of this finding, the team modifies the original question to one that can be answered by the data. What is a risk that could impact the value of this analysis?

Options:

A.

The objective of the original research may not be met

B.

Timelines will be pushed out making stakeholders unhappy

C.

Increased costs associated with the source data

D.

The quality of the analysis may be negatively impacted

Question 14

Collaborative games are used by a business analyst to identify the research questions to be explored within an analytics system.

Participants are asked to write down a research question on a sticky note, put the notes on the wall, and move them towards related research questions. What type of Collaborative game is being played?

Options:

A.

Affinity Map

B.

Fishbowl

C.

People polling

D.

Product Box

Question 15

A colleague proposes measuring job satisfaction by asking the question "What is your salary?". What is the concerning factor about this question?

Options:

A.

Validity

B.

Clarity

C.

Reproducibility

D.

Subjectivity

Question 16

An insurance company has seen an upward trend in winter-related accidents over the past three years. The company has just completed an analytics study to better understand the primary reasons for these accidents and assess how many of the drivers were using winter tires. This analysis will help the company decide how to move forward with drivers not taking precautionary measures during winter. What type of analysis will help in determining the primary reasons and percentage of those drivers with winter tires?

Options:

A.

Prescriptive

B.

Descriptive and Predictive

C.

Descriptive

D.

Descriptive and Diagnostic

Question 17

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?

Options:

A.

Normality

B.

Heteroskedacity

C.

Linearity

D.

Variation

Question 18

A job satisfaction survey is being developed. Half of the employees will be asked the question "Do you enjoy working in your workplace?" The other half will be asked "Do you like the current work benefits?". The business analyst raises concern over the survey. What is concerning to the business analyst?

Options:

A.

Precision

B.

Reproducibility

C.

Reliability

D.

Validity

Question 19

A new dataset describing employee salaries is received by a company. A colleague wonders whether a variable follows a Gaussian distribution. Which of the following plots would demonstrate this?

Options:

A.

Normal probability plot

B.

Scatterplot

C.

Boxplot

D.

Lowess curve

Question 20

A Human Resource manager recently learned that their competitor reduced employee attrition rates by 20% after implementing personality tests as part of their screening process. Intrigued by the idea, the manager suggests collecting data on personality tests and attrition rates over the next year. The data from this year is then analyzed to explore possible relationships. What type of analytics has the team been asked to perform?

Options:

A.

Predictive

B.

Descriptive

C.

Prescriptive

D.

Diagnostic

Question 21

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:

Options:

A.

What product launch related costs can we expect?

B.

How much revenue does the product generate in Eastern Europe?

C.

Why does management need to know this?

D.

Do existing customers really like the product?

Question 22

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:

Options:

A.

Stratified sampling

B.

Quota sampling

C.

Purposive sampling

D.

Snowball sampling

Page: 1 / 15
Total 150 questions