Question 1

A customer reports an error and provides the following snippet of a log file:INFO | jvm 1 | srvmain

| 2013/11/15 21:36:38.829 | ERROR [ImpExWorker<1/4>] (000000RS-ImpEx-Import) [MultiThreadedImpExImportReader] line 11 at main script: worker 1 got error com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint

'PK 3819157796645776366'. Cannot insert duplicate key in object 'dbo.users'. The duplicate key value is (8796126019588).INFO | jvm 1 | srvmain | 2013/11/15 21:36:38.876 | de.hybris.platform.jalo.JaloSystemException: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK 3819157796645776366'. Cannot insert duplicate key in object 'dbo.users'. The duplicate key value is (8796126019588).[HY--1]What could be the root cause of the error?Note: There are 2 correct answers to this question.

AThe current PK sequence value is corrupt.

BA primary key is used in the database instead of a unique index.

CSAP Commerce verifies that the key is NOT unique and reports an exception.

DThe database engine verifies that the key is NOT unique and reports an exception
The root cause of the error is that the database engine verifies that the key is not unique and reports an exception. This happens when an attempt is made to insert a duplicate primary key value in the users table. SAP Commerce also verifies that the key is not unique and reports an exception.The current PK sequence value is not corrupt, nor is a primary key used instead of a unique index.

Answer : C, D

Question 2

Your customer is planning to use a PostgreSQL database for a new project.Where do you confirm the third-party compatibility?

ASAP Store

BSAP Commerce official product documentation

CSAP Support Portal

DSAP Community
You can confirm the third-party compatibility in the SAP Commerce official product documentation.The documentation provides information on the supported versions of Java, application servers, operating systems, databases, libraries, search engines, web browsers, and other software and platforms that are compatible with SAP Commerce

Answer : B

Question 3

Which scripting languages are supported by the Backoffice application in SAP Commerce?Note: There are 3 correct answers to this question.

AGroovy

BBeanShell

CPython

DJavaScript

EBash
The scripting languages that are supported by the Backoffice application in SAP Commerce are Groovy, BeanShell, and JavaScript. These languages can be used to create scripts for various purposes such as data manipulation, testing, debugging, or automation.Python and Bash are not supported by the Backoffice application

Answer : A, B, D

Question 4

A customer reports a performance problem with DefaultStockService. After checking the customer's system by running SELECT COUNT(*) FROM {StockLevelHistoryEntry}, you discover that there are hundreds of millions of instances of StockLevelHistoryEntry.What would you do to resolve this performance issue?Note: There are 2 correct answers to this question.

ADelete the content of the StockLevelHistoryEntry table directly from the database to immediately improve performance.

BImplement a CronJob that will clean the StockLevelHistoryEntry table according to customer business needs.

CSuggest an improvement by creating a maintenance request for the customer.

DRun Cleanup Type System in the SAP Commerce Administration Console.
You can resolve the performance issue with DefaultStockService by implementing a CronJob that will clean the StockLevelHistoryEntry table according to customer business needs and by suggesting an improvement by creating a maintenance request for the customer. The CronJob can help reduce the size of the table and improve the query performance. The maintenance request can help inform SAP about the issue and request a possible enhancement or fix. You should not delete the content of the table directly from the database, as this may cause data inconsistency or loss.You should not run Cleanup Type System in the SAP Commerce Administration Console, as this will not affect the StockLevelHistoryEntry table.

Answer : B, C

Question 5

Why would you use an SAP Commerce JDBC log?Note: There are 3 correct answers to this question.

ATo check how long a query took in milliseconds

BTo check the Java classes caller hierarchy (Enable Trace checkbox must be activated)

CTo retrieve the log from the database

DTo analyze the number of user connections to the database at various times

ETo check FlexibleSearch queries that have been fired
You would use an SAP Commerce JDBC log to check how long a query took in milliseconds, to check the Java classes caller hierarchy (if Enable Trace checkbox is activated), and to check FlexibleSearch queries that have been fired. The JDBC log can help you monitor and analyze the database queries executed by SAP Commerce and identify any performance issues or errors.You cannot use an SAP Commerce JDBC log to retrieve the log from the database or to analyze the number of user connections to the database at various times.

Answer : A, B, E

Free Practice Questions for SAP E_C4HYCP_12 Exam

Question 1

Question 2

Question 3

Question 4

Question 5