QUESTION ONE

How fast data is processed and accessed is represented by which of the following V’s of Big Data?

Velocity

Correct Incorrect Correct answer

Virality

Correct Incorrect Correct answer

Validity

Correct Incorrect Correct answer

Veracity

Correct Incorrect Correct answer

QUESTION TWO

Data modelling is a process that helps one to understand the structures, form, and relationships of information. It requires one to first think of the model, then identify the model details and then how the model will be implemented. Which of the following is the correct name of data model implementation?

Logical

Correct Incorrect Correct answer

Conceptual

Correct Incorrect Correct answer

Rational

Correct Incorrect Correct answer

Physical

Correct Incorrect Correct answer

QUESTION THREE

The following activities are included in the Cross-Industry Standard Process for data mining:

Data Preparation

Data Understanding

Data Deployment

Business Understanding

Data Evaluation

Data modelling

Which of the following is the proper sequence of these activities?

4,2,1,6,5,3

Correct Incorrect Correct answer

1,6,5,2,3,4

Correct Incorrect Correct answer

1,3,5,6,4,2

Correct Incorrect Correct answer

2,1,3,5,6,4

Correct Incorrect Correct answer

QUESTION FOUR

Which of the following is NOT an activity in the modeling stage in the Cross-Industry Standard Process for Data Mining?

Select

Correct Incorrect Correct answer

Evaluate

Correct Incorrect Correct answer

Design

Correct Incorrect Correct answer

Build

Correct Incorrect Correct answer

QUESTION FIVE

For data visualisation, a bar chart will likely be classified as a______________.

Comparison

Correct Incorrect Correct answer

Composition

Correct Incorrect Correct answer

Relationship

Correct Incorrect Correct answer

Distribution

Correct Incorrect Correct answer

QUESTION SIX

A data analyst would like to present data in the form of a distribution. He will likely use all the following EXCEPT?

Histogram

Correct Incorrect Correct answer

Scatter graph

Correct Incorrect Correct answer

Line chart

Correct Incorrect Correct answer

Pie Chart

Correct Incorrect Correct answer

QUESTION SEVEN

Data Ethics are the norms of behaviour that promote appropriate judgements and accountability when acquiring, managing,

or using data, with the goals of protecting civil liberties, minimising risks to individuals and society, and maximising the

public good. All the following promote data ethics EXCEPT?

Fairness

Correct Incorrect Correct answer

Complying with the law

Correct Incorrect Correct answer

Promoting transparency

Correct Incorrect Correct answer

Respecting privacy and confidentiality

Correct Incorrect Correct answer

QUESTION EIGHT

Which of the following is NOT a concept of data integrity?

Data availability

Correct Incorrect Correct answer

Data validity

Correct Incorrect Correct answer

Data currency

Correct Incorrect Correct answer

Data accuracy

Correct Incorrect Correct answer

QUESTION NINE

With the high volume of data available for businesses, collecting meaningful data is a big challenge. To enable handling large

volumes of data, data collection tools are critical. Which of the following will likely be a data collection software?

Zoho

Correct Incorrect Correct answer

Python

Correct Incorrect Correct answer

Excel

Correct Incorrect Correct answer

R

Correct Incorrect Correct answer

QUESTION TEN

A data analyst makes the following comments about functions in excel:

To determine the variance of a list of 10 numbers we use =VAR.P(A1:A10)

To determine the standard deviation of 10 numbers we use = VAR.P(A1:A10)

To determine the variance of a list of 10 numbers we use = VAR.S(A1:A10)

Which of the following statements is TRUE?

Only statement 2 is correct

Correct Incorrect Correct answer

All the statements are correct

Correct Incorrect Correct answer

Only statement 3 is correct

Correct Incorrect Correct answer

Only statement 1 is correct

Correct Incorrect Correct answer

QUESTION ELEVEN

The following are the various phases of data models:

Physical

Logical

Conceptual

Which of the following represents the correct order of the models?

1,2,3

Correct Incorrect Correct answer

2,3,1

Correct Incorrect Correct answer

3,1,2

Correct Incorrect Correct answer

3,2,1

Correct Incorrect Correct answer

QUESTION TWELVE

Which of the following techniques is LEAST effective in obtaining data for easy storage and analysis?

Interviews

Correct Incorrect Correct answer

Online questionnaire such as on google forms

Correct Incorrect Correct answer

Recorded interviews

Correct Incorrect Correct answer

Self-administered email questionnaire

Correct Incorrect Correct answer

QUESTION THIRTEEN

According to cross-industry standard process for data mining, data preparation involves:

Obtaining data and information from different sources, processing and storing for future reference.

Correct Incorrect Correct answer

Fixing or removing incorrect, corrupted, incorrectly formatted data and information.

Correct Incorrect Correct answer

Collecting data and information about business requirements from stakeholders and end users.

Correct Incorrect Correct answer

Creating a visual representation of either a whole information system or parts of it to communicate connections between data points and structures.

Correct Incorrect Correct answer

QUESTION FOURTEEN

The following statements are associated with big data:

(i)Big data is a collection of data that is huge in volume, yet growing exponentially with time.

(ii)Big data that can be stored, accessed and processed in the form of fixed format is termed as structured data.

(iii)Big data that is heterogeneous and contains a combination of simple text files and images is semi structured.

Which of the following choices is correct?

Statements (i) and (ii) are correct

Correct Incorrect Correct answer

Statements (ii) and (iii) are correct

Correct Incorrect Correct answer

All the statements are correct

Correct Incorrect Correct answer

Statements (i) and (iii) are correct

Correct Incorrect Correct answer

QUESTION FIFTEEN

Which of the following is NOT the correct definition of one of the ‘V’s of Big Data?

Velocity: The speed at which big data is collected and processed

Correct Incorrect Correct answer

Value: The usefulness of the information obtained from analysing big data

Correct Incorrect Correct answer

Veracity: Multifactor, unstructured and dynamic nature of big data

Correct Incorrect Correct answer

Volume: The size of big data

Correct Incorrect Correct answer

QUESTION SIXTEEN

The following are the different categories of data analytics:

Diagnostic

Predictive

Descriptive

Prescriptive

Which of the following is the correct order of value?

3,1,4,2

Correct Incorrect Correct answer

3,4,2,1

Correct Incorrect Correct answer

2,3,4,1

Correct Incorrect Correct answer

1,3,2,4

Correct Incorrect Correct answer

QUESTION SEVENTEEN
David Mongare is the audit manager of Mkaguzi Auditors. He is carrying out analytical reviews at two stages: at planning
and at substantive testing. Which type of analytics relates to the two stages?

Predictive analytics for planning and diagnostic analytics for substantive testing

Correct Incorrect Correct answer

Diagnostic analytics for planning and predictive analytics for substantive testing

Correct Incorrect Correct answer

Descriptive analytics for planning and diagnostic analytics for substantive testing

Correct Incorrect Correct answer

Predictive analytics for planning and descriptive analytics for substantive testing

Correct Incorrect Correct answer

QUESTION EIGHTEEN

Which of the following is NOT a strategy that the data analyst will use in handling missing data to enable data analysis:

Drop observations that have missing values

Correct Incorrect Correct answer

Estimate the missing value using other observations

Correct Incorrect Correct answer

Assign an integer that will enable the values to be processed as null values

Correct Incorrect Correct answer

Highlighting the observation with a tag

Correct Incorrect Correct answer

QUESTION NINETEEN
You are given the following categories of data visualisation:
1.Composition
2.Distribution
3.Comparison
4.Relationship
5.Trends
Which of the following choices represents the order from simple to complex in terms of analysing data for visualisation?

5,3,2,4,1

Correct Incorrect Correct answer

4,3,2,1,5

Correct Incorrect Correct answer

2,3,1,4,5

Correct Incorrect Correct answer

1,5,4,3,2

Correct Incorrect Correct answer

QUESTION TWENTY

Which of the following data visualisation charts will likely present more than two variables over time effectively?

Scatter Graph

Correct Incorrect Correct answer

Bubble Chart

Correct Incorrect Correct answer

Column Chart

Correct Incorrect Correct answer

Line Chart

Correct Incorrect Correct answer

USE THE FILE BELOW TO ANSWER QUESTIONS FROM Q21-Q25

QUESTION Q21 AND 22 ARE COMPULSORY

ANSWER ANY OTHER ONE QUESTION EITHER Q23, Q24 OR Q25

https://rcmonlinecollege.co.ke/wp-content/uploads/2023/09/PIVOT-TABLES.xlsx

Upload your answer to this question.

This response will be reviewed and graded after submission.

FINAL BDA TEST DECEMBER 2023

FINAL BDA TEST DECEMBER 2023

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

Average score
Your score