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 gives DataFrame summary info?

a) df.shape

b) All of the above

c) df.describe()

d) df.info()

2 / 45

Which method renames columns?

a) df.change_cols()

b) df.rename_cols()

c) df.set_names()

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

3 / 45

Which function groups data by column?

a) df.groupby()

b) df.group()

c) df.aggregate()

d) df.split()

4 / 45

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

a) [1,2,3]

b) [1,2,3,4]

c) [4]

d) Error

5 / 45

Which of the following is immutable in Python?

a) Tuple

b) List

c) Set

d) Dictionary

6 / 45

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

a) Count of unique values

b) Column average

c) Column sum

d) Total rows

7 / 45

Which function computes mean in NumPy?

a) np.mean()

b) np.sum()

c) np.median()

d) np.avg()

8 / 45

Which operation is vectorized broadcasting?

a) Looping

b) Vectorization

c) Broadcasting

d) Iteration

9 / 45

loc[] is used for:

a) Dropping rows

b) Random sampling

c) Index-based selection

d) Label-based selection

10 / 45

10)

Which method merges DataFrames?

a) pd.concat()

b) pd.merge()

c) pd.combine()

d) pd.append()

11 / 45

11)

Which function converts a column to datetime?

a) df.to_dt()

b) df.convert_date()

c) pd.to_datetime()

d) pd.to_date()

12 / 45

12)

Which operator is used for exponentiation in Python?

a) %

b) ^

c) //

d) **

13 / 45

13)

Which Pandas function shows data types of columns?

a) df.type

b) df.dtypes

c) df.dtype

d) df.types

14 / 45

14)

Which keyword is used to define a function in Python?

a) function

b) def

c) fun

d) define

15 / 45

15)

Which method drops duplicate rows?

a) df.drop_duplicates()

b) df.remove_duplicates()

c) df.unique()

d) df.clean()

16 / 45

16)

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

a) var-1

b) _data

c) 1var

d) @value

17 / 45

17)

NumPy arrays are preferred over Python lists because

a) They are memory efficient

b) They only store strings

c) They don’t support operations

d) They are slower

18 / 45

18)

Which method shows the first 5 rows of a DataFrame?

a) df.info()

b) df.head()

c) df.tail()

d) df.first()

19 / 45

19)

Which built-in function returns length of a list?

a) size()

b) count()

c) len()

d) length()

20 / 45

20)

How to shuffle rows of a DataFrame?

a) df.sample(frac=1)

b) df.shuffle()

c) df.mix()

d) df.random()

21 / 45

21)

How to reset the index of a DataFrame?

a) df.reindex()

b) df.set_index(None)

c) df.reset()

d) df.reset_index()

22 / 45

22)

Which function calculates quantiles?

a) df.quantile()

b) df.percentile()

c) df.q()

d) df.quant()

23 / 45

23)

Which method fills missing values?

a) df.dropna()

b) null()

c) df.fillna()

d) na_replace()

24 / 45

24)

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

a) False True False

b) True True False

c) False False True

d) True False False

25 / 45

25)

Which axis applies a row-wise operation in Pandas?

a) axis=0

b) axis=row

c) axis=1

d) axis=2

26 / 45

26)

What does df.shape return?

a) Number of columns

b) (rows, columns)

c) Number of rows

d) Column names

27 / 45

27)

Which creates an array of zeros in NumPy?

a) np.array()

b) np.empty()

c) np.zeros()

d) np.ones()

28 / 45

28)

To handle missing values you can use:

a) df.replace()

b) df.dropna()

c) df.fillna()

d) Both a & b

29 / 45

29)

Which reads a CSV file into a DataFrame?

a) pd.read_csv()

b) pd.readcsv()

c) pd.file()

d) pd.open()

30 / 45

30)

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

a) df.isnull()

b) df.count()

c) df.sum()

d) df.dropna()

31 / 45

31)

Which NumPy attribute gives the shape of an array?

a) size

b) type

c) shape

d) ndim

32 / 45

32)

Which function gets unique values from a column?

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

b) df.unique()

c) df.values()

d) df.distinct()

33 / 45

33)

Which method selects rows by integer position?

a) df.get[]

b) df.loc[]

c) df.at[]

d) df.iloc[]

34 / 45

34)

Which function computes standard deviation in NumPy

a) np.var()

b) np.std()

c) np.dev()

d) np.mean()

35 / 45

35)

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

a) The smallest value

b) The most frequent value

c) The sum

d) The count

36 / 45

36)

Which function sorts DataFrame by column values?

a) sort_values()

b) sort()

c) order()

d) ort_index()

37 / 45

37)

Which method drops a column?

a) df.delete('col')

b) df.remove('col')

c) df.pop('col')

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

38 / 45

38)

Indentation in Python is used for:

a) Defining code blocks

b) Code decoration

c) Separating functions

d) Documentation

39 / 45

39)

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

40 / 45

40)

Which of these is used to combine DataFrames?

a) All of the above

b) df.join()

c) df.merge()

d) df.concat()

41 / 45

41)

Which function gives column summary stats?

a) describe()

b) stat()

c) info()

d) summary()

42 / 45

42)

Which function converts a value to integer?

a) float()

b) int()

c) bool()

d) str()

43 / 45

43)

Which method applies a function to each row?

a) df.applymap()

b) df.map()

c) df.apply()

d) df.transform()

44 / 45

44)

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

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

b) [2,4,6]

c) [1,2,3,2]

d) Error

45 / 45

45)

Which method creates a pivot table?

a) df.table()

b) pd.pivot_table()

c) df.pivot()

d) pd.pivot()

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

b) Charts

c) DAX formulas

d) Reports

2 / 45

2) Data Analytics mainly focuses on:

a) Collecting data only

b) Computer hardware maintenance

c) Creating new programming languages

d) Analyzing past data for insights

3 / 45

3) Predictive analytics is used to:

a) Describe the past

b) Forecast future outcomes

c) Clean datasets

d) Create pie charts

4 / 45

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

a) R

b) Both a and b

c) Photoshop

d) Python

5 / 45

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

a) Photoshop

b) MS Word

c) Power BI

d) Notepad

6 / 45

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

a) Storing raw data

b) Creating dashboards

c) Data cleaning and formatting

d) Importing charts

7 / 45

7) DAX in Power BI stands for:

a) Data Analysis Expressions

b) Data Array Exchange

c) Database Access XML

d) Data Automated Execution

8 / 45

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

a) Data Mining

b) Data Loading

c) Data Cleaning

d) Data Reporting

9 / 45

9) What is Big Data mainly characterized by?

a) Size only

b) SQL queries

c) Value, Vision, Validation

d) Volume, Velocity, Variety

10 / 45

10) Cleaning data involves:

a) Handling missing values

b) Removing duplicates

c) Correcting errors

d) All of the above

11 / 45

11) What does ETL stand for?

a) Extract, Transform, Load

b) Enter, Test, Learn

c) Execute, Transfer, Log

d) Encrypt, Translate, Locate

12 / 45

12) The ultimate goal of Data Analytics is to:

a) Generate insights for better decisions

b) Collect large amounts of raw data

c) Write computer programs

d) Build hardware devices

13 / 45

13) Which visualization is best for frequency distribution?

a) Pie chart

b) Line graph

c) Area chart

d) Histogram

14 / 45

14) A bar chart is best suited for:

a) Displaying proportions

b) Comparing categories

c) Showing correlations

d) Showing trends over time

15 / 45

15) Which visualization shows parts of a whole?

a) Pie chart

b) Scatter plot

c) Line chart

d) Histogram

16 / 45

16) What is the purpose of data transformation?

a) Store data in raw form

b) Convert data into usable format

c) Visualize the data

d) Erase unnecessary data permanently

17 / 45

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

a) Power BI Mobile

b) Power BI Service

c) Power Query

d) Power BI Desktop

18 / 45

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

a) SELECT

b) UPDATE

c) JOIN

d) DELETE

19 / 45

19) Which cloud platform is popular for analytics?

a) Google Cloud

b) AWS

c) All of the above

d) Azure

20 / 45

20) In analytics, KPI stands for:

a) Key Power Index

b) Knowledge Processing Input

c) Kernel Process Integration

d) Key Performance Indicator

21 / 45

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

a) JOIN

b) WHERE

c) FROM

d) SELECT

22 / 45

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

a) Date/Time

b) Music File

c) Decimal Number

d) Whole Number

23 / 45

23) A slicer in Power BI is used for:

a) Formatting reports

b) Creating charts

c) Filtering data interactively

d) Joining tables

24 / 45

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

a) Tableau

b) Power BI

c) All of the above

d) Google Data Studio

25 / 45

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

a) Collect social media data

b) Present key insights visually

c) Store raw data

d) Train machine learning models

26 / 45

26) What is the main benefit of using dashboards?

a) Writing long reports

b) Storing raw files

c) Replacing databases

d) Interactive and real-time insights

27 / 45

27) Data storytelling in analytics refers to:

a) Writing novels

b) Coding in SQL

c) Using data to entertain

d) Presenting data with narratives and visuals

28 / 45

28) Prescriptive analytics helps to:

a) Delete unwanted data

b) Visualize data

c) Suggest actions to optimize results

d) Identify what happened

29 / 45

29) Which database language is widely used in analytics?

a) HTML

b) Java

c) SQL

d) C++

30 / 45

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

a) Data Cleaning

b) Data Collection

c) Model Deployment

d) Data Visualization

31 / 45

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

a) NumPy

b) Python

c) DAX

d) SQL

32 / 45

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

a) Pie chart

b) Scatter plot

c) Line chart

d) Bar chart

33 / 45

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

a) All of the above

b) Excel

c) Cloud services

d) SQL databases

34 / 45

34) What is the role of a Data Analyst?

a) Write networking protocols

b) Develop operating systems

c) Build computer hardware

d) Extract insights from data

35 / 45

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

a) Predicting sales

b) Explaining past sales trends

c) Optimizing supply chain

d) Automating workflows

36 / 45

36) Which function in Power BI creates aggregate measures?

a) COUNT()

b) AVERAGE()

c) All of the above

d) SUM()

37 / 45

37) A primary key in a database is:

a) A chart type

b) A column allowing duplicates

c) A unique identifier for each record

d) A foreign key

38 / 45

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

a) Left Join

b) Cross Join

c) Inner Join

d) Outer Join

39 / 45

39) A foreign key is used to:

a) Visualize dashboards

b) Define a unique record

c) Store passwords

d) Link two tables together

40 / 45

40) Power BI dashboards can be shared through:

a) Cloud storage

b) Power BI Service

c) Emails

d) All of the above

41 / 45

41) What is data visualization mainly used for?

a) Make insights easier to understand

b) Increase data errors

c) Encrypt data

d) Hide data

42 / 45

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

a) Space Exploration

b) Data Collection

c) Data Cleaning

d) Data Visualization

43 / 45

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

a) Pie chart

b) Histogram

c) Line chart

d) Scatter plot

44 / 45

44) Which chart is suitable for showing cumulative values?

a) Scatter plot

b) Area chart

c) Pie chart

d) Line chart

45 / 45

45) . What does a Data Warehouse store?

a) Historical and structured data

b) Emails only

c) Music files

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) In Power BI, calculated columns are used to:

a) Add new columns using formulas

b) Import data

c) Delete rows

d) Clean datasets

2 / 45

2) Which chart is most suitable to compare proportions?

a) Line chart

b) Histogram

c) Pie chart

d) Scatter plot

3 / 45

3) Which chart is best for comparing categories?

a) Line chart

b) Histogram

c) Pie chart

d) Bar chart

4 / 45

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

a) Measure business performance

b) Show historical events

c) Create random charts

d) Predict future trends

5 / 45

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

a) Report Pane

b) Visualization Pane

c) Fields Pane

d) Data Pane

6 / 45

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

a) PowerPoint

b) Power BI

c) C++

d) Photoshop

7 / 45

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

a) Data Storage

b) Data Importing

c) Visualization Formatting

d) Data Querying and Calculation

8 / 45

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

a) Predictive Analytics

b) Prescriptive Analytics

c) Diagnostic Analytics

d) Creative Analytics

9 / 45

9) Which SQL command removes duplicate values from results?

a) GROUP

b) DISTINCT

c) UNIQUE

d) CLEAN

10 / 45

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

a) Pie chart

b) Scatter plot

c) Line chart

d) Bar chart

11 / 45

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

a) C language

b) Tableau

c) Word

d) Notepad

12 / 45

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

a) GROUP BY

b) UNION

c) DISTINCT

d) JOIN

13 / 45

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

a) Histogram

b) Waterfall chart

c) Pie chart

d) Scatter plot

14 / 45

14) Which chart is used for cumulative analysis?

a) Area chart

b) Histogram

c) Pie chart

d) Line chart

15 / 45

15) The primary goal of Data Analytics is:

a) To create AI models

b) To design websites

c) To find patterns and insights from data

d) To build operating systems

16 / 45

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

a) SPLIT

b) MATCH

c) CONCATENATE

d) VLOOKUP

17 / 45

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

a) Manual data entry

b) Non-visual output

c) Interactive and real-time insights

d) Static reports

18 / 45

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

a) DATE

b) CHAR

c) VARCHAR

d) INT

19 / 45

19) What is the purpose of data normalization?

a) Adding duplicates

b) Removing all rows

c) Changing data types

d) Reducing data redundancy

20 / 45

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

a) HAVING

b) FILTER

c) WHERE

d) ORDER BY

21 / 45

21) In Power BI, AI visuals can:

a) Replace datasets

b) Identify key influencers and trends

c) Run SQL queries

d) Clean data automatically

22 / 45

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

a) A Python script

b) Relationships between tables

c) Only raw numbers

d) Random charts

23 / 45

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

a) Random Columns

b) Formulas

c) Filters

d) Primary and Foreign Keys

24 / 45

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

a) Data Wrangling

b) Data Visualization

c) Data Mining

d) Data Cleaning

25 / 45

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

a) Descriptive

b) Predictive

c) Diagnostic

d) Prescriptive

26 / 45

26) What is the role of prescriptive analytics?

a) To describe past data

b) To predict future outcomes

c) To suggest actions

d) To explain causes

27 / 45

27) Which SQL keyword combines rows from two queries?

a) JOIN

b) UNION

c) MERGE

d) SELECT

28 / 45

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

a) AVG()

b) COUNT()

c) TOTAL()

d) SUM()

29 / 45

29) Which SQL clause is used to filter results?

a) WHERE

b) ORDER BY

c) GROUP BY

d) HAVING

30 / 45

30) In Power BI, a dashboard is?

a) A SQL script

b) A dataset

c) A collection of visualizations

d) A single chart

31 / 45

31) What does “Data Transformation” mean?

a) Changing data format and structure

b) Encrypting data

c) Copying data

d) Deleting entire dataset

32 / 45

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

a) Data Refresh

b) Data Cleaning

c) DAX Functions

d) Auto Filter

33 / 45

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

a) Encrypting sensitive data

b) Cleaning and structuring raw data

c) Collecting new datasets

d) Deploying models

34 / 45

34) Which visualization is best for analyzing correlation?

a) Line chart

b) Scatter plot

c) Pie chart

d) Histogram

35 / 45

35) In Power BI, measures are:

a) Visual types

b) Pre-calculated fields

c) SQL queries

d) Raw datasets

36 / 45

36) Which chart is best for showing data distribution?

a) Line chart

b) Bar chart

c) Histogram

d) Pie chart

37 / 45

37) In Power BI, slicers are used for:

a) Data filtering

b) Data loading

c) Data storage

d) Data cleaning

38 / 45

38) Which SQL function finds the average value?

a) MAX()

b) AVG()

c) SUM()

d) COUNT()

39 / 45

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

a) Integer

b) Boolean

c) Date/Time

d) String

40 / 45

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

a) SUM()

b) COUNT()

c) AVG()

d) TOTAL()

41 / 45

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

a) Removing duplicates

b) Handling missing values

c) Adding random errors

d) Data normalization

42 / 45

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

a) CONCATENATE

b) INDEX

c) MATCH

d) VLOOKUP

43 / 45

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

a) SORT

b) GROUP BY

c) ARRANGE

d) ORDER BY

44 / 45

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

a) UNION

b) JOIN

c) DISTINCT

d) GROUP BY

45 / 45

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

a) Encode, Transfer, Load data

b) Encrypt, Test, Log data

c) Execute, Train, Learn models

d) Extract, Transform, Load data

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) Big data is often defined by which 3Vs?

a) Visualization, Validation, Variance

b) Value, Version, Virtualization

c) ariable, Volume, Vector

d) Variety, Volume, Velocity

2 / 46

2) Which of these best describes Data Mining?

a) Visualization only

b) Cleaning missing values

c) Extracting patterns and knowledge from large datasets

d) Storing data only

3 / 46

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

a) AWS S3

b) K-Means

c) Docker

d) Apache Spark

4 / 46

4) Which SQL function is used to count rows?

a) AVG()

b) COUNT()

c) SUM()

d) TOTAL()

5 / 46

5) Feature scaling is important because:

a) It increases dataset size

b) Algorithms perform better when features are on similar scales

c) It reduces memory size

d) It removes missing values

6 / 46

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

a) Median

b) Mean

c) Mode

d) Range

7 / 46

7) Which visualization is best for correlation analysis?

a) Scatter plot

b) Line graph

c) Pie chart

d) Histogram

8 / 46

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

a) JOIN

b) UNION

c) INTERSECT

d) SELECT

9 / 46

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

a) Histogram

b) Bar chart

c) Line chart

d) Box plot

10 / 46

10) A heatmap is useful for:

a) Outlier detection

b) Showing distribution of one variable

c) Visualizing proportions

d) Showing correlations between variables

11 / 46

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

a) Scatter plot

b) Pie chart

c) Histogram

d) Line plot

12 / 46

12) The process of identifying duplicate data is called:

a) Data Normalization

b) Data Mining

c) Data Deduplication

d) Data Aggregation

13 / 46

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

a) C++

b) Ruby

c) Java

d) Python

14 / 46

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

a) NumPy

b) TensorFlow

c) Matplotlib

d) Pandas

15 / 46

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

a) Normalization

b) Encoding

c) Feature engineering

d) Aggregation

16 / 46

16) Which SQL clause is used to filter results?

a) ORDER BY

b) SELECT

c) WHERE

d) GROUP BY

17 / 46

17) What does ETL stand for in data processing?

a) Extract, Transform, Load

b) Extract, Test, Learn

c) Encode, Test, Load

d) Enter, Transfer, Leave

18 / 46

18) A confusion matrix is used in:

a) Classification

b) Data Cleaning

c) Regression

d) Clustering

19 / 46

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

a) Python

b) CSS

c) HTML

d) C#

20 / 46

20) The accuracy of a classification model is:

a) FN / Total samples

b) TP / Total samples

c) (TP + TN) / Total samples

d) FP + FN) / Total samples

21 / 46

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

a) Pandas

b) Hadoop

c) Scikit-learn

d) TensorFlow

22 / 46

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

a) Variety

b) Improved insights

c) Complexity in management

d) Scalability

23 / 46

23) A data lake primarily stores:

a) Summarized data

b) Structured data only

c) Only transactional data

d) Raw structured and unstructured data

24 / 46

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

a) Tableau

b) MS Word

c) Photoshop

d) Eclipse

25 / 46

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

a) Deleting rows

b) All of the above

c) Predicting with models

d) Replacing with mean/median

26 / 46

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

a) Dimensionality Reduction

b) Classification

c) Regression

d) Clustering

27 / 46

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

a) Height

b) Temperature

c) Weight

d) Gender

28 / 46

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

a) SSD

b) tape storage

c) RAM

d) GPU memory

29 / 46

29) Time-series analysis is mostly applied in:

a) Image recognition

b) Stock market prediction

c) Clustering

d) Customer segmentation

30 / 46

30) SQL keyword used to sort results:

a) WHERE

b) GROUP BY

c) ORDER BY

d) SORT

31 / 46

31) Recall is also called:

a) Sensitivity

b) Accuracy

c) Specificity

d) Precision

32 / 46

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

a) Relational queries

b) Distributed storage of big data

c) Data mining only

d) Visualization

33 / 46

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

a) K-Means

b) DBSCAN

c) Apriori

d) Linear Regression

34 / 46

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

a) Scatter plot

b) Histogram

c) Line chart

d) Pie chart

35 / 46

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

a) XML

b) HTML

c) CSV

d) JSON

36 / 46

36) Which of these is NOT a NoSQL database?

a) CouchDB

b) MySQL

c) Cassandra

d) MongoDB

37 / 46

37) Which of these databases is column-oriented?

a) Cassandra

b) MongoDB

c) PostgreSQL

d) MySQL

38 / 46

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

a) Machine Learning

b) Statistics

c) Data Visualization

d) Plumbing

39 / 46

39) In classification, Precision is defined as:

a) TP / (TP + FP)

b) TP / (TP + FN)

c) (TP + TN) / Total

d) FP / (TP + FP)

40 / 46

40) Data warehouse mainly stores:

a) Transactional data

b) Historical data

c) Streaming logs

d) Real-time sensor data

41 / 46

41) Outlier detection can be performed using:

a) All of the above

b) Boxplot

c) Z-score

d) IQR

42 / 46

42) Which is an example of unstructured data?

a) SQL tables

b) JSON logs

c) Images and videos

d) Excel sheets

43 / 46

43) Which language is widely used for statistical analysis?

a) Python

b) R

c) Java

d) C

44 / 46

44) Which Python library is used for visualization?

a) Numpy

b) Matplotlib

c) Scikit-learn

d) Pandas

45 / 46

45) Which metric is used to evaluate regression models?

a) Precision

b) Accuracy

c) Recall

d) RMSE

46 / 46

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

a) Predictive

b) Descriptive

c) Generative

d) Diagnostic

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 cloud platforms provide ML and DS tools

a) AWS

b) All of the above

c) Google Cloud

d) Azure

2 / 45

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

a) Logistic Regression

b) Decision Trees

c) K-Means

d) Linear Regression

3 / 45

3) A scatter plot is mainly used to:

a) Show relationships between two variables

b) Compare proportions

c) Display time-series data

d) Show distribution of frequencies

4 / 45

4) Data transformation means:

a) Encrypting sensitive data

b) Deleting old data

c) Converting data from one format to another

d) Archiving data

5 / 45

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

a) Python

b) All of the above

c) R

d) Scala

6 / 45

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

a) .exe

b) csv

c) .csv

d) .mp3

7 / 45

7) Which graph shows the distribution of data spread?

a) Box plot

b) Pie chart

c) Heatmap

d) Line chart

8 / 45

8) Which visualization is best for categorical comparison?

a) Bar chart

b) ) Pie chart

c) Histogram

d) Scatter plot

9 / 45

9) Power BI and Tableau are examples of:

a) Visualization tools

b) Operating systems

c) Programming languages

d) Database systems

10 / 45

10) Which Python library is commonly used for visualization?

a) Matplotlib

b) NumPy

c) Scikit-learn

d) Pandas

11 / 45

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

a) TensorFlow

b) Flask

c) Matplotlib

d) Pandas

12 / 45

12) A heatmap is useful for:

a) Extracting datasets

b) Predicting missing values

c) Showing correlation strength

d) Cleaning data

13 / 45

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

14 / 45

14) Cross-validation is used to:

a) Encrypt data

b) Test the model on different splits of data

c) Train the model faster

d) Increase dataset size

15 / 45

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

a) Data wrangling

b) Modeling

c) Extraction

d) Validation

16 / 45

16) OLAP stands for:

a) Online Advanced Processing

b) Online Application Processing

c) Online Analytical Processing

d) Open Layer Application Protocol

17 / 45

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

a) Tuple

b) Dictionary

c) List

d) DataFrame

18 / 45

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

a) Analytical

b) Strategic

c) Technical

d) Operational

19 / 45

19) Time-series forecasting is an example of:

a) Descriptive analytics

b) Diagnostic analytics

c) None

d) Predictive analytics

20 / 45

20) Outliers are:

a) Duplicates

b) Values within expected range

c) Missing data

d) Extreme values outside the normal range

21 / 45

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

a) Pie chart

b) Line chart

c) Bar chart

d) Box plot

22 / 45

22) Which step comes first in the analytics process?

a) Reporting

b) Data visualization

c) Prediction

d) Data collection

23 / 45

23) The ETL process stands for:

a) Edit, Transform, Link

b) Encode, Transfer, Load

c) Extract, Transform, Load

d) Extract, Transfer, Link

24 / 45

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

a) All of the above

b) R-squared

c) ROC curve

d) Mean Squared Error

25 / 45

25) Histogram is best used to show:

a) Comparison between categories

b) Numerical data distribution

c) Categorical data distribution

d) Time series trends

26 / 45

26) Which distribution is most common in analytics?

a) Normal (Gaussian)

b) Poisson

c) Exponential

d) Uniform

27 / 45

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

a) Bar chart

b) Pie chart

c) Histogram

d) Line chart

28 / 45

28) Which step ensures data reliability and correctness?

a) Visualization

b) Transformation

c) Data validation

d) Storage

29 / 45

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

a) Inner join

b) Full join

c) Left join

d) Right join

30 / 45

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

a) HTML

b) C++

c) Java

d) Python

31 / 45

31) A correlation coefficient close to -1 means:

a) Strong positive relation

b) Strong negative relation

c) Weak relation

d) No relation

32 / 45

32) What is metadata?

a) Data about data

b) Encrypted data

c) Duplicate data

d) Deleted data

33 / 45

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

a) Build websites

b) Extract useful insights

c) Encrypt data

d) Store data

34 / 45

34) Which technique reduces dataset dimensionality?

a) Regression

b) PCA (Principal Component Analysis)

c) Classification

d) Clustering

35 / 45

35) SQL is primarily used for:

a) Web design

b) Data extraction and querying

c) Machine learning

d) Image processing

36 / 45

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

a) JSON data

b) Semi-structured data

c) Unstructured data

d) Tabular data

37 / 45

37) Descrip ve analy cs focuses on:

a) What has already happened

b) Predic ng future events

c) Why something happened

d) Prescribing ac ons

38 / 45

38) Data normalization means:

a) Reducing redundancy

b) Scaling values

c) All of the above

d) Cleaning duplicates

39 / 45

39) Which is a BI tool used for dashboards?

a) MongoDB

b) Power BI

c) Spark

d) Hadoop

40 / 45

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

a) Ignoring them

b) Predicting them using models

c) All of the above

d) Filling with mean/median/mode

41 / 45

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

a) Median

b) Mean

c) None

d) Mode

42 / 45

42) KPI stands for:

a) Knowledge Performance Insights

b) Key Performance Indicator

c) Key Predictive Input

d) Known Predictive Index

43 / 45

43) Which is an open-source BI tool?

a) Looker

b) Power BI

c) Tableau Public

d) QlikView

44 / 45

44) An example of predictive analytics is:

a) Estimating next month’s sales

b) Generating a past report

c) Identifying missing values

d) Cleaning messy data

45 / 45

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

a) Descriptive

b) Prescriptive

c) Diagnostic

d) Predictive

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) Data normalization is used to:

a) All of the above

b) Improve consistency

c) Reduce redundancy

d) Organize databases

2 / 44

2) Outliers in data can:

a) Always be ignored

b) Have no impact

c) Improve accuracy

d) Skew results

3 / 44

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

a) Predicting values

b) Removing rows

c) All of the above

d) Replacing with mean/median

4 / 44

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

a) Matplotlib

b) TensorFlow

c) NumPy

d) Pandas

5 / 44

5) Which analytics approach recommends actions?

a) Prescriptive

b) Predictive

c) Diagnostic

d) Descriptive

6 / 44

6) Which type of chart shows distribution of data?

a) Pie chart

b) Line chart

c) Scatter plot

d) Histogram

7 / 44

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

a) MERGE

b) CONNECT

c) JOIN

d) UNION

8 / 44

8) Which data type represents continuous numbers?

a) String

b) Boolean

c) Integer

d) Float

9 / 44

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

a) Deletion

b) Mean imputation

c) Regression imputation

d) Encoding

10 / 44

10) Which type of analytics predicts future trends?

a) Predictive

b) Descriptive

c) Diagnostic

d) Prescriptive

11 / 44

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

a) Columns

b) Keys

c) Attributes

d) Indexes

12 / 44

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

a) NumPy

b) Matplotlib

c) Pandas

d) SciPy

13 / 44

13) Which chart type is best for categorical comparisons?

a) Scatter plot

b) Bar chart

c) Line chart

d) Histogram

14 / 44

14) Which analytics type answers “What happened?”

a) Predictive

b) Diagnostic

c) Prescriptive

d) Descriptive

15 / 44

15) Which file format is commonly used for datasets?

a) .xlsx

b) .csv

c) All of the above

d) .txt

16 / 44

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

a) Histogram

b) Scatter plot

c) Line chart

d) Pie chart

17 / 44

17) What does KPI stand for in analytics?

a) Knowledge Processing Interface

b) Key Process Integration

c) Key Profit Index

d) Key Performance Indicator

18 / 44

18) What does OLAP stand for?

a) Online Logical Application

b) Open Learning Analytics Process

c) Operational Logic Analysis Platform

d) Online Analytical Processing

19 / 44

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

a) Entries

b) Fields

c) Records

d) Keys

20 / 44

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

a) Faster results

b) None

c) Accurate predictions

d) Biased analysis

21 / 44

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

a) SUM()

b) COUNT()

c) TOTAL()

d) NUMBER()

22 / 44

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

a) Matplotlib

b) Seaborn

c) NumPy

d) Pandas

23 / 44

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

a) Data Visualization

b) Data Cleaning

c) Data Collection

d) Data Transformation

24 / 44

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

a) Range

b) Interquartile range

c) Variance

d) Standard deviation

25 / 44

25) A pivot table in Excel is used for:

a) Summarizing data

b) Data validation

c) Data storage

d) Data cleaning

26 / 44

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

a) Power BI

b) All of the above

c) Tableau

d) Excel

27 / 44

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

a) Pie chart

b) Histogram

c) Bar chart

d) Line chart

28 / 44

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

a) Data collection

b) Data entry

c) Data visualization

d) Data cleaning

29 / 44

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

a) INSERT

b) SELECT

c) UPDATE

d) DELETE

30 / 44

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

a) Tableau

b) Excel

c) Python

d) Power BI

31 / 44

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

a) Line chart

b) Histogram

c) Scatter plot

d) Pie chart

32 / 44

32) Which SQL clause filters data?

a) HAVING

b) WHERE

c) ORDER BY

d) GROUP BY

33 / 44

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

a) Colors of cars

b) Monthly sales

c) Student grades

d) Employee names

34 / 44

34) Which SQL keyword removes duplicates from a result?

a) FILTER

b) UNIQUE

c) CLEAR

d) DISTINCT

35 / 44

35) Which function finds the largest value in Excel?

a) =BIG()

b) =MAX()

c) =GREATEST()

d) =LARGE()

36 / 44

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

a) =SUM()

b) =AVERAGE()

c) =MEAN()

d) =COUNT()

37 / 44

37) Which of these measures central tendency?

a) Median

b) Mode

c) All of the above

d) Mean

38 / 44

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

a) Exploratory Data Analysis

b) Estimated Data Application

c) Enhanced Data Analytics

d) Enterprise Data Architecture

39 / 44

39) Which is an example of qualitative data?

a) Salary

b) Height

c) Eye color

d) Weight

40 / 44

40) Data dashboards are mainly used for:

a) Visual reporting

b) Data collection

c) Database design

d) Data cleaning

41 / 44

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

a) Time-series

b) Categorical

c) Continuous

d) Numerical

42 / 44

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

a) DAX

b) SQL

c) Python

d) R

43 / 44

43) Which of the following is a BI tool?

a) All of the above

b) QlikView

c) Tableau

d) Power BI

44 / 44

44) What does ETL stand for in Data Analytics?

a) Extract, Transform, Load

b) Execute, Test, Learn

c) Encode, Transfer, Load

d) Export, Track, Link

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 type of join returns only the common records between two tables?

a) RIGHT JOIN

b) FULL OUTER JOIN

c) LEFT JOIN

d) INNER JOIN

2 / 46

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

a) known Predictive Indicator

b) Key Process Integration

c) Knowledge Processing Insight

d) Key Performance Indicator

3 / 46

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

a) FILTER

b) GROUP BY

c) ORDER BY

d) SORT

4 / 46

4) Which visualization helps compare two continuous variables?

a) Pie chart

b) Scatter plot

c) Histogram

d) Bar chart

5 / 46

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

a) Pie chart

b) Box plot

c) Scatter plot

d) Line chart

6 / 46

6) Which SQL function is used to count rows?

a) NUMBER()

b) SUM()

c) COUNT()

d) TOTAL()

7 / 46

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

a) Matplotlib

b) Tableau

c) Plotly

d) Seaborn

8 / 46

8) Which plot is best for identifying correlations?

a) Scatter plot

b) Line chart

c) Pie chart

d) Histogram

9 / 46

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

a) Informative

b) Predictive

c) Descriptive

d) Prescriptive

10 / 46

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

a) Power BI

b) Google Data Studio

c) all of the above

d) Tableau

11 / 46

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

a) DataFrame

b) Set

c) Dictionary

d) list

12 / 46

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

a) All of the above

b) Mode

c) Mean

d) Median

13 / 46

13) Which SQL command removes an entire table?

a) REMOVE

b) DELETE

c) DROP

d) CLEAR

14 / 46

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

a) Excel

b) Hadoop

c) PowerPoint

d) GitHub

15 / 46

15) Which chart is suitable for categorical data comparison?

a) Line chart

b) Histogram

c) Bar chart

d) Scatter plot

16 / 46

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

a) Docker

b) TensorFlow

c) Power BI

d) GitHub

17 / 46

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

a) Adding noise to data

b) Data transformation

c) Handling missing values

d) Removing duplicates

18 / 46

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

a) Images and videos

b) CSV files

c) Database table

d) Excel sheets

19 / 46

19) Which step comes immediately after Data Collection?

a) Data Visualization

b) Data Modeling

c) Data Loading

d) Data Cleaning

20 / 46

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

a) QlikView

b) Tableau

c) Power BI

d) Looker

21 / 46

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

a) df.head()

b) df.show()

c) df.tail()

d) df.start()

22 / 46

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

a) df.stats()

b) df.mean()

c) df.describe()

d) df.summary()

23 / 46

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

a) Integer

b) Float

c) String

d) Boolean

24 / 46

24) Which SQL command is used to filter rows?

a) WHERE

b) SELECT

c) oRDER BY

d) gROUP BY

25 / 46

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

a) MySQL

b) MongoDB

c) Snowflake

d) SQLite

26 / 46

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

27 / 46

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

a) Summarizing insights and patterns

b) Predicting future outcomes

c) Cleaning data

d) Building dashboards

28 / 46

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

a) Designed

b) Unstructured

c) Semi-structured

d) Structured

29 / 46

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

a) merge()

b) append()

c) concat()

d) join()

30 / 46

30) Which function in Pandas removes missing values?

a) df.clean()

b) df.remove()

c) df.na()

d) df.dropna()

31 / 46

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

a) Pie chart

b) Line chart

c) Histogram

d) Bar chart

32 / 46

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

a) UNION

b) JOIN

c) ORDER BY

d) GROUP BY

33 / 46

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

a) Load

b) Extract

c) Transform

d) Model

34 / 46

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

a) UNIQUE

b) DISTINCT

c) DELETE

d) REMOVE

35 / 46

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

a) Data Reporting

b) Data Collection

c) Data Cleaning

d) Data Visualization

36 / 46

36) Which type of data visualization best shows correlation?

a) Histogram

b) Bar chart

c) Pie chart

d) Scatter plot

37 / 46

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

a) Float

b) Boolean

c) String

d) Integer

38 / 46

38) Which SQL aggregate function returns the maximum value?

a) MAX()

b) TOP()

c) BIG()

d) HIGH()

39 / 46

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

a) Seaborn

b) NumPy

c) Matplotlib

d) Pandas

40 / 46

40) Which plot is best for identifying outliers?

a) Box plot

b) Pie chart

c) Bar chart

d) Line chart

41 / 46

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

a) f.na()

b) df.isnull()

c) df.dropna()

d) df.empty()

42 / 46

42) Which visualization is best for showing proportions?

a) Histogram

b) Pie chart

c) Scatter plot

d) Line chart

43 / 46

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

a) Seaborn

b) SciPy

c) Pandas

d) NumPy

44 / 46

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

a) data entry

b) Normalization

c) Data loading

d) Data visualization

45 / 46

45) What does ETL stand for?

a) Evaluate, Transform, Load

b) Extract, Transform, Load

c) Explore, Transfer, Learn

d) Extract, Test, Link

46 / 46

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

a) Pie chart

b) Box plot

c) Line chart

d) Histogram

Your score is

The average score is 0%

Exit

What is a Data Analyst Intern?

Leave a Reply Cancel reply