Add office photos
Filter interviews by
0SBS Azure Engineer Interview Questions and Answers
0SBS Azure Engineer Interview Experiences
1 interview found
Anonymous
I applied via Referral and was interviewed before Aug 2021. There were 2 interview rounds.
(2 Questions)
- Q1. What are the layers of the OSI model
- Ans.
The OSI model has 7 layers that define how data is transmitted over a network.
Layer 1: Physical layer - deals with the physical aspects of transmitting data
Layer 2: Data link layer - responsible for error-free transfer of data between nodes
Layer 3: Network layer - manages the routing of data between nodes
Layer 4: Transport layer - ensures reliable data transfer between applications
Layer 5: Session layer - establishes a...
- Q2. What is the difference between a hub and switch
- Ans.
A hub broadcasts data to all connected devices, while a switch only sends data to the intended recipient.
A hub operates at the physical layer of the OSI model, while a switch operates at the data link layer.
A hub is less secure than a switch, as it broadcasts data to all connected devices.
A switch can improve network performance by reducing network congestion.
Example of a hub: Ethernet hub. Example of a switch: Etherne
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
swetha varaganti
(1 Question)
- Q1. Last project I worked on
- Ans.
Designed and implemented a cloud migration project for a large enterprise company
Led team in assessing current on-premises infrastructure
Developed migration plan to Azure cloud services
Implemented automation for seamless transition
Ensured data security and compliance throughout the process
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
(5 Questions)
- Q1. How would you create a pipeline for ADLS to SQL data movement?
- Q2. How would you create a pipeline from REST API to ADLS? What is there are 8 million rows of records?
- Q3. IF data needs filtering, joining and aggregation, how would you do it with ADF?
- Q4. Explain medallion architecture.
- Q5. Explain medallion with databricks
(1 Question)
- Q1. Basic questions and salary expectation.
Interview Preparation Tips
- ADF
- Databricks
Selected
I applied via Recruitment Consulltant and was interviewed in Aug 2024. There were 3 interview rounds.
(4 Questions)
- 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.
- 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...
- Q3. Spark Architecture, Optimisation techniques
- Q4. Some personal questions.
(5 Questions)
- 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
- 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
- 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?
- 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)
- 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 ...
(1 Question)
- Q1. Basic HR questions
Interview Preparation Tips
- SQL
- Databricks
- Azure Data Factory
- Pyspark
- Spark
Skills evaluated in this interview
I applied via Company Website and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. SCD type 1 and SCD type 2 in databircks
- Q2. How to pass parameters form ADF to ADB
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- 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.
- 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.
Interview Preparation Tips
(2 Questions)
- 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...
- 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')
(2 Questions)
- Q1. Managerial Questions
- Q2. About project roles and resposibilities
Skills evaluated in this interview
Selected
I applied via Naukri.com
(4 Questions)
- Q1. Based on my previous company projects
- Q2. SQL based questions are asked
- Q3. ADF based questions are asked
- Q4. Azure related questions are asked
(1 Question)
- Q1. Reg salary discussion
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There was 1 interview round.
(4 Questions)
- 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.
- 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 ...
- 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
- Q4. How do you read from Kafka?
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Job Fair and was interviewed in Dec 2023. There was 1 interview round.
(4 Questions)
- Q1. What is details that interview
- Q2. What is problem in slow in Amazon
- Ans.
The problem of slow performance in Amazon can be attributed to various factors.
Insufficient server capacity leading to high latency
Network congestion causing delays in data transfer
Inefficient code or algorithms affecting processing speed
Inadequate optimization of database queries
Heavy traffic load impacting overall system performance
- Q3. What this means you have any
- Q4. The Amazon's product
- Ans.
Amazon's product is a popular online marketplace and cloud computing platform.
Amazon's product offers a wide range of products and services for customers and businesses.
It allows individuals and companies to sell and buy products online.
Amazon's product also provides cloud computing services through Amazon Web Services (AWS).
Some examples of Amazon's product include Amazon Prime, Amazon Echo, and Amazon Web Services (A
Interview Preparation Tips
Skills evaluated in this interview
0SBS Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Azure Data Engineer Interview Questions
- Azure DevOps Engineer Interview Questions
- Azure Administrator Interview Questions
- Azure Developer Interview Questions
- Azure Cloud Engineer Interview Questions
- Azure Cloud Administrator Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
TCS
Accenture
Wipro
Cognizant
Calculate your in-hand salary
- Home >
- Interviews >
- 0SBS Interview Questions >
- 0SBS Azure Engineer Interview Questions
