Free AD0-E717 Exam Braindumps (page: 8)

Page 8 of 20

Which two attribute input types does Magento already have by default? (Choose two.)

  1. Multiple Select
  2. Text Field
  3. Geographic coordinate
  4. Numeric Field

Answer(s): A,B

Explanation:

The two attribute input types that Adobe Commerce already has by default are Multiple Select and Text Field. Multiple Select allows the user to select multiple values from a list of options. Text Field allows the user to enter text in a single line.

The Geographic coordinate and Numeric Field input types do not exist in Adobe Commerce.


Reference:

[Adobe Commerce User Guide - Create a product attribute]



How are multiple EAV attributes belonging to the same entity grouped in the database?

  1. Based on the sizes of values they contain
  2. Based on all numeric values being stored in one table while text values are stored in the other
  3. Based on the types of values they contain

Answer(s): C

Explanation:

Multiple EAV attributes belonging to the same entity are grouped in the database based on their data types, such as datetime, decimal, int, text, or varchar. For example, all attributes with datetime values are stored in one table, while all attributes with text values are stored in another table.

The sizes or numeric/text values of attributes do not determine how they are grouped in the database.


Reference:

[Adobe Commerce Developer Guide - EAV data model]



How should a record be removed from a database which is using a model that was inherited from the \Magento\Framework\Model\AbstractModel class?

  1. Call the "unset" method on this model object
  2. Call the "remove" method on this model object
  3. Call the "delete" method on this model object

Answer(s): C

Explanation:

The "delete" method on the \Magento\Framework\Model\AbstractModel class is used to remove a record from the database. This method will also cascade the delete to any related records.



In a new release of a module, a developer decides to rename a table that was defined in the earlier versions.
Which action, if any, allows the developer to prevent data loss?

  1. Define onCreate="migrateDataFromAnotherTable(old_table_name)" attribute in the table tag.
  2. Declarative schema supports RENAME TABLE', so the data will be migrated to the new table automatically.
  3. Define the table and columns mapping in the db.schema_whitelist.json

Answer(s): A

Explanation:

To prevent data loss when renaming a table that was defined in the earlier versions of a module, the developer should define onCreate="migrateDataFromAnotherTable(old_table_name)" attribute in the table tag of the db_schema.xml file. This attribute will instruct Adobe Commerce to copy all data from the old table to the new table during installation or upgrade.

Declarative schema does not support RENAME TABLE statement, so the data will not be migrated to the new table automatically. The db.schema_whitelist.json file is used to whitelist changes that are allowed for backward compatibility, not for data migration.


Reference:

Adobe Commerce Developer Guide - Declare schema and data patches



Page 8 of 20



Post your Comments and Discuss Adobe AD0-E717 exam with other Community members:

Christine commented on November 06, 2024
Good for practice
Anonymous
upvote

Xiching commented on August 20, 2024
Thank you for publishing these questions. I assisted me to pass my exam.
China
upvote