Alldigi Tech Technical Analyst Interview Questions and Answers

Asked to write a code to select values on the basis of the map keys using java 8 stream API

Q1. How OAuth works?
Ans. 
OAuth is an open standard for access delegation, commonly used as a way for Internet users to grant websites or applications access to their information on other websites but without giving them the passwords.
• OAuth allows users to grant access to their information without sharing their passwords.

• It is commonly used for authentication and authorization in web applications.

• OAuth uses tokens to grant access to resources o...read more
Answered by AI
Add your answer
Q2. Benefits of using Stream API.
Ans. 
Stream API provides a way to process collections of objects in a functional style.
• Allows for concise and readable code

• Supports parallel processing for improved performance

• Provides a set of powerful functions like map, filter, reduce, etc.

• Enables lazy evaluation for better memory efficiency
Answered by AI
Add your answer

Q1. Salary Negotiation
Add your answer

Q1. Technical about SQL, Unix and domain
Add your answer

Q1. Which type Scheduler you used in ADF ?
Ans. 
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
Answered by AI
View 3 more answers
Q2. How do you perform sql query optimization ?
Ans. 
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
Answered by AI
View 2 more answers

Q1. Tell me about yourself.
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. What are your salary expectations?
Add your answer