HSBC Software Development Consultant Interview Questions and Answers

Power BI has added new features for data visualization, AI insights, and data modeling.

• New AI-powered visuals like decomposition tree and key influencers

• New data modeling capabilities like composite models and aggregations

• Improved performance and accessibility features

• Enhanced integration with Azure services

Static class and static constructor in C#

• Static class can only contain static members and cannot be instantiated

• Static constructor is called only once when the class is first accessed

• Static constructor is used to initialize static members of the class

• Example: Math class in C# is a static class

• Example: static constructor can be used to initialize a static variable with a value

Performance improvement in Angular app

• Use lazy loading to load modules on demand

• Optimize change detection strategy

• Use trackBy function in ngFor loops

• Minimize DOM manipulation

• Use AOT compilation

• Implement server-side rendering

• Use web workers for heavy computations

• Use caching for frequently accessed data