Utthunga Technologies Interview Questions and Answers

DAX (Data Analysis Expressions) is a formula language used in Power BI, Excel, and SQL Server for data modeling and analysis.

• DAX is used to create custom calculations in Power BI and Excel.

• It includes functions for filtering, aggregating, and manipulating data.

• Example: CALCULATE function allows you to modify filter context in calculations.

• DAX supports time intelligence functions like YEAR, MONTH, and DATEDIFF for ...read more

Association, aggregation, and composition are types of relationships between classes in object-oriented programming.

• Association is a relationship where two classes are connected, but not dependent on each other.

• Aggregation is a type of association where one class contains another class, but the contained class can exist independently.

• Composition is a stronger form of aggregation where the contained class is part o...read more

List is mutable, tuple is immutable in Python.

• List can be modified after creation, tuple cannot.

• List uses square brackets [], tuple uses parentheses ().

• List is used for collections of items that may change, tuple for fixed collections.

• Example: list - [1, 2, 3], tuple - (1, 2, 3)

var is function scoped, let is block scoped, const is block scoped and cannot be reassigned.

• var is function scoped, let is block scoped, const is block scoped and cannot be reassigned

• var can be redeclared and updated, let can be updated but not redeclared, const cannot be redeclared or updated

• Use const for values that should not change, use let for values that may change, use var sparingly

Object-oriented programming paradigm focusing on objects and classes for code organization and reusability.

• Encapsulation: Bundling data and methods that operate on the data into a single unit (object)

• Inheritance: Ability of a class to inherit properties and behavior from another class

• Polymorphism: Ability to present the same interface for different data types

OOPs concepts in C#, SOLID and design principles, Task vs Thread, Interface vs Abstract class

• OOPs concepts in C# include encapsulation, inheritance, polymorphism, and abstraction

• SOLID principles are Single Responsibility, Open/Closed, Liskov Substitution, Interface Segregation, and Dependency Inversion

• Task is a unit of work in C# that represents an asynchronous operation, while Thread is a separate path of executi...read more