Given a Sandbox Instance and Data Import Files, Import Files Using Business Manager Import/Export Modules. B2C-COMMERCE-DEVELOPER Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A developer receives a CSV file for importing customer groups into a sandbox. The file opens correctly in Excel, but the import fails with a validation error about the 'ID' column. The file was saved with UTF-8 with BOM encoding. What is the most likely cause of the failure?

   • AThe CSV file has an extra empty row at the end that is being interpreted as a data record.
   • BThe CSV file includes a Byte Order Mark (BOM) that is not recognized by the import parser.
   • CThe CSV file was saved with Windows line endings (CRLF) instead of Unix line endings (LF).
   • DThe CSV file uses a semicolon as the delimiter instead of a comma.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A developer schedules an import job to run every night at 2:00 AM. The job is configured to import a product catalog. After the first run, the developer checks the job status and sees that the job is 'Running' even though it is now 3:00 PM. What should the developer do to investigate the issue?

   • ARe-upload the import file and start the job again.
   • BCheck the server's system clock to ensure it is set correctly.
   • CCheck the job's execution log to see if it is stuck or still processing.
   • DCancel the job and reschedule it for a later time.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   After importing a product CSV file, the import results show that 10 out of 1000 products failed validation. The error message states: 'Invalid value for attribute: color'. The CSV file has a 'color' column with values like 'Red', 'Blue', and 'Green'. What is the most likely cause of the validation failure?

   • AThe 'color' attribute has a restricted list of valid values, and the 10 products use values not in the list.
   • BThe 'color' attribute is a multi-value attribute, but the CSV provides a single value.
   • CThe 'color' column header is misspelled in the CSV file.
   • DThe 'color' attribute is not defined in the product attribute definition.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   After uploading a data file in the Import & Export module, what must the developer do to start the import process?

   • ARefresh the page
   • BClick the 'Import' button
   • CSend an email to the administrator
   • DWait for the system to auto-import
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   After importing a customer CSV file, the import results show that 50 customers were skipped because of duplicate 'customerNo' values. The developer needs to import all customers, including those with duplicates. What should the developer do?

   • AIgnore the skipped customers because they are duplicates and do not need to be imported.
   • BImport the duplicates using a different import module, such as 'Customer Groups'.
   • CChange the import job settings to allow duplicate 'customerNo' values.
   • DModify the CSV file to ensure each 'customerNo' is unique, then re-import.
   Reveal Solution Discussion Select an answer first