ExamGecko
Search Search Login
Home Home / Adobe / AD0-E716
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

For security reasons, merchant requested to a developer to change default admin url to a unique url for every branch/environment of their Adobe Commerce Cloud project. Which CLI command would the developer use update the admin url?
During database migration in the Adobe Commerce Cloud integration environment, a developer experienced a disk space error causing the database import to fail. How would the developer fix this issue?
A developer wants to deploy a new release to the Adobe Commerce Cloud Staging environment, but first they need the latest code from Production. What would the developer do to update the Staging environment?
What are two features with Adobe Commerce Cloud that come out of the box? (Choose Two.)
What is the command used to upgrade ECE-Tools on an Adobe Commerce Cloud platform?
A merchant of an Adobe Commerce Cloud project wants to setup one of their websites using a subdomain. The merchant is considering the domain to be set as secondstore.example.com. In addition to editing the magento-vars.php file, and apply a domain check and set $_SERVER['MAGE_RUN_CODE'] and $_SERVER['MAGE_RUN_TYPE']. What file is required to perform this action?
An Adobe Commerce developer has created a module that adds a product attribute to all product types via a Data Patch-According to best practices, how would the developer ensure this product attribute is removed in the event that the module is uninstalled at a later date?
An Adobe Commerce developer is developing a custom module. As part of their implementation they have decided that all instances of their Custom\Module\Model\Example class should receive a new instance of Magento\Filesystem\Adapter\Local. How would the developer achieve this using di. xml? A) B) C)
Which hashing algorithm will Adobe Commerce choose to hash customer passwords?
An Adobe Commerce developer adds a new extension attribute to add an array of values to the invoices that are fetched through the APIs. After a while, their technical manager reviews their work and notices something wrong with the extension_attributes. xml file that the developer created in their module: What is the problem with this xml snippet?

Question 28 - AD0-E716 discussion

Report
Export

An Adobe Commerce developer is trying to create a custom table using declarative schema, but is unable to do so.

What are two errors in the snippet above? (Choose two.)

A.
Column (roll_no) does not have index. It is needed since attribute identity is set to true.
Answers
A.
Column (roll_no) does not have index. It is needed since attribute identity is set to true.
B.
Column (entity_id) does not have index. It is needed since attribute identity is set to false.
Answers
B.
Column (entity_id) does not have index. It is needed since attribute identity is set to false.
C.
Column (student_name) does not have attribute length.
Answers
C.
Column (student_name) does not have attribute length.
D.
null is not a valid value for column (roll_no).
Answers
D.
null is not a valid value for column (roll_no).
Suggested answer: A, C

Explanation:

The correct answers are A and C.

The errors in the snippet are:

Columnroll_nodoes not have an index. It is needed sinceattribute_identityis set totrue.

Columnstudent_namedoes not have an attribute length.

The attribute_identity attribute specifies whether the primary key of the table should be auto-incremented. If attribute_identity is set to true, then the roll_no column must have an index. The student_name column does not have an attribute length, which is required for string columns.

The following code shows how to fix the errors:

XML

<table name='vendor_module_table'>

<entity_id>

<type>int</type>

<identity>true</identity>

<unsigned>true</unsigned>

<nullable>false</nullable>

</entity_id>

<roll_no>

<type>int</type>

<identity>false</identity>

<unsigned>true</unsigned>

<nullable>false</nullable>

true

<index>true</index>

</roll_no>

<student_name>

<type>string</type>

<length>255</length>

<nullable>false</nullable>

</student_name>

</table>

Once the errors have been fixed, the table can be created successfully.

Show Answer
asked 02/10/2024
franz yap
27 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