ACN Interview Questions and Answers

English, Quant & Reasoning- 3 section, each section 15 que, Total 45 minutes & 45 questions, cut off for each section

Q1. Java What is JVM,JRE,JDK? what is the difference between class and instance variable in java? what is string Pool? write a code in java(prefer a good standard question) Web development if you have inter...read more
Ans. 
To build a web application, I would use a combination of front-end technologies like HTML, CSS, and JavaScript, along with back-end technologies like Node.js and MongoDB.
• Use HTML for structuring the content of the web pages

• Use CSS for styling the web pages and making them visually appealing

• Use JavaScript for adding interactivity to the web pages and handling user input

• Use Node.js for server-side scripting and handling ...read more
Answered by AI
Add your answer
Q2. If you have azure certification what is azure, what is Azure Blob Storage, What is ARM, what is horizontal Scaling?
Ans. 
Azure is a cloud computing platform by Microsoft. Azure Blob Storage is a service for storing large amounts of unstructured data. ARM stands for Azure Resource Manager, used for managing resources in Azure. Horizontal scaling is increasing the number of instances of a service to distribute load.
• Azure is a cloud computing platform by Microsoft

• Azure Blob Storage is a service for storing large amounts of unstructured data

• ...read more
Answered by AI
Add your answer

Q1. Why cse? explain a project (they might ask about a project in your resume)
Add your answer
Q2. How you solved the problems that you have faced while working on projects?
Ans. 
I approach problems by breaking them down into smaller parts, analyzing root causes, seeking input from team members, and implementing solutions systematically.
• Identify the root cause of the problem

• Break down the problem into smaller parts

• Seek input from team members for different perspectives

• Implement solutions systematically

• Learn from the experience to prevent similar issues in the future
Answered by AI
Add your answer

Q1. Introduction Family Background Do you have any placement/internship offers in your hand? if so, why Ericsson At last, they will tell you about stipend, role
Ans. 
Yes, I have internship offers from Ericsson due to their reputation for innovation and cutting-edge technology.
• I have received internship offers from Ericsson because of their reputation for innovation and cutting-edge technology.

• I am excited about the opportunity to work with a global leader in telecommunications.

• I believe that interning at Ericsson will provide me with valuable experience and skills that will benefit
Answered by AI
Add your answer

Q1. Basic techno managerial questions on tech you worked on work, interests, challenges you faced. Was fairly short.
Add your answer

Initially had a string based coding problem. Then was asked technical questions and then had a small break before doing system design with same interviewer for building book my show system and db schema.

Q1. Had a discussion with hiring manager on expectations, salary and growth.
Add your answer

It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions

Q1. Clustering and partition difference in data warehousing solutions
Ans. 
Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.
• Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.

• Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.

• Clustering is often used for data a...read more
Answered by AI
Add your answer
Q2. What are the different approaches to Optimising SQL
Ans. 
Different approaches to optimizing SQL include indexing, query optimization, and database design.
• Use indexing to improve query performance

• Optimize queries by avoiding unnecessary joins and using appropriate functions

• Design the database schema efficiently to reduce redundancy and improve data retrieval speed
Answered by AI
Add your answer
Q3. Spark and it’s architecture
Add your answer
Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
Ans. 
To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.
• Aggregate the data by customer and item purchased

• Filter out transactions from February

• Count the number of items bought by each customer
Answered by AI
Add your answer

Q1. What is Object-Oriented Programming (OOP), and can you explain its fundamental concepts?
Add your answer
Q2. What is the definition of an array, and what are the different types of arrays?
Add your answer
Q3. What is the clr
Add your answer

The content is based on HTML, Windows, and ADO.NET.

Q1. What motivates you to pursue this job?
Add your answer
Q2. What is your expected salary?
Add your answer

Q1. How can we do Integrations in Salesforce
Ans. 
Integrations in Salesforce involve connecting Salesforce with external systems to exchange data and automate processes.
• Use Salesforce APIs like REST and SOAP for integrating with external systems

• Utilize middleware tools like MuleSoft or Informatica for seamless integrations

• Leverage Salesforce Connect to access data from external sources in real-time

• Implement custom integrations using Apex code and web services
Answered by AI
Add your answer
Q2. What are frameworks or Trigger frameworks in Salesforce?
Ans. 
Frameworks or Trigger frameworks in Salesforce are design patterns that help developers organize and structure their code for triggers.
• Frameworks provide a set of best practices and guidelines for writing trigger logic.

• They help in separating concerns, making code more modular and maintainable.

• Examples include Trigger Handler Framework, Trigger Factory Framework, and Trigger Pattern Framework.
Answered by AI
Add your answer
Q3. Explain your GitHub project.
Ans. 
My GitHub project is a web application for tracking personal fitness goals and progress.
• Developed using HTML, CSS, JavaScript, and Salesforce Lightning Web Components

• Utilizes Salesforce platform for data storage and user authentication

• Includes features such as goal setting, progress tracking, and personalized workout plans
Answered by AI
Add your answer

Q1. What motivates you?
Add your answer
Q2. What are you most proud of?
Add your answer
Q3. What is one thing you think where there is room for improvement?
Ans. 
One area for improvement is the integration of AI and machine learning capabilities in Salesforce.
• Enhancing predictive analytics for better decision-making

• Automating repetitive tasks to increase efficiency

• Improving personalized customer experiences through AI-driven insights
Answered by AI
Add your answer

Q1. Do you currently have any offers : )
Ans. 
No, I do not currently have any offers.
• I am actively searching for opportunities in the Salesforce development field.

• I have been applying to various companies and attending interviews.

• I am eager to start my career as a Junior Salesforce Developer.
Answered by AI
Add your answer