Preview Questions Data Analyst | Role Specific Skill

Question 1: In the process of handling time series data, how do you ensure that the dataset is stationary before applying machine learning models?

Which action should you take?

Choose only one option

Apply transformations like differencing or log transformation to remove trends

Ignore stationarity and proceed with model training

Use data smoothing techniques like moving averages to stabilize variance

Normalize the data using Min-Max scaling

Question 2: How would you handle schema changes in a production database, particularly when introducing new fields in financial tables?

Which action should you take?

Choose only one option

I directly modify the production database schema without testing

I ignore schema changes unless they are absolutely necessary

I create a backup and manually change the schema without using scripts

I apply migrations using version-controlled scripts and thoroughly test the changes before deployment

Question 3: When documenting a comprehensive analysis of loan portfolios, which of the following is the most appropriate format to summarize key findings?

Which action should you take?

Choose only one option

Executive summary with visual representations of key trends

Use a series of raw data tables without context

Long-form textual description without charts

A pie chart showing loan breakdown without detailed analysis

Question 4: In relational databases, how would you optimize a query that involves multiple joins and large tables to improve performance?

Which action should you take?

Choose only one option

Use full-text search indexes instead of relational joins

Use subqueries to reduce the size of intermediate tables

Use indexes on the columns involved in the joins

Rewrite the query to eliminate joins entirely

Question 5: When dealing with highly skewed financial data in a regression model, what method should be used to handle non-normality?

Which action should you take?

Choose only one option

Use ridge regression

Perform a chi-square transformation

Normalize the data

Log transformation of the dependent variable

Question 6: What is the primary advantage of using data blending in Tableau for generating comprehensive financial reports in BFSI?

Which action should you take?

Choose only one option

It simplifies the data cleaning process

It automatically generates predictive models based on the data

It enhances the visual aesthetics of the reports

It allows merging data from multiple sources without altering the original datasets