DXC Technology Interview Questions and Answers

.NET Core Singleton Design Pattern Example

• Singleton pattern ensures only one instance of a class is created

• In .NET Core, Singleton can be implemented using Dependency Injection

• Example: services.AddSingleton();

• This ensures only one instance of MyService is created and shared across the application

Delegates are reference types that hold a reference to a method. Anonymous methods are methods without a name. SOLID is a set of principles for software design.

• Delegates allow methods to be passed as parameters or returned as values.

• Anonymous methods are often used for event handlers or to define a method inline.

• SOLID stands for Single Responsibility, Open/Closed, Liskov Substitution, Interface Segregation, and Dependency Inversion.

• SOLID principles help create maintainable, s...read more

Applying profile permissions in Apex

• Use the Schema class to retrieve the profile object

• Use the Profile object to access and modify the profile permissions

• Use the Metadata API to deploy the updated profile permissions

Performance tuning of Data Warehouse involves optimizing queries, indexing, partitioning, and hardware configurations.

• Identify and optimize slow-running queries by analyzing execution plans and indexing strategies.

• Implement proper indexing on tables to improve query performance.

• Partition large tables to distribute data and queries across multiple physical storage units.

• Optimize hardware configurations such as memory, CPU, and storage to handle large data volumes efficiently.

Data Warehouse design involves structuring data for efficient querying and analysis.

• Identify business requirements and data sources

• Design dimensional model with facts and dimensions

• Implement ETL processes to load data into the warehouse

• Optimize queries for performance

• Consider scalability and data governance

SOLID is a set of five principles for designing object-oriented software to make it more maintainable, flexible, and scalable.

• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open/Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Objects of a superclass should be replaceable with objects of its subclasses without affecting the functionality.

• I - Interface Segrega...read more

Aura components are reusable UI elements in Salesforce. They are built using JavaScript and can be used in Lightning Experience and Communities.

• Aura components are built using JavaScript and can be used in Lightning Experience and Communities.

• They are reusable UI elements that can be easily customized and extended.

• Aura components use a component-based architecture and can communicate with each other using events.

• They can be created using the Aura framework or the Lightning We...read more

Use a SQL query with DISTINCT keyword to delete duplicates from a table.

• Use a SELECT statement with DISTINCT keyword to identify unique rows

• Create a temporary table with the unique rows

• Delete all rows from the original table

• Insert the unique rows back into the original table