Data Analyst | Assesments

A Data Analyst internship is a short-term opportunity designed to help students or recent graduates gain practical experience in collecting, analyzing, and interpreting data to drive business decisions. Interns typically work on real-world datasets and support analytics teams in identifying trends, patterns, and insights.

What is a Data Analyst Intern?

A Data Analyst Intern:

Assists in collecting, cleaning, and organizing data
Uses tools like Excel, SQL, Python, and Tableau
Helps build reports, dashboards, and visualizations
Identifies trends and patterns to support decision-making
Works with teams on real business problems and KPIs

Important Notice:
Once you start the quiz, you will not be able to pause, exit, or restart it. Please ensure you are ready before beginning.

Data Analyst D1

1 / 45

To handle missing values you can use:

a) Both a & b

b) df.dropna()

c) df.fillna()

d) df.replace()

2 / 45

Which method renames columns?

a) df.rename(columns={'a':'b'})

b) df.rename_cols()

c) df.set_names()

d) df.change_cols()

3 / 45

What will be the output of: print(type([1,2,3]))?

4 / 45

Which method creates a pivot table?

a) df.pivot()

b) df.table()

c) pd.pivot_table()

d) pd.pivot()

5 / 45

Which function sorts DataFrame by column values?

a) ort_index()

b) sort()

c) order()

d) sort_values()

6 / 45

Which gives DataFrame summary info?

a) df.describe()

b) df.shape

c) df.info()

d) All of the above

7 / 45

What will be the output of: print(bool(0), bool(5), bool(''))?

a) True True False

b) False False True

c) False True False

d) True False False

8 / 45

Which method applies a function to each row?

a) df.apply()

b) df.transform()

c) df.map()

d) df.applymap()

9 / 45

Which of these is used to combine DataFrames?

a) df.merge()

b) df.join()

c) df.concat()

d) All of the above

10 / 45

10)

Which method drops duplicate rows?

a) df.remove_duplicates()

b) df.unique()

c) df.drop_duplicates()

d) df.clean()

11 / 45

11)

Which function converts a column to datetime?

a) pd.to_datetime()

b) df.convert_date()

c) df.to_dt()

d) pd.to_date()

12 / 45

12)

What will this print? x = [1,2,3]; y = x; y.append(4); print(x)

a) [1,2,3,4]

b) Error

c) [1,2,3]

d) [4]

13 / 45

13)

Which method merges DataFrames?

a) pd.append()

b) pd.combine()

c) pd.concat()

d) pd.merge()

14 / 45

14)

Which function groups data by column?

a) df.aggregate()

b) df.split()

c) df.group()

d) df.groupby()

15 / 45

15)

Which function converts a value to integer?

a) float()

b) int()

c) str()

d) bool()

16 / 45

16)

Result of: np.array([1,2,3]) * 2

a) [1,2,3,1,2,3]

b) Error

c) [2,4,6]

d) [1,2,3,2]

17 / 45

17)

How to reset the index of a DataFrame?

a) df.set_index(None)

b) df.reset_index()

c) df.reindex()

d) df.reset()

18 / 45

18)

Which function computes mean in NumPy?

a) np.sum()

b) np.avg()

c) np.median()

d) np.mean()

19 / 45

19)

Which of the following is immutable in Python?

a) Set

b) List

c) Tuple

d) Dictionary

20 / 45

20)

Which axis applies a row-wise operation in Pandas?

a) axis=2

b) axis=1

c) axis=row

d) axis=0

21 / 45

21)

Which method drops a column?

a) df.drop('col', axis=1)

b) df.remove('col')

c) df.delete('col')

d) df.pop('col')

22 / 45

22)

Which of the following is a valid variable name in Python?

a) 1var

b) var-1

c) @value

d) _data

23 / 45

23)

Indentation in Python is used for:

a) Separating functions

b) Documentation

c) Code decoration

d) Defining code blocks

24 / 45

24)

NumPy arrays are preferred over Python lists because

a) They are slower

b) They only store strings

c) They are memory efficient

d) They don’t support operations

25 / 45

25)

What does df['col'].value_counts().idxmax() give?

a) The count

b) The most frequent value

c) The sum

d) The smallest value

26 / 45

26)

What does df['col'].value_counts() return?

a) Total rows

b) Column sum

c) Count of unique values

d) Column average

27 / 45

27)

Which function gives column summary stats?

a) describe()

b) summary()

c) info()

d) stat()

28 / 45

28)

Which operator is used for exponentiation in Python?

a) %

b) //

c) **

d) ^

29 / 45

29)

Which Pandas function shows data types of columns?

a) df.dtype

b) df.dtypes

c) df.type

d) df.types

30 / 45

30)

Which reads a CSV file into a DataFrame?

a) pd.open()

b) pd.file()

c) pd.read_csv()

d) pd.readcsv()

31 / 45

31)

Which function computes standard deviation in NumPy

a) np.dev()

b) np.var()

c) np.mean()

d) np.std()

32 / 45

32)

How to shuffle rows of a DataFrame?

a) df.shuffle()

b) df.mix()

c) df.random()

d) df.sample(frac=1)

33 / 45

33)

Which creates an array of zeros in NumPy?

a) np.zeros()

b) np.empty()

c) np.array()

d) np.ones()

34 / 45

34)

Which method shows the first 5 rows of a DataFrame?

a) df.head()

b) df.info()

c) df.first()

d) df.tail()

35 / 45

35)

Which operation is vectorized broadcasting?

a) Broadcasting

b) Looping

c) Iteration

d) Vectorization

36 / 45

36)

loc[] is used for:

a) Label-based selection

b) Dropping rows

c) Random sampling

d) Index-based selection

37 / 45

37)

Which method selects rows by integer position?

a) df.loc[]

b) df.at[]

c) df.iloc[]

d) df.get[]

38 / 45

38)

Which built-in function returns length of a list?

a) length()

b) len()

c) size()

d) count()

39 / 45

39)

Which NumPy attribute gives the shape of an array?

a) size

b) shape

c) type

d) ndim

40 / 45

40)

Which keyword is used to define a function in Python?

a) function

b) fun

c) def

d) define

41 / 45

41)

Which function returns the number of non-null rows per column?

a) df.isnull()

b) df.sum()

c) df.dropna()

d) df.count()

42 / 45

42)

Which method fills missing values?

a) na_replace()

b) null()

c) df.dropna()

d) df.fillna()

43 / 45

43)

Which function calculates quantiles?

a) df.quantile()

b) df.q()

c) df.quant()

d) df.percentile()

44 / 45

44)

What does df.shape return?

a) Number of columns

b) Column names

c) (rows, columns)

d) Number of rows

45 / 45

45)

Which function gets unique values from a column?

a) df['col'].unique()

b) df.values()

c) df.distinct()

d) df.unique()

Your score is

The average score is 75%

Exit

Important Notice:
Once you start the quiz, you will not be able to pause, exit, or restart it. Please ensure you are ready before beginning.

Data Analyst D2

1 / 45

1) In Power BI, relationships are built between:

a) Charts

b) Tables

c) Reports

d) DAX formulas

2 / 45

2) A slicer in Power BI is used for:

a) Joining tables

b) Creating charts

c) Formatting reports

d) Filtering data interactively

3 / 45

3) Which cloud platform is popular for analytics?

a) Azure

b) AWS

c) Google Cloud

d) All of the above

4 / 45

4) Data Analytics mainly focuses on:

a) Creating new programming languages

b) Analyzing past data for insights

c) Computer hardware maintenance

d) Collecting data only

5 / 45

5) Which chart is best for showing trends over time?

a) Scatter plot

b) Pie chart

c) Line chart

d) Histogram

6 / 45

6) DAX in Power BI stands for:

a) Database Access XML

b) Data Array Exchange

c) Data Automated Execution

d) Data Analysis Expressions

7 / 45

7) Which tool can be integrated with Power BI for advanced analytics?

a) R

b) Python

c) Both a and b

d) Photoshop

8 / 45

8) Which tool is most widely used for business data visualization?

a) MS Word

b) Notepad

c) Power BI

d) Photoshop

9 / 45

9) A foreign key is used to:

a) Link two tables together

b) Define a unique record

c) Store passwords

d) Visualize dashboards

10 / 45

10) Data storytelling in analytics refers to:

a) Coding in SQL

b) Using data to entertain

c) Presenting data with narratives and visuals

d) Writing novels

11 / 45

11) What does ETL stand for?

a) Extract, Transform, Load

b) Execute, Transfer, Log

c) Encrypt, Translate, Locate

d) Enter, Test, Learn

12 / 45

12) Which of these is an open-source tool for data visualization?

a) Power BI

b) All of the above

c) Tableau

d) Google Data Studio

13 / 45

13) Predictive analytics is used to:

a) Clean datasets

b) Forecast future outcomes

c) Describe the past

d) Create pie charts

14 / 45

14) What is the purpose of data transformation?

a) Store data in raw form

b) Erase unnecessary data permanently

c) Visualize the data

d) Convert data into usable format

15 / 45

15) A primary key in a database is:

a) A unique identifier for each record

b) A column allowing duplicates

c) A chart type

d) A foreign key

16 / 45

16) Which component of Power BI is used for creating reports?

a) Power BI Service

b) Power Query

c) Power BI Mobile

d) Power BI Desktop

17 / 45

17) Which function in Power BI creates aggregate measures?

a) All of the above

b) COUNT()

c) SUM()

d) AVERAGE()

18 / 45

18) Which of these is an example of descriptive analytics?

a) Explaining past sales trends

b) Optimizing supply chain

c) Automating workflows

d) Predicting sales

19 / 45

19) What is Big Data mainly characterized by?

a) SQL queries

b) Size only

c) Value, Vision, Validation

d) Volume, Velocity, Variety

20 / 45

20) The ultimate goal of Data Analytics is to:

a) Collect large amounts of raw data

b) Write computer programs

c) Build hardware devices

d) Generate insights for better decisions

21 / 45

21) What is the main benefit of using dashboards?

a) Storing raw files

b) Interactive and real-time insights

c) Replacing databases

d) Writing long reports

22 / 45

22) Power BI dashboards can be shared through:

a) Emails

b) Cloud storage

c) All of the above

d) Power BI Service

23 / 45

23) What is the role of a Data Analyst?

a) Write networking protocols

b) Build computer hardware

c) Extract insights from data

d) Develop operating systems

24 / 45

24) Which of these is NOT a data type in Power BI?

a) Decimal Number

b) Whole Number

c) Date/Time

d) Music File

25 / 45

25) Which function in Power BI is used to create calculated columns?

a) NumPy

b) DAX

c) Python

d) SQL

26 / 45

26) In ETL, the "Transform" step includes:

a) Data cleaning and formatting

b) Creating dashboards

c) Importing charts

d) Storing raw data

27 / 45

27) In SQL, which clause is used to filter records?

a) FROM

b) JOIN

c) WHERE

d) SELECT

28 / 45

28) Prescriptive analytics helps to:

a) Delete unwanted data

b) Suggest actions to optimize results

c) Visualize data

d) Identify what happened

29 / 45

29) Cleaning data involves:

a) Removing duplicates

b) All of the above

c) Handling missing values

d) Correcting errors

30 / 45

30) Which visualization shows parts of a whole?

a) Histogram

b) Scatter plot

c) Pie chart

d) Line chart

31 / 45

31) In Power BI, data can be imported from:

a) SQL databases

b) All of the above

c) Excel

d) Cloud services

32 / 45

32) Which chart is best to show correlation between two variables?

a) Scatter plot

b) Pie chart

c) Line chart

d) Bar chart

33 / 45

33) Which database language is widely used in analytics?

a) SQL

b) HTML

c) Java

d) C++

34 / 45

34) In analytics, KPI stands for:

a) Kernel Process Integration

b) Key Performance Indicator

c) Knowledge Processing Input

d) Key Power Index

35 / 45

35) Which of the following is the first step in Data Analytics?

a) Model Deployment

b) Data Visualization

c) Data Cleaning

d) Data Collection

36 / 45

36) Which analytical method helps to find hidden patterns in data?

a) Data Loading

b) Data Cleaning

c) Data Reporting

d) Data Mining

37 / 45

37) Which SQL command is used to combine rows from two tables?

a) DELETE

b) SELECT

c) UPDATE

d) JOIN

38 / 45

38) Which of these is NOT a stage in the analytics process?

a) Data Cleaning

b) Data Visualization

c) Data Collection

d) Space Exploration

39 / 45

39) Which type of join keeps only the matching records from two tables?

a) Outer Join

b) Inner Join

c) Cross Join

d) Left Join

40 / 45

40) Which chart is suitable for showing cumulative values?

a) Pie chart

b) Scatter plot

c) Area chart

d) Line chart

41 / 45

41) A bar chart is best suited for:

a) Displaying proportions

b) Showing trends over time

c) Comparing categories

d) Showing correlations

42 / 45

42) Which visualization is best for frequency distribution?

a) Area chart

b) Pie chart

c) Histogram

d) Line graph

43 / 45

43) What is the main purpose of a dashboard in analytics?

a) Store raw data

b) Collect social media data

c) Train machine learning models

d) Present key insights visually

44 / 45

44) What is data visualization mainly used for?

a) Hide data

b) Encrypt data

c) Make insights easier to understand

d) Increase data errors

45 / 45

45) . What does a Data Warehouse store?

a) Music files

b) Historical and structured data

c) Emails only

d) Live gaming data

Your score is

The average score is 79%

Exit

Important Notice:
Once you start the quiz, you will not be able to pause, exit, or restart it. Please ensure you are ready before beginning.

Data Analyst D3

1 / 45

1) Which of these best describes “data wrangling”?

a) Deploying models

b) Collecting new datasets

c) Encrypting sensitive data

d) Cleaning and structuring raw data

2 / 45

2) In Power BI, calculated columns are used to:

a) Delete rows

b) Add new columns using formulas

c) Clean datasets

d) Import data

3 / 45

3) The primary goal of Data Analytics is:

a) To build operating systems

b) To design websites

c) To create AI models

d) To find patterns and insights from data

4 / 45

4) Which type of analytics answers “Why did it happen?

a) Descriptive

b) Prescriptive

c) Diagnostic

d) Predictive

5 / 45

5) Which of the following is NOT a data cleaning technique?

a) Adding random errors

b) Removing duplicates

c) Data normalization

d) Handling missing values

6 / 45

6) In Power BI, relationships between tables are created using:

a) Random Columns

b) Primary and Foreign Keys

c) Filters

d) Formulas

7 / 45

7) Which tool can be used for advanced data visualization apart from Power BI?

a) Word

b) Notepad

c) C language

d) Tableau

8 / 45

8) Which Excel function is used to combine data from multiple cells?

a) INDEX

b) MATCH

c) CONCATENATE

d) VLOOKUP

9 / 45

9) Which visualization is best for trend analysis over time?

a) Scatter plot

b) Line chart

c) Bar chart

d) Pie chart

10 / 45

10) Which DAX function calculates the total of a column?

a) AVG()

b) SUM()

c) COUNT()

d) TOTAL()

11 / 45

11) Which SQL clause is used to filter results?

a) ORDER BY

b) HAVING

c) WHERE

d) GROUP BY

12 / 45

12) In Power BI, a dashboard is?

a) A dataset

b) A SQL script

c) A collection of visualizations

d) A single chart

13 / 45

13) What is the main use of ETL in Data Analytics?

a) Encrypt, Test, Log data

b) Encode, Transfer, Load data

c) Execute, Train, Learn models

d) Extract, Transform, Load data

14 / 45

14) In Power BI, measures are:

a) SQL queries

b) Visual types

c) Pre-calculated fields

d) Raw datasets

15 / 45

15) What is a key benefit of Power BI dashboards?

a) Interactive and real-time insights

b) Manual data entry

c) Static reports

d) Non-visual output

16 / 45

16) Which chart is used for cumulative analysis?

a) Line chart

b) Pie chart

c) Area chart

d) Histogram

17 / 45

17) What is the purpose of data normalization?

a) Adding duplicates

b) Reducing data redundancy

c) Changing data types

d) Removing all rows

18 / 45

18) What does “Data Transformation” mean?

a) Encrypting data

b) Changing data format and structure

c) Deleting entire dataset

d) Copying data

19 / 45

19) Which feature in Power BI allows scheduled data updates?

a) Auto Filter

b) Data Refresh

c) Data Cleaning

d) DAX Functions

20 / 45

20) Which SQL command is used to sort query results?

a) ORDER BY

b) ARRANGE

c) SORT

d) GROUP BY

21 / 45

21) Which tool is most commonly used for business dashboards?

a) PowerPoint

b) C++

c) Power BI

d) Photoshop

22 / 45

22) In Power BI, slicers are used for:

a) Data loading

b) Data cleaning

c) Data filtering

d) Data storage

23 / 45

23) Which visualization is best for analyzing correlation?

a) Pie chart

b) Line chart

c) Scatter plot

d) Histogram

24 / 45

24) Which chart is most suitable to compare proportions?

a) Histogram

b) Line chart

c) Pie chart

d) Scatter plot

25 / 45

25) In Power BI, AI visuals can:

a) Identify key influencers and trends

b) Replace datasets

c) Run SQL queries

d) Clean data automatically

26 / 45

26) Which data type in SQL stores variable-length text?

a) DATE

b) CHAR

c) VARCHAR

d) INT

27 / 45

27) Which SQL keyword groups rows that have the same values?

a) GROUP BY

b) UNION

c) JOIN

d) DISTINCT

28 / 45

28) What is the function of DAX in Power BI?

a) Data Querying and Calculation

b) Visualization Formatting

c) Data Importing

d) Data Storage

29 / 45

29) Which data type is best for storing dates in analytics?

a) String

b) Boolean

c) Integer

d) Date/Time

30 / 45

30) In analytics, which term refers to identifying incorrect or inconsistent data?

a) Data Mining

b) Data Cleaning

c) Data Visualization

d) Data Wrangling

31 / 45

31) What is the role of prescriptive analytics?

a) To explain causes

b) To predict future outcomes

c) To describe past data

d) To suggest actions

32 / 45

32) Which SQL keyword combines rows from two queries?

a) SELECT

b) JOIN

c) UNION

d) MERGE

33 / 45

33) In Power BI, which pane is used to add fields to visuals?

a) Fields Pane

b) Report Pane

c) Visualization Pane

d) Data Pane

34 / 45

34) Which SQL function finds the average value?

a) COUNT()

b) SUM()

c) MAX()

d) AVG()

35 / 45

35) Which chart is best for showing data distribution?

a) Line chart

b) Histogram

c) Pie chart

d) Bar chart

36 / 45

36) Which Excel function looks up values in a table?

a) VLOOKUP

b) MATCH

c) SPLIT

d) CONCATENATE

37 / 45

37) Which chart is best for showing percentage change over time?

a) Waterfall chart

b) Histogram

c) Scatter plot

d) Pie chart

38 / 45

38) Which SQL clause is used after GROUP BY to filter aggregated data?

a) HAVING

b) FILTER

c) WHERE

d) ORDER BY

39 / 45

39) In SQL, which function returns the number of rows in a dataset?

a) SUM()

b) TOTAL()

c) COUNT()

d) AVG()

40 / 45

40) In analytics, a "data model" represents:

a) Random charts

b) Relationships between tables

c) Only raw numbers

d) A Python script

41 / 45

41) Which SQL keyword groups rows that have the same values?

a) GROUP BY

b) JOIN

c) DISTINCT

d) UNION

42 / 45

42) Which chart is best for comparing categories?

a) Line chart

b) Pie chart

c) Bar chart

d) Histogram

43 / 45

43) A KPI (Key Performance Indicator) in analytics is used to:

a) Predict future trends

b) Measure business performance

c) Show historical events

d) Create random charts

44 / 45

44) Which SQL command removes duplicate values from results?

a) GROUP

b) UNIQUE

c) CLEAN

d) DISTINCT

45 / 45

45) Which of these is NOT a type of analytics?

a) Predictive Analytics

b) Creative Analytics

c) Prescriptive Analytics

d) Diagnostic Analytics

Your score is

The average score is 71%

Exit

Important Notice:
Once you start the quiz, you will not be able to pause, exit, or restart it. Please ensure you are ready before beginning.

Data Analyst D4

1 / 46

1) Which plot is suitable for time-series data?

a) Pie chart

b) Scatter plot

c) Histogram

d) Line plot

2 / 46

2) Recall is also called:

a) Accuracy

b) Precision

c) Sensitivity

d) Specificity

3 / 46

3) Outlier detection can be performed using:

a) IQR

b) Boxplot

c) All of the above

d) Z-score

4 / 46

4) Which metric is used to evaluate regression models?

a) Precision

b) Recall

c) RMSE

d) Accuracy

5 / 46

5) Data warehouse mainly stores:

a) Streaming logs

b) Real-time sensor data

c) Transactional data

d) Historical data

6 / 46

6) Which is an example of unstructured data?

a) Images and videos

b) JSON logs

c) Excel sheets

d) SQL tables

7 / 46

7) Which visualization is best for correlation analysis?

a) Scatter plot

b) Pie chart

c) Line graph

d) Histogram

8 / 46

8) A heatmap is useful for:

a) Outlier detection

b) Showing distribution of one variable

c) Visualizing proportions

d) Showing correlations between variables

9 / 46

9) Which SQL function is used to count rows?

a) TOTAL()

b) AVG()

c) COUNT()

d) SUM()

10 / 46

10) Which of the following is a supervised learning algorithm?

a) DBSCAN

b) Linear Regression

c) Apriori

d) K-Means

11 / 46

11) Which Python library is most commonly used for data manipulation in analytics?

a) Matplotlib

b) NumPy

c) Pandas

d) TensorFlow

12 / 46

12) Which of these is a disadvantage of big data?

a) Improved insights

b) Complexity in management

c) Variety

d) Scalability

13 / 46

13) Which of these languages is most popular for Data Science?

a) C#

b) HTML

c) CSS

d) Python

14 / 46

14) Which of these is NOT a machine learning library?

a) TensorFlow

b) Pandas

c) Hadoop

d) Scikit-learn

15 / 46

15) Which data format is lightweight and commonly used for APIs?

a) JSON

b) CSV

c) XML

d) HTML

16 / 46

16) Which programming language is most popular for data analysis?

a) Java

b) Python

c) Ruby

d) C++

17 / 46

17) In EDA (Exploratory Data Analysis), which visualization helps detect outliers?

a) Bar chart

b) Box plot

c) Histogram

d) Line chart

18 / 46

18) Which SQL clause is used to filter results?

a) GROUP BY

b) ORDER BY

c) SELECT

d) WHERE

19 / 46

19) Which of the following is NOT a part of Data Science?

a) Plumbing

b) Data Visualization

c) Statistics

d) Machine Learning

20 / 46

20) Principal Component Analysis (PCA) is used for:

a) Regression

b) Classification

c) Clustering

d) Dimensionality Reduction

21 / 46

21) Which cloud service is widely used for data storage?

a) AWS S3

b) K-Means

c) Apache Spark

d) Docker

22 / 46

22) Big data is often defined by which 3Vs?

a) Variety, Volume, Velocity

b) ariable, Volume, Vector

c) Visualization, Validation, Variance

d) Value, Version, Virtualization

23 / 46

23) Which of these is an example of categorical data?

a) Weight

b) Height

c) Gender

d) Temperature

24 / 46

24) Which of the following is NOT a type of Data Analytics?

a) Predictive

b) Diagnostic

c) Descriptive

d) Generative

25 / 46

25) The process of converting categorical variables into numeric is:

a) Feature engineering

b) Normalization

c) Aggregation

d) Encoding

26 / 46

26) In data cleaning, handling missing values can be achieved by:

a) All of the above

b) Predicting with models

c) Replacing with mean/median

d) Deleting rows

27 / 46

27) Which tool is commonly used for interactive data visualization?

a) Photoshop

b) MS Word

c) Tableau

d) Eclipse

28 / 46

28) A data lake primarily stores:

a) Only transactional data

b) Structured data only

c) Raw structured and unstructured data

d) Summarized data

29 / 46

29) Which SQL command is used to combine results from two queries?

a) UNION

b) SELECT

c) JOIN

d) INTERSECT

30 / 46

30) Which type of chart is best for showing proportions?

a) Line chart

b) Histogram

c) Pie chart

d) Scatter plot

31 / 46

31) Feature scaling is important because:

a) Algorithms perform better when features are on similar scales

b) It increases dataset size

c) It reduces memory size

d) It removes missing values

32 / 46

32) A confusion matrix is used in:

a) Data Cleaning

b) Clustering

c) Classification

d) Regression

33 / 46

33) The accuracy of a classification model is:

a) FN / Total samples

b) FP + FN) / Total samples

c) TP / Total samples

d) (TP + TN) / Total samples

34 / 46

34) Which language is widely used for statistical analysis?

a) R

b) Java

c) C

d) Python

35 / 46

35) What does ETL stand for in data processing?

a) Extract, Test, Learn

b) Encode, Test, Load

c) Enter, Transfer, Leave

d) Extract, Transform, Load

36 / 46

36) Which of these databases is column-oriented?

a) MySQL

b) MongoDB

c) PostgreSQL

d) Cassandra

37 / 46

37) In classification, Precision is defined as:

a) TP / (TP + FP)

b) (TP + TN) / Total

c) FP / (TP + FP)

d) TP / (TP + FN)

38 / 46

38) SQL keyword used to sort results:

a) WHERE

b) GROUP BY

c) SORT

d) ORDER BY

39 / 46

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

a) Mode

b) Median

c) Mean

d) Range

40 / 46

40) Hadoop Distributed File System (HDFS) is mainly used for:

a) Data mining only

b) Visualization

c) Relational queries

d) Distributed storage of big data

41 / 46

41) Which of these is NOT a NoSQL database?

a) MongoDB

b) Cassandra

c) CouchDB

d) MySQL

42 / 46

42) Time-series analysis is mostly applied in:

a) Stock market prediction

b) Customer segmentation

c) Clustering

d) Image recognition

43 / 46

43) Which of these best describes Data Mining?

a) Cleaning missing values

b) Visualization only

c) Storing data only

d) Extracting patterns and knowledge from large datasets

44 / 46

44) Which Python library is used for visualization?

a) Scikit-learn

b) Pandas

c) Numpy

d) Matplotlib

45 / 46

45) The process of identifying duplicate data is called:

a) Data Aggregation

b) Data Normalization

c) Data Mining

d) Data Deduplication

46 / 46

46) Which storage is most cost-effective for cold data?

a) SSD

b) tape storage

c) GPU memory

d) RAM

Your score is

The average score is 60%

Exit

Important Notice:
Once you start the quiz, you will not be able to pause, exit, or restart it. Please ensure you are ready before beginning.

Data Analyst D5

1 / 45

1) Which distribution is most common in analytics?

a) Exponential

b) Normal (Gaussian)

c) Uniform

d) Poisson

2 / 45

2) The ETL process stands for:

a) Edit, Transform, Link

b) Extract, Transform, Load

c) Extract, Transfer, Link

d) Encode, Transfer, Load

3 / 45

3) Which is an example of diagnostic analytics?

a) Finding why sales dropped last quarter

b) Predicting sales for next year

c) Recommending marketing strategies

d) Summarizing past year’s sales

4 / 45

4) OLAP stands for:

a) Online Application Processing

b) Online Analytical Processing

c) Online Advanced Processing

d) Open Layer Application Protocol

5 / 45

5) Data transformation means:

a) Deleting old data

b) Archiving data

c) Encrypting sensitive data

d) Converting data from one format to another

6 / 45

6) A scatter plot is mainly used to:

a) Display time-series data

b) Compare proportions

c) Show distribution of frequencies

d) Show relationships between two variables

7 / 45

7) Which chart type is ideal for tracking trends over time?

a) Bar chart

b) Box plot

c) Pie chart

d) Line chart

8 / 45

8) Which visualization is best for categorical comparison?

a) Bar chart

b) Histogram

c) ) Pie chart

d) Scatter plot

9 / 45

9) An example of predictive analytics is:

a) Identifying missing values

b) Estimating next month’s sales

c) Generating a past report

d) Cleaning messy data

10 / 45

10) Data that is structured into rows and columns is called:

a) Tabular data

b) JSON data

c) Unstructured data

d) Semi-structured data

11 / 45

11) Histogram is best used to show:

a) Comparison between categories

b) Time series trends

c) Numerical data distribution

d) Categorical data distribution

12 / 45

12) Which Python library is commonly used for visualization?

a) Pandas

b) NumPy

c) Matplotlib

d) Scikit-learn

13 / 45

13) Which file format is commonly used to store tabular datasets?

a) .exe

b) .mp3

c) csv

d) .csv

14 / 45

14) Which data structure in Python is best for analytics tasks?

a) List

b) Tuple

c) DataFrame

d) Dictionary

15 / 45

15) Power BI and Tableau are examples of:

a) Database systems

b) Operating systems

c) Visualization tools

d) Programming languages

16 / 45

16) Which step ensures data reliability and correctness?

a) Transformation

b) Storage

c) Visualization

d) Data validation

17 / 45

17) A heatmap is useful for:

a) Predicting missing values

b) Extracting datasets

c) Showing correlation strength

d) Cleaning data

18 / 45

18) Which is an open-source BI tool?

a) Tableau Public

b) Power BI

c) Looker

d) QlikView

19 / 45

19) Which step comes first in the analytics process?

a) Reporting

b) Data collection

c) Data visualization

d) Prediction

20 / 45

20) Outliers are:

a) Extreme values outside the normal range

b) Missing data

c) Duplicates

d) Values within expected range

21 / 45

21) Cross-validation is used to:

a) Encrypt data

b) Increase dataset size

c) Test the model on different splits of data

d) Train the model faster

22 / 45

22) What is the primary goal of data analy cs?

a) Encrypt data

b) Extract useful insights

c) Store data

d) Build websites

23 / 45

23) Which is a BI tool used for dashboards?

a) Hadoop

b) Power BI

c) Spark

d) MongoDB

24 / 45

24) Which graph shows the distribution of data spread?

a) Box plot

b) Heatmap

c) Line chart

d) Pie chart

25 / 45

25) Descrip ve analy cs focuses on:

a) What has already happened

b) Why something happened

c) Predic ng future events

d) Prescribing ac ons

26 / 45

26) Which library is most suitable in Python for data cleaning and analysis?

a) TensorFlow

b) Flask

c) Matplotlib

d) Pandas

27 / 45

27) missing values in a dataset can be handled by:

a) Ignoring them

b) All of the above

c) Predicting them using models

d) Filling with mean/median/mode

28 / 45

28) What is metadata?

a) Encrypted data

b) Data about data

c) Deleted data

d) Duplicate data

29 / 45

29) KPI stands for:

a) Known Predictive Index

b) Key Performance Indicator

c) Knowledge Performance Insights

d) Key Predictive Input

30 / 45

30) Which technique is often used for clustering in analytics?

a) Decision Trees

b) Linear Regression

c) Logistic Regression

d) K-Means

31 / 45

31) . Which cloud platforms provide ML and DS tools

a) AWS

b) Azure

c) All of the above

d) Google Cloud

32 / 45

32) Which dashboard type is used by top-level executives?

a) Operational

b) Analytical

c) Technical

d) Strategic

33 / 45

33) Which join in SQL returns only matching rows between two tables?

a) Full join

b) Inner join

c) Left join

d) Right join

34 / 45

34) A correlation coefficient close to -1 means:

a) Strong negative relation

b) Weak relation

c) No relation

d) Strong positive relation

35 / 45

35) The process of converting raw data into a readable format is called:

a) Validation

b) Extraction

c) Modeling

d) Data wrangling

36 / 45

36) Which technique reduces dataset dimensionality?

a) Regression

b) Classification

c) PCA (Principal Component Analysis)

d) Clustering

37 / 45

37) Which metric is commonly used to measure model accuracy in analytics?

a) R-squared

b) All of the above

c) Mean Squared Error

d) ROC curve

38 / 45

38) Which central tendency measure is most affected by outliers?

a) Mean

b) None

c) Median

d) Mode

39 / 45

39) Which language is most commonly used in data analy cs?

a) Java

b) HTML

c) Python

d) C++

40 / 45

40) Data normalization means:

a) Scaling values

b) Reducing redundancy

c) Cleaning duplicates

d) All of the above

41 / 45

41) Which analytics approach uses “what-if” scenarios?

a) Diagnostic

b) Predictive

c) Prescriptive

d) Descriptive

42 / 45

42) Time-series forecasting is an example of:

a) None

b) Predictive analytics

c) Diagnostic analytics

d) Descriptive analytics

43 / 45

43) Which chart type is best to show propor ons?

a) Bar chart

b) Line chart

c) Histogram

d) Pie chart

44 / 45

44) SQL is primarily used for:

a) Data extraction and querying

b) Image processing

c) Machine learning

d) Web design

45 / 45

45) Which programming language is most used in Big Data Analytics?

a) Python

b) All of the above

c) R

d) Scala

Your score is

The average score is 0%

Exit

Important Notice:
Once you start the quiz, you will not be able to pause, exit, or restart it. Please ensure you are ready before beginning.

Data Analyst D6

1 / 44

1) Which of the following tools is commonly used for Data Analytics?

a) All of the above

b) Tableau

c) Power BI

d) Excel

2 / 44

2) Which function in Excel is used to calculate the average?

a) =AVERAGE()

b) =SUM()

c) =COUNT()

d) =MEAN()

3 / 44

3) Which SQL clause filters data?

a) ORDER BY

b) WHERE

c) HAVING

d) GROUP BY

4 / 44

4) In data analytics, what does EDA stand for?

a) Enhanced Data Analytics

b) Exploratory Data Analysis

c) Enterprise Data Architecture

d) Estimated Data Application

5 / 44

5) Which SQL keyword removes duplicates from a result?

a) CLEAR

b) UNIQUE

c) DISTINCT

d) FILTER

6 / 44

6) In Power BI, relationships between tables are created using:

a) Columns

b) Indexes

c) Keys

d) Attributes

7 / 44

7) Which of these is an open-source Data Analytics tool?

a) Excel

b) Power BI

c) Tableau

d) Python

8 / 44

8) A dataset with too many missing values may lead to:

a) Faster results

b) Accurate predictions

c) Biased analysis

d) None

9 / 44

9) A pivot table in Excel is used for:

a) Data cleaning

b) Summarizing data

c) Data storage

d) Data validation

10 / 44

10) Which of the following is an example of time-series data?

a) Employee names

b) Monthly sales

c) Colors of cars

d) Student grades

11 / 44

11) Which data type represents continuous numbers?

a) Integer

b) Float

c) String

d) Boolean

12 / 44

12) In a dataset, columns are also known as:

a) Keys

b) Entries

c) Fields

d) Records

13 / 44

13) Which type of chart is best to show proportions?

a) Histogram

b) Scatter plot

c) Line chart

d) Pie chart

14 / 44

14) Which Power BI feature allows creating calculated columns and measures?

a) SQL

b) DAX

c) R

d) Python

15 / 44

15) Which function finds the largest value in Excel?

a) =MAX()

b) =BIG()

c) =LARGE()

d) =GREATEST()

16 / 44

16) Which file format is commonly used for datasets?

a) All of the above

b) .txt

c) .csv

d) .xlsx

17 / 44

17) What does OLAP stand for?

a) Online Logical Application

b) Open Learning Analytics Process

c) Operational Logic Analysis Platform

d) Online Analytical Processing

18 / 44

18) Which data cleaning technique replaces missing values with averages?

a) Regression imputation

b) Deletion

c) Mean imputation

d) Encoding

19 / 44

19) Which visualization is best for comparing trends over time?

a) Histogram

b) Line chart

c) Pie chart

d) Bar chart

20 / 44

20) What does ETL stand for in Data Analytics?

a) Extract, Transform, Load

b) Export, Track, Link

c) Execute, Test, Learn

d) Encode, Transfer, Load

21 / 44

21) Which of these measures central tendency?

a) Mode

b) All of the above

c) Median

d) Mean

22 / 44

22) Which chart type is best for categorical comparisons?

a) Bar chart

b) Histogram

c) Line chart

d) Scatter plot

23 / 44

23) Which Python library is mainly used for handling tabular data?

a) Pandas

b) Seaborn

c) NumPy

d) Matplotlib

24 / 44

24) Which command is used in SQL to combine rows from two tables?

a) CONNECT

b) UNION

c) MERGE

d) JOIN

25 / 44

25) Which type of analytics predicts future trends?

a) Diagnostic

b) Descriptive

c) Predictive

d) Prescriptive

26 / 44

26) Which Python library is widely used for data visualization?

a) SciPy

b) NumPy

c) Pandas

d) Matplotlib

27 / 44

27) Which analytics type answers “What happened?”

a) Predictive

b) Descriptive

c) Prescriptive

d) Diagnostic

28 / 44

28) Which measure of spread shows the difference between max and min values?

a) Standard deviation

b) Interquartile range

c) Variance

d) Range

29 / 44

29) Which is an example of qualitative data?

a) Height

b) Salary

c) Eye color

d) Weight

30 / 44

30) What does KPI stand for in analytics?

a) Key Process Integration

b) Key Profit Index

c) Key Performance Indicator

d) Knowledge Processing Interface

31 / 44

31) Which of these is NOT a Python library for Data Analytics?

a) TensorFlow

b) Pandas

c) NumPy

d) Matplotlib

32 / 44

32) Missing values in a dataset can be handled by:

a) Replacing with mean/median

b) Removing rows

c) All of the above

d) Predicting values

33 / 44

33) Which analytics approach recommends actions?

a) Prescriptive

b) Predictive

c) Descriptive

d) Diagnostic

34 / 44

34) Which type of data is represented as categories (e.g., gender, colors)?

a) Numerical

b) Categorical

c) Time-series

d) Continuous

35 / 44

35) Which of the following is the first step in the Data Analytics process?

a) Data Transformation

b) Data Visualization

c) Data Cleaning

d) Data Collection

36 / 44

36) Which of these helps to detect patterns in data?

a) Data visualization

b) Data cleaning

c) Data collection

d) Data entry

37 / 44

37) Data normalization is used to:

a) Reduce redundancy

b) Organize databases

c) All of the above

d) Improve consistency

38 / 44

38) Which of the following is a BI tool?

a) QlikView

b) Tableau

c) All of the above

d) Power BI

39 / 44

39) Data dashboards are mainly used for:

a) Data collection

b) Database design

c) Visual reporting

d) Data cleaning

40 / 44

40) Outliers in data can:

a) Have no impact

b) Skew results

c) Improve accuracy

d) Always be ignored

41 / 44

41) Which visualization shows part-to-whole relationships?

a) Histogram

b) Line chart

c) Scatter plot

d) Pie chart

42 / 44

42) Which SQL function counts the number of rows in a table?

a) TOTAL()

b) COUNT()

c) SUM()

d) NUMBER()

43 / 44

43) Which type of chart shows distribution of data?

a) Line chart

b) Histogram

c) Scatter plot

d) Pie chart

44 / 44

44) Which SQL keyword is used to retrieve data from a database?

a) UPDATE

b) SELECT

c) DELETE

d) INSERT

Your score is

The average score is 0%

Exit

Important Notice:
Once you start the quiz, you will not be able to pause, exit, or restart it. Please ensure you are ready before beginning.

Data Analyst D7

1 / 46

1) Which of the following is a Python data structure useful for data analytics?

a) Set

b) list

c) DataFrame

d) Dictionary

2 / 46

2) Which chart is most suitable for showing the distribution of a single variable?

a) Line chart

b) Pie chart

c) Histogram

d) Bar chart

3 / 46

3) Which of the following is used for interactive dashboards?

a) Tableau

b) Power BI

c) Google Data Studio

d) all of the above

4 / 46

4) In ETL, which step involves cleaning and restructuring data?

a) Extract

b) Transform

c) Model

d) Load

5 / 46

5) Which of the following is a cloud-based data warehouse?

a) Snowflake

b) SQLite

c) MySQL

d) MongoDB

6 / 46

6) Which SQL function is used to count rows?

a) SUM()

b) COUNT()

c) NUMBER()

d) TOTAL()

7 / 46

7) Which of the following is NOT a type of analytics?

a) Descriptive

b) Prescriptive

c) Informative

d) Predictive

8 / 46

8) Which of the following is NOT a data visualization library in Python?

a) Tableau

b) Plotly

c) Matplotlib

d) Seaborn

9 / 46

9) Which function in Pandas removes missing values?

a) df.remove()

b) df.clean()

c) df.na()

d) df.dropna()

10 / 46

10) Which visualization helps compare two continuous variables?

a) Bar chart

b) Pie chart

c) Scatter plot

d) Histogram

11 / 46

11) Which type of data visualization best shows correlation?

a) Pie chart

b) Scatter plot

c) Histogram

d) Bar chart

12 / 46

12) Which of the following is an example of unstructured data?

a) Images and videos

b) Database table

c) CSV files

d) Excel sheets

13 / 46

13) In Python, which library is most widely used for data analysis?

a) Matplotlib

b) Pandas

c) NumPy

d) Seaborn

14 / 46

14) Which of the following is a BI tool used for data analytics?

a) Docker

b) Power BI

c) GitHub

d) TensorFlow

15 / 46

15) Which chart is best for showing trends over time?

a) Box plot

b) Line chart

c) Histogram

d) Pie chart

16 / 46

16) Which SQL command is used to filter rows?

a) gROUP BY

b) SELECT

c) WHERE

d) oRDER BY

17 / 46

17) Which function in Pandas is used to get summary statistics?

a) df.mean()

b) df.stats()

c) df.describe()

d) df.summary()

18 / 46

18) Which command is used to remove duplicates in SQL?

a) DELETE

b) DISTINCT

c) REMOVE

d) UNIQUE

19 / 46

19) Which SQL command removes an entire table?

a) DELETE

b) REMOVE

c) CLEAR

d) DROP

20 / 46

20) Which function in Pandas is used to view the first few rows of a dataset?

a) df.tail()

b) df.start()

c) df.show()

d) df.head()

21 / 46

21) Which data type best represents True/False values?

a) Float

b) Boolean

c) String

d) Integer

22 / 46

22) Which Python library is used mainly for numerical operations?

a) Pandas

b) NumPy

c) Seaborn

d) SciPy

23 / 46

23) in data analytics, what does KPI stand for?

a) Key Performance Indicator

b) Key Process Integration

c) Knowledge Processing Insight

d) known Predictive Indicator

24 / 46

24) Which metric is commonly used to measure central tendency?

a) All of the above

b) Mean

c) Mode

d) Median

25 / 46

25) Which of the following is a data transformation step?

a) data entry

b) Normalization

c) Data visualization

d) Data loading

26 / 46

26) Which of the following is the first step in Data Analytics?

a) Data Collection

b) Data Visualization

c) Data Reporting

d) Data Cleaning

27 / 46

27) Which plot is best for identifying correlations?

a) Scatter plot

b) Pie chart

c) Histogram

d) Line chart

28 / 46

28) Which step comes immediately after Data Collection?

a) Data Cleaning

b) Data Modeling

c) Data Loading

d) Data Visualization

29 / 46

29) Which method is used to check missing values in Pandas?

a) df.isnull()

b) df.dropna()

c) df.empty()

d) f.na()

30 / 46

30) Which BI tool is most closely integrated with Microsoft products?

a) Looker

b) Tableau

c) Power BI

d) QlikView

31 / 46

31) Which SQL clause is used to combine rows with the same values?

a) UNION

b) JOIN

c) ORDER BY

d) GROUP BY

32 / 46

32) What does ETL stand for?

a) Evaluate, Transform, Load

b) Explore, Transfer, Learn

c) Extract, Transform, Load

d) Extract, Test, Link

33 / 46

33) Which data type is commonly used to represent categorical values?

a) String

b) Integer

c) Float

d) Boolean

34 / 46

34) Which of the following is an example of time-series data?

a) Product categories

b) Student names in a class

c) Sales data by date

d) Employee salaries

35 / 46

35) Which command in SQL is used to sort data?

a) GROUP BY

b) SORT

c) FILTER

d) ORDER BY

36 / 46

36) Which method in Pandas combines two DataFrames by columns?

a) join()

b) concat()

c) merge()

d) append()

37 / 46

37) Which plot is best for identifying outliers?

a) Pie chart

b) Box plot

c) Line chart

d) Bar chart

38 / 46

38) Which of the following is NOT a type of data?

a) Unstructured

b) Designed

c) Structured

d) Semi-structured

39 / 46

39) What is the primary goal of Exploratory Data Analysis (EDA)?

a) Summarizing insights and patterns

b) Cleaning data

c) Predicting future outcomes

d) Building dashboards

40 / 46

40) Which of the following is NOT a data cleaning technique?

a) Data transformation

b) Removing duplicates

c) Handling missing values

d) Adding noise to data

41 / 46

41) Which visualization is best for showing data distribution and quartiles?

a) Box plot

b) Line chart

c) Scatter plot

d) Pie chart

42 / 46

42) Which SQL aggregate function returns the maximum value?

a) MAX()

b) BIG()

c) TOP()

d) HIGH()

43 / 46

43) Which chart is suitable for categorical data comparison?

a) Scatter plot

b) Line chart

c) Histogram

d) Bar chart

44 / 46

44) Which visualization is best for showing proportions?

a) Pie chart

b) Histogram

c) Line chart

d) Scatter plot

45 / 46

45) Which of the following tools is used for big data analytics

a) GitHub

b) Hadoop

c) Excel

d) PowerPoint

46 / 46

46) Which type of join returns only the common records between two tables?

a) RIGHT JOIN

b) FULL OUTER JOIN

c) LEFT JOIN

d) INNER JOIN

Your score is

The average score is 0%

Exit

What is a Data Analyst Intern?

Leave a Reply Cancel reply