Adobe AD0-E716 Exam - Topic 8 Question 55 Discussion

Actual exam question for Adobe's AD0-E716 exam

Question #: 55
Topic #: 8

An international merchant is complaining that changes are taking too long to be reflected on the frontend after a full product import.

Thinking it may be database issues, the Adobe Commerce developer collects the following entity counts:

* Categories: 900

* Products: 300k

* Customers: 700k

* Customer groups : 106

* Orders: 1600k

* Invoices: 500k

* Creditmemos: 50k

* Websites : 15

* Stores : 45

What is a probable cause for this?

AThe combination of the number of products, categories and stores is too big. This leads to a huge amount of values being stored in the flat catalog indexes which are too large to be processed at a normal speed.

CThe combination of the number of products, customer groups and websites is too big. This leads to a huge amount of values being stored in the price index which is too large to be processed at a normal speed.

BThe combination of the number of orders, customers, invoices and creditmemos is too big. This leads to a huge amount of values being stored in the customer grid index which is too large to be processed at a normal speed.

Show Suggested Answer

Suggested Answer: C

The probable cause for the delay in reflecting the changes on the frontend after a full product import is the combination of the number of products, customer groups and websites. This leads to a huge amount of values being stored in the price index which is too large to be processed at a normal speed. The price index calculates the final price of each product for each customer group and website, taking into account various factors such as tax, discounts, catalog price rules, etc. When there are many products, customer groups and websites, the price index becomes very complex and time-consuming to update. Verified Reference: [Magento 2.4 DevDocs] [Magento Stack Exchange]

by Barney at Jan 25, 2026, 03:44 PM

Limited Time Offer

25%

1 month ago

This sounds like a complex issue with a lot of data to consider. I'll need to think through the different database entities and how they might be impacting performance.

upvoted 0 times

...