Adobe Exam AD0-E704 Topic 6 Question 14 Discussion

Actual exam question for Adobe's AD0-E704 exam

Question #: 14
Topic #: 6

You are integrating an external system from which products and categories will be synchronized with Magento.

To keep the category tree synchronized, an identifier attribute needs to be added to the catalog_category entity. The identifier value is generated by the external system as an unsigned 3 byte integer and is global in scope. Your code will run many concurrent queries to select categories based on this ID in order to synchronize changes.

Keeping performance in mind, what attribute backend type do you choose when creating the EAV attribute?

Aint

Bvarchar

Cstatic

Dtext

Show Suggested Answer

Suggested Answer: A

by Christiane at Jan 05, 2023, 12:07 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Vonda

5 days ago

Option C, static, could work too. But since the identifier is global, an int type makes more sense to me.

upvoted 0 times

...

Coral

7 days ago

I agree, A is the way to go. The external system is already using a 3-byte integer, so keeping it that way will make the integration smoother and faster.

upvoted 0 times

...

Carmela

15 days ago

Hmm, I'd go for option A. An unsigned 3-byte integer should be more efficient than a larger data type like varchar or text, especially for the number of concurrent queries.

upvoted 0 times

...