Tech Mahindra Senior Power BI Developer Interview Questions and Answers

Switch case is used for multiple conditions while if else is for binary conditions. Sorting can be done using various algorithms.

• Switch case is faster than if else for multiple conditions

• If else is more readable for binary conditions

• Sorting can be done using bubble sort, insertion sort, quick sort, etc.

• Example code for bubble sort: for(i=0;iarr[j+1]){swap(&arr[j],&arr[j+1]);}}}

Difference between compiler and interpreter with a coding challenge

• Compiler translates the entire code into machine language before execution while interpreter translates line by line during execution

• Compiler generates an executable file while interpreter does not

• Compiler is faster but debugging is harder while interpreter is slower but debugging is easier

• Coding challenge: Write a program to find the sum of two numbers

I am familiar with a wide range of technologies used in software development.

• Java

• Python

• C++

• JavaScript

• HTML/CSS

• SQL

• Git

• Linux

• RESTful APIs

• Agile methodologies

OOPs concepts in Java include encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation: Bundling data and methods together in a class.

• Inheritance: Creating new classes from existing ones, inheriting their properties and behaviors.

• Polymorphism: Objects of different classes can be treated as objects of a common superclass.

• Abstraction: Hiding complex implementation details and providing a simplified interfa

Abstraction can be achieved through interfaces, abstract classes, and encapsulation.

• Using interfaces to define a set of methods that a class must implement

• Using abstract classes to provide a base implementation that can be extended by subclasses

• Encapsulating implementation details to hide complexity and provide a simpler interface

• Using design patterns such as Factory and Strategy to abstract away implementation details

Class is a blueprint for creating objects while interface defines a contract for implementing classes.

• Class is a template for creating objects with properties and methods.

• Interface is a contract that defines a set of methods and properties that a class must implement.

• Object is an instance of a class that has its own set of properties and methods.

• Function instance is a reference to a function that can be called with arg...read more

Access modifiers control the visibility and accessibility of class members.

• Access modifiers include public, private, protected, and internal.

• Public members can be accessed from anywhere.

• Private members can only be accessed within the same class.

• Protected members can be accessed within the same class and its subclasses.

• Internal members can be accessed within the same assembly.

• Access modifiers help enforce encapsulation ...read more

Cloud refers to the delivery of computing services over the internet.

• Cloud computing allows users to access data and applications from anywhere with an internet connection.

• Cloud services can be categorized into three main types: Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS).

• Cloud providers include Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.

• ...read more

There are multiple ways to achieve tasks on AWS depending on the specific task.

• Using AWS Management Console

• Using AWS CLI

• Using AWS SDKs

• Using AWS CloudFormation

• Using AWS Elastic Beanstalk

• Using AWS Lambda

• Using AWS Step Functions

• Using AWS Batch