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

Which method merges DataFrames?

a) pd.combine()

b) pd.merge()

c) pd.concat()

d) pd.append()

2 / 45

Which method drops duplicate rows?

a) df.remove_duplicates()

b) df.drop_duplicates()

c) df.unique()

d) df.clean()

3 / 45

Which function converts a value to integer?

a) int()

b) bool()

c) str()

d) float()

4 / 45

Which axis applies a row-wise operation in Pandas?

a) axis=0

b) axis=1

c) axis=2

d) axis=row

5 / 45

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

6 / 45

Which method drops a column?

a) df.remove('col')

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

c) df.pop('col')

d) df.delete('col')

7 / 45

What does df.shape return?

a) (rows, columns)

b) Number of columns

c) Number of rows

d) Column names

8 / 45

Which method creates a pivot table?

a) pd.pivot()

b) df.table()

c) df.pivot()

d) pd.pivot_table()

9 / 45

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

a) The sum

b) The most frequent value

c) The count

d) The smallest value

10 / 45

10)

Which method shows the first 5 rows of a DataFrame?

a) df.info()

b) df.tail()

c) df.first()

d) df.head()

11 / 45

11)

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

a) [4]

b) [1,2,3,4]

c) Error

d) [1,2,3]

12 / 45

12)

Which method applies a function to each row?

a) df.map()

b) df.transform()

c) df.apply()

d) df.applymap()

13 / 45

13)

Which reads a CSV file into a DataFrame?

a) pd.file()

b) pd.readcsv()

c) pd.open()

d) pd.read_csv()

14 / 45

14)

Which operator is used for exponentiation in Python?

a) //

b) %

c) **

d) ^

15 / 45

15)

Which function gives column summary stats?

a) info()

b) stat()

c) summary()

d) describe()

16 / 45

16)

Which function sorts DataFrame by column values?

a) sort()

b) sort_values()

c) order()

d) ort_index()

17 / 45

17)

Which Pandas function shows data types of columns?

a) df.type

b) df.types

c) df.dtype

d) df.dtypes

18 / 45

18)

Which of the following is immutable in Python?

a) List

b) Dictionary

c) Set

d) Tuple

19 / 45

19)

Which of these is used to combine DataFrames?

a) df.merge()

b) df.join()

c) df.concat()

d) All of the above

20 / 45

20)

Which function computes standard deviation in NumPy

a) np.std()

b) np.var()

c) np.dev()

d) np.mean()

21 / 45

21)

How to shuffle rows of a DataFrame?

a) df.mix()

b) df.random()

c) df.sample(frac=1)

d) df.shuffle()

22 / 45

22)

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

a) var-1

b) @value

c) _data

d) 1var

23 / 45

23)

Which method renames columns?

a) df.change_cols()

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

c) df.rename_cols()

d) df.set_names()

24 / 45

24)

NumPy arrays are preferred over Python lists because

a) They only store strings

b) They don’t support operations

c) They are memory efficient

d) They are slower

25 / 45

25)

Which NumPy attribute gives the shape of an array?

a) shape

b) size

c) type

d) ndim

26 / 45

26)

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

a) Count of unique values

b) Total rows

c) Column sum

d) Column average

27 / 45

27)

Which function computes mean in NumPy?

a) np.mean()

b) np.avg()

c) np.sum()

d) np.median()

28 / 45

28)

How to reset the index of a DataFrame?

a) df.set_index(None)

b) df.reindex()

c) df.reset()

d) df.reset_index()

29 / 45

29)

loc[] is used for:

a) Random sampling

b) Index-based selection

c) Dropping rows

d) Label-based selection

30 / 45

30)

Which gives DataFrame summary info?

a) df.shape

b) df.describe()

c) All of the above

d) df.info()

31 / 45

31)

Which function calculates quantiles?

a) df.percentile()

b) df.q()

c) df.quantile()

d) df.quant()

32 / 45

32)

Which creates an array of zeros in NumPy?

a) np.zeros()

b) np.array()

c) np.ones()

d) np.empty()

33 / 45

33)

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

a) df.dropna()

b) df.sum()

c) df.count()

d) df.isnull()

34 / 45

34)

To handle missing values you can use:

a) Both a & b

b) df.dropna()

c) df.fillna()

d) df.replace()

35 / 45

35)

Which method fills missing values?

a) df.fillna()

b) null()

c) na_replace()

d) df.dropna()

36 / 45

36)

Which operation is vectorized broadcasting?

a) Looping

b) Iteration

c) Broadcasting

d) Vectorization

37 / 45

37)

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

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

b) [1,2,3,2]

c) [2,4,6]

d) Error

38 / 45

38)

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

a) False False True

b) True False False

c) False True False

d) True True False

39 / 45

39)

Which function converts a column to datetime?

a) df.to_dt()

b) pd.to_datetime()

c) pd.to_date()

d) df.convert_date()

40 / 45

40)

Which method selects rows by integer position?

a) df.loc[]

b) df.iloc[]

c) df.at[]

d) df.get[]

41 / 45

41)

Which function gets unique values from a column?

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

b) df.unique()

c) df.values()

d) df.distinct()

42 / 45

42)

Which keyword is used to define a function in Python?

a) fun

b) def

c) define

d) function

43 / 45

43)

Which function groups data by column?

a) df.split()

b) df.groupby()

c) df.aggregate()

d) df.group()

44 / 45

44)

Indentation in Python is used for:

a) Code decoration

b) Separating functions

c) Defining code blocks

d) Documentation

45 / 45

45)

Which built-in function returns length of a list?

a) len()

b) size()

c) count()

d) length()

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) What is Big Data mainly characterized by?

a) Volume, Velocity, Variety

b) Value, Vision, Validation

c) SQL queries

d) Size only

2 / 45

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

a) Histogram

b) Line chart

c) Pie chart

d) Scatter plot

3 / 45

3) DAX in Power BI stands for:

a) Data Automated Execution

b) Data Array Exchange

c) Data Analysis Expressions

d) Database Access XML

4 / 45

4) Predictive analytics is used to:

a) Describe the past

b) Create pie charts

c) Clean datasets

d) Forecast future outcomes

5 / 45

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

a) FROM

b) SELECT

c) JOIN

d) WHERE

6 / 45

6) A slicer in Power BI is used for:

a) Filtering data interactively

b) Creating charts

c) Formatting reports

d) Joining tables

7 / 45

7) Which chart is suitable for showing cumulative values?

a) Area chart

b) Line chart

c) Scatter plot

d) Pie chart

8 / 45

8) Prescriptive analytics helps to:

a) Visualize data

b) Suggest actions to optimize results

c) Identify what happened

d) Delete unwanted data

9 / 45

9) Data storytelling in analytics refers to:

a) Coding in SQL

b) Presenting data with narratives and visuals

c) Using data to entertain

d) Writing novels

10 / 45

10) In analytics, KPI stands for:

a) Key Performance Indicator

b) Kernel Process Integration

c) Knowledge Processing Input

d) Key Power Index

11 / 45

11) Which database language is widely used in analytics?

a) SQL

b) C++

c) HTML

d) Java

12 / 45

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

a) JOIN

b) UPDATE

c) SELECT

d) DELETE

13 / 45

13) In Power BI, relationships are built between:

a) Tables

b) DAX formulas

c) Reports

d) Charts

14 / 45

14) What is the main benefit of using dashboards?

a) Storing raw files

b) Writing long reports

c) Replacing databases

d) Interactive and real-time insights

15 / 45

15) Which visualization shows parts of a whole?

a) Histogram

b) Line chart

c) Scatter plot

d) Pie chart

16 / 45

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

a) Storing raw data

b) Creating dashboards

c) Importing charts

d) Data cleaning and formatting

17 / 45

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

a) Notepad

b) Photoshop

c) MS Word

d) Power BI

18 / 45

18) A foreign key is used to:

a) Define a unique record

b) Link two tables together

c) Visualize dashboards

d) Store passwords

19 / 45

19) Which function in Power BI creates aggregate measures?

a) AVERAGE()

b) COUNT()

c) SUM()

d) All of the above

20 / 45

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

a) Power BI Mobile

b) Power BI Desktop

c) Power BI Service

d) Power Query

21 / 45

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

a) Optimizing supply chain

b) Explaining past sales trends

c) Predicting sales

d) Automating workflows

22 / 45

22) The ultimate goal of Data Analytics is to:

a) Collect large amounts of raw data

b) Build hardware devices

c) Write computer programs

d) Generate insights for better decisions

23 / 45

23) What is data visualization mainly used for?

a) Encrypt data

b) Make insights easier to understand

c) Hide data

d) Increase data errors

24 / 45

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

a) Data Mining

b) Data Loading

c) Data Reporting

d) Data Cleaning

25 / 45

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

a) Scatter plot

b) Pie chart

c) Bar chart

d) Line chart

26 / 45

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

a) Present key insights visually

b) Train machine learning models

c) Collect social media data

d) Store raw data

27 / 45

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

a) SQL databases

b) Cloud services

c) All of the above

d) Excel

28 / 45

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

a) NumPy

b) DAX

c) Python

d) SQL

29 / 45

29) What is the purpose of data transformation?

a) Convert data into usable format

b) Visualize the data

c) Erase unnecessary data permanently

d) Store data in raw form

30 / 45

30) Data Analytics mainly focuses on:

a) Creating new programming languages

b) Collecting data only

c) Analyzing past data for insights

d) Computer hardware maintenance

31 / 45

31) What does ETL stand for?

a) Execute, Transfer, Log

b) Enter, Test, Learn

c) Extract, Transform, Load

d) Encrypt, Translate, Locate

32 / 45

32) Which visualization is best for frequency distribution?

a) Area chart

b) Pie chart

c) Line graph

d) Histogram

33 / 45

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

a) Both a and b

b) Python

c) Photoshop

d) R

34 / 45

34) A primary key in a database is:

a) A foreign key

b) A column allowing duplicates

c) A chart type

d) A unique identifier for each record

35 / 45

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

a) All of the above

b) Tableau

c) Power BI

d) Google Data Studio

36 / 45

36) A bar chart is best suited for:

a) Showing correlations

b) Displaying proportions

c) Showing trends over time

d) Comparing categories

37 / 45

37) Which cloud platform is popular for analytics?

a) AWS

b) Azure

c) Google Cloud

d) All of the above

38 / 45

38) What is the role of a Data Analyst?

a) Develop operating systems

b) Build computer hardware

c) Extract insights from data

d) Write networking protocols

39 / 45

39) Power BI dashboards can be shared through:

a) Cloud storage

b) All of the above

c) Power BI Service

d) Emails

40 / 45

40) Cleaning data involves:

a) Correcting errors

b) Removing duplicates

c) Handling missing values

d) All of the above

41 / 45

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

a) Data Visualization

b) Model Deployment

c) Data Cleaning

d) Data Collection

42 / 45

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

a) Data Cleaning

b) Space Exploration

c) Data Collection

d) Data Visualization

43 / 45

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

a) Decimal Number

b) Date/Time

c) Music File

d) Whole Number

44 / 45

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

a) Left Join

b) Inner Join

c) Cross Join

d) Outer Join

45 / 45

45) . What does a Data Warehouse store?

a) Historical and structured data

b) Emails only

c) Live gaming data

d) Music files

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) What does “Data Transformation” mean?

a) Changing data format and structure

b) Deleting entire dataset

c) Copying data

d) Encrypting data

2 / 45

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

a) Prescriptive

b) Predictive

c) Descriptive

d) Diagnostic

3 / 45

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

a) FILTER

b) WHERE

c) HAVING

d) ORDER BY

4 / 45

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

a) Interactive and real-time insights

b) Static reports

c) Manual data entry

d) Non-visual output

5 / 45

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

a) Power BI

b) PowerPoint

c) C++

d) Photoshop

6 / 45

6) In Power BI, AI visuals can:

a) Replace datasets

b) Clean data automatically

c) Identify key influencers and trends

d) Run SQL queries

7 / 45

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

a) Add new columns using formulas

b) Delete rows

c) Import data

d) Clean datasets

8 / 45

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

a) Random charts

b) A Python script

c) Only raw numbers

d) Relationships between tables

9 / 45

9) Which chart is best for comparing categories?

a) Pie chart

b) Bar chart

c) Histogram

d) Line chart

10 / 45

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

a) CHAR

b) DATE

c) VARCHAR

d) INT

11 / 45

11) What is the role of prescriptive analytics?

a) To explain causes

b) To suggest actions

c) To predict future outcomes

d) To describe past data

12 / 45

12) In Power BI, a dashboard is?

a) A collection of visualizations

b) A dataset

c) A SQL script

d) A single chart

13 / 45

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

a) Data Wrangling

b) Data Mining

c) Data Visualization

d) Data Cleaning

14 / 45

14) Which SQL keyword combines rows from two queries?

a) UNION

b) SELECT

c) MERGE

d) JOIN

15 / 45

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

a) GROUP BY

b) DISTINCT

c) JOIN

d) UNION

16 / 45

16) Which SQL command removes duplicate values from results?

a) GROUP

b) UNIQUE

c) DISTINCT

d) CLEAN

17 / 45

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

a) ARRANGE

b) ORDER BY

c) GROUP BY

d) SORT

18 / 45

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

a) C language

b) Notepad

c) Word

d) Tableau

19 / 45

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

a) SUM()

b) TOTAL()

c) COUNT()

d) AVG()

20 / 45

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

a) INDEX

b) CONCATENATE

c) VLOOKUP

d) MATCH

21 / 45

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

a) Handling missing values

b) Adding random errors

c) Data normalization

d) Removing duplicates

22 / 45

22) In Power BI, measures are:

a) SQL queries

b) Raw datasets

c) Visual types

d) Pre-calculated fields

23 / 45

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

a) Boolean

b) Date/Time

c) Integer

d) String

24 / 45

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

a) Data Storage

b) Data Querying and Calculation

c) Data Importing

d) Visualization Formatting

25 / 45

25) What is the purpose of data normalization?

a) Reducing data redundancy

b) Adding duplicates

c) Removing all rows

d) Changing data types

26 / 45

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

a) Primary and Foreign Keys

b) Formulas

c) Filters

d) Random Columns

27 / 45

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

a) Encrypting sensitive data

b) Cleaning and structuring raw data

c) Collecting new datasets

d) Deploying models

28 / 45

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

a) Auto Filter

b) Data Cleaning

c) Data Refresh

d) DAX Functions

29 / 45

29) The primary goal of Data Analytics is:

a) To find patterns and insights from data

b) To design websites

c) To build operating systems

d) To create AI models

30 / 45

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

a) CONCATENATE

b) VLOOKUP

c) SPLIT

d) MATCH

31 / 45

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

a) Pie chart

b) Scatter plot

c) Histogram

d) Waterfall chart

32 / 45

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

a) Predict future trends

b) Create random charts

c) Show historical events

d) Measure business performance

33 / 45

33) Which chart is best for showing data distribution?

a) Line chart

b) Pie chart

c) Histogram

d) Bar chart

34 / 45

34) In Power BI, slicers are used for:

a) Data storage

b) Data cleaning

c) Data filtering

d) Data loading

35 / 45

35) Which chart is used for cumulative analysis?

a) Area chart

b) Pie chart

c) Histogram

d) Line chart

36 / 45

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

a) Creative Analytics

b) Diagnostic Analytics

c) Predictive Analytics

d) Prescriptive Analytics

37 / 45

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

a) Extract, Transform, Load data

b) Encode, Transfer, Load data

c) Encrypt, Test, Log data

d) Execute, Train, Learn models

38 / 45

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

a) COUNT()

b) AVG()

c) TOTAL()

d) SUM()

39 / 45

39) Which SQL clause is used to filter results?

a) GROUP BY

b) WHERE

c) ORDER BY

d) HAVING

40 / 45

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

a) DISTINCT

b) JOIN

c) GROUP BY

d) UNION

41 / 45

41) Which SQL function finds the average value?

a) MAX()

b) AVG()

c) COUNT()

d) SUM()

42 / 45

42) Which chart is most suitable to compare proportions?

a) Line chart

b) Scatter plot

c) Pie chart

d) Histogram

43 / 45

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

a) Line chart

b) Pie chart

c) Bar chart

d) Scatter plot

44 / 45

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

a) Fields Pane

b) Report Pane

c) Data Pane

d) Visualization Pane

45 / 45

45) Which visualization is best for analyzing correlation?

a) Pie chart

b) Scatter plot

c) Line chart

d) Histogram

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) Principal Component Analysis (PCA) is used for:

a) Regression

b) Clustering

c) Classification

d) Dimensionality Reduction

2 / 46

2) Which of these databases is column-oriented?

a) PostgreSQL

b) MongoDB

c) Cassandra

d) MySQL

3 / 46

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

a) CSS

b) C#

c) Python

d) HTML

4 / 46

4) Data warehouse mainly stores:

a) Historical data

b) Transactional data

c) Real-time sensor data

d) Streaming logs

5 / 46

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

a) Temperature

b) Gender

c) Height

d) Weight

6 / 46

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

a) Feature engineering

b) Normalization

c) Encoding

d) Aggregation

7 / 46

7) Which of these best describes Data Mining?

a) Storing data only

b) Extracting patterns and knowledge from large datasets

c) Visualization only

d) Cleaning missing values

8 / 46

8) Feature scaling is important because:

a) It increases dataset size

b) It removes missing values

c) Algorithms perform better when features are on similar scales

d) It reduces memory size

9 / 46

9) Which language is widely used for statistical analysis?

a) Java

b) C

c) Python

d) R

10 / 46

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

a) Scatter plot

b) Histogram

c) Line chart

d) Pie chart

11 / 46

11) What does ETL stand for in data processing?

a) Extract, Transform, Load

b) Enter, Transfer, Leave

c) Extract, Test, Learn

d) Encode, Test, Load

12 / 46

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

a) Scatter plot

b) Pie chart

c) Histogram

d) Line plot

13 / 46

13) Which is an example of unstructured data?

a) Images and videos

b) SQL tables

c) JSON logs

d) Excel sheets

14 / 46

14) In classification, Precision is defined as:

a) TP / (TP + FP)

b) TP / (TP + FN)

c) FP / (TP + FP)

d) (TP + TN) / Total

15 / 46

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

a) Hadoop

b) Scikit-learn

c) TensorFlow

d) Pandas

16 / 46

16) Recall is also called:

a) Accuracy

b) Sensitivity

c) Precision

d) Specificity

17 / 46

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

a) Java

b) C++

c) Ruby

d) Python

18 / 46

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

a) Variety

b) Complexity in management

c) Scalability

d) Improved insights

19 / 46

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

a) Visualization, Validation, Variance

b) Variety, Volume, Velocity

c) ariable, Volume, Vector

d) Value, Version, Virtualization

20 / 46

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

a) MS Word

b) Tableau

c) Eclipse

d) Photoshop

21 / 46

21) The process of identifying duplicate data is called:

a) Data Normalization

b) Data Aggregation

c) Data Deduplication

d) Data Mining

22 / 46

22) Which SQL clause is used to filter results?

a) SELECT

b) ORDER BY

c) WHERE

d) GROUP BY

23 / 46

23) Outlier detection can be performed using:

a) IQR

b) Z-score

c) Boxplot

d) All of the above

24 / 46

24) A data lake primarily stores:

a) Raw structured and unstructured data

b) Structured data only

c) Only transactional data

d) Summarized data

25 / 46

25) Which Python library is used for visualization?

a) Pandas

b) Numpy

c) Matplotlib

d) Scikit-learn

26 / 46

26) Time-series analysis is mostly applied in:

a) Image recognition

b) Customer segmentation

c) Stock market prediction

d) Clustering

27 / 46

27) A confusion matrix is used in:

a) Clustering

b) Classification

c) Data Cleaning

d) Regression

28 / 46

28) The accuracy of a classification model is:

a) TP / Total samples

b) FP + FN) / Total samples

c) (TP + TN) / Total samples

d) FN / Total samples

29 / 46

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

a) Machine Learning

b) Plumbing

c) Data Visualization

d) Statistics

30 / 46

30) A heatmap is useful for:

a) Showing correlations between variables

b) Visualizing proportions

c) Outlier detection

d) Showing distribution of one variable

31 / 46

31) Which visualization is best for correlation analysis?

a) Scatter plot

b) Line graph

c) Histogram

d) Pie chart

32 / 46

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

a) SSD

b) RAM

c) GPU memory

d) tape storage

33 / 46

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

a) All of the above

b) Deleting rows

c) Predicting with models

d) Replacing with mean/median

34 / 46

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

a) Mean

b) Range

c) Mode

d) Median

35 / 46

35) SQL keyword used to sort results:

a) SORT

b) WHERE

c) GROUP BY

d) ORDER BY

36 / 46

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

a) K-Means

b) Apriori

c) DBSCAN

d) Linear Regression

37 / 46

37) Which of these is NOT a NoSQL database?

a) Cassandra

b) CouchDB

c) MySQL

d) MongoDB

38 / 46

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

a) K-Means

b) AWS S3

c) Apache Spark

d) Docker

39 / 46

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

a) Generative

b) Predictive

c) Diagnostic

d) Descriptive

40 / 46

40) Which SQL function is used to count rows?

a) TOTAL()

b) COUNT()

c) AVG()

d) SUM()

41 / 46

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

a) Pandas

b) NumPy

c) TensorFlow

d) Matplotlib

42 / 46

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

a) Visualization

b) Data mining only

c) Relational queries

d) Distributed storage of big data

43 / 46

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

a) INTERSECT

b) UNION

c) JOIN

d) SELECT

44 / 46

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

a) Line chart

b) Histogram

c) Box plot

d) Bar chart

45 / 46

45) Which metric is used to evaluate regression models?

a) Accuracy

b) Precision

c) RMSE

d) Recall

46 / 46

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

a) HTML

b) XML

c) CSV

d) JSON

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 metric is commonly used to measure model accuracy in analytics?

a) Mean Squared Error

b) All of the above

c) ROC curve

d) R-squared

2 / 45

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

a) Linear Regression

b) Logistic Regression

c) Decision Trees

d) K-Means

3 / 45

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

a) Python

b) C++

c) Java

d) HTML

4 / 45

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

a) R

b) Python

c) All of the above

d) Scala

5 / 45

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

a) Strategic

b) Operational

c) Technical

d) Analytical

6 / 45

6) Which graph shows the distribution of data spread?

a) Heatmap

b) Box plot

c) Pie chart

d) Line chart

7 / 45

7) Which is an example of diagnostic analytics?

a) Recommending marketing strategies

b) Summarizing past year’s sales

c) Finding why sales dropped last quarter

d) Predicting sales for next year

8 / 45

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

a) Box plot

b) Pie chart

c) Line chart

d) Bar chart

9 / 45

9) A heatmap is useful for:

a) Predicting missing values

b) Extracting datasets

c) Cleaning data

d) Showing correlation strength

10 / 45

10) What is metadata?

a) Data about data

b) Duplicate data

c) Deleted data

d) Encrypted data

11 / 45

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

a) Extract useful insights

b) Store data

c) Build websites

d) Encrypt data

12 / 45

12) Which is an open-source BI tool?

a) QlikView

b) Looker

c) Tableau Public

d) Power BI

13 / 45

13) The ETL process stands for:

a) Edit, Transform, Link

b) Extract, Transfer, Link

c) Extract, Transform, Load

d) Encode, Transfer, Load

14 / 45

14) KPI stands for:

a) Knowledge Performance Insights

b) Key Predictive Input

c) Key Performance Indicator

d) Known Predictive Index

15 / 45

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

a) Diagnostic

b) Descriptive

c) Prescriptive

d) Predictive

16 / 45

16) OLAP stands for:

a) Online Analytical Processing

b) Open Layer Application Protocol

c) Online Advanced Processing

d) Online Application Processing

17 / 45

17) Which step ensures data reliability and correctness?

a) Transformation

b) Visualization

c) Data validation

d) Storage

18 / 45

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

a) Histogram

b) Line chart

c) Pie chart

d) Bar chart

19 / 45

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

a) None

b) Mode

c) Mean

d) Median

20 / 45

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

a) All of the above

b) Predicting them using models

c) Filling with mean/median/mode

d) Ignoring them

21 / 45

21) Which distribution is most common in analytics?

a) Exponential

b) Uniform

c) Poisson

d) Normal (Gaussian)

22 / 45

22) Descrip ve analy cs focuses on:

a) Prescribing ac ons

b) Why something happened

c) Predic ng future events

d) What has already happened

23 / 45

23) Histogram is best used to show:

a) Time series trends

b) Comparison between categories

c) Categorical data distribution

d) Numerical data distribution

24 / 45

24) Data transformation means:

a) Converting data from one format to another

b) Encrypting sensitive data

c) Deleting old data

d) Archiving data

25 / 45

25) Cross-validation is used to:

a) Train the model faster

b) Encrypt data

c) Test the model on different splits of data

d) Increase dataset size

26 / 45

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

a) Inner join

b) Left join

c) Full join

d) Right join

27 / 45

27) Which Python library is commonly used for visualization?

a) Scikit-learn

b) NumPy

c) Pandas

d) Matplotlib

28 / 45

28) An example of predictive analytics is:

a) Estimating next month’s sales

b) Cleaning messy data

c) Identifying missing values

d) Generating a past report

29 / 45

29) Outliers are:

a) Duplicates

b) Missing data

c) Values within expected range

d) Extreme values outside the normal range

30 / 45

30) Time-series forecasting is an example of:

a) Predictive analytics

b) None

c) Diagnostic analytics

d) Descriptive analytics

31 / 45

31) Which step comes first in the analytics process?

a) Data collection

b) Prediction

c) Reporting

d) Data visualization

32 / 45

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

a) Validation

b) Modeling

c) Extraction

d) Data wrangling

33 / 45

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

a) .mp3

b) .csv

c) csv

d) .exe

34 / 45

34) Which technique reduces dataset dimensionality?

a) PCA (Principal Component Analysis)

b) Clustering

c) Classification

d) Regression

35 / 45

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

a) Tabular data

b) Semi-structured data

c) Unstructured data

d) JSON data

36 / 45

36) Data normalization means:

a) Scaling values

b) All of the above

c) Reducing redundancy

d) Cleaning duplicates

37 / 45

37) Which visualization is best for categorical comparison?

a) Bar chart

b) Histogram

c) ) Pie chart

d) Scatter plot

38 / 45

38) . Which cloud platforms provide ML and DS tools

a) Azure

b) All of the above

c) Google Cloud

d) AWS

39 / 45

39) A scatter plot is mainly used to:

a) Show relationships between two variables

b) Compare proportions

c) Show distribution of frequencies

d) Display time-series data

40 / 45

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

a) DataFrame

b) Dictionary

c) List

d) Tuple

41 / 45

41) A correlation coefficient close to -1 means:

a) No relation

b) Weak relation

c) Strong negative relation

d) Strong positive relation

42 / 45

42) Which is a BI tool used for dashboards?

a) Spark

b) Power BI

c) Hadoop

d) MongoDB

43 / 45

43) SQL is primarily used for:

a) Web design

b) Machine learning

c) Image processing

d) Data extraction and querying

44 / 45

44) Power BI and Tableau are examples of:

a) Programming languages

b) Database systems

c) Visualization tools

d) Operating systems

45 / 45

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

a) TensorFlow

b) Matplotlib

c) Flask

d) Pandas

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 data cleaning technique replaces missing values with averages?

a) Mean imputation

b) Regression imputation

c) Deletion

d) Encoding

2 / 44

2) Which SQL keyword removes duplicates from a result?

a) FILTER

b) DISTINCT

c) CLEAR

d) UNIQUE

3 / 44

3) Which type of analytics predicts future trends?

a) Prescriptive

b) Descriptive

c) Diagnostic

d) Predictive

4 / 44

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

a) MERGE

b) UNION

c) CONNECT

d) JOIN

5 / 44

5) Which function finds the largest value in Excel?

a) =BIG()

b) =LARGE()

c) =GREATEST()

d) =MAX()

6 / 44

6) Which of the following is a BI tool?

a) Tableau

b) All of the above

c) QlikView

d) Power BI

7 / 44

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

a) NumPy

b) TensorFlow

c) Pandas

d) Matplotlib

8 / 44

8) Which is an example of qualitative data?

a) Eye color

b) Weight

c) Height

d) Salary

9 / 44

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

a) NumPy

b) Pandas

c) Matplotlib

d) SciPy

10 / 44

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

a) All of the above

b) Power BI

c) Excel

d) Tableau

11 / 44

11) A pivot table in Excel is used for:

a) Data storage

b) Data cleaning

c) Data validation

d) Summarizing data

12 / 44

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

a) Range

b) Interquartile range

c) Standard deviation

d) Variance

13 / 44

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

a) Bar chart

b) Line chart

c) Pie chart

d) Histogram

14 / 44

14) Which of these measures central tendency?

a) Mean

b) Mode

c) Median

d) All of the above

15 / 44

15) What does KPI stand for in analytics?

a) Key Performance Indicator

b) Key Process Integration

c) Key Profit Index

d) Knowledge Processing Interface

16 / 44

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

a) Seaborn

b) NumPy

c) Pandas

d) Matplotlib

17 / 44

17) Which analytics type answers “What happened?”

a) Predictive

b) Diagnostic

c) Prescriptive

d) Descriptive

18 / 44

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

a) Keys

b) Fields

c) Records

d) Entries

19 / 44

19) Outliers in data can:

a) Improve accuracy

b) Have no impact

c) Always be ignored

d) Skew results

20 / 44

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

a) None

b) Faster results

c) Biased analysis

d) Accurate predictions

21 / 44

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

a) Data Collection

b) Data Transformation

c) Data Cleaning

d) Data Visualization

22 / 44

22) Data normalization is used to:

a) Improve consistency

b) All of the above

c) Reduce redundancy

d) Organize databases

23 / 44

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

a) R

b) DAX

c) SQL

d) Python

24 / 44

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

a) Columns

b) Indexes

c) Attributes

d) Keys

25 / 44

25) Which type of chart shows distribution of data?

a) Histogram

b) Line chart

c) Scatter plot

d) Pie chart

26 / 44

26) Data dashboards are mainly used for:

a) Data cleaning

b) Database design

c) Data collection

d) Visual reporting

27 / 44

27) Which chart type is best for categorical comparisons?

a) Scatter plot

b) Bar chart

c) Histogram

d) Line chart

28 / 44

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

a) SELECT

b) DELETE

c) UPDATE

d) INSERT

29 / 44

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

a) Categorical

b) Continuous

c) Time-series

d) Numerical

30 / 44

30) What does ETL stand for in Data Analytics?

a) Extract, Transform, Load

b) Export, Track, Link

c) Encode, Transfer, Load

d) Execute, Test, Learn

31 / 44

31) What does OLAP stand for?

a) Operational Logic Analysis Platform

b) Online Logical Application

c) Open Learning Analytics Process

d) Online Analytical Processing

32 / 44

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

a) Enterprise Data Architecture

b) Enhanced Data Analytics

c) Exploratory Data Analysis

d) Estimated Data Application

33 / 44

33) Which file format is commonly used for datasets?

a) .xlsx

b) .csv

c) All of the above

d) .txt

34 / 44

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

a) COUNT()

b) SUM()

c) TOTAL()

d) NUMBER()

35 / 44

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

a) Histogram

b) Pie chart

c) Scatter plot

d) Line chart

36 / 44

36) Which analytics approach recommends actions?

a) Predictive

b) Prescriptive

c) Diagnostic

d) Descriptive

37 / 44

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

a) Colors of cars

b) Student grades

c) Employee names

d) Monthly sales

38 / 44

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

a) Histogram

b) Pie chart

c) Scatter plot

d) Line chart

39 / 44

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

a) Data collection

b) Data cleaning

c) Data entry

d) Data visualization

40 / 44

40) Which data type represents continuous numbers?

a) String

b) Integer

c) Float

d) Boolean

41 / 44

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

a) All of the above

b) Removing rows

c) Predicting values

d) Replacing with mean/median

42 / 44

42) Which SQL clause filters data?

a) WHERE

b) ORDER BY

c) GROUP BY

d) HAVING

43 / 44

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

a) Python

b) Excel

c) Tableau

d) Power BI

44 / 44

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

a) =AVERAGE()

b) =MEAN()

c) =COUNT()

d) =SUM()

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 NOT a type of data?

a) Structured

b) Designed

c) Semi-structured

d) Unstructured

2 / 46

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

a) TensorFlow

b) Power BI

c) Docker

d) GitHub

3 / 46

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

a) f.na()

b) df.isnull()

c) df.empty()

d) df.dropna()

4 / 46

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

a) join()

b) concat()

c) merge()

d) append()

5 / 46

5) Which step comes immediately after Data Collection?

a) Data Visualization

b) Data Cleaning

c) Data Loading

d) Data Modeling

6 / 46

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

a) String

b) Integer

c) Boolean

d) Float

7 / 46

7) Which type of data visualization best shows correlation?

a) Scatter plot

b) Pie chart

c) Histogram

d) Bar chart

8 / 46

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

a) df.mean()

b) df.summary()

c) df.describe()

d) df.stats()

9 / 46

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

a) JOIN

b) GROUP BY

c) ORDER BY

d) UNION

10 / 46

10) Which plot is best for identifying correlations?

a) Histogram

b) Line chart

c) Pie chart

d) Scatter plot

11 / 46

11) Which function in Pandas removes missing values?

a) df.dropna()

b) df.na()

c) df.remove()

d) df.clean()

12 / 46

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

a) String

b) Integer

c) Float

d) Boolean

13 / 46

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

a) Images and videos

b) CSV files

c) Database table

d) Excel sheets

14 / 46

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

a) Tableau

b) Seaborn

c) Plotly

d) Matplotlib

15 / 46

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

a) Normalization

b) Data loading

c) Data visualization

d) data entry

16 / 46

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

a) Hadoop

b) GitHub

c) PowerPoint

d) Excel

17 / 46

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

a) Predictive

b) Descriptive

c) Informative

d) Prescriptive

18 / 46

18) What does ETL stand for?

a) Explore, Transfer, Learn

b) Evaluate, Transform, Load

c) Extract, Transform, Load

d) Extract, Test, Link

19 / 46

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

a) Transform

b) Extract

c) Model

d) Load

20 / 46

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

a) MongoDB

b) Snowflake

c) SQLite

d) MySQL

21 / 46

21) Which SQL aggregate function returns the maximum value?

a) MAX()

b) HIGH()

c) TOP()

d) BIG()

22 / 46

22) Which SQL command removes an entire table?

a) DROP

b) CLEAR

c) DELETE

d) REMOVE

23 / 46

23) Which chart is suitable for categorical data comparison?

a) Histogram

b) Line chart

c) Bar chart

d) Scatter plot

24 / 46

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

a) GROUP BY

b) SORT

c) ORDER BY

d) FILTER

25 / 46

25) Which SQL command is used to filter rows?

a) gROUP BY

b) SELECT

c) oRDER BY

d) WHERE

26 / 46

26) Which visualization is best for showing proportions?

a) Line chart

b) Histogram

c) Scatter plot

d) Pie chart

27 / 46

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

a) df.tail()

b) df.start()

c) df.head()

d) df.show()

28 / 46

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

a) Box plot

b) Histogram

c) Pie chart

d) Line chart

29 / 46

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

a) list

b) Set

c) DataFrame

d) Dictionary

30 / 46

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

a) Employee salaries

b) Product categories

c) Sales data by date

d) Student names in a class

31 / 46

31) Which visualization helps compare two continuous variables?

a) Histogram

b) Pie chart

c) Scatter plot

d) Bar chart

32 / 46

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

a) DELETE

b) UNIQUE

c) DISTINCT

d) REMOVE

33 / 46

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

a) LEFT JOIN

b) INNER JOIN

c) RIGHT JOIN

d) FULL OUTER JOIN

34 / 46

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

a) Knowledge Processing Insight

b) known Predictive Indicator

c) Key Performance Indicator

d) Key Process Integration

35 / 46

35) Which plot is best for identifying outliers?

a) Bar chart

b) Box plot

c) Line chart

d) Pie chart

36 / 46

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

a) Mean

b) All of the above

c) Mode

d) Median

37 / 46

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

a) Line chart

b) Box plot

c) Scatter plot

d) Pie chart

38 / 46

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

a) SciPy

b) Pandas

c) Seaborn

d) NumPy

39 / 46

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

a) QlikView

b) Tableau

c) Power BI

d) Looker

40 / 46

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

a) Histogram

b) Bar chart

c) Pie chart

d) Line chart

41 / 46

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

a) Data Reporting

b) Data Visualization

c) Data Collection

d) Data Cleaning

42 / 46

42) Which SQL function is used to count rows?

a) NUMBER()

b) TOTAL()

c) SUM()

d) COUNT()

43 / 46

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

a) Building dashboards

b) Summarizing insights and patterns

c) Predicting future outcomes

d) Cleaning data

44 / 46

44) 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

45 / 46

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

a) Matplotlib

b) Pandas

c) NumPy

d) Seaborn

46 / 46

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

a) all of the above

b) Google Data Studio

c) Tableau

d) Power BI

Your score is

The average score is 0%

Exit

What is a Data Analyst Intern?

Leave a Reply Cancel reply