TCS Azure Cloud Engineer Interview Questions and Answers

Mental ability, problem of L.C.M and H.C.F,simplification etc

Q1. Lets say you have table 1 with values 1,2,3,5,null,null,0 and table 2 has null,2,4,7,3,5 What would be the output after inner join?
Ans. 
The output after inner join of table 1 and table 2 will be 2,3,5.
• Inner join only includes rows that have matching values in both tables.

• Values 2, 3, and 5 are present in both tables, so they will be included in the output.

• Null values are not considered as matching values in inner join.
Answered by AI
Add your answer
Q2. Lets say you have customers table with customerID and customer name, Orders table with OrderId and CustomerID. write a query to find the customer name who placed the maximum orders. if more than one person...read more
Add your answer
Q3. Spark Architecture, Optimisation techniques
Add your answer
Q4. Some personal questions.
Add your answer

Q1. Explain the entire architecture of a recent project you are working on in your organisation.
Ans. 
The project involves building a data pipeline to ingest, process, and analyze large volumes of data from various sources in Azure.
• Utilizing Azure Data Factory for data ingestion and orchestration

• Implementing Azure Databricks for data processing and transformation

• Storing processed data in Azure Data Lake Storage

• Using Azure Synapse Analytics for data warehousing and analytics

• Leveraging Azure DevOps for CI/CD pipeline aut
Answered by AI
Add your answer
Q2. How do you design an effective ADF pipeline and what all metrics and considerations you should keep in mind while designing?
Ans. 
Designing an effective ADF pipeline involves considering various metrics and factors.
• Understand the data sources and destinations

• Identify the dependencies between activities

• Optimize data movement and processing for performance

• Monitor and track pipeline execution for troubleshooting

• Consider security and compliance requirements

• Use parameterization and dynamic content for flexibility

• Implement error handling and retries fo
Answered by AI
Add your answer
Q3. Lets say you have a very huge data volume and in terms of performance how would you slice and dice the data in such a way that you can boost the performance?
Add your answer
Q4. Lets say you have to reconstruct a table and we have to preserve the historical data ? ( i couldnt answer that but please refer to SCD)
Add your answer
Q5. We have adf and databricks both, i can achieve transformation , fetching the data and loading the dimension layer using adf also but why do we use databricks if both have the similar functionality for few ...read more
Add your answer

Q1. Basic HR questions
Add your answer

Q1. What is Terraform
Ans. 
Terraform is an open-source infrastructure as code software tool created by HashiCorp.
• Terraform allows users to define and provision infrastructure using a declarative configuration language.

• It supports multiple cloud providers such as AWS, Azure, Google Cloud, and more.

• Terraform uses 'terraform plan' to create an execution plan and 'terraform apply' to apply the changes.

• It helps in automating the creation, modificatio...read more
Answered by AI
Add your answer
Q2. What is Azure DevOps
Ans. 
Azure DevOps is a set of development tools provided by Microsoft to help teams collaborate and deliver high-quality software.
• Azure DevOps includes services such as Azure Repos, Azure Pipelines, Azure Boards, Azure Artifacts, and Azure Test Plans.

• It allows for version control, continuous integration/continuous deployment (CI/CD), project management, and testing.

• Teams can plan, build, test, and deploy applications using ...read more
Answered by AI
Add your answer
Q3. What is CI/CD pipelines
Ans. 
CI/CD pipelines automate the process of building, testing, and deploying code changes.
• CI/CD stands for Continuous Integration/Continuous Deployment

• Automates the process of integrating code changes into a shared repository and deploying them to production

• Helps in detecting and fixing integration errors early in the development process

• Enables faster delivery of software updates and improvements

• Popular tools for CI/CD pip...read more
Answered by AI
Add your answer
Q4. What is Docker and Kubernetes
Ans. 
Docker is a platform for developing, shipping, and running applications in containers. Kubernetes is a container orchestration tool for managing containerized applications across a cluster of nodes.
• Docker allows developers to package applications and their dependencies into containers for easy deployment.

• Kubernetes automates the deployment, scaling, and management of containerized applications.

• Docker containers are lig...read more
Answered by AI
Add your answer