Adobe Exam AD0-E703 Topic 5 Question 72 Discussion

Actual exam question for Adobe's AD0-E703 exam

Question #: 72
Topic #: 5

How can you access the select query of a collection?

AYou can only access the select query after the collection has been loaded by calling the public method query()

BIt is stored in a protected variable $query and can only be accessed from the inside of a collection class

CYou can get it by using public method getSelect() which returns an instance of Magento\Framework\DB\Select

DThe select query is not available in the collection class, it will be generated by the MySQL adapter right before executing a query

Show Suggested Answer

Suggested Answer: A

by Alaine at Jul 12, 2024, 03:30 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ricki

8 months ago

I bet the person who came up with this question has had some real fun debugging Magento indexers in the past. Option A for me!

upvoted 0 times

...

Sharen

8 months ago

Creating a bash script to execute each indexer in the correct order seems like a feasible solution as well.

upvoted 0 times

...

Mollie

8 months ago

Ah, the joys of Magento indexing! Option B all the way - keep it simple and straightforward.

upvoted 0 times

...

Destiny

8 months ago

D is a bit hacky, I don't think I'd want to rely on a bash script for this. I'd choose one of the configuration options.

upvoted 0 times

Mariann

7 months ago

C) Use a plugin on the IndexManager class to change load order.

upvoted 0 times

...

Shaun

7 months ago

B) Specify the sortOrder in your indexer configuration.

upvoted 0 times

...

Ettie

8 months ago

A) Use a dependencies node in your indexer configuration.

upvoted 0 times

...

Thersa

8 months ago

Option C is interesting, but a plugin might be overkill for this. I'd stick with the indexer configuration.

upvoted 0 times

...

Ligia

8 months ago

I'd go with Option A. Using the dependencies node is a cleaner approach than a plugin or a bash script.

upvoted 0 times

Janey

7 months ago

Option A it is then!

upvoted 0 times

...

Barbra

7 months ago

I always prefer cleaner solutions.

upvoted 0 times

...

Maryrose

7 months ago

I agree, using the dependencies node is cleaner.

upvoted 0 times

...

Carli

7 months ago

I think Option A is the best solution.

upvoted 0 times

...

Sommer

9 months ago

Option B seems like the way to go. The sortOrder should let you control the order of execution for the indexers.

upvoted 0 times

Paulina

7 months ago

Option B seems like the way to go. The sortOrder should let you control the order of execution for the indexers.

upvoted 0 times

...

Dahlia

7 months ago

B) Specify the sortOrder in your indexer configuration.

upvoted 0 times

...

Mitzie

7 months ago

A) Use a dependencies node in your indexer configuration.

upvoted 0 times

...

Thersa

7 months ago

C) Use a plugin on the IndexManager class to change load order.

upvoted 0 times

...

Tammi

7 months ago

A) Use a dependencies node in your indexer configuration.

upvoted 0 times

...

Val

7 months ago

B) Specify the sortOrder in your indexer configuration.

upvoted 0 times

...

Cassandra

9 months ago

I believe using a plugin on the IndexManager class to change load order could also work.

upvoted 0 times

...

Tracey

9 months ago

I agree with Johnna, specifying the sortOrder in the indexer configuration should solve the issue.

upvoted 0 times

...

Johnna

9 months ago

I think the resolution is to use a dependencies node in the indexer configuration.

upvoted 0 times

...