Preview Questions Data Analyst | Role Specific Skill

Question 1: When assessing the relationship between two continuous variables, which correlation coefficient is most robust against outliers commonly found in financial data?

Which action should you take?

Choose only one option

Spearman Rank Correlation

Point-Biserial Correlation

Pearson Correlation

Kendall's Tau

Question 2: In a financial database, how would you efficiently manage data retention policies for transaction records?

Which action should you take?

Choose only one option

Use automatic deletion with triggers

Use data compression techniques

Store data in a NoSQL database

Use data archiving and partitioning

Question 3: How do you handle noise in financial data when identifying significant trends in stock prices or interest rates?

Which action should you take?

Choose only one option

I discard all outlier data points and focus on the remaining data

I assume noise is irrelevant and ignore it in my analysis

I apply smoothing techniques such as exponential smoothing or moving averages to remove noise

I use only raw data without any pre-processing

Question 4: In BFSI, which type of visualization is most effective for comparing the market share of different financial institutions?

Which action should you take?

Choose only one option

Treemap

Line graph

Pie chart

Stacked bar chart

Question 5: Which of the following methods would be most effective for handling a large influx of loan application data that must be processed in real-time?

Which action should you take?

Choose only one option

Data warehousing

Event-driven architecture

OLAP cubes

Batch processing

Question 6: In financial forecasting, when is it appropriate to use ARIMA (AutoRegressive Integrated Moving Average) models?

Which action should you take?

Choose only one option

When there is no seasonal pattern in the data

When the data is normally distributed

When the data is non-stationary and exhibits seasonality

When the data shows a clear linear relationship