SAP E_C4HYCP_12 Exam Practice Test Instant Access

Question 1

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

Question 2

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

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 5

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 6

What must you do before you can run CronJobs in SAP Commerce Cloud?

ASet a reference to a specific job implementation within the CronJob.

BAssign a CronJob to a group of nodes to run on a configured node group.

CConfigure a trigger to run at a specified time.

DAssign a CronJob to run on a node with a specified ID.
You must set a reference to a specific job implementation within the CronJob before you can run it. The job implementation defines the logic and parameters of the CronJob.The other options are not mandatory for running a CronJob.

Answer : A

Question 7

You are deploying the OAuth2 user credentials in SAP Cloud Integration.Where do you configure the OAuth Client data?

ASAP Commerce Backoffice|SAP Cloud Integration Web UI

BSAP BTP cockpit|SAP Cloud Integration Web UI

CSAP Commerce Backoffice|Administration Console

DSAP BTP cockpit|SAP Commerce Backoffice
You configure the OAuth Client data in the SAP BTP cockpit and the SAP Cloud Integration Web UI. In the SAP BTP cockpit, you create a service instance of type xsuaa and provide the client ID and secret.In the SAP Cloud Integration Web UI, you create an OAuth2 credentials artifact and provide the authentication URL and token service URL.

Answer : B

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