ExamGecko
Search Search Login
Home Home / Adobe / AD0-E717
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A developer is making customizations in the checkout, and access to the quotes shipping address is needed. Which file provides the shipping address of the current quote?
What will happen if a developer fails to mention the start date in the 'From' field when creating a price rule?
Which price type should be used if the developer wants to provide a discount for a product based on quantity, for example, being able to buy two for X amount each?
Which condition must be satisfied to ensure that a Discard Subsequent Rules option that is set to 'Yes' actually prevents multiple discounts from being applied to the same product?
A developer needs to extend the existing jQuery widget. Which jQuery function is used for this purpose?
Which is a correct CMS content element in Adobe Commerce?
A developer defined a new table in db.schema.xml while creating a new module. What should be done to allow the removal of columns from the database when deleting them from db.schema.xml?
Which two attribute input types can be used for a date? (Choose two.)
How should a developer display a custom attribute on the category edit page in the admin panel when a new module Vendor.Category is created?
Which log file would help a developer to investigate 503 errors caused by traffic or insufficient server resources on an Adobe Commerce Cloud project?

Question 32 - AD0-E717 discussion

Report
Export

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?

A.
Define onCreate='migrateDataFromAnotherTable(old_table_name)' attribute in the table tag.
Answers
A.
Define onCreate='migrateDataFromAnotherTable(old_table_name)' attribute in the table tag.
B.
Declarative schema supports RENAME TABLE', so the data will be migrated to the new table automatically.
Answers
B.
Declarative schema supports RENAME TABLE', so the data will be migrated to the new table automatically.
C.
Define the table and columns mapping in the db.schema_whitelist.json
Answers
C.
Define the table and columns mapping in the db.schema_whitelist.json
Suggested answer: 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.

Verified

Reference:Adobe Commerce Developer Guide - Declare schema and data patches

Show Answer
asked 02/10/2024
Shady Mohamed Ibrahim
31 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms