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

1 years 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

1 years ago

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

upvoted 0 times

...

Mollie

1 years ago

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

upvoted 0 times

...

Destiny

1 years 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

11 months ago

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

upvoted 0 times

...

Shaun

11 months ago

B) Specify the sortOrder in your indexer configuration.

upvoted 0 times

...

Ettie

12 months ago

A) Use a dependencies node in your indexer configuration.

upvoted 0 times

...

Thersa

1 years ago

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

upvoted 0 times

...

Ligia

1 years 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

11 months ago

Option A it is then!

upvoted 0 times

...

Barbra

11 months ago

I always prefer cleaner solutions.

upvoted 0 times

...

Maryrose

11 months ago

I agree, using the dependencies node is cleaner.

upvoted 0 times

...

Carli

11 months ago

I think Option A is the best solution.

upvoted 0 times

...

Sommer

1 years 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

11 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

11 months ago

B) Specify the sortOrder in your indexer configuration.

upvoted 0 times

...

Mitzie

11 months ago

A) Use a dependencies node in your indexer configuration.

upvoted 0 times

...

Thersa

11 months ago

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

upvoted 0 times

...

Tammi

11 months ago

A) Use a dependencies node in your indexer configuration.

upvoted 0 times

...

Val

11 months ago

B) Specify the sortOrder in your indexer configuration.

upvoted 0 times

...

Cassandra

1 years ago

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

upvoted 0 times

...

Tracey

1 years ago

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

upvoted 0 times

...

Johnna

1 years ago

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

upvoted 0 times

...