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 drops a column?

a) df.delete('col')

b) df.remove('col')

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

d) df.pop('col')

2 / 45

Which method drops duplicate rows?

a) df.clean()

b) df.unique()

c) df.drop_duplicates()

d) df.remove_duplicates()

3 / 45

To handle missing values you can use:

a) df.fillna()

b) df.replace()

c) df.dropna()

d) Both a & b

4 / 45

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

a) Column average

b) Total rows

c) Column sum

d) Count of unique values

5 / 45

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

a) 1var

b) var-1

c) _data

d) @value

6 / 45

How to shuffle rows of a DataFrame?

a) df.mix()

b) df.shuffle()

c) df.sample(frac=1)

d) df.random()

7 / 45

Which reads a CSV file into a DataFrame?

a) pd.open()

b) pd.read_csv()

c) pd.file()

d) pd.readcsv()

8 / 45

Which method shows the first 5 rows of a DataFrame?

a) df.head()

b) df.tail()

c) df.first()

d) df.info()

9 / 45

Which NumPy attribute gives the shape of an array?

a) ndim

b) size

c) shape

d) type

10 / 45

10)

Which function gets unique values from a column?

a) df.values()

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

c) df.unique()

d) df.distinct()

11 / 45

11)

NumPy arrays are preferred over Python lists because

a) They are slower

b) They are memory efficient

c) They only store strings

d) They don’t support operations

12 / 45

12)

Indentation in Python is used for:

a) Code decoration

b) Defining code blocks

c) Separating functions

d) Documentation

13 / 45

13)

Which function gives column summary stats?

a) summary()

b) describe()

c) stat()

d) info()

14 / 45

14)

Which function converts a value to integer?

a) str()

b) float()

c) bool()

d) int()

15 / 45

15)

How to reset the index of a DataFrame?

a) df.reindex()

b) df.reset_index()

c) df.set_index(None)

d) df.reset()

16 / 45

16)

Which method renames columns?

a) df.rename_cols()

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

c) df.set_names()

d) df.change_cols()

17 / 45

17)

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

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

b) Error

c) [1,2,3,2]

d) [2,4,6]

18 / 45

18)

Which of the following is immutable in Python?

a) Dictionary

b) List

c) Tuple

d) Set

19 / 45

19)

loc[] is used for:

a) Label-based selection

b) Dropping rows

c) Index-based selection

d) Random sampling

20 / 45

20)

Which axis applies a row-wise operation in Pandas?

a) axis=2

b) axis=row

c) axis=0

d) axis=1

21 / 45

21)

Which method fills missing values?

a) df.fillna()

b) df.dropna()

c) na_replace()

d) null()

22 / 45

22)

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

a) [4]

b) Error

c) [1,2,3,4]

d) [1,2,3]

23 / 45

23)

Which Pandas function shows data types of columns?

a) df.type

b) df.types

c) df.dtypes

d) df.dtype

24 / 45

24)

Which of these is used to combine DataFrames?

a) df.concat()

b) df.join()

c) All of the above

d) df.merge()

25 / 45

25)

Which function calculates quantiles?

a) df.quant()

b) df.q()

c) df.percentile()

d) df.quantile()

26 / 45

26)

Which function groups data by column?

a) df.groupby()

b) df.split()

c) df.group()

d) df.aggregate()

27 / 45

27)

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

a) The smallest value

b) The count

c) The sum

d) The most frequent value

28 / 45

28)

Which method merges DataFrames?

a) pd.combine()

b) pd.concat()

c) pd.merge()

d) pd.append()

29 / 45

29)

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

30 / 45

30)

Which function computes standard deviation in NumPy

a) np.mean()

b) np.var()

c) np.dev()

d) np.std()

31 / 45

31)

Which operation is vectorized broadcasting?

a) Looping

b) Iteration

c) Vectorization

d) Broadcasting

32 / 45

32)

Which creates an array of zeros in NumPy?

a) np.ones()

b) np.zeros()

c) np.empty()

d) np.array()

33 / 45

33)

What does df.shape return?

a) Number of rows

b) (rows, columns)

c) Number of columns

d) Column names

34 / 45

34)

Which built-in function returns length of a list?

a) count()

b) size()

c) len()

d) length()

35 / 45

35)

Which method applies a function to each row?

a) df.applymap()

b) df.transform()

c) df.map()

d) df.apply()

36 / 45

36)

Which method selects rows by integer position?

a) df.iloc[]

b) df.at[]

c) df.get[]

d) df.loc[]

37 / 45

37)

Which function converts a column to datetime?

a) pd.to_date()

b) df.to_dt()

c) df.convert_date()

d) pd.to_datetime()

38 / 45

38)

Which function sorts DataFrame by column values?

a) sort()

b) order()

c) ort_index()

d) sort_values()

39 / 45

39)

Which gives DataFrame summary info?

a) df.info()

b) All of the above

c) df.describe()

d) df.shape

40 / 45

40)

Which operator is used for exponentiation in Python?

a) //

b) **

c) %

d) ^

41 / 45

41)

Which method creates a pivot table?

a) pd.pivot()

b) pd.pivot_table()

c) df.table()

d) df.pivot()

42 / 45

42)

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

43 / 45

43)

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

a) df.dropna()

b) df.sum()

c) df.isnull()

d) df.count()

44 / 45

44)

Which keyword is used to define a function in Python?

a) fun

b) define

c) def

d) function

45 / 45

45)

Which function computes mean in NumPy?

a) np.avg()

b) np.mean()

c) np.sum()

d) np.median()

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) A foreign key is used to:

a) Store passwords

b) Link two tables together

c) Visualize dashboards

d) Define a unique record

2 / 45

2) Which function in Power BI creates aggregate measures?

a) COUNT()

b) AVERAGE()

c) All of the above

d) SUM()

3 / 45

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

a) Excel

b) SQL databases

c) All of the above

d) Cloud services

4 / 45

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

a) All of the above

b) Power BI

c) Google Data Studio

d) Tableau

5 / 45

5) Predictive analytics is used to:

a) Clean datasets

b) Forecast future outcomes

c) Create pie charts

d) Describe the past

6 / 45

6) A bar chart is best suited for:

a) Showing correlations

b) Comparing categories

c) Showing trends over time

d) Displaying proportions

7 / 45

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

a) Date/Time

b) Decimal Number

c) Music File

d) Whole Number

8 / 45

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

a) NumPy

b) SQL

c) Python

d) DAX

9 / 45

9) In analytics, KPI stands for:

a) Kernel Process Integration

b) Key Power Index

c) Key Performance Indicator

d) Knowledge Processing Input

10 / 45

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

a) Data Visualization

b) Model Deployment

c) Data Cleaning

d) Data Collection

11 / 45

11) What does ETL stand for?

a) Execute, Transfer, Log

b) Extract, Transform, Load

c) Encrypt, Translate, Locate

d) Enter, Test, Learn

12 / 45

12) Power BI dashboards can be shared through:

a) All of the above

b) Cloud storage

c) Emails

d) Power BI Service

13 / 45

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

a) Bar chart

b) Scatter plot

c) Line chart

d) Pie chart

14 / 45

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

a) Data Collection

b) Data Cleaning

c) Space Exploration

d) Data Visualization

15 / 45

15) DAX in Power BI stands for:

a) Database Access XML

b) Data Array Exchange

c) Data Analysis Expressions

d) Data Automated Execution

16 / 45

16) A slicer in Power BI is used for:

a) Joining tables

b) Formatting reports

c) Creating charts

d) Filtering data interactively

17 / 45

17) Which visualization is best for frequency distribution?

a) Area chart

b) Line graph

c) Histogram

d) Pie chart

18 / 45

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

a) DELETE

b) JOIN

c) UPDATE

d) SELECT

19 / 45

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

a) Cross Join

b) Left Join

c) Inner Join

d) Outer Join

20 / 45

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

a) Automating workflows

b) Optimizing supply chain

c) Predicting sales

d) Explaining past sales trends

21 / 45

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

a) Data Cleaning

b) Data Mining

c) Data Reporting

d) Data Loading

22 / 45

22) The ultimate goal of Data Analytics is to:

a) Build hardware devices

b) Collect large amounts of raw data

c) Generate insights for better decisions

d) Write computer programs

23 / 45

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

a) Power BI

b) Photoshop

c) Notepad

d) MS Word

24 / 45

24) Which visualization shows parts of a whole?

a) Histogram

b) Pie chart

c) Line chart

d) Scatter plot

25 / 45

25) What is the role of a Data Analyst?

a) Write networking protocols

b) Extract insights from data

c) Build computer hardware

d) Develop operating systems

26 / 45

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

a) JOIN

b) SELECT

c) WHERE

d) FROM

27 / 45

27) What is the main benefit of using dashboards?

a) Interactive and real-time insights

b) Replacing databases

c) Storing raw files

d) Writing long reports

28 / 45

28) Which database language is widely used in analytics?

a) HTML

b) Java

c) C++

d) SQL

29 / 45

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

a) Power Query

b) Power BI Desktop

c) Power BI Mobile

d) Power BI Service

30 / 45

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

a) Histogram

b) Scatter plot

c) Line chart

d) Pie chart

31 / 45

31) Which cloud platform is popular for analytics?

a) Azure

b) All of the above

c) Google Cloud

d) AWS

32 / 45

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

a) Python

b) Both a and b

c) Photoshop

d) R

33 / 45

33) Data Analytics mainly focuses on:

a) Analyzing past data for insights

b) Computer hardware maintenance

c) Collecting data only

d) Creating new programming languages

34 / 45

34) . What does a Data Warehouse store?

a) Emails only

b) Live gaming data

c) Historical and structured data

d) Music files

35 / 45

35) Which chart is suitable for showing cumulative values?

a) Scatter plot

b) Pie chart

c) Area chart

d) Line chart

36 / 45

36) What is the purpose of data transformation?

a) Store data in raw form

b) Convert data into usable format

c) Erase unnecessary data permanently

d) Visualize the data

37 / 45

37) What is data visualization mainly used for?

a) Make insights easier to understand

b) Encrypt data

c) Increase data errors

d) Hide data

38 / 45

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

39 / 45

39) Prescriptive analytics helps to:

a) Identify what happened

b) Visualize data

c) Delete unwanted data

d) Suggest actions to optimize results

40 / 45

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

a) Storing raw data

b) Importing charts

c) Creating dashboards

d) Data cleaning and formatting

41 / 45

41) What is Big Data mainly characterized by?

a) Volume, Velocity, Variety

b) Value, Vision, Validation

c) Size only

d) SQL queries

42 / 45

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

a) Store raw data

b) Present key insights visually

c) Collect social media data

d) Train machine learning models

43 / 45

43) In Power BI, relationships are built between:

a) Reports

b) Charts

c) DAX formulas

d) Tables

44 / 45

44) Cleaning data involves:

a) Correcting errors

b) Handling missing values

c) Removing duplicates

d) All of the above

45 / 45

45) Data storytelling in analytics refers to:

a) Presenting data with narratives and visuals

b) Writing novels

c) Using data to entertain

d) Coding in SQL

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 SQL function finds the average value?

a) AVG()

b) MAX()

c) SUM()

d) COUNT()

2 / 45

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

a) Power BI

b) Photoshop

c) C++

d) PowerPoint

3 / 45

3) Which SQL command removes duplicate values from results?

a) UNIQUE

b) GROUP

c) DISTINCT

d) CLEAN

4 / 45

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

a) Encode, Transfer, Load data

b) Execute, Train, Learn models

c) Extract, Transform, Load data

d) Encrypt, Test, Log data

5 / 45

5) Which chart is most suitable to compare proportions?

a) Histogram

b) Line chart

c) Scatter plot

d) Pie chart

6 / 45

6) In Power BI, measures are:

a) Visual types

b) Raw datasets

c) SQL queries

d) Pre-calculated fields

7 / 45

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

a) Boolean

b) String

c) Integer

d) Date/Time

8 / 45

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

a) Scatter plot

b) Pie chart

c) Bar chart

d) Line chart

9 / 45

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

a) Filters

b) Random Columns

c) Formulas

d) Primary and Foreign Keys

10 / 45

10) Which SQL keyword combines rows from two queries?

a) UNION

b) MERGE

c) JOIN

d) SELECT

11 / 45

11) What is the role of prescriptive analytics?

a) To describe past data

b) To suggest actions

c) To explain causes

d) To predict future outcomes

12 / 45

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

a) Non-visual output

b) Interactive and real-time insights

c) Manual data entry

d) Static reports

13 / 45

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

a) Cleaning and structuring raw data

b) Encrypting sensitive data

c) Deploying models

d) Collecting new datasets

14 / 45

14) In Power BI, AI visuals can:

a) Run SQL queries

b) Identify key influencers and trends

c) Replace datasets

d) Clean data automatically

15 / 45

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

a) Relationships between tables

b) Random charts

c) Only raw numbers

d) A Python script

16 / 45

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

a) GROUP BY

b) ORDER BY

c) SORT

d) ARRANGE

17 / 45

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

a) JOIN

b) UNION

c) DISTINCT

d) GROUP BY

18 / 45

18) Which SQL clause is used to filter results?

a) HAVING

b) GROUP BY

c) ORDER BY

d) WHERE

19 / 45

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

a) Predictive Analytics

b) Prescriptive Analytics

c) Diagnostic Analytics

d) Creative Analytics

20 / 45

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

a) Fields Pane

b) Visualization Pane

c) Report Pane

d) Data Pane

21 / 45

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

a) Create random charts

b) Show historical events

c) Measure business performance

d) Predict future trends

22 / 45

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

a) Data Cleaning

b) Data Visualization

c) Data Wrangling

d) Data Mining

23 / 45

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

a) Data Querying and Calculation

b) Visualization Formatting

c) Data Importing

d) Data Storage

24 / 45

24) Which chart is best for showing data distribution?

a) Line chart

b) Histogram

c) Pie chart

d) Bar chart

25 / 45

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

a) Pie chart

b) Scatter plot

c) Waterfall chart

d) Histogram

26 / 45

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

a) SUM()

b) AVG()

c) COUNT()

d) TOTAL()

27 / 45

27) Which visualization is best for analyzing correlation?

a) Pie chart

b) Scatter plot

c) Histogram

d) Line chart

28 / 45

28) Which chart is best for comparing categories?

a) Line chart

b) Bar chart

c) Pie chart

d) Histogram

29 / 45

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

a) Handling missing values

b) Data normalization

c) Adding random errors

d) Removing duplicates

30 / 45

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

a) FILTER

b) ORDER BY

c) WHERE

d) HAVING

31 / 45

31) Which chart is used for cumulative analysis?

a) Histogram

b) Line chart

c) Area chart

d) Pie chart

32 / 45

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

a) Notepad

b) C language

c) Word

d) Tableau

33 / 45

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

a) SPLIT

b) VLOOKUP

c) CONCATENATE

d) MATCH

34 / 45

34) What does “Data Transformation” mean?

a) Changing data format and structure

b) Copying data

c) Encrypting data

d) Deleting entire dataset

35 / 45

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

a) Prescriptive

b) Descriptive

c) Predictive

d) Diagnostic

36 / 45

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

a) Clean datasets

b) Add new columns using formulas

c) Import data

d) Delete rows

37 / 45

37) In Power BI, a dashboard is?

a) A single chart

b) A dataset

c) A collection of visualizations

d) A SQL script

38 / 45

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

a) DAX Functions

b) Auto Filter

c) Data Refresh

d) Data Cleaning

39 / 45

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

a) SUM()

b) TOTAL()

c) AVG()

d) COUNT()

40 / 45

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

a) INDEX

b) VLOOKUP

c) MATCH

d) CONCATENATE

41 / 45

41) The primary goal of Data Analytics is:

a) To design websites

b) To build operating systems

c) To create AI models

d) To find patterns and insights from data

42 / 45

42) What is the purpose of data normalization?

a) Changing data types

b) Reducing data redundancy

c) Adding duplicates

d) Removing all rows

43 / 45

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

a) VARCHAR

b) INT

c) CHAR

d) DATE

44 / 45

44) In Power BI, slicers are used for:

a) Data loading

b) Data storage

c) Data cleaning

d) Data filtering

45 / 45

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

a) UNION

b) JOIN

c) DISTINCT

d) GROUP BY

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) The process of converting categorical variables into numeric is:

a) Feature engineering

b) Aggregation

c) Normalization

d) Encoding

2 / 46

2) SQL keyword used to sort results:

a) GROUP BY

b) WHERE

c) ORDER BY

d) SORT

3 / 46

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

a) Line chart

b) Histogram

c) Pie chart

d) Scatter plot

4 / 46

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

a) Scalability

b) Variety

c) Improved insights

d) Complexity in management

5 / 46

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

a) Classification

b) Regression

c) Dimensionality Reduction

d) Clustering

6 / 46

6) Which is an example of unstructured data?

a) JSON logs

b) Images and videos

c) Excel sheets

d) SQL tables

7 / 46

7) Time-series analysis is mostly applied in:

a) Clustering

b) Stock market prediction

c) Image recognition

d) Customer segmentation

8 / 46

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

a) Ruby

b) Java

c) Python

d) C++

9 / 46

9) Data warehouse mainly stores:

a) Streaming logs

b) Real-time sensor data

c) Historical data

d) Transactional data

10 / 46

10) The accuracy of a classification model is:

a) (TP + TN) / Total samples

b) FN / Total samples

c) TP / Total samples

d) FP + FN) / Total samples

11 / 46

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

a) UNION

b) INTERSECT

c) SELECT

d) JOIN

12 / 46

12) Which SQL function is used to count rows?

a) TOTAL()

b) COUNT()

c) AVG()

d) SUM()

13 / 46

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

a) Docker

b) AWS S3

c) Apache Spark

d) K-Means

14 / 46

14) Outlier detection can be performed using:

a) Z-score

b) IQR

c) Boxplot

d) All of the above

15 / 46

15) Which of these is NOT a NoSQL database?

a) CouchDB

b) MySQL

c) Cassandra

d) MongoDB

16 / 46

16) Which metric is used to evaluate regression models?

a) Precision

b) Accuracy

c) Recall

d) RMSE

17 / 46

17) Feature scaling is important because:

a) It removes missing values

b) It reduces memory size

c) It increases dataset size

d) Algorithms perform better when features are on similar scales

18 / 46

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

a) Temperature

b) Weight

c) Gender

d) Height

19 / 46

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

a) TensorFlow

b) NumPy

c) Matplotlib

d) Pandas

20 / 46

20) Which language is widely used for statistical analysis?

a) Python

b) R

c) C

d) Java

21 / 46

21) Which Python library is used for visualization?

a) Pandas

b) Scikit-learn

c) Matplotlib

d) Numpy

22 / 46

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

a) JSON

b) HTML

c) XML

d) CSV

23 / 46

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

a) Distributed storage of big data

b) Relational queries

c) Data mining only

d) Visualization

24 / 46

24) A confusion matrix is used in:

a) Regression

b) Classification

c) Data Cleaning

d) Clustering

25 / 46

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

a) Generative

b) Predictive

c) Descriptive

d) Diagnostic

26 / 46

26) The process of identifying duplicate data is called:

a) Data Aggregation

b) Data Deduplication

c) Data Normalization

d) Data Mining

27 / 46

27) A data lake primarily stores:

a) Summarized data

b) Raw structured and unstructured data

c) Structured data only

d) Only transactional data

28 / 46

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

a) Histogram

b) Bar chart

c) Box plot

d) Line chart

29 / 46

29) In classification, Precision is defined as:

a) FP / (TP + FP)

b) TP / (TP + FP)

c) (TP + TN) / Total

d) TP / (TP + FN)

30 / 46

30) Which of these databases is column-oriented?

a) Cassandra

b) PostgreSQL

c) MySQL

d) MongoDB

31 / 46

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

a) GPU memory

b) RAM

c) SSD

d) tape storage

32 / 46

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

a) K-Means

b) Linear Regression

c) DBSCAN

d) Apriori

33 / 46

33) Recall is also called:

a) Accuracy

b) Specificity

c) Sensitivity

d) Precision

34 / 46

34) What does ETL stand for in data processing?

a) Extract, Transform, Load

b) Enter, Transfer, Leave

c) Extract, Test, Learn

d) Encode, Test, Load

35 / 46

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

a) Replacing with mean/median

b) Deleting rows

c) Predicting with models

d) All of the above

36 / 46

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

a) ariable, Volume, Vector

b) Visualization, Validation, Variance

c) Value, Version, Virtualization

d) Variety, Volume, Velocity

37 / 46

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

a) TensorFlow

b) Scikit-learn

c) Pandas

d) Hadoop

38 / 46

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

a) Median

b) Mode

c) Range

d) Mean

39 / 46

39) A heatmap is useful for:

a) Outlier detection

b) Visualizing proportions

c) Showing distribution of one variable

d) Showing correlations between variables

40 / 46

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

a) CSS

b) Python

c) C#

d) HTML

41 / 46

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

a) Statistics

b) Plumbing

c) Data Visualization

d) Machine Learning

42 / 46

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

a) MS Word

b) Eclipse

c) Photoshop

d) Tableau

43 / 46

43) Which visualization is best for correlation analysis?

a) Pie chart

b) Histogram

c) Scatter plot

d) Line graph

44 / 46

44) Which SQL clause is used to filter results?

a) SELECT

b) ORDER BY

c) GROUP BY

d) WHERE

45 / 46

45) Which of these best describes Data Mining?

a) Extracting patterns and knowledge from large datasets

b) Storing data only

c) Cleaning missing values

d) Visualization only

46 / 46

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

a) Histogram

b) Pie chart

c) Line plot

d) Scatter plot

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) The ETL process stands for:

a) Edit, Transform, Link

b) Encode, Transfer, Load

c) Extract, Transform, Load

d) Extract, Transfer, Link

2 / 45

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

a) Python

b) Java

c) C++

d) HTML

3 / 45

3) Time-series forecasting is an example of:

a) Descriptive analytics

b) Diagnostic analytics

c) Predictive analytics

d) None

4 / 45

4) A heatmap is useful for:

a) Predicting missing values

b) Showing correlation strength

c) Extracting datasets

d) Cleaning data

5 / 45

5) Power BI and Tableau are examples of:

a) Database systems

b) Operating systems

c) Visualization tools

d) Programming languages

6 / 45

6) Which is an open-source BI tool?

a) Tableau Public

b) Looker

c) QlikView

d) Power BI

7 / 45

7) SQL is primarily used for:

a) Web design

b) Image processing

c) Machine learning

d) Data extraction and querying

8 / 45

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

a) Bar chart

b) Histogram

c) Pie chart

d) Line chart

9 / 45

9) Data normalization means:

a) Reducing redundancy

b) Scaling values

c) Cleaning duplicates

d) All of the above

10 / 45

10) Which visualization is best for categorical comparison?

a) Histogram

b) ) Pie chart

c) Scatter plot

d) Bar chart

11 / 45

11) Which Python library is commonly used for visualization?

a) NumPy

b) Pandas

c) Scikit-learn

d) Matplotlib

12 / 45

12) KPI stands for:

a) Knowledge Performance Insights

b) Known Predictive Index

c) Key Performance Indicator

d) Key Predictive Input

13 / 45

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

a) Decision Trees

b) Logistic Regression

c) K-Means

d) Linear Regression

14 / 45

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

15 / 45

15) Which technique reduces dataset dimensionality?

a) Classification

b) PCA (Principal Component Analysis)

c) Clustering

d) Regression

16 / 45

16) Which step ensures data reliability and correctness?

a) Visualization

b) Data validation

c) Transformation

d) Storage

17 / 45

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

a) All of the above

b) Python

c) R

d) Scala

18 / 45

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

a) Ignoring them

b) Predicting them using models

c) Filling with mean/median/mode

d) All of the above

19 / 45

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

a) Analytical

b) Strategic

c) Technical

d) Operational

20 / 45

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

a) .csv

b) csv

c) .exe

d) .mp3

21 / 45

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

a) Extract useful insights

b) Encrypt data

c) Build websites

d) Store data

22 / 45

22) Data transformation means:

a) Deleting old data

b) Archiving data

c) Converting data from one format to another

d) Encrypting sensitive data

23 / 45

23) Which is an example of diagnostic analytics?

a) Summarizing past year’s sales

b) Recommending marketing strategies

c) Predicting sales for next year

d) Finding why sales dropped last quarter

24 / 45

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

a) None

b) Mean

c) Mode

d) Median

25 / 45

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

a) Unstructured data

b) Semi-structured data

c) Tabular data

d) JSON data

26 / 45

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

27 / 45

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

a) TensorFlow

b) Matplotlib

c) Flask

d) Pandas

28 / 45

28) Which step comes first in the analytics process?

a) Prediction

b) Data visualization

c) Reporting

d) Data collection

29 / 45

29) Descrip ve analy cs focuses on:

a) Predic ng future events

b) Prescribing ac ons

c) Why something happened

d) What has already happened

30 / 45

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

a) Prescriptive

b) Diagnostic

c) Descriptive

d) Predictive

31 / 45

31) Outliers are:

a) Missing data

b) Duplicates

c) Extreme values outside the normal range

d) Values within expected range

32 / 45

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

a) Tuple

b) Dictionary

c) List

d) DataFrame

33 / 45

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

a) Inner join

b) Left join

c) Full join

d) Right join

34 / 45

34) Cross-validation is used to:

a) Test the model on different splits of data

b) Train the model faster

c) Increase dataset size

d) Encrypt data

35 / 45

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

a) Data wrangling

b) Extraction

c) Modeling

d) Validation

36 / 45

36) Histogram is best used to show:

a) Categorical data distribution

b) Comparison between categories

c) Time series trends

d) Numerical data distribution

37 / 45

37) OLAP stands for:

a) Online Advanced Processing

b) Online Analytical Processing

c) Online Application Processing

d) Open Layer Application Protocol

38 / 45

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

a) Line chart

b) Pie chart

c) Box plot

d) Bar chart

39 / 45

39) Which graph shows the distribution of data spread?

a) Pie chart

b) Line chart

c) Box plot

d) Heatmap

40 / 45

40) A correlation coefficient close to -1 means:

a) Strong positive relation

b) Strong negative relation

c) Weak relation

d) No relation

41 / 45

41) . Which cloud platforms provide ML and DS tools

a) Google Cloud

b) All of the above

c) AWS

d) Azure

42 / 45

42) Which distribution is most common in analytics?

a) Poisson

b) Normal (Gaussian)

c) Uniform

d) Exponential

43 / 45

43) What is metadata?

a) Encrypted data

b) Data about data

c) Duplicate data

d) Deleted data

44 / 45

44) Which is a BI tool used for dashboards?

a) Spark

b) Power BI

c) Hadoop

d) MongoDB

45 / 45

45) An example of predictive analytics is:

a) Cleaning messy data

b) Estimating next month’s sales

c) Generating a past report

d) Identifying missing values

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 Python library is mainly used for handling tabular data?

a) NumPy

b) Seaborn

c) Pandas

d) Matplotlib

2 / 44

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

a) Student grades

b) Colors of cars

c) Monthly sales

d) Employee names

3 / 44

3) Data normalization is used to:

a) All of the above

b) Improve consistency

c) Organize databases

d) Reduce redundancy

4 / 44

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

a) Line chart

b) Bar chart

c) Histogram

d) Pie chart

5 / 44

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

a) NumPy

b) SciPy

c) Pandas

d) Matplotlib

6 / 44

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

a) Continuous

b) Numerical

c) Time-series

d) Categorical

7 / 44

7) Which of the following is a BI tool?

a) Power BI

b) QlikView

c) All of the above

d) Tableau

8 / 44

8) Which analytics approach recommends actions?

a) Diagnostic

b) Prescriptive

c) Predictive

d) Descriptive

9 / 44

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

a) Pandas

b) NumPy

c) Matplotlib

d) TensorFlow

10 / 44

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

a) Data visualization

b) Data entry

c) Data cleaning

d) Data collection

11 / 44

11) What does OLAP stand for?

a) Operational Logic Analysis Platform

b) Open Learning Analytics Process

c) Online Logical Application

d) Online Analytical Processing

12 / 44

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

a) Replacing with mean/median

b) Predicting values

c) All of the above

d) Removing rows

13 / 44

13) Which data type represents continuous numbers?

a) String

b) Boolean

c) Float

d) Integer

14 / 44

14) Outliers in data can:

a) Skew results

b) Always be ignored

c) Improve accuracy

d) Have no impact

15 / 44

15) Which file format is commonly used for datasets?

a) .csv

b) All of the above

c) .xlsx

d) .txt

16 / 44

16) Data dashboards are mainly used for:

a) Data cleaning

b) Database design

c) Visual reporting

d) Data collection

17 / 44

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

a) Data Collection

b) Data Visualization

c) Data Transformation

d) Data Cleaning

18 / 44

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

a) TOTAL()

b) COUNT()

c) SUM()

d) NUMBER()

19 / 44

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

a) Histogram

b) Pie chart

c) Scatter plot

d) Line chart

20 / 44

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

a) Excel

b) Python

c) Tableau

d) Power BI

21 / 44

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

a) Interquartile range

b) Range

c) Variance

d) Standard deviation

22 / 44

22) Which is an example of qualitative data?

a) Height

b) Weight

c) Salary

d) Eye color

23 / 44

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

a) Scatter plot

b) Line chart

c) Histogram

d) Pie chart

24 / 44

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

a) Encoding

b) Deletion

c) Regression imputation

d) Mean imputation

25 / 44

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

a) Biased analysis

b) None

c) Faster results

d) Accurate predictions

26 / 44

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

a) Entries

b) Keys

c) Fields

d) Records

27 / 44

27) Which SQL clause filters data?

a) WHERE

b) ORDER BY

c) GROUP BY

d) HAVING

28 / 44

28) A pivot table in Excel is used for:

a) Data validation

b) Summarizing data

c) Data cleaning

d) Data storage

29 / 44

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

a) =AVERAGE()

b) =COUNT()

c) =MEAN()

d) =SUM()

30 / 44

30) Which SQL keyword removes duplicates from a result?

a) FILTER

b) DISTINCT

c) CLEAR

d) UNIQUE

31 / 44

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

a) Python

b) DAX

c) SQL

d) R

32 / 44

32) Which type of chart shows distribution of data?

a) Pie chart

b) Histogram

c) Scatter plot

d) Line chart

33 / 44

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

a) Enterprise Data Architecture

b) Exploratory Data Analysis

c) Estimated Data Application

d) Enhanced Data Analytics

34 / 44

34) Which of these measures central tendency?

a) Median

b) Mode

c) All of the above

d) Mean

35 / 44

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

a) Attributes

b) Indexes

c) Keys

d) Columns

36 / 44

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

a) MERGE

b) JOIN

c) UNION

d) CONNECT

37 / 44

37) Which chart type is best for categorical comparisons?

a) Bar chart

b) Line chart

c) Scatter plot

d) Histogram

38 / 44

38) Which type of analytics predicts future trends?

a) Descriptive

b) Prescriptive

c) Diagnostic

d) Predictive

39 / 44

39) Which analytics type answers “What happened?”

a) Prescriptive

b) Predictive

c) Descriptive

d) Diagnostic

40 / 44

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

a) DELETE

b) INSERT

c) SELECT

d) UPDATE

41 / 44

41) What does KPI stand for in analytics?

a) Key Profit Index

b) Key Performance Indicator

c) Knowledge Processing Interface

d) Key Process Integration

42 / 44

42) Which function finds the largest value in Excel?

a) =MAX()

b) =BIG()

c) =GREATEST()

d) =LARGE()

43 / 44

43) What does ETL stand for in Data Analytics?

a) Export, Track, Link

b) Execute, Test, Learn

c) Extract, Transform, Load

d) Encode, Transfer, Load

44 / 44

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

a) All of the above

b) Tableau

c) Power BI

d) Excel

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 SQL command removes an entire table?

a) CLEAR

b) REMOVE

c) DROP

d) DELETE

2 / 46

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

a) Structured

b) Unstructured

c) Designed

d) Semi-structured

3 / 46

3) Which visualization is best for showing proportions?

a) Line chart

b) Scatter plot

c) Pie chart

d) Histogram

4 / 46

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

a) GitHub

b) Excel

c) Hadoop

d) PowerPoint

5 / 46

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

a) Building dashboards

b) Predicting future outcomes

c) Cleaning data

d) Summarizing insights and patterns

6 / 46

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

a) GROUP BY

b) JOIN

c) ORDER BY

d) UNION

7 / 46

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

a) Power BI

b) Google Data Studio

c) all of the above

d) Tableau

8 / 46

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

a) Boolean

b) Float

c) String

d) Integer

9 / 46

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

a) Pie chart

b) Scatter plot

c) Line chart

d) Box plot

10 / 46

10) Which plot is best for identifying outliers?

a) Line chart

b) Bar chart

c) Pie chart

d) Box plot

11 / 46

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

a) DELETE

b) UNIQUE

c) DISTINCT

d) REMOVE

12 / 46

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

a) df.mean()

b) df.describe()

c) df.stats()

d) df.summary()

13 / 46

13) Which SQL function is used to count rows?

a) TOTAL()

b) COUNT()

c) SUM()

d) NUMBER()

14 / 46

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

a) Matplotlib

b) Seaborn

c) Plotly

d) Tableau

15 / 46

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

a) All of the above

b) Mode

c) Median

d) Mean

16 / 46

16) Which chart is suitable for categorical data comparison?

a) Line chart

b) Histogram

c) Scatter plot

d) Bar chart

17 / 46

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

a) Matplotlib

b) Pandas

c) NumPy

d) Seaborn

18 / 46

18) Which SQL aggregate function returns the maximum value?

a) TOP()

b) MAX()

c) BIG()

d) HIGH()

19 / 46

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

a) Product categories

b) Sales data by date

c) Employee salaries

d) Student names in a class

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 BI tool is most closely integrated with Microsoft products?

a) Power BI

b) Looker

c) Tableau

d) QlikView

22 / 46

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

a) data entry

b) Normalization

c) Data visualization

d) Data loading

23 / 46

23) Which visualization helps compare two continuous variables?

a) Bar chart

b) Pie chart

c) Scatter plot

d) Histogram

24 / 46

24) What does ETL stand for?

a) Extract, Transform, Load

b) Extract, Test, Link

c) Explore, Transfer, Learn

d) Evaluate, Transform, Load

25 / 46

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

a) Power BI

b) Docker

c) GitHub

d) TensorFlow

26 / 46

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

a) Histogram

b) Bar chart

c) Line chart

d) Pie chart

27 / 46

27) Which function in Pandas removes missing values?

a) df.remove()

b) df.clean()

c) df.na()

d) df.dropna()

28 / 46

28) Which step comes immediately after Data Collection?

a) Data Modeling

b) Data Loading

c) Data Cleaning

d) Data Visualization

29 / 46

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

a) Descriptive

b) Informative

c) Prescriptive

d) Predictive

30 / 46

30) Which plot is best for identifying correlations?

a) Pie chart

b) Line chart

c) Histogram

d) Scatter plot

31 / 46

31) Which SQL command is used to filter rows?

a) SELECT

b) gROUP BY

c) WHERE

d) oRDER BY

32 / 46

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

a) Extract

b) Model

c) Transform

d) Load

33 / 46

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

a) Data Visualization

b) Data Reporting

c) Data Collection

d) Data Cleaning

34 / 46

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

a) df.dropna()

b) df.isnull()

c) f.na()

d) df.empty()

35 / 46

35) Which type of data visualization best shows correlation?

a) Histogram

b) Pie chart

c) Bar chart

d) Scatter plot

36 / 46

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

a) Set

b) DataFrame

c) Dictionary

d) list

37 / 46

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

a) INNER JOIN

b) LEFT JOIN

c) FULL OUTER JOIN

d) RIGHT JOIN

38 / 46

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

a) Float

b) Boolean

c) Integer

d) String

39 / 46

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

a) merge()

b) concat()

c) append()

d) join()

40 / 46

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

a) Removing duplicates

b) Data transformation

c) Handling missing values

d) Adding noise to data

41 / 46

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

a) FILTER

b) ORDER BY

c) GROUP BY

d) SORT

42 / 46

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

a) Line chart

b) Box plot

c) Histogram

d) Pie chart

43 / 46

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

a) MySQL

b) Snowflake

c) MongoDB

d) SQLite

44 / 46

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

a) Database table

b) Excel sheets

c) Images and videos

d) CSV files

45 / 46

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

a) SciPy

b) Seaborn

c) Pandas

d) NumPy

46 / 46

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

a) Key Performance Indicator

b) known Predictive Indicator

c) Key Process Integration

d) Knowledge Processing Insight

Your score is

The average score is 0%

Exit

What is a Data Analyst Intern?

Leave a Reply Cancel reply