Which Excel feature enables users to combine data from multiple sources into a single data table?

A) Data Analysis

Correct Incorrect Correct answer

B) Data Validation

Correct Incorrect Correct answer

C) Data Consolidation

Correct Incorrect Correct answer

D) Data Modeling

Correct Incorrect Correct answer

2

The CRISP framework is used for:

A) Data visualization in Excel

Correct Incorrect Correct answer

B) Conducting financial analysis

Correct Incorrect Correct answer

C) Data mining and analytics

Correct Incorrect Correct answer

D) Creating pivot tables

Correct Incorrect Correct answer

3.

What is the first stage in the data lifecycle according to the CRISP framework?

A) Obtaining data

Correct Incorrect Correct answer

B) Modeling data requirements

Correct Incorrect Correct answer

C) Identifying data sources

Correct Incorrect Correct answer

D) Using data for business decisions

Correct Incorrect Correct answer

4

Which data cleaning tool is used for data integration and blending in data analytics?

A) Tableau

Correct Incorrect Correct answer

B) Alteryx

Correct Incorrect Correct answer

C) PowerBI

Correct Incorrect Correct answer

D) Oracle

Correct Incorrect Correct answer

5

What is the primary purpose of the “Data Management” stage in data analytics?

A) To query and retrieve data from databases

Correct Incorrect Correct answer

B) To clean and prepare data for analysis

Correct Incorrect Correct answer

C) To provide data storage and database administration

Correct Incorrect Correct answer

D) To apply statistical algorithms to discover patterns in data

Correct Incorrect Correct answer

6

What does the term “data visualization” mean in the context of data analytics?

A) The process of querying and retrieving data from databases

Correct Incorrect Correct answer

B) The use of visual elements to represent data in a graphical format

Correct Incorrect Correct answer

C) The analysis of historical data to identify trends and patterns

Correct Incorrect Correct answer

D) The transformation of raw data into a usable format

Correct Incorrect Correct answer

7

What is the role of skepticism in data analytics?

A) To trust all data sources without questioning their accuracy

Correct Incorrect Correct answer

B) To verify and validate data to ensure its reliability

Correct Incorrect Correct answer

D) To rely solely on automated data analytics tools

Correct Incorrect Correct answer

C) To ignore any potential biases in data analysis

Correct Incorrect Correct answer

8

Why are challenges encountered in data analytics processes?

A) Data analytics tools are outdated and ineffective

Correct Incorrect Correct answer

B) Data analytics professionals lack technical skills

Correct Incorrect Correct answer

C) Data analysis results are always accurate and reliable

Correct Incorrect Correct answer

D) Data sources may be incomplete, inconsistent, or unstructured

Correct Incorrect Correct answer

9

What are ethical issues related to data analytics?

select more than one option

A) Failing to protect data from security breaches

Correct Incorrect Correct answer

B) Disclosing sensitive information without consent

Correct Incorrect Correct answer

C) Being overly skeptical of data sources

Correct Incorrect Correct answer

D) Using outdated analytics tools

Correct Incorrect Correct answer

10

What is the primary goal of exploratory data analysis?

A) To make predictions about future outcomes

Correct Incorrect Correct answer

B) To uncover patterns and relationships in data

Correct Incorrect Correct answer

C) To encrypt data to ensure security

Correct Incorrect Correct answer

D) To validate data sources

Correct Incorrect Correct answer

11

. ___ is a category, also called supervised machine learning methods in which the data is split on two parts.

Classification

Correct Incorrect Correct answer

Clustering

Correct Incorrect Correct answer

Data mining

Correct Incorrect Correct answer

None of the mentioned above

Correct Incorrect Correct answer

12

Clustering belongs to ___ data analysis.

Supervised

Correct Incorrect Correct answer

Unsupervised

Correct Incorrect Correct answer

Both A and B

Correct Incorrect Correct answer

None of the mentioned above

Correct Incorrect Correct answer

13

Data Analysis is a process of ?

inspecting data

Correct Incorrect Correct answer

cleaning data

Correct Incorrect Correct answer

transforming data

Correct Incorrect Correct answer

All of the above

Correct Incorrect Correct answer

14

Which of the following is not a major data analysis approaches?

Data Mining

Correct Incorrect Correct answer

Predictive Intelligence

Correct Incorrect Correct answer

Business Intelligence

Correct Incorrect Correct answer

Text Analytics

Correct Incorrect Correct answer

15

___ are used when we want to visually examine the relationship between

two quantitative variables.

Bar graph

Correct Incorrect Correct answer

Scatterplot

Correct Incorrect Correct answer

Line graph

Correct Incorrect Correct answer

Pie chart

Correct Incorrect Correct answer

16

Choose the correct keyword for this definition: A graphical representation of a data set:

Data Set

Correct Incorrect Correct answer

Visualization

Correct Incorrect Correct answer

Data Plot

Correct Incorrect Correct answer

Investigative Cycle

Correct Incorrect Correct answer

17

Which of the following steps is performed by a data scientist after collecting the data?

Data integration

Correct Incorrect Correct answer

Data manipulation

Correct Incorrect Correct answer

Data replication

Correct Incorrect Correct answer

Data cleansing

Correct Incorrect Correct answer

18

One or more of the following activities is/are not from Phase 1 of Data Science Life Cycle.

Developing initial hypothesis

Correct Incorrect Correct answer

Learning the target domain

Correct Incorrect Correct answer

Visualize initial hypothesis

Correct Incorrect Correct answer

All of the above

Correct Incorrect Correct answer

19

A bank collected data on visitors’ viewing habits at the bank’s website. Which technique can be best used to identify pages commonly viewed during the same visit to the website?

Association rules

Correct Incorrect Correct answer

Classification

Correct Incorrect Correct answer

Clustering

Correct Incorrect Correct answer

Panel analysis

Correct Incorrect Correct answer

20

.“Alteryx” is an example of a__________.

Data analysis tool

Correct Incorrect Correct answer

Data cleaning tool

Correct Incorrect Correct answer

Data management tool

Correct Incorrect Correct answer

Data visualisation tool

Correct Incorrect Correct answer

21

Correlation analysis is an example of:

Descriptive analytics

Correct Incorrect Correct answer

Prescriptive analytics

Correct Incorrect Correct answer

Exploratory analytics

Correct Incorrect Correct answer

Predictive analytics

Correct Incorrect Correct answer

22

What Excel function is used to calculate the payment required to pay off a loan over a set period of time?

PV

Correct Incorrect Correct answer

FV

Correct Incorrect Correct answer

PMT

Correct Incorrect Correct answer

RATE

Correct Incorrect Correct answer

23

Which toolsin Excel are best for undertaking a sensitivity analysis?

Scenarios and Data tables

Correct Incorrect Correct answer

Scenarios and Solver

Correct Incorrect Correct answer

Data tables and Goal seek

Correct Incorrect Correct answer

Data tables and Scenarios

Correct Incorrect Correct answer

24

When dealing with models containing multiple rows of data, users can use the___________________________ function
in Excel to create expandable/contractable sections in the worksheet for easy auditing.

Text to Columns

Correct Incorrect Correct answer

Tables

Correct Incorrect Correct answer

Group

Correct Incorrect Correct answer

Filter

Correct Incorrect Correct answer

25

Which of the following is not a type of data analysis in business?

Explanatory analytics

Correct Incorrect Correct answer

Descriptive analytics

Correct Incorrect Correct answer

Prescriptive analytics

Correct Incorrect Correct answer

Predictive analytics

Correct Incorrect Correct answer

BDA MOCK ONE

BDA MOCK ONE

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

22. Question

23. Question

24. Question

25. Question