G Sekar Associates Interview Questions and Answers

Convert small letters to capital and caps to small in a string

• Iterate through each character in the string

• Check if the character is a small letter or a capital letter

• Convert small letters to capital and caps to small using ASCII values

Dashboard is a visual display of key metrics and trends, while a report is a detailed collection of data and analysis.

• Dashboard provides a high-level overview, while a report dives deeper into specific data points

• Dashboards are interactive and allow for drill-down capabilities, reports are static

• Dashboards are typically used for monitoring and decision-making, reports are used for in-depth analysis

• Example: A dashboard may show sales performance by region with interactive filt...read more

I have 2 years of experience in data analytics, including working with large datasets and using tools like Python and SQL.

• 2 years of experience in data analytics

• Proficient in working with large datasets

• Skilled in using Python and SQL for data analysis

Lead and lag are SQL functions used to access data from a previous or subsequent row in a result set.

• Lead function is used to access data from a subsequent row in the result set.

• Lag function is used to access data from a previous row in the result set.

• Both functions can be used to compare values between rows or calculate differences.

• Example: SELECT lead(column_name) OVER (ORDER BY column_name) FROM table_name;

ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.

• ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.

• It supports a wide range of data sources, including Azure Blob Storage, Azure SQL Database, and on-premises data sources.

• You can use ADF to ingest data from various sources, transform the data using compute services such as A...read more