Magento allows you to specify custom values per store for product attributes created in the admin panel.
Which architectural pattern makes it possible?

You are building a report using complex SQL aggregations to locate the required data.
In what type of class do you put these SQL statements?

You have been asked to display details from the customer's latest order on the customer's account dashboard (customer/account/). You create a new custom template to show the information.
How do you obtain an order repository so you can fetch an order?

The module MyCompany_MyModule provides custom admin interface pages.
Access to these pages should only be granted to specific users.
You add the required configuration to the module's acl.xml file, but the setting does not seem to work as expected.
How do you visually check if Magento evaluates your ACL resource as expected?

What happens when a category's is_anchor attribute is set to 1?