Preview Questions Data Analyst | Role Specific Skill

Question 1: What is the best approach for detecting outliers in a financial dataset where extreme values could distort analysis but must be handled with care?

Which action should you take?

Choose only one option

Apply the Z-score method to identify outliers based on standard deviations

Use boxplots and calculate the IQR (Interquartile Range) to identify potential outliers

Automatically replace outliers with the median or mean

Remove rows with extreme values without further analysis

Question 2: What is the most appropriate way to handle text-based data when performing natural language processing (NLP) in a financial report?

Which action should you take?

Choose only one option

Remove punctuation and spaces from the text

Convert all text to lowercase, remove stop words, and tokenize it

Apply one-hot encoding directly to text data

Keep the text data as it is without any modifications

Question 3: During the process of data cleaning, which method would you use to handle duplicate records in a financial dataset that could cause inaccurate reporting?

Which action should you take?

Choose only one option

Remove duplicates based on a subset of relevant features

Drop all duplicates in the dataset

Use a custom algorithm to detect and merge duplicate entries

Keep only the first occurrence of each duplicate

Question 4: In time series analysis, what does the term "stationarity" refer to in the context of BFSI data?

Which action should you take?

Choose only one option

The data is normally distributed

The series shows a cyclic pattern

The data exhibits consistent trends over time

The mean, variance, and autocovariance of the series do not change over time

Question 5: How can you ensure optimal performance when querying large datasets in a banking database that contains millions of loan records?

Which action should you take?

Choose only one option

Use indexing and query optimization

Normalize all tables

Reduce the number of joins

Limit the number of tables queried

Question 6: How would you handle inconsistent currency values across different countries in a financial dataset?

Which action should you take?

Choose only one option

Use the highest value currency for all entries

Remove all rows that contain foreign currency

Ignore the differences in currency and treat them as equal

Convert all currencies into one base currency using exchange rates