Accenture
80+ Brit Life Science Interview Questions and Answers
Q1. There is an international bank (US based) that has been operating in Asia for the past 10 years. However, recently it has noticed that a lot of its customers are leaving the bank and using services of other loc...
read moreCustomers leaving a US-based international bank in Asia for local/regional banks.
Possible reasons could be lack of understanding of local market and culture
Inability to provide personalized services to customers
Higher fees and charges compared to local/regional banks
Competition from other international banks with better offerings
Negative perception due to scandals or controversies involving the bank
Lack of innovation and adoption of new technologies
Language barriers and commu...read more
Q2. Identify ways to push up declining sales of a major player in the ready to eat food category in Tier I cities in India. The target segment was IT/ consult sector people (convenience seekers) and hostelites. Giv...
read moreTo push up declining sales of a major player in the ready to eat food category in Tier I cities in India, recommendations include targeting IT/consult sector people and hostelites, improving product packaging and branding, offering discounts and promotions, expanding distribution channels, and conducting market research.
Target the IT/consult sector people and hostelites as the primary consumer segment
Improve product packaging and branding to attract attention and differentiat...read more
Q3. How will you convince someone to use technology for cost optimization? What are the few suggestions that you might give the person specially in Covid-19? Give me financial suggestions and technical suggestions...
read moreTo optimize costs during Covid-19, technology is essential. Here are some financial and technical suggestions to convince someone.
Explain how technology can automate processes and reduce manual labor costs
Provide examples of successful cost optimization through technology implementation
Highlight the long-term benefits of technology investment for cost savings
Suggest cloud-based solutions to reduce infrastructure costs
Recommend the use of data analytics to identify cost-saving...read more
Q4. There is a factory. The transportation company charges the factory owners as long as their trucks stay in the factory area. Costs are rising due to this. How do you account for this problem?
The factory is facing rising costs due to transportation company charging for trucks staying in the factory area.
Analyze the transportation company's pricing structure and negotiate for a better deal
Consider alternative transportation options such as rail or water transport
Optimize the factory's logistics to reduce the time trucks spend in the factory area
Explore the possibility of outsourcing transportation to a third-party logistics provider
Q5. How many beer bottles are sold in Lucknow? (in a max of 2 mins, No number, instead, tell me how you would go about it)
I would approach this question by breaking it down into smaller parts and gathering data from various sources.
I would start by researching the population of Lucknow and the average consumption of beer per capita in India.
I would also look into the number of bars, restaurants, and liquor stores in Lucknow and estimate their sales.
I would gather data from beer manufacturers and distributors to get an idea of their sales in the region.
I would also consider any major events or fe...read more
Q6. Case: Client is Automotive Industry with both commercial and passenger vehicles. Their commercial sales are 65%. Their market share has been decreasing every year since last 3 years. Suggest how to revive sales...
read moreTo revive sales for the automotive industry client, focus on improving marketing strategies, expanding product offerings, and enhancing customer experience.
Analyze the market trends and customer preferences to identify the reasons for decreasing market share
Develop targeted marketing campaigns to promote commercial vehicles and increase brand awareness
Introduce new and innovative features in commercial vehicles to attract customers
Expand the product portfolio by introducing n...read more
Q7. How many DPS branches are there all over the world? (Give a number)
The number of DPS branches all over the world is not available.
The exact number of DPS branches worldwide is unknown.
DPS does not publicly disclose the total number of branches.
The number of DPS branches may vary over time due to openings and closures.
To obtain the current number of DPS branches, contact DPS directly.
Q8. Which POR is the one in which you feel you had the maximum impact?
My maximum impact was in the XYZ project where I successfully implemented cost-saving measures resulting in a 20% reduction in expenses.
XYZ project - maximum impact
Implemented cost-saving measures
20% reduction in expenses
Q9. Cloud security and other experiences and projects worked in the past?
I have extensive experience in cloud security and have worked on multiple projects in the past.
Implemented security measures for cloud-based applications and infrastructure
Conducted vulnerability assessments and penetration testing
Developed and implemented disaster recovery plans
Worked on projects involving AWS, Azure, and Google Cloud Platform
Collaborated with cross-functional teams to ensure compliance with industry standards and regulations
Q10. Every project at ABC has 3 phases – Diagnostics, Design and Implementation. You are a consultant to an oil and gas company so take me through each of the three phases in a structured manner
The three phases of a project at ABC - Diagnostics, Design, and Implementation
Diagnostics phase involves gathering information and analyzing the current state of the oil and gas company
Design phase focuses on developing a plan or strategy to address the identified issues or goals
Implementation phase involves executing the plan, monitoring progress, and making necessary adjustments
Example: In the diagnostics phase, consultants may conduct interviews, collect data, and analyze ...read more
Q11. What did you do in relation to financial products?
I have experience in managing and selling various financial products.
Managed a portfolio of mutual funds and provided investment advice to clients
Sold insurance policies and explained the benefits and coverage to customers
Assisted in the underwriting process for loans and evaluated creditworthiness of applicants
Developed financial models to analyze the performance of different investment options
Collaborated with other departments to create marketing materials for financial pr...read more
Q12. when is Qualified and unqualified SSA used for calls
Qualified SSA is used for calls that meet specific criteria, while unqualified SSA is used for calls that do not meet the criteria.
Qualified SSA is used for calls that meet specific criteria set by the organization or client.
Unqualified SSA is used for calls that do not meet the criteria and may require a different approach or response.
Examples of qualified SSA calls include customer inquiries that can be resolved within a certain timeframe, while unqualified SSA calls may in...read more
Q13. Explain one scenario where you have taken out of the box approach to solving the problem?
In a project to reduce customer complaints, I suggested using social media listening tools to identify and address issues proactively.
Proposed using social media listening tools to monitor customer feedback
Analyzed data to identify common complaints and patterns
Developed a proactive approach to address issues before they escalated
Resulted in a 30% reduction in customer complaints within 3 months
Q14. What do understand by working capital financing and what is the ideal working capital ratio for FMCG companies.
Working capital financing is the management of short-term assets and liabilities. Ideal working capital ratio for FMCG companies is 1.5 to 2.
Working capital financing involves managing short-term assets and liabilities to ensure smooth operations.
It includes managing inventory, accounts receivable, and accounts payable.
The ideal working capital ratio for FMCG companies is 1.5 to 2, which means they have enough current assets to cover current liabilities.
A higher ratio may ind...read more
Q15. Present Power Scenario in India. Difficulties faced by thermal power plants at present
India's power scenario is complex with challenges faced by thermal power plants.
India's power demand is increasing rapidly
Renewable energy sources are being promoted to reduce dependence on fossil fuels
Thermal power plants are facing challenges due to shortage of coal, environmental concerns, and competition from renewable sources
Several thermal power plants are operating below capacity or shutting down
Government is taking steps to address the issues and promote sustainable p...read more
Q16. Cloud project planning and delivery management experience?
Extensive experience in cloud project planning and delivery management.
Managed end-to-end delivery of multiple cloud migration projects for clients in various industries.
Developed project plans, timelines, and budgets for cloud projects.
Collaborated with cross-functional teams to ensure successful project delivery.
Implemented agile methodologies to improve project efficiency and delivery timelines.
Provided regular project status updates to stakeholders and senior management.
Q17. What do you think ‘Accenture’ means?
Accenture is a global professional services firm providing strategy, consulting, digital, technology and operations services.
Accenture is a multinational company that offers a wide range of services to clients across various industries.
It provides consulting, technology, and outsourcing services to help clients improve their business performance.
Accenture has a strong focus on digital transformation and innovation, helping clients to leverage new technologies to drive growth ...read more
Q18. Tell me about the current e-commerce trends in India and how they will change by 2024?
E-commerce in India is rapidly growing with increasing internet penetration and mobile usage. By 2024, it is expected to see a rise in social commerce and voice commerce.
E-commerce market in India is expected to reach $200 billion by 2026.
Mobile commerce is the primary driver of e-commerce growth in India.
Social commerce is expected to grow with the rise of social media usage and influencer marketing.
Voice commerce is expected to gain popularity with the increasing use of sma...read more
Q19. Compare between Accenture and 1. IBM 2. Deloitte 3. Mckinsey and few other consulting companies
Comparison between Accenture and IBM, Deloitte, McKinsey and other consulting companies.
Accenture has a larger global presence than IBM and Deloitte.
McKinsey is known for its strategy consulting while Accenture focuses on technology consulting.
Accenture has a strong digital transformation practice.
Deloitte has a strong presence in the financial services industry.
IBM has a strong focus on artificial intelligence and cloud computing.
Accenture has a lower employee turnover rate ...read more
Q20. If the funds are idle for short term (then equity or debt market, as per risk taking capacity) or if long term (current production expansion or acquisition).
Idle funds should be invested in equity or debt market for short term and in current production expansion or acquisition for long term.
Idle funds should not be kept idle for long as it leads to opportunity cost.
For short term, equity or debt market can be considered based on risk taking capacity.
For long term, investing in current production expansion or acquisition can yield better returns.
Investment decisions should be based on thorough analysis of market trends and risk as...read more
Q21. What are the upcoming trends in auto industry - globally and in India?
Electric vehicles, autonomous driving, and connected cars are the upcoming trends in the auto industry globally and in India.
Electric vehicles are gaining popularity due to environmental concerns and government incentives.
Autonomous driving technology is being developed by major automakers and tech companies.
Connected cars are becoming more common with features like GPS, Wi-Fi, and smartphone integration.
In India, the government is promoting electric vehicles and has set a ta...read more
Q22. How many years of experience do you have for manual testing ?
I have 5 years of experience in manual testing.
I have worked as a manual tester for 5 years.
During this time, I have tested various software applications and systems.
I am proficient in creating test cases, executing tests, and reporting defects.
I have experience in both functional and non-functional testing.
I am familiar with various testing methodologies and tools.
I have also worked on test automation projects.
Overall, my experience has helped me develop a strong understandi...read more
Q23. What were the variables considered, tools used, modelling done, and conclusions drawn?
Variables, tools, modelling and conclusions were considered in the project.
Variables considered: market trends, customer behavior, competition
Tools used: Excel, SPSS, Tableau
Modelling done: regression analysis, cluster analysis, decision trees
Conclusions drawn: market is highly competitive, customers prefer quality over price
Q24. What did you like in Deloitte? and how will you implement the same at Accenture?
I liked Deloitte's focus on innovation and collaboration. I plan to bring the same mindset to Accenture.
Deloitte's emphasis on innovation and collaboration helped me develop new ideas and work effectively with my team.
I plan to implement the same mindset at Accenture by encouraging my team to think outside the box and work together to find creative solutions.
I also appreciated Deloitte's commitment to professional development and plan to prioritize this at Accenture as well.
F...read more
Q25. Consulting seems glamorous but it is generally not. Would you be able to cope up with pressures and different Client Expectations?
Yes, I understand that consulting can be challenging and I am prepared to handle the pressures and meet client expectations.
I have experience working in high-pressure environments and have developed strong time-management and problem-solving skills.
I am adaptable and able to quickly adjust to changing client needs and expectations.
I am committed to delivering high-quality work and am willing to put in the extra effort to ensure client satisfaction.
I am comfortable communicati...read more
Q26. Guesstimation – Estimate the no: of 3-wheelers (market size for 3- wheelers) in lucknow
Approximately 50,000 3-wheelers are estimated to be in Lucknow.
Consider the population of Lucknow and the percentage of people who use 3-wheelers as a mode of transportation.
Look at the number of registered 3-wheelers in the city.
Take into account the number of 3-wheeler manufacturers and dealers in the area.
Consider the demand for 3-wheelers in the city for commercial purposes such as transportation of goods and passengers.
Assume an average lifespan of a 3-wheeler and calcul...read more
Q27. How will you make a blind person understand the color green?
I would use descriptive language and tactile objects to help a blind person understand the color green.
Describe green as the color of grass, leaves, and trees
Use tactile objects such as a leaf or grass to allow the person to feel the texture
Explain that green is often associated with growth and nature
Use comparisons to other colors, such as blue being cool and calming while red is warm and energizing
Q28. I am an insurance company. I want to have a digital transformation. What strategy will you take up?
Develop a comprehensive digital strategy that includes customer-centric solutions, data analytics, and agile methodologies.
Conduct a thorough analysis of the current business processes and identify areas that can be digitized
Develop customer-centric solutions that enhance the customer experience and improve engagement
Implement data analytics to gain insights into customer behavior and preferences
Adopt agile methodologies to enable rapid development and deployment of digital s...read more
Q29. Estimate the market for ipads in India. (Give a number)
The market for iPads in India is estimated to be growing steadily.
The demand for iPads in India has been increasing due to the rise in digitalization and the growing popularity of tablets.
The education sector in India has also contributed to the demand for iPads, as many schools and colleges are adopting digital learning methods.
The availability of affordable iPads and the expansion of Apple's retail presence in India have further boosted the market.
The market size can be est...read more
Q30. Have you worked with APP? EXPLAIN THE STEPS
Yes, I have worked with APP. The steps involve designing, developing, testing, and deploying the application.
Design the user interface and functionality of the APP
Develop the APP using programming languages like Java, Swift, or React Native
Test the APP for bugs and errors
Deploy the APP to app stores or internal servers for users to access
Q31. Are you aware of Agile methodologies?
Yes, Agile methodologies are a set of principles and practices for iterative development.
Agile methodologies prioritize customer collaboration and responding to change over following a strict plan.
Scrum, Kanban, and Extreme Programming (XP) are popular Agile frameworks.
Agile promotes adaptive planning, evolutionary development, early delivery, and continuous improvement.
Daily stand-up meetings, sprint planning, and retrospectives are common Agile practices.
Agile emphasizes de...read more
Q32. Which AWS services would you require to build the chatbot you just designed?
AWS services required to build a chatbot
Amazon Lex for natural language processing
AWS Lambda for serverless computing
Amazon S3 for storing chatbot data
Amazon CloudWatch for monitoring and logging
Amazon API Gateway for creating RESTful APIs
Q33. Describe your work? What is the problem that exist in NLP?
NLP involves developing algorithms to understand and generate human language.
NLP is used in various applications such as chatbots, sentiment analysis, and machine translation.
One of the biggest challenges in NLP is understanding the nuances of human language, including sarcasm, irony, and context.
Other challenges include dealing with language ambiguity, handling rare or unknown words, and developing models that can handle multiple languages.
NLP also faces ethical concerns suc...read more
Q34. What Is difference between SAP ERP AND S/4 HANA
SAP ERP is the traditional enterprise resource planning software, while S/4 HANA is the next-generation ERP suite built on the SAP HANA platform.
SAP ERP is based on traditional on-premise architecture, while S/4 HANA is designed for cloud deployment.
SAP ERP uses a row-based database structure, while S/4 HANA utilizes an in-memory columnar database for faster data processing.
SAP ERP requires separate systems for transactional and analytical processing, while S/4 HANA combines ...read more
Q35. What are the steps for implementation in SAP
Implementation steps in SAP involve planning, configuration, testing, training, and deployment.
1. Planning phase involves defining project scope, objectives, and timeline.
2. Configuration phase includes setting up SAP modules according to business requirements.
3. Testing phase ensures that the system functions correctly and meets user needs.
4. Training phase involves educating users on how to use the SAP system effectively.
5. Deployment phase involves rolling out the SAP syst...read more
Q36. Chalk out the market entry strategy for a player wanting to enter into second hand cars market
Market entry strategy for a player entering second hand cars market
Conduct market research to identify target audience and competition
Establish partnerships with local dealerships and mechanics
Create a user-friendly online platform for buying and selling cars
Offer competitive pricing and financing options
Invest in marketing and advertising to increase brand awareness
Provide excellent customer service to build trust and loyalty
Q37. Hydro-electric plants and their pros and cons
Hydro-electric plants use flowing water to generate electricity, but have both advantages and disadvantages.
Pros: Renewable energy source, low operating costs, minimal greenhouse gas emissions
Cons: High initial costs, impact on ecosystems and fish populations, limited availability of suitable locations
Example: The Hoover Dam in the United States is a large hydro-electric plant that provides electricity to millions of people.
Q38. Guesstimate the number of cab drivers in Delhi
There are approximately 100,000 cab drivers in Delhi.
Estimate the population of Delhi (approx. 20 million)
Assume 1 cab driver for every 200 people
Factor in the number of tourists and visitors to the city
Consider the number of cab companies and their fleet sizes
Q39. Future of Nuclear Power Plants. Pros and Cons
Nuclear power plants have pros like low carbon emissions but cons like high cost and safety concerns.
Pros: low carbon emissions, high energy output, reliable power source
Cons: high cost, safety concerns, nuclear waste disposal
Examples: Fukushima disaster, Chernobyl disaster, Three Mile Island accident
Future: advancements in technology may improve safety and efficiency, but public perception remains a challenge
Q40. How good are you with Excel and PowerPoint?
I am proficient in both Excel and PowerPoint.
I have extensive experience in creating and manipulating spreadsheets in Excel, including using advanced functions and macros.
I am skilled in creating visually appealing and effective presentations in PowerPoint, including using animations and multimedia.
I am also familiar with integrating Excel data into PowerPoint presentations.
Overall, I am confident in my ability to use both Excel and PowerPoint to effectively analyze data and ...read more
Q41. Estimate the market size of second hand cars in India. (both from demand side and supply side)
The second-hand car market in India is estimated to be worth several billion dollars, with a large demand and supply side.
India is the fourth largest automobile market in the world, with a large number of cars being sold every year.
The second-hand car market is driven by factors such as affordability, availability, and the desire for newer models.
The demand for second-hand cars is particularly high in smaller cities and towns, where people may not be able to afford new cars.
O...read more
Q42. How to do cloud migration?
Cloud migration involves planning, preparation, and execution of moving data and applications from on-premise to cloud infrastructure.
Assess current infrastructure and identify applications and data to be migrated
Choose the right cloud provider and service model
Prepare a migration plan and timeline
Test the migration plan before execution
Execute the migration plan in phases
Monitor and optimize the migrated applications and data
Q43. Estimate the annual number of travelers visiting to Delhi Airport. (domestic + international)
The annual number of travelers visiting Delhi Airport is estimated to be around 70 million.
Delhi Airport is one of the busiest airports in India.
In 2019, the airport handled over 69 million passengers.
The airport serves both domestic and international flights.
The number of travelers has been steadily increasing over the years.
Factors like tourism, business travel, and transit passengers contribute to the footfall.
Q44. What all areas do we operate in?
We operate in various areas including technology, finance, healthcare, and more.
Technology
Finance
Healthcare
Retail
Manufacturing
Education
Government
Energy
Telecommunications
Q45. How would you go about building a customer service chatbot?
To build a customer service chatbot, one must first identify the customer needs and design a conversational flow to address them.
Identify the most common customer inquiries and design a conversational flow to address them
Choose a chatbot platform or build a custom solution
Train the chatbot using natural language processing and machine learning
Integrate the chatbot with customer service systems and channels
Continuously monitor and improve the chatbot's performance
Q46. Cloud consulting experience?
I have extensive experience in cloud consulting, having worked with various clients to migrate their systems to the cloud.
Assisted clients in selecting the appropriate cloud service provider based on their needs and budget
Developed cloud migration strategies and provided guidance on best practices
Implemented cloud-based solutions and provided ongoing support and maintenance
Helped clients optimize their cloud infrastructure for cost and performance
Examples: Migrated a client's...read more
Q47. Estimate the size of the pre-owned LCV market in India
The pre-owned LCV market in India is estimated to be around X units.
The market size can be estimated based on the number of registered vehicles and their age.
Factors like demand, supply, and pricing also play a crucial role in determining the market size.
According to a report by IndianBlueBook, the pre-owned commercial vehicle market is expected to grow at a CAGR of 15% by 2022.
The market is dominated by players like Mahindra First Choice, Tata Motors Assured, and Shriram Aut...read more
Q48. Give us 3-4 values basis which you function.
My values are integrity, empathy, teamwork, and continuous learning.
Integrity: I believe in being honest and transparent in all my dealings.
Empathy: I strive to understand and relate to the perspectives of others.
Teamwork: I value collaboration and believe in working towards common goals.
Continuous learning: I am committed to personal and professional growth through ongoing education and development.
Q49. Different types of back up? and difference between incremental and differential backup
Types of backups include full, incremental, and differential. Incremental backups only save changes since last backup, while differential saves changes since last full backup.
Types of backups: full, incremental, differential
Incremental backup: saves changes since last backup
Differential backup: saves changes since last full backup
Examples: Full backup - all data is backed up, Incremental backup - only changes since last backup are saved, Differential backup - changes since la...read more
Q50. Can you tell me more about the chatbot you built?
I built a chatbot using natural language processing and machine learning to assist customers with their queries.
Used Python and libraries like NLTK and TensorFlow to develop the chatbot
Trained the chatbot on a large dataset of customer queries and responses
Implemented a user-friendly interface for customers to interact with the chatbot
Integrated the chatbot with the company's website and social media platforms
Continuously monitored and improved the chatbot's performance throu...read more
Q51. How would you configure material?
Material can be configured by adjusting its properties and parameters to meet specific requirements.
Identify the specific requirements for the material
Adjust properties such as density, strength, and flexibility
Consider parameters like temperature resistance and chemical compatibility
Test the configured material to ensure it meets the desired specifications
Q52. How has your IIM Journey been so far?
My IIM journey has been challenging yet rewarding.
I have been exposed to diverse perspectives and ideas through case studies and discussions.
I have developed strong analytical and problem-solving skills.
I have also honed my communication and leadership abilities through group projects and presentations.
I have had the opportunity to network with industry professionals and alumni.
Overall, I feel well-prepared for a career in consulting.
Q53. Duration: 10-12 mins: Size of men's hair cut salon in Lucknow.
The size of men's hair cut salon in Lucknow varies depending on the location and target market.
The size of the salon can range from a small shop to a large chain
Factors such as location, target market, and services offered can impact the size of the salon
For example, a salon located in a busy commercial area may have a smaller physical space but cater to a larger customer base
On the other hand, a salon located in a residential area may have a larger physical space but cater t...read more
Q54. What industries is Accenture into?
Accenture is into various industries including technology, healthcare, financial services, consumer goods, and energy.
Accenture provides consulting, technology, and outsourcing services to various industries.
Some of the industries Accenture serves are healthcare, financial services, consumer goods, energy, communications, and media.
Accenture also has specialized practices for industries such as automotive, aerospace and defense, and travel and hospitality.
Accenture's industry...read more
Q55. How well are you with programming launguages
I am proficient in multiple programming languages including Java, Python, and C++.
Proficient in Java, Python, and C++
Experience with web development languages such as HTML, CSS, and JavaScript
Familiarity with database languages like SQL
Q56. Please elaborate on the work that Team Synapse does.
Team Synapse provides consulting services to businesses in various industries.
Team Synapse offers customized solutions to clients based on their specific needs and goals.
They specialize in areas such as strategy development, process improvement, and organizational design.
For example, they may work with a healthcare company to streamline their patient intake process or with a retail company to optimize their supply chain management.
Team Synapse also provides training and coach...read more
Q57. Given 2 matrix, one is transposed combine both of them as one.
To combine two matrices, transpose one and then concatenate them horizontally.
Transpose one of the matrices
Concatenate the transposed matrix with the other matrix horizontally
Q58. The number of three wheelers in Lucknow
The exact number of three wheelers in Lucknow is not available.
There is no official data available on the exact number of three wheelers in Lucknow.
However, it is estimated that there are thousands of three wheelers operating in the city.
Three wheelers are a popular mode of transportation in Lucknow, especially for short distances.
They are commonly used for commuting to work, running errands, and for tourists to explore the city.
The number of three wheelers in Lucknow has inc...read more
Q59. What is RICEF? explain
RICEF is a prioritization framework used in project management to rank tasks based on their impact and effort required.
RICEF stands for Reach, Impact, Confidence, and Effort.
Reach refers to the number of people affected by the task.
Impact is the potential positive outcome of the task.
Confidence is how sure you are about the estimates for Reach and Impact.
Effort is the amount of time and resources needed to complete the task.
Tasks are ranked based on a formula: (Reach x Impact...read more
Q60. Use-cases of AI in R&D in automotive industry.
AI can aid in R&D of automotive industry by optimizing design, predicting failures, and improving safety.
AI can optimize the design of vehicles by analyzing data and creating simulations.
AI can predict failures in vehicles by analyzing sensor data and identifying potential issues before they occur.
AI can improve safety by analyzing driver behavior and providing real-time feedback to prevent accidents.
AI can also aid in the development of autonomous vehicles by analyzing data ...read more
Q61. Difference between sort and sort by key
Sort is a general function to arrange elements in a collection, while sort by key is used to sort elements based on a specific key or property.
Sort function arranges elements in a collection based on their natural order or a custom comparator function.
Sort by key function arranges elements in a collection based on a specific key or property of the elements.
Example: Sorting an array of objects by a specific property like age using sort by key.
Q62. Guesstimate the number of chairs in IIM Lucknow.
Guesstimate the number of chairs in IIM Lucknow.
Estimate the number of classrooms and common areas in IIM Lucknow
Determine the average number of chairs in each classroom and common area
Multiply the average number of chairs by the total number of classrooms and common areas
Consider additional factors like auditoriums, conference rooms, and outdoor seating areas
Adjust the estimate based on the size and capacity of IIM Lucknow
Q63. How is pharma targeting different?
Pharma targeting is different due to the complex nature of the industry and regulations.
Pharma companies target healthcare professionals and patients through various channels such as conferences, social media, and direct mail.
Targeting is heavily regulated by the FDA and other governing bodies to ensure ethical practices.
Pharma companies also use data analytics to target specific patient populations and personalize their marketing efforts.
Targeting also involves educating hea...read more
Q64. Have you worked on big query?
Yes, I have worked on BigQuery extensively.
I have experience in designing and optimizing BigQuery tables and queries.
I have used BigQuery for data warehousing, analytics, and machine learning projects.
I am familiar with BigQuery's SQL dialect and its integration with other Google Cloud services.
For example, I used BigQuery to analyze customer behavior data for a retail client and to train machine learning models for a healthcare startup.
Q65. What is Delta Table and how it works
Delta Table is a type of table in Delta Lake that allows users to efficiently manage large-scale data lakes.
Delta Table is a type of table in Delta Lake, which is an open-source storage layer that brings ACID transactions to Apache Spark and big data workloads.
It allows users to efficiently manage large-scale data lakes by providing features like schema enforcement, data versioning, and time travel capabilities.
Delta Table supports both batch and streaming data processing, ma...read more
Q66. 3 use-cases of AI in auto industry.
AI is transforming the auto industry in many ways. Here are 3 use-cases:
Autonomous driving: AI-powered self-driving cars are being developed by companies like Tesla, Waymo, and Uber.
Predictive maintenance: AI algorithms can predict when a vehicle needs maintenance, reducing downtime and costs.
Customer service: AI chatbots can assist customers with inquiries and provide personalized recommendations.
Q67. Drawback of VLOOKUP, alternative to solve this.
VLOOKUP has limitations in handling large datasets and requires exact match. INDEX-MATCH is an alternative.
VLOOKUP can only search for values in the leftmost column of the table array
VLOOKUP requires an exact match, otherwise it returns an error
VLOOKUP can be slow and inefficient for large datasets
INDEX-MATCH is an alternative that can handle larger datasets and allows for approximate matches
INDEX-MATCH can also search for values in any column of the table array
Q68. Why do we user ID Mapping?
ID Mapping is used to link different identifiers for the same entity, allowing for seamless data integration and analysis.
ID Mapping helps in resolving discrepancies in data from different sources.
It allows for cross-referencing of data from multiple databases or systems.
ID Mapping is essential for data integration in healthcare systems, where patient information may be stored using different identifiers (e.g. medical record number, social security number).
Q69. What do you mean by idocs
IDocs are Intermediate Documents used in SAP systems for exchanging data between systems.
IDocs are structured XML or text files used for data exchange in SAP systems.
They are used to transfer data between SAP systems and between SAP and non-SAP systems.
IDocs contain information about the data being exchanged, such as sender, receiver, and data fields.
They are processed by the SAP system using IDoc processing programs.
Examples of IDocs include ORDERS (for purchase orders) and ...read more
Q70. How to get ALV report ?
ALV report can be obtained by using ALV function modules in SAP ABAP.
Use function modules like REUSE_ALV_GRID_DISPLAY or REUSE_ALV_LIST_DISPLAY to create ALV reports.
Define field catalog and layout for ALV display.
Populate data into internal table and display using ALV function modules.
Q71. What were the use-cases?
The use-cases varied depending on the project requirements.
Use-cases were determined based on the specific needs of each project.
Examples include improving customer experience, increasing efficiency, and reducing costs.
Use-cases were also developed to address specific challenges or pain points within a company or industry.
Overall, the use-cases were tailored to meet the unique goals and objectives of each project.
Q72. How does a chatbot function?
A chatbot functions through natural language processing and machine learning algorithms to understand and respond to user queries.
Chatbots use natural language processing to understand user queries
They use machine learning algorithms to generate responses
Chatbots can be rule-based or AI-based
They can be integrated with messaging platforms or websites
Examples of chatbots include Siri, Alexa, and Google Assistant
Q73. What is NoSQL Database?
NoSQL Database is a type of database that provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.
NoSQL databases are non-relational databases that can handle large volumes of structured, semi-structured, and unstructured data.
They are designed to be flexible, scalable, and provide high performance.
Examples of NoSQL databases include MongoDB, Cassandra, Redis, and Amazon DynamoDB.
Q74. Justification of numbers on CV.
Justify numbers on CV by providing specific examples and quantifiable results.
Provide specific examples of achievements and quantify results
Explain the impact of your contributions on the company or project
Use numbers to demonstrate your success and growth
Be honest and transparent about your accomplishments
Q75. Create new consumer for alert
Creating a new consumer alert for a product or service.
Identify the target audience for the alert
Craft a clear and concise message for the alert
Choose the appropriate channel for delivering the alert (email, SMS, app notification)
Include relevant information such as product updates, safety warnings, or promotions
Q76. Tell me about Scenario
A scenario is a hypothetical situation or sequence of events used for planning or analysis.
Scenarios are often used in business to anticipate potential outcomes and make informed decisions.
They can also be used in training exercises to simulate real-life situations.
In software development, scenarios are used to test the functionality of a system under different conditions.
For example, a business may create a scenario where sales decrease by 20% to determine the impact on prof...read more
Q77. How to implement RAP ?
RAP (Rapid Application Prototyping) can be implemented by following a structured process to quickly develop and test software prototypes.
Identify the requirements and objectives of the project
Create a rough sketch or wireframe of the application
Develop a basic prototype using tools like Sketch, Adobe XD, or Figma
Gather feedback from stakeholders and make necessary iterations
Test the prototype with end-users to validate functionality and usability
Refine the prototype based on ...read more
Q78. Detailed process of risk assessment
Risk assessment involves identifying, analyzing, and evaluating potential risks to determine their impact and likelihood.
Identify potential risks by reviewing past incidents, conducting interviews, and analyzing data
Analyze the identified risks by assessing their impact and likelihood of occurrence
Evaluate the risks by prioritizing them based on their severity and likelihood
Develop risk mitigation strategies to address the identified risks
Monitor and review the effectiveness ...read more
Q79. Business perspective of technologies.
Technologies must align with business goals to achieve success.
Technologies should be chosen based on their ability to solve business problems and achieve goals.
The cost of implementing and maintaining the technology should be weighed against the potential benefits.
Technologies should be scalable and adaptable to meet changing business needs.
Examples include cloud computing, data analytics, and automation tools.
Regular evaluation of technology use and effectiveness is necessa...read more
Q80. Disadvantage of Cloud?
One disadvantage of cloud computing is potential security risks.
Security concerns such as data breaches and unauthorized access
Dependence on internet connection for access to data and applications
Potential for downtime and service interruptions
Limited control over data storage and management
Costs associated with data transfer and storage
Compliance and regulatory issues may arise
Q81. Deeper in cloud
Deeper in cloud
Cloud computing refers to the delivery of computing services over the internet.
It involves the use of remote servers to store, manage, and process data.
Cloud services can include infrastructure, platforms, and software.
Examples of cloud providers include Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.
More about working at Accenture
Top HR Questions asked in Brit Life Science
Interview Process at Brit Life Science
Top Consultant Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month