LTIMindtree Azure Engineer Interview Questions and Answers

Q1. How would you create a pipeline for ADLS to SQL data movement?
Add your answer
Q2. How would you create a pipeline from REST API to ADLS? What is there are 8 million rows of records?
Add your answer
Q3. IF data needs filtering, joining and aggregation, how would you do it with ADF?
Add your answer
Q4. Explain medallion architecture.
Add your answer
Q5. Explain medallion with databricks
Add your answer

Q1. Basic questions and salary expectation.
Add your answer

Q1. 2 Python Questions based on Strong and List manipulation.
Add your answer
Q2. 2 Sql Questions
Add your answer
Q3. 1 Pyspark Question
Add your answer
Q4. What is service principal, ADF questions...
Add your answer

Q1. Introduction. Question on last company why left.
Add your answer
Q2. Salary Negotiation.
Add your answer

Q1. SCD type 1 and SCD type 2 in databircks
Add your answer
Q2. How to pass parameters form ADF to ADB
Add your answer

Q1. How do you build a Docker file with a specific tag?
Ans. 
To build a Docker file with a specific tag, you can use the 'docker build' command with the '-t' flag followed by the desired tag.
• Use the 'docker build' command with the '-t' flag to specify the tag.

• Example: docker build -t myimage:latest .

• Replace 'myimage' with the desired image name and 'latest' with the desired tag.
Answered by AI
Add your answer
Q2. Which build tool is commonly used for Java applications?
Ans. 
Apache Maven is commonly used for building Java applications.
• Apache Maven is a popular build automation tool used for Java projects.

• It simplifies the build process by providing a standard way to structure projects and manage dependencies.

• Maven uses a Project Object Model (POM) file to define project settings and dependencies.

• Example: mvn clean install command is used to build and package a Java project using Maven.
Answered by AI
Add your answer

Q1. Activities used in ADF
Ans. 
Activities in Azure Data Factory (ADF) are the building blocks of a pipeline and perform various tasks like data movement, data transformation, and data orchestration.
• Activities can be used to copy data from one location to another (Copy Activity)

• Activities can be used to transform data using mapping data flows (Data Flow Activity)

• Activities can be used to run custom code or scripts (Custom Activity)

• Activities can be u...read more
Answered by AI
Add your answer
Q2. Dataframes in pyspark
Ans. 
Dataframes in pyspark are distributed collections of data organized into named columns.
• Dataframes are similar to tables in a relational database, with rows and columns.

• They can be created from various data sources like CSV, JSON, Parquet, etc.

• Dataframes support SQL queries and transformations using PySpark functions.

• Example: df = spark.read.csv('file.csv')
Answered by AI
Add your answer

Q1. Managerial Questions
Add your answer
Q2. About project roles and resposibilities
Add your answer

Q1. Nothing interviewers interested about your past experience, work you handled in last project , your roles & responsibilities.
Ans. Just prepare everything you mentioned in your resume
Answered Anonymously
Add your answer

Q1. Second round is with project head. Only looking for your problem handling skills & how youn present yourself. Mostly focus on your communication.
Add your answer

Q1. Salty discussion. Be carefully they try to give you only 20% hikes on current package. Negotiate properly.
Add your answer

Q1. How are you connecting your onPerm from Azure?
Ans. 
I connect onPrem to Azure using Azure ExpressRoute or VPN Gateway.
• Use Azure ExpressRoute for private connection through a dedicated connection.

• Set up a VPN Gateway for secure connection over the internet.

• Ensure proper network configurations and security settings.

• Use Azure Virtual Network Gateway to establish the connection.

• Consider using Azure Site-to-Site VPN for connecting onPremises network to Azure Virtual Network.
Answered by AI
Add your answer
Q2. What is Autoloader in Databricks?
Ans. 
Autoloader in Databricks is a feature that automatically loads new data files as they arrive in a specified directory.
• Autoloader monitors a specified directory for new data files and loads them into a Databricks table.

• It supports various file formats such as CSV, JSON, Parquet, Avro, and ORC.

• Autoloader simplifies the process of ingesting streaming data into Databricks without the need for manual intervention.

• It can be ...read more
Answered by AI
Add your answer
Q3. How do you normalize your Json data
Ans. 
Json data normalization involves structuring data to eliminate redundancy and improve efficiency.
• Identify repeating groups of data

• Create separate tables for each group

• Establish relationships between tables using foreign keys

• Eliminate redundant data by referencing shared values
Answered by AI
Add your answer
Q4. How do you read from Kafka?
Add your answer

30 Minutes Round- Easy to moderate level

Q1. Day to day activities?
Ans. 
Day to day activities involve managing Azure DevOps pipelines, monitoring builds, resolving issues, collaborating with teams.
• Managing Azure DevOps pipelines for continuous integration and deployment

• Monitoring builds and deployments for any issues or failures

• Resolving any issues that arise during the development process

• Collaborating with development teams to ensure smooth workflow and communication

• Implementing best prac...read more
Answered by AI
Add your answer
Q2. Quetsions on various devops tools
Add your answer