Data Analyst

Data Analyst L1

1 / 100

1)

Which of the following is an open-source data visualization tool?

a) Tableau

b) Power BI

c) QlikView

d) Apache Superset

2 / 100

2) Which term describes data that is continuously generated and needs to be processed in real-time or near real-time?

a) Streaming Data

b) Batch Data

c) Static Data

d) Historical Data

3 / 100

3) What is data cleansing (or data scrubbing)?

a) The process of collecting data from various sources.

b) The process of backing up data.

c) The process of transforming data into a new format.

d) The process of identifying and correcting or removing corrupt, inaccurate, or irrelevant data.

4 / 100

4) What does the term “dirty data” mean?

a) Data that is encrypted

b) Highly sensitive data

c) Data that is raw

d) Inaccurate, incorrect, or incomplete data

5 / 100

5) What does normalization in databases do?

a) Backup data

b) Remove data redundancy

c) Visualize data

d) Aggregate data

6 / 100

6) What is "inferential statistics"?

a) b) Methods used to draw conclusions or make predictions about a population based on a sample of data.

b) c) Techniques for visualizing data.

c) a) Techniques used to describe the main characteristics of a dataset.

d) d) Methods for cleaning data.

7 / 100

7) What SQL keyword is used to sort data?

a) SORT

b) ORDER BY

c) HAVING

d) GROUP BY

8 / 100

8) What kind of machine learning is clustering?

a) Unsupervised

b) Reinforcement

c) Supervised

d) None

9 / 100

9) How do you create a pivot table in Excel?

a) View → Copy

b) Home → Sort

c) Insert → Table

d) Data → Pivot Table

10 / 100

10) What is a "primary key" in a relational database?

a) A field used to link two tables together.

b) A field that contains duplicate values.

c) A field that stores sensitive information.

d) A field that uniquely identifies each record in a table.

11 / 100

11) Which of the following is an appropriate measure of variability for categorical data?

a) Variance

b) Frequency distribution

c) Range

d) Standard deviation

12 / 100

12) What is a "dashboard" in data analysis?

a) A written report with detailed statistical analysis.

b) A raw data file.

c) A graphical user interface that provides at-a-glance views of key performance indicators (KPIs) and metrics

d) A tool for data entry.

13 / 100

13)

Which analytics helps in decision-making by suggesting actions?

a) Predictive

b) Prescriptive

c) Diagnostic

d) Historical

14 / 100

14) What is the default join type in SQL if JOIN is specified without a type?

a) FULL JOIN

b) RIGHT JOIN

c) LEFT JOIN

d) INNER JOIN

15 / 100

15)

What type of analytics answers “What is likely to happen?”

a) Predictive

b) Descriptive

c) Diagnostic

d) Prescriptive

16 / 100

16) When cleaning data in Excel, what does "deduplication" refer to?

a) Doubling the size of a dataset.

b) Formatting data for printing.

c) Copying data to another sheet.

d) Removing duplicate rows or entries from a dataset.

17 / 100

17) What is "multicollinearity" in regression?

a) c) When the relationship between variables is non-linear.

b) d) When there are missing values in the independent variables.

c) a) When the dependent variable has multiple categories.

d) b) When two or more independent variables in a regression model are highly correlated with each other.

18 / 100

18)

Which chart is best for displaying correlation?

a) Area chart

b) Scatter plot

c) Histogram

d) Pie chart

19 / 100

19) What is a "Type I error" in hypothesis testing?

a) b) Rejecting a true null hypothesis (false positive).

b) a) Failing to reject a false null hypothesis.

c) c) Accepting a false null hypothesis.

d) d) Not collecting enough data.

20 / 100

20) Which Python library is primarily used for data visualization?

a) SciPy

b) Matplotlib

c) NumPy

d) Pandas

21 / 100

21)

What does KPI stand for?

a) Key Performance Indicator

b) Knowledge Per Index

c) Key Predictive Insight

d) Knowledge Performance Input

22 / 100

22) Which of the following is a common issue encountered during data acquisition?

a) Instant access to all necessary data.

b) Perfectly clean and consistent data.

c) d) No security concerns

d) Data silos, inconsistent formats, and missing values.

23 / 100

23)

What is the purpose of "sampling" in data analysis?

a) To analyze every single data point in a large dataset.

b) To permanently delete data from a dataset.

c) To create new data points from existing ones.

d) To select a representative subset of data from a larger dataset for analysis.

24 / 100

24) What does ETL stand for in the context of data processing?

a) Export, Transform, Load

b) Extract, Transform, Load

c) Encode, Translate, Link

d) Extract, Transfer, Link

25 / 100

25) Which chart type is best for showing the distribution of a single numerical variable?

a) d) Scatter plot

b) a) Bar chart

c) c) Histogram

d) b) Pie chart

26 / 100

26) Which correlation coefficient indicates a perfect positive linear relationship?

a) 1

b) 0

c) -1

d) 0.5

27 / 100

27) What is the "mean" of a dataset?

a) The difference between the highest and lowest values.

b) The most frequently occurring value.

c) The sum of all values divided by the number of values.

d) The middle value when data is ordered.

28 / 100

28) What is the primary purpose of data validation during data entry?

a) To make data entry faster.

b) To automatically generate reports.

c) To ensure the accuracy and integrity of data at the point of entry.

d) To encrypt data.

29 / 100

29)

What is "correlation"?

a) a) A measure of cause and effect between two variables.

b) c) The average of two datasets.

c) b) A statistical measure that expresses the extent to which two variables are linearly related.

d) d) The difference between two variables.

30 / 100

30)

What is the role of a data analyst?

a) Building front-end apps

b) Designing logos

c) Interpreting and analyzing data to support decision-making

d) Installing hardware

31 / 100

31) What is the "mode" of a dataset?

a) The middle value.

b) The value that appears most frequently in a dataset.

c) The sum of all values.

d) The average of the values.

32 / 100

32) What does "SQL" stand for?

a) Sequential Query Logic

b) Structured Query Language

c) Standard Question Logic

d) System Query Link

33 / 100

33)

What is the main focus of diagnostic analytics?

a) Predicting future outcomes

b) Recommending actions

c) Understanding why something happened

d) Understanding what happened

34 / 100

34) What is "data granularity"?

a) The level of detail at which data is collected or stored.

b) The overall size of a dataset.

c) The format of the data.

d) The freshness of the data.

35 / 100

35) What formula is used to calculate variance?

a) Range

b) Average squared deviation from mean

c) Sum of all values

d) Median

36 / 100

36) What is a "p-value" in hypothesis testing?

a) d) The power of the test.

b) a) The probability of rejecting the null hypothesis when it is true.

c) b) The probability of observing results as extreme as, or more extreme than, the observed results, assuming the null hypothesis is true.

d) c) The significance level of the test

37 / 100

37) What is "descriptive statistics"?

a) Techniques used to make predictions about future outcomes.

b) Methods used to describe and summarize the main features of a dataset.

c) Methods used to draw conclusions about a population based on a sample

d) Techniques for collecting raw data.

38 / 100

38)

A heatmap is used to:

a) Clean datasets

b) Track errors

c) Filter rows

d) Highlight patterns in data

39 / 100

39) What is the primary purpose of SQL?

a) Writing reports

b) Designing websites

c) Managing databases

d) Creating presentations

40 / 100

40)

Which of the following is NOT a data source?

a) Sensors

b) Web logs

c) Illustrator

d) Telemetry

41 / 100

41) What is the difference between "descriptive analytics" and "predictive analytics"?

a) Descriptive analytics tells you what will happen, predictive analytics tells you what has happened.

b) They are the same thing.

c) Descriptive analytics tells you what has happened, predictive analytics tells you what will happen.

d) Descriptive analytics uses only qualitative data, predictive analytics uses only quantitative data.

42 / 100

42) What is "data governance"?

a) The process of cleaning data.

b) The process of collecting data from public sources.

c) The government's control over data privacy.

d) The overall management of the availability, usability, integrity, and security of data.

43 / 100

43) Which is a continuous variable?

a) Age

b) Gender

c) Eye color

d) Marital status

44 / 100

44)

Descriptive Analytics focuses on:

a) Future trends

b) Data visualization

c) Past performance

d) Automation

45 / 100

45)

Which skill is crucial for a data analyst?

a) Communication

b) All of the above

c) SQL

d) Visualization

46 / 100

46) What is the "median" of a dataset?

a) b) The most common value.

b) c) The middle value when the data is arranged in ascending or descending order.

c) d) The average of the highest and lowest values.

d) a) The sum of all values.

47 / 100

47) What is the difference between a "data warehouse" and a "data lake"?

a) A data warehouse is optimized for structured, processed data for reporting, while a data lake stores raw, diverse data for various analytical purposes.

b) A data warehouse is always cloud-based, a data lake is always on-premise.

c) A data warehouse stores raw data, a data lake stores processed data.

d) There is no significant difference.

48 / 100

48) How does a Box Plot help?

a) Plots time series

b) It visualizes frequency distribution

c) Shows relationships between variables

d) Displays min, max, median, quartiles, and outliers

49 / 100

49) What is the purpose of "A/B testing"?

a) To test the reliability of a database.

b) To compare two versions of a product, webpage, or feature to determine which performs better.

c) To analyze customer demographics.

d) To categorize unstructured data.

50 / 100

50) What does EDA stand for?

a) Estimated Data Aggregation

b) Exploratory Data Analysis

c) Enhanced Data Analysis

d) Extended Data Assimilation

51 / 100

51) How do you describe categorical variables?

a) Continuous

b) Quantitative

c) Numerical

d) Qualitative

52 / 100

52) What is the role of a "data dictionary"?

a) To translate data into different languages.

b) To store passwords for databases.

c) To provide metadata about data elements, including definitions, types, and relationships.

d) To define business terms and their meaning.

53 / 100

53) In Excel, which function returns the current time?

a) TIME()

b) DATE()

c) NOW()

d) TODAY()

54 / 100

54) Which chart would you use to show the relationship between two numeric variables?

a) Pie chart

b) Scatter plot

c) Histogram

d) Bar chart

55 / 100

55)

Which of these is a type of Data Analytics?

a) Behavioral Analytics

b) Comparative Analytics

c) Quantitative Analytics

d) Predictive Analytics

56 / 100

56) What is the difference between a "metric" and a "dimension" in data analysis?

a) They are interchangeable terms.

b) A metric is a descriptive category (e.g., product name), a dimension is a quantifiable measure (e.g., sales revenue).

c) A metric is a quantifiable measure (e.g., sales revenue), a dimension is a descriptive category (e.g., product name).

d) Metrics are only used in dashboards, dimensions are only used in reports.

57 / 100

57) Which tool is commonly used for business intelligence dashboards?

a) MS Word

b) Sublime Text

c) Tableau

d) Photoshop

58 / 100

58)

What is the first step in the data analytics process?

a) Data modeling

b) Data visualization

c) Decision-making

d) Data collection

59 / 100

59) When would you typically use a "t-test"?

a) To analyze the correlation between multiple variables

b) To determine if a dataset is normally distributed.

c) To compare the means of two groups.

d) To visualize data distributions.

60 / 100

60) Which type of data error involves a value being outside the expected range or type?

a) Duplicate data

b) Missing data

c) Outlier/Invalid data

d) Inconsistent formatting

61 / 100

61) What is "sampling bias"?

a) A situation where the sample is not representative of the population from which it was drawn.

b) When data is collected from only one source.

c) When every member of the population has an equal chance of being selected for a sample.

d) Random errors in data collection.

62 / 100

62) Which technique involves cleaning and transforming raw data?

a) Data storage

b) Data blending

c) Data mining

d) Data wrangling

63 / 100

63)

What is required for successful A/B testing?

a) Large data only

b) Only one variation

c) Only historic data

d) Randomized assignment

64 / 100

64)

Structured data is best stored in:

a) SQL databases

b) Excel

c) PDFs

d) Images

65 / 100

65) What is a "time series analysis"?

a) Analysis of data points collected or recorded over a period of time.

b) Analysis of spatial data.

c) Analysis of qualitative data.

d) Analysis of data collected at a single point in time.

66 / 100

66) Which type of database is most commonly used for storing structured data in rows and columns?

a) Document Database

b) Graph Database

c) NoSQL Database

d) Relational Database (SQL)

67 / 100

67) What does "standard deviation" measure?

a) The correlation between two variables.

b) The spread or dispersion of data points around the mean.

c) The central tendency of the data.

d) The frequency of the most common value.

68 / 100

68) What is "bias" in data?

a) The act of creating data visualizations.

b) The process of securing data.

c) A systematic error in a data collection process that leads to skewed or inaccurate results.

d) The process of collecting data from multiple sources.

69 / 100

69) What is the purpose of "confidence intervals"?

a) To provide a range of values within which the true population parameter is likely to lie, with a certain level of confidence.

b) To provide a single best estimate of a population parameter.

c) To measure the correlation between variables.

d) To reject the null hypothesis.

70 / 100

70) What is a "Foreign Key" in a relational database?

a) A column or a set of columns that uniquely identifies a record in its own table.

b) A key that restricts data access to foreign users.

c) A key used for encrypting data.

d) A column or a set of columns in one table that refers to the primary key in another table.

71 / 100

71) What does SQL JOIN do?

a) Deletes rows

b) Filters rows

c) Combines rows from multiple tables based on related columns

d) Creates tables

72 / 100

72) What is the difference between OLAP and OLTP?

a) OLAP is for analytics; OLTP is for transactions

b) OLTP stores images

c) OLAP is slower

d) OLAP is unstructured data

73 / 100

73) What is pivoting in data analysis?

a) Wrangling data

b) Removing duplicates

c) Optimizing queries

d) Transforming data from long to wide format

74 / 100

74) What Python function helps find missing data in a DataFrame?

a) df.fillna()

b) df.clean()

c) df.dropna()

d) df.isnull()

75 / 100

75) What does Python’s Pandas library stand for?

a) Parallel Analysis

b) Panel Data

c) Pandemonium Data

d) None of the above

76 / 100

76) In statistics, what is a "null hypothesis" (H0)?

a) The conclusion of a statistical test.

b) A statement that there is a significant relationship between variables.

c) A statement that there is no significant difference or relationship between variables.

d) A statement that the experiment will fail.

77 / 100

77) What is the "central limit theorem"?

a) States that the sum of a large number of independent and identically distributed random variables will be normally distributed, regardless of the original distribution.

b) Describes the behavior of outliers.

c) States that all data distributions are normal.

d) Is only applicable to small datasets.

78 / 100

78) What does the correlation coefficient measure?

a) Causality

b) Variance

c) Strength and direction of linear relationship

d) Distribution shape

79 / 100

79) Q23. Which of the following data types is not primitive in JavaScript?

a) Boolean

b) String

c) Number

d) Object

80 / 100

80) Q36. Which new data structure was introduced in ES6 to store unique values?

a) Map

b) Set

c) Stack

d) List

81 / 100

81) What is a histogram used for?

a) Predict future values

b) Show parts of a whole

c) Show frequency distribution

d) Show relationships

82 / 100

82) What is a foreign key in a database?

a) An index

b) A key from another table to create relationship

c) The primary identifier in a table

83 / 100

83) Which is a common measure of central tendency?

a) Correlation

b) Median

c) Standard Deviation

d) Variance

84 / 100

84) What is "data privacy"?

a) Storing data on private servers only.

b) Encrypting all data regardless of content.

c) Making all data publicly available.

d) The protection of personal data from unauthorized access and use.

85 / 100

85) In Python, which function reads an Excel file into a DataFrame?

a) pd.read_excel()

b) pd.open_excel()

c) pd.import_excel()

d) pd.load_excel()

86 / 100

86)

Outlier detection is critical because:

a) Outliers are required for sampling

b) Outliers can distort analytic results

c) Outliers are always correct

d) Outliers always indicate mistakes

87 / 100

87)

What is the primary goal of Data Analytics?

a) Increase website traffic

b) Design graphics

c) Manage servers

d) Extract useful insights from data

88 / 100

88) Which between mean, median and mode is most sensitive to outliers?

a) None

b) Median

c) Mean

d) Mode

89 / 100

89) What is the primary purpose of data profiling?

a) Discover hidden patterns

b) Evaluate data quality

c) Predict future trends

d) Visualize data

90 / 100

90) What is the purpose of "normalization" in database design?

a) To make queries more complex.

b) To speed up data retrieval.

c) To improve data integrity and reduce data redundancy.

d) To increase data redundancy.

91 / 100

91) What is the concept of "Big Data" in finance?

a) Data that is only accessible to financial institutions.

b) Refers to extremely large datasets that may be analyzed computationally to reveal patterns, trends, and associations, especially relating to human behavior and interactions.

c) Only refers to very large spreadsheets.

d) Data that is always perfectly accurate.

92 / 100

92)

Which of the following is NOT a Big Data characteristic?

a) Variety

b) Volume

c) Versioning

d) Velocity

93 / 100

93) What is "regression analysis" primarily used for?

a) To clean missing data.

b) To describe the relationship between a dependent variable and one or more independent variables.

c) To calculate the standard deviation.

d) To find the mode of a dataset.

94 / 100

94) Which measure of central tendency is most affected by outliers?

a) All are equally affected.

b) Median

c) Mode

d) Mean

95 / 100

95) When performing a "chi-square test," what kind of data are you typically working with?

a) Categorical data

b) Textual data

c) Numerical data

d) Time-series data

96 / 100

96) What does the Excel function IF() do?

a) Joins two cells

b) Returns date

c) Performs conditional checks

d) Counts numbers

97 / 100

97)

Which of these is NOT a BI tool?

a) MS Paint

b) Power BI

c) Tableau

d) Google Data Studio

98 / 100

98) What is the use of GROUP BY in SQL?

a) Delete rows

b) Filter rows

c) Group rows with same column value

d) Sort rows

99 / 100

99) What’s the use of the SQL DISTINCT keyword?

a) To delete rows

b) To remove duplicate rows

c) To count rows

d) To select all rows

100 / 100

100) What does a "Z-score" tell you?

a) The correlation between two variables.

b) How many standard deviations a data point is from the mean.

c) The mean of a distribution.

d) The probability of an event occurring.

Your score is

The average score is 78%

0%

Exit

What is a Data Analyst Intern?

Which of the following is an open-source data visualization tool?

Which analytics helps in decision-making by suggesting actions?

What type of analytics answers “What is likely to happen?”

Which chart is best for displaying correlation?

What does KPI stand for?

What is the role of a data analyst?

What is the main focus of diagnostic analytics?

A heatmap is used to:

Which of the following is NOT a data source?

Descriptive Analytics focuses on:

Which skill is crucial for a data analyst?

Which of these is a type of Data Analytics?

What is the first step in the data analytics process?

What is required for successful A/B testing?

Structured data is best stored in:

Outlier detection is critical because:

What is the primary goal of Data Analytics?

Which of the following is NOT a Big Data characteristic?

Which of these is NOT a BI tool?

Leave a Reply Cancel reply