IIBA-CBDA Analyst Practice Questions
The free IIBA-CBDA: Certification in Business Data Analytics questions that deal with analyst, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #5
An analyst is looking at a particular dataset that includes the scores across all 8th grade students, across three schools. The analyst is trying to determine which type of statistics average to use to best represent the results. On looking through the dataset, the analyst has identified a few extreme outliers. As a result, the analyst was led to use the following type of average:
Correct answer: A
Explanation
The median is the type of statistics average that the analyst should use to best represent the results, because it is a measure of central tendency that divides the data set into two equal halves. The median is the middle value of the data set when it is arranged in ascending or descending order. The median is not affected by extreme outliers, unlike the mean, which is the arithmetic average of the data set. The median can give a more accurate representation of the typical score of the 8th grade students across the three schools. Options B, C, and D are not types of statistics average, but types of statistics measures that describe other aspects of the data set. The range is a measure of dispersion that shows the difference between the highest and the lowest values of the data set. The mean is a measure of central tendency that shows the sum of the values of the data set divided by the number of values. The mode is a measure of central tendency that shows the most frequent value of the data set. References: •Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 3: Analyze Data •Understanding the Guide to Business Data Analytics, page 17 •Business Data Analytics (IIBA®-CBDA Exam preparation) | Udemy, Section 3: Analyze Data, Lecture 13: Descriptive Statistics
Question #6
While creating a dataset for analysis, the analyst reviews the data collected and finds a large percentage of records are missing values. Which activity would the analyst perform in order to use this dataset?
Correct answer: C
Explanation
Weighting is a technique that assigns different values or weights to different records or variables in a dataset, based on their importance or relevance. Weighting can be used to handle missing values by giving them a lower weight or imputing them with a weighted average of other values. Weighting can also help to adjust for sampling bias or non- response bias in the data collection process. References: •Understanding the Guide to Business Data Analytics, page 16 •Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 3: Analyze Data •CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA®, page 8, CBDA Exam Sample Questions and Self-Assessment, Question 4
Question #9
A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?
Correct answer: C
Explanation
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 References: 1: Logical schema - Wikipedia 2: What Is a Data Model? | Coursera
Continue with IIBA-CBDA: Certification in Business Data Analytics
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in IIBA-CBDA: Certification in Business Data Analytics, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
All IIBA-CBDA: Certification in Business Data Analytics practice questions →