Preview Questions Data Analyst | Role Specific Skill

Question 1: How do you differentiate between a true financial trend and short-term fluctuations in stock market data?

Which action should you take?

Choose only one option

I rely only on visual inspection of the data to identify trends

I use statistical tests like the Mann-Kendall trend test or apply smoothing techniques to separate long-term trends from short-term fluctuations

I assume any change in the data over time represents a trend

I look at the data over a short time window and treat all changes as trends

Question 2: 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 3: In a banking database, what is the primary purpose of using a foreign key constraint when managing customer and loan tables?

Which action should you take?

Choose only one option

To ensure referential integrity

To enforce data types

To improve query performance

To allow for quicker data insertion

Question 4: What is the key benefit of implementing row-level security (RLS) in BI tools like Power BI when generating reports for different departments in a bank?

Which action should you take?

Choose only one option

Increases the loading speed of reports

Simplifies the report design process

Enhances the visual appeal of reports

Allows different users to see only the data relevant to their roles

Question 5: In financial data visualization, how would you best visualize the correlation between customer satisfaction scores and loan repayment behavior in BFSI?

Which action should you take?

Choose only one option

Scatter plot

Box plot

Radar chart

Heatmap

Question 6: In a financial dataset with several categorical variables, which chart type would best allow for comparison between multiple categories across different groups?

Which action should you take?

Choose only one option

Stacked bar chart

Treemap

Pie chart

Radar chart