db.md

Magento 2 Exam Working with Databases

Magento 2 Certified Associate Developer-18%

4.1 Describe models, resource models & collections

• Basic concepts of models, resource models & collections? codilar, belvg, spiredigital, markshust, etatvasoft

• What are the responsibilities of each of the ORM object types? mageplaza,alanstorm, saviost, magenticians

• How do they relate to one another? interactivated, excellencemagentoblog

4.2 Describe Entity Load & Save

• How entity load and save occurs?github
• How do you use the native Magento save/load process in the development process? inchoo

4.3 Describe filter, sort collections & repositories

• How to filter, sort & specify the selected values for collections & repositories?rakeshjesadiya, mage2-blog
• How do you select a subset of records from the database? mageplaza, stackexchange

4.4 Demonstrate an ability to use declarative schema declarative

• How do you add a column using declarative schema? onilab, devdocs, cedcommerce, idslogic, slideshare, stagebit

• How do you modify a table added by another module???mod-declarative, stackexchange

• How do you delete a column?

• How do you add an index or foreign key using declarative schema? declarative,

• How do you manipulate data using data patches? sushilkumar,

• What is the purpose of schema patches? github

Magento 2 Certified Professional Developer-7% +(EAV) Model 8%= 15%

4.1 Demonstrate ability to use data-related classes

• Describe repositories & data API classes? belvg ,vinaikopp,

• How do you obtain an object or set of objects from the database using a repository? dzone,devdocs

• How do you configure and create a SearchCriteria instance using the builder? medium, alanstorm, stackexchange, ipfs-sec, githubVinai, scommerce, ibnab, webkul

• How do you use Data/Api classes? belvg, scommerce, inchoo, belvg

• Describe how to create and register new entities? coolblueweb, blogtreat

• How do you add a new table to the database? devdocs

• Describe the entity load and save process? stackexchange1, stackexchange2, belvg

• Describe how to extend existing entities. devdocs, devdocs.github, ashsmith

• What mechanisms are available to extend existing classes, for example by adding a new attribute, a new field in the database, or a new related entity? yireo, inchoo, magenest

• Describe how to filter, sort, and specify the selected values for collections & repositories? devdocs, ipfs, rakeshjesadiya

• How do you select a subset of records from the database? stackexchange, belvg, firebearstudio

• Describe the database abstraction layer for Magento? belvg, stackexchange, medium, stackexchange

• What type of exceptions does the database layer throw? stackexchange1, devdocs, stackexchange2, stackexchange3, mage2, rollbar

• What additional functionality does Magento provide over Zend_Adapter? stackexchange, zend, elgentos

4.2 Demonstrate an ability to use declarative schema

• Demonstrate use of declarative schema? devdocs

• How to manipulate columns and keys using declarative schema? declarative, dckap

• What is the purpose of whitelisting? declarative, idslogic

• How to use Data and Schema patches? devdocs, markshust, willfeeling, stagebit, medium, stackexchange

• How to manage dependencies between patch files? devdocs

5.1 Demonstrate ability to use EAV model concepts

• Describe the EAV hierarchy structure. docs, blog , meetanshi, bsscommerce ,

• What happens when a new attribute is added to the system? magestore

• What is the role of attribute sets and attribute groups? blogtreat

• How are attributes presented in the admin? planetwebsolution, meetanshi

• Describe how EAV data storage works in Magento. belvg, meigeeteam

• Which additional options do you have when saving EAV entities? ibnab, rakeshjesadiya

• How do you create customizations based on changes to attribute values? meigeeteam, community

• Describe the key differences between EAV and flat table collections.ipfs, amasty

• In which situations would you use EAV for a new entity? magestore, meetanshi

• What are the pros and cons of EAV architecture? magentoplanet, w3ctrl, amasty

5.2 Demonstrate ability to use EAV entity load and save

• Describe EAV load & save process and differences from flat table load & save process. belvg, stackexchange
• What happens when an EAV entity has too many attributes? stackoverflow
• How does the number of websites/stores affect the EAV load/save process? progostech
• How would you customize load & save process for an EAV entity in situations described here?

5.3 Demonstrate ability to manage attributes

• Describe EAV attributes, including the frontend/source/backend structure. belvg
• How would you add dropdown/multiselect attributes? stackexchange
• What other possibilities do you have when adding an attribute (to a product, for example)?magestore
• Describe how to implement the interface for attribute frontend models. [github](https://github.com/magento-notes/magento2-exam-notes/blob/master/5. Using the Entity-Attribute-Value -EAV- Model/2. Demonstrate ability to use EAV entity load and save.md)
• What is the purpose of this interface?devdocs
• How can you render your attribute value on the frontend?stackexchange
• Identify the purpose and describe how to implement the interface for attribute source models.devdocs
• For a given dropdown/multiselect attribute, how can you specify and manipulate its list of options?devdocs
• Identify the purpose and describe how to implement the interface for attribute backend models.github
• How (and why) would you create a backend model for an attribute?belvg
• Describe how to create and customize attributes.devdocs
• How would you add a new attribute to the product, category or customer entities?stackexchange,magestore
• What is the difference between adding a new attribute and modifying an existing one? zynovo magecom

Magento 2 Certified Professional Developer Plus-14% +(EAV) Model 10%=24%

3.1 Demonstrate Db Access Classes(models,repositories & data mappers)

• Architectural layers of db access classes, including models, repositories & data mappers?belvg, crosp, devdocs

• Models, resource models, and collections in Magento, their impact on performance? magenteiro, stackexchange, hellomagento2

• Repositories, SearchCriteria? fishchenko, stackexchange, offset101, ibnab, willfeeling, ipfs

• WebAPI, WebAPI access, extension attributes? devdocs, mageseller, stackexchange, bizspice, belvg, dckap

• How to create an entity that supports extension attributes?tigren, community, devdocs, omsdocs, magentodeveloper

• How to implement SearchCriteria processing in the repository::getList method?stackexchange, rakeshjesadiya, fishchenko, devdocs

• How to perform bulk save operations in Magento? devdocs, stackexchange, itegration, meetanshi, webnexs

• How to extend data object (Data API class) with an attribute that has values in a remote system? [codilar]https://www.codilar.com/blog/data-objects-magento-2/ magestore, scommerce, stackoverflow

• How to extend exisitng WebAPI calls with a new parameter? community, bizspice, borngroup

• How to create a dynamic WebAPI ACL?, amasty, stackoverflow

• The difference between extension attributes and custom attributes?stackexchange, atwix, dckap, zynovo

3.2 Demonstrate understanding of the staging workflow

• Staging modification to the Magento database operations (row_id, entity managers) stackexchange

• How does data versioning work? yireo, handybackup

• Different possibilities of data versioning (row/table/database level) & implemented? stackexchange

• The role of the entity manager? yireo, stackexchange, magentoextensions, hotexamples

• High level staging implementation overview?devdocs, devdocs

3.3 Demonstrate an ability to use different types of setup scripts in Magento

• Schema and data setup scripts, uninstall scripts, recurring scripts, uninstall schema vs. uninstall data? inchoo, devdocs
• What happens when an uninstall script is executed: data version change, deleted tables, etc? inviqa
• Recurring scripts and their order in the setup:upgrade process? dev98
• Accessing areas and system configuration values in setup scrip?inviqa

4.1 Describe the EAV data access process in Magento

• Getting an attribute instance, impact of attribute sets, large number of attributes and attribute sets? webkul, atwix
• What is the impact of 10,000 attribute sets? 1,000 attributes in a set?[](
• How to get information about an attribute? stackexchange, firebearstudio
• How to perform attribute operations programmatically: assign it to a set/group, update properties, etc? stackexchange, magecomp, magestore, ibnab

4.2 Describe the database tables for EAV entities and how to create them

• The EAV database structure, performance considerations, entity-level attribute properties (catalog_eav_attribute) belvg, fishpig
• Where are catalog-specific attribute properties stored and what are they used for? fastcomet
• How does Magento store the attribute to attribute group association?magestore, docs
• What backend types are available? How do you add a new backend type?belvg, meigeeteam, bsscommerce
• Specifics around static attributes? stackexchange

4.3 Demonstrate an ability to operate with attribute options

• Different ways to store attribute options. Using eav_attribute_option_* tables?
• Config base, database base options? mage2
• The eav_attribute_option_ table: tables that contain shared options between different entities, pros and cons of using the table? stackexchange, webetutorial

4.4 Demonstrate an ability to use non-catalog EAV entities

• Adding an attribute to Customer, Customer Address and Sales entities? web4pro, mageplaza docs magestore
• Making an attribute visible in the Admin or the storefront? stackexchange, stackoverflow, mageplaza, develodesign
• Pitfalls in attributes operations in non-catalog EAV attributes? emiprotechnologies
• Adding an attribute to customers, saving and loading the attribute, problems related to the save process? dckap, magecomp, stackoverflow
• What is the role of attribute sets and groups for customer attributes? bsscommerce mag-manager
• Adding an attribute to customer addresses, the role of the ""is_system"" property and why it only works for the Customer Address entity? mage2
• How to make a customer or customer address attribute visible in the My Account, Checkout, and Admin pages? docs, belvg, webkul
• What is the purpose of the SalesSetup class?magentoextensions, hotexamples, webkul
• Why do you use the addAttribute method for sales entities? yereone, amasty, siphor

---

Magento 2 DB ALL Question Solution

---

• ibnabEavWorkshop