SAP E_C4HYCP_12 Exam Practice Test Instant Access

Question 1

Which ImpEx headers can you use to update an SAP Commerce Cloud item?Note: There are 2 correct answers to this question.

AINSERT_UPDATE UserGroup;UID[unique=true];locname[lang=en];locname[lang=de];groups(uid)[mode=append]

BINSERT_UPDATE UserGroup;UID[unique=true];locname[lang:en];locname[lang:de];groups(uid)[mode=append]

CUPDATE UserGroup;UID[unique=true];locname;groups(uid)[mode=append]

DINSERT_UPDATE UserGroup;UID;locname;groups(uid)[mode=append]
The ImpEx headers that you can use to update an SAP Commerce Cloud item are INSERT_UPDATE UserGroup;UID[unique=true];locname[lang=en];locname[lang=de];groups(uid)[mode=append] and UPDATE UserGroup;UID[unique=true];locname;groups(uid)[mode=append]. These headers can modify existing items or create new items if they do not exist. The INSERT_UPDATE header can also specify the language for localized attributes using the lang modifier.The other headers are not valid because they either use an incorrect syntax for the lang modifier (B) or do not specify the unique attribute (D).

Answer : A, C

Question 2

Where can you check the SAP Commerce platform version?Note: There are 2 correct answers to this question.

AIn the bin/platform/build.number file.

BIn the bin/platform/project.properties file.

CIn the Administration Console.

DIn the command line by running the ant-version.
You can check the SAP Commerce platform version in the bin/platform/build.number file or in the Administration Console. The build.number file contains information about the platform version, patch version, build date, and build number. The Administration Console displays the platform version on its main page.You cannot check the platform version in the bin/platform/project.properties file or in the command line by running ant-version, as these sources do not contain this information

Answer : A, C

Question 3

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 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

How do you persist changes to enable and disable JDBC logging?

ASAP Commerce Administration Console

BJava code

CConfiguration properties file

DBackoffice Administration Cockpit
The tool that you use to persist changes to enable and disable JDBC logging is configuration properties file. You can use this file to set various configuration parameters related to JDBC logging, such as jdbc.log.enable, jdbc.log.level, jdbc.log.file.path, or jdbc.log.trace. These parameters are persisted across server restarts and can be changed without modifying the source code.You do not use SAP Commerce Administration Console, Java code, or Backoffice Administration Cockpit to persist changes to enable and disable JDBC logging. Reference:2

Answer : C

Question 6

You need to run a FlexibleSearchService query to get results without restrictions.To whom do you assign the session?Note: There are 2 correct answers to this question.

AAdmin user

BAny user that does NOT have any restrictions

CAnonymous user

DAny member of the admingroup
You can assign the session to an admin user or any member of the admingroup to run a FlexibleSearchService query without restrictions.These users have the ROLE_ADMIN assigned to them, which allows them to bypass any restrictions applied to other users or user groups.

Answer : A, D

Question 7

Where can you find SAP knowledge base articles (KBAs) to search for known issues?Note: There are 2 correct answers to this question.

ASAP Community

BSAP Support Portal

CSAP Help Portal

DSAP ONE Support Launchpad
SAP knowledge base articles (KBAs) are available on the SAP Support Portal and the SAP ONE Support Launchpad. They provide information on known issues, troubleshooting guides, best practices, and tips for SAP products.The SAP Community and the SAP Help Portal do not contain KBAs.

Answer : B, D

SAP E_C4HYCP_12 SAP Certified Product Support Specialist - SAP Commerce Cloud Exam Practice Test