Hakuhodo Percept Interview Questions and Answers

Q1. Which function is used to calculate weighted product
Ans. 
The function used to calculate weighted product is the SUMPRODUCT function.
• The SUMPRODUCT function multiplies corresponding components in the given arrays and returns the sum of those products.

• It is commonly used in financial analysis, inventory management, and supply chain optimization.

• Example: =SUMPRODUCT(A1:A3, B1:B3) will calculate the weighted product of values in cells A1 to A3 and B1 to B3.
Answered by AI
Add your answer
Q2. What can we use to summarize the data
Ans. 
Data can be summarized using various methods such as charts, graphs, tables, and statistical measures.
• Charts: Visual representation of data like bar charts, pie charts, line graphs.

• Graphs: Representing data points and relationships between them.

• Tables: Organizing data in rows and columns for easy comparison.

• Statistical measures: Calculating averages, medians, standard deviations, etc.
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated MIS executive with a strong background in data analysis and reporting.
• Experienced in managing databases and generating reports for decision-making

• Proficient in data visualization tools such as Tableau and Power BI

• Skilled in identifying trends and patterns in data to improve business processes
Answered by AI
Add your answer
Q2. Questions related to Hobbies
Add your answer

Q1. Countif, countifs, sumif, sumifs
Add your answer
Q2. Question related to vlookup
Add your answer

Basic English, Mathematics and computer

Certain topic will be given to speak in 5 to 10 members of group

Q1. Any topic will be given
Add your answer
Q2. Check the English slang and grammar
Add your answer

Q1. About role related questions such as advertising
Add your answer

Q1. Same as per technical round
Add your answer

Q1. Tell me about yourself, portfolio walk through
Ans. 
I am a passionate graphic designer with a strong eye for detail and a love for creating visually appealing designs.
• I have a Bachelor's degree in Graphic Design from XYZ University.

• I have 5 years of experience working as a graphic designer at ABC Company.

• I specialize in branding, logo design, and digital illustrations.

• I will walk you through my portfolio showcasing a variety of projects I have worked on, including brand...read more
Answered by AI
Add your answer

Maths and reasoning question

Q1. HR round and knowing
Add your answer

Q1. Technical question related to profile
Add your answer

Q1. What is MVC, and how magento uses MVC
Ans. 
MVC stands for Model-View-Controller. Magento uses MVC architecture to separate business logic, presentation, and user input.
• Model represents the data and business logic

• View represents the presentation layer

• Controller handles user input and updates the model and view accordingly

• Magento uses the layout XML files to define the view layer

• Magento's controllers are responsible for handling requests and responses

• Magento's mo...read more
Answered by AI
View 1 more answer
Q2. Ways to create a custom attribute in magento Product, Customer and Sales.
Ans. 
Custom attributes can be created in Magento Product, Customer and Sales.
• For Product: Use Magento's setup script to create a custom attribute.

• For Customer: Use Magento's customer setup script to create a custom attribute.

• For Sales: Use Magento's sales setup script to create a custom attribute.

• Custom attributes can also be created programmatically using Magento's API.

• Attributes can be added to attribute sets and used in
Answered by AI
View 1 more answer
Q3. What is the difference in product, customer and sales entity. Also do these all have EAV ?
Add your answer
Q4. What is the Mview file usage and what are the indexing techniques.
Ans. 
Mview files are used for indexing in Magento. Indexing techniques include full, partial, and delta indexing.
• Mview files are used to store data for indexing purposes.

• Full indexing updates all data in the index, while partial indexing updates only specific data.

• Delta indexing updates only the data that has changed since the last indexing.

• Indexing can be done manually or automatically based on a schedule or trigger.
Answered by AI
Add your answer

Q1. Magento2 config ways, Also how we can set config so at time of deployment in multiple environments it auto update magento.
Ans. 
Magento2 config can be set via XML files, database, or environment variables. Configuration can be automatically updated during deployment using tools like Ansible or Jenkins.
• Magento2 configuration can be set via XML files in the app/code/[Vendor]/[Module]/etc directory

• Configuration can also be set in the database using the core_config_data table

• Environment variables can be used to set configuration values

• Tools like An...read more
Answered by AI
View 1 more answer
Q2. What caching techniques magento uses, and how we can control them.
Ans. 
Magento uses various caching techniques to improve performance. We can control them through configuration settings.
• Magento uses full page caching, block caching, and session caching.

• Full page caching stores the entire page in cache to reduce server load.

• Block caching stores individual blocks of content in cache to reduce database queries.

• Session caching stores session data in cache to reduce database queries.

• Caching ca...read more
Answered by AI
Add your answer
Q3. What is Redis cache, and how we can modify / clear a customer based cache.
Ans. 
Redis cache is an in-memory data structure store that can be used as a database, cache, and message broker.
• Redis cache is used to speed up the performance of web applications by storing frequently accessed data in memory.

• To modify or clear a customer based cache, we can use Redis commands like DEL, KEYS, and FLUSHDB.

• For example, to clear a customer's cache, we can use the command 'DEL customer:123'.
Answered by AI
Add your answer
Q4. What is the use of composer.json and composer.lock
Ans. 
composer.json defines dependencies and composer.lock ensures their versions are consistent.
• composer.json lists the dependencies required by the project

• composer.lock ensures that the versions of the dependencies remain consistent across different environments

• composer.lock is generated automatically when dependencies are installed or updated

• composer.json can be manually edited to add or remove dependencies

• composer.lock s...read more
Answered by AI
Add your answer
Q5. Steps to make packaging an magento module as a global package to use in composer require.
Ans. 
To make a Magento module a global package for Composer, follow these steps:
• Create a composer.json file in the root directory of the module

• Specify the name, version, and type of the package in the composer.json file

• Add the module's files to the 'src' directory

• Create a 'vendor' directory in the module's root directory

• Run 'composer install' to generate the vendor/autoload.php file

• Publish the package to a repository like P...read more
Answered by AI
Add your answer

Q1. Platform knowledge
Add your answer
Q2. Digital advertising experience and client handling
Ans. 
I have 5 years of experience in digital advertising, managing client accounts and campaigns.
• Managed digital advertising campaigns for various clients, optimizing performance and ROI

• Handled client communication, addressing concerns and providing regular updates

• Utilized data analytics to track campaign performance and make data-driven decisions

• Collaborated with creative teams to develop engaging ad content

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

Q1. Technical knowledge
Add your answer
Q2. Overall experience
Add your answer

Q1. Self introduction and communication
Add your answer
Q2. Why do you choose Hogarth?
Add your answer

Q1. Why do you want to join
Add your answer
Q2. Can you use social media
Add your answer