Invensis Technologies Technical Lead Interview Questions and Answers

I have used the built-in scheduler in Azure Data Factory (ADF).

• ADF provides a built-in scheduler that allows you to schedule and orchestrate data integration and data transformation activities.

• The scheduler in ADF supports various scheduling options such as time-based, event-based, and tumbling window triggers.

• You can define the schedule for your pipelines and activities using JSON-based expressions.

• For example, you ca...read more

SQL query optimization involves analyzing and modifying queries to improve performance.

• Identify and eliminate unnecessary or redundant queries

• Use appropriate indexes to speed up data retrieval

• Optimize query structure and syntax

• Avoid using wildcard characters at the beginning of a LIKE statement

• Minimize the use of subqueries

• Use EXPLAIN or query execution plans to identify bottlenecks

• Consider denormalizing tables for fre...read more