Preview Questions Data Analyst | Role Specific Skill

Question 1: How would you prevent SQL injection attacks when accessing financial data stored in a relational database?

Which action should you take?

Choose only one option

Allow only read-only access to all users

Use dynamic SQL to build queries on the fly

Use parameterized queries or prepared statements

Use complex stored procedures for all database operations

Question 2: What is the correct method for handling categorical variables in a BFSI dataset when preparing data for analysis?

Which action should you take?

Choose only one option

Use label encoding

Replace categorical values with numerical codes

Both A and C are correct

Apply one-hot encoding

Question 3: In the context of BFSI, what does a p-value of 0.03 signify when testing a hypothesis?

Which action should you take?

Choose only one option

The test data does not follow a normal distribution

The null hypothesis is accepted

The result is statistically significant at a 5% level

There is a 3% chance that the result is due to chance

Question 4: What is the primary purpose of using pivot tables in Excel for generating financial summaries in banking?

Which action should you take?

Choose only one option

To visualize data trends

To apply conditional logic to financial data

To create complex financial models

To summarize and aggregate large datasets for easier analysis

Question 5: What role does "Trend Extrapolation" play in financial forecasting, and how do you apply it in a risk model?

Which action should you take?

Choose only one option

I avoid extrapolation and rely solely on current market conditions

I use linear extrapolation without considering non-linearities in financial data

I use trend extrapolation only when historical data is complete

Trend extrapolation helps predict future values based on existing trends, and I apply statistical or machine learning models to extend trends

Question 6: How would you best organize a financial report with multiple metrics and KPIs for BFSI stakeholders?

Which action should you take?

Choose only one option

Present only raw data with minimal context

Structure the report with an executive summary, detailed analysis, visualizations, and KPIs

Use charts without providing any numerical context

Use a combination of tables and descriptive text only