Appsron Technologies Azure Developer Interview Questions and Answers

Q1. Case study for logic apps
Add your answer
Q2. Types of triggers
Ans. 
Triggers are events that initiate the execution of a function in Azure.
• There are several types of triggers in Azure, including HTTP, Blob, Queue, Timer, and Event Grid triggers.

• HTTP triggers are initiated by an HTTP request.

• Blob triggers are initiated when a new or updated blob is detected in Azure Blob Storage.

• Queue triggers are initiated when a new message is added to an Azure Storage queue.

• Timer triggers are initiat...read more
Answered by AI
Add your answer

Q1. About salary and how many years of experience.
Add your answer

Q1. SQL, pyspark, python
Add your answer
Q2. Medallion arctiicture
Add your answer

Q1. Basics scenario based questions
Add your answer

Q1. Sallery discussion.
Add your answer

Sql queries and knowledge of different syntaxes

Q1. Find the student with marks greater than 80 in all subjects
Ans. 
Filter students with marks greater than 80 in all subjects
• Iterate through each student's marks in all subjects

• Check if all marks are greater than 80 for a student

• Return the student if all marks are greater than 80
Answered by AI
Add your answer
Q2. Write the syntax to define the schema of a file for loading.
Ans. 
Syntax to define schema of a file for loading
• Use CREATE EXTERNAL TABLE statement in SQL

• Specify column names and data types in the schema definition

• Example: CREATE EXTERNAL TABLE MyTable (col1 INT, col2 STRING) USING CSV
Answered by AI
Add your answer

Q1. Azure architecture
Add your answer
Q2. Azure security/ azure logic apps/data engineering
Add your answer

Q1. Azure migration
Add your answer
Q2. Azure devops / azure data engineering
Add your answer

Architecture roadmap 3 tier

Q1. Culture of firm
Ans. 
The culture of the firm is collaborative, innovative, and customer-focused.
• Encourages teamwork and open communication

• Values creativity and continuous improvement

• Prioritizes customer satisfaction

• Promotes diversity and inclusion

• Emphasizes work-life balance
Answered by AI
Add your answer

Q1. What is polybase?
Ans. 
Polybase is a feature in Azure SQL Data Warehouse that allows users to query data stored in Hadoop or Azure Blob Storage.
• Polybase enables users to access and query external data sources without moving the data into the database.

• It provides a virtualization layer that allows SQL queries to seamlessly integrate with data stored in Hadoop or Azure Blob Storage.

• Polybase can significantly improve query performance by levera...read more
Answered by AI
View 1 more answer
Q2. Explain your current project architecture.
Add your answer

Q1. How do you handle cloud migration of .net webapp?
Ans. 
Cloud migration of .NET webapp involves assessing the application, choosing the right migration strategy, and executing the migration process.
• Assess the application to understand its dependencies, architecture, and resource requirements.

• Choose the appropriate migration strategy: rehost, refactor, rearchitect, rebuild, or replace.

• Prepare the target Azure environment, including creating necessary resources like virtual m...read more
Answered by AI
Add your answer

Q1. How to do performance tuning in adf
Ans. 
Performance tuning in Azure Data Factory involves optimizing data flows and activities to improve efficiency and reduce processing time.
• Identify bottlenecks in data flows and activities

• Optimize data partitioning and distribution

• Use appropriate data integration patterns

• Leverage caching and parallel processing

• Monitor and analyze performance metrics
Answered by AI
Add your answer

Q1. Write dockerfile
Ans. 
A Dockerfile is a text document that contains all the commands a user could call on the command line to assemble an image.
• Start with a base image using the FROM keyword

• Use the RUN keyword to execute commands in the container

• Use the COPY keyword to add files from your local machine to the container

• Use the CMD keyword to specify the command to run when the container starts
Answered by AI
Add your answer
Q2. Write yaml file
Ans. 
Creating a YAML file for Azure DevOps
• Use proper indentation with spaces, not tabs

• Start with '---' to indicate the beginning of the YAML file

• Define stages, jobs, and tasks within the YAML file

• Use variables and templates for reusability

• Utilize YAML anchors and aliases for DRY (Don't Repeat Yourself) code
Answered by AI
Add your answer