Adobe AD0-E704 Exam - Topic 7 Question 74 Discussion

Actual exam question for Adobe's AD0-E704 exam

Question #: 74
Topic #: 7

A merchant is planning to create a single scheduled update for one million products. They are wondering about website performance. What two performance issues will the update cause?

AMagento will index all records in the cataiog_product_entity table regardless of the version so the index tables will be big

BWhen applying a scheduled update Magento will reindex all affected products

CThe catalog_product_entity_* tables will contain all the staged values which slows down all queries related to them

DMagento runs a cron job every minute to generate and maintain preview data

Show Suggested Answer

Suggested Answer: A, B

by Winifred at Apr 10, 2026, 04:38 PM

Limited Time Offer

25%

Off

Get Premium AD0-E704 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Cheryll

18 days ago

I disagree, B) is more critical since it affects all affected products.

upvoted 0 times

...

Dion

23 days ago

A) is definitely a big issue, those index tables will blow up!

upvoted 0 times

...

Aleshia

1 month ago

I recall a similar question about cron jobs affecting performance, but I'm not convinced option D is relevant here.

upvoted 0 times

...

Salome

1 month ago

I feel like option C could be an issue too, since having all those staged values might complicate queries and slow them down.

upvoted 0 times

...

Jordan

2 months ago

I'm not entirely sure, but I remember something about how large index tables can impact performance, so maybe option A is also a valid concern?

upvoted 0 times

...

Willow

2 months ago

I think option B makes sense because reindexing all affected products could definitely slow things down during the update.

upvoted 0 times

...