SAP SAP Certifications C_HANATEC142 Questions & Answers

• Question 11:

  In addition to the in-memory database, which of the following technologies are part of SAP HANA?

  There are 2 correct answers to this question.

  Choose:

  A. Asymmetric multi-processing

  B. Diskless data storage

  C. Columnar store

  D. Massive parallel processing

  Correct Answer: CD

• Question 12:

  A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system

  resources.

  How can you find out which ABAP module and which SAP NetWeaver user called the query?

  Please choose the correct answer.

  A. - Open Transaction Process Overview (SM50) in the SAP NetWeaver system

  -Sort the list by CPU time

  -Select the top entry

  -Check the User and Report columns

  B. - Go to the Performance tab of SAP HANA studio

  -Check the System load diagram

  C. - Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system

  -Sort the list by CPU time

  -Select the top entry

  D. - In SAP HANA studio, check the session overview

  -Identify the logical CONNECTION ID for the SAP NetWeaver work process

  -Check the columns APPLICATIONSOURCE and APPLICATIONUSER

  Correct Answer: D

• Question 13:

  Which of the following must you implement for high availability in an SAP HANA production system? There are 3 correct answers to this question.

  A. A name server on one active node

  B. Index server processes on all nodes

  C. Shared file system for all nodes

  D. Data replication to the standby nodes

  E. A statistics server on one active node

  Correct Answer: BCE

• Question 14:

  What is the recommended approach by SAP when loading tables into SAP HANA from SAP ERP via Data Services?

  Please choose the correct answer.

  A. Use open hub

  B. Use the data staging server

  C. Use the ABAP application tier

  D. Use the Replication Server

  Correct Answer: C

• Question 15:

  When you transport objects between SAP HANA systems using the Change and Transport System (CTS),

  you want to create and release the transport requests manually.

  Which transport strategy should you choose?

  Please choose the correct answer.

  Choose one:

  A. WBO_GET_REQ_STRATEGY = Tagged WBO_REL_REQ_STRATEGY = Manual

  B. WBO_GET_REQ_STRATEGY = Smart WBO_REL_REQ_STRATEGY = Auto

  C. WBO_GET_REQ_STRATEGY = Create WBO_REL_REQ_STRATEGY = Auto

  D. WBO_GET_REQ_STRATEGY = Smart WBO_REL_REQ_STRATEGY = Manual

  Correct Answer: A

• Question 16:

  Which of the following is a result of using SAP HANA as an application platform? Please choose the correct answer.

  A. All database queries have a sub-second response time.

  B. Aggregates in data models are only materialized when required.

  C. Calculation-intensive logic is pushed down to the database.

  D. The need for indexes is eliminated.

  Correct Answer: C

• Question 17:

  In SAP HANA, what is the recommended memory size you must reserve for dynamic objects?

  Please choose the correct answer.

  Choose one:

  A. The same size as the uncompressed source data

  B. The same size as the total size of the log files

  C. The same size as the memory required for static data

  D. The same size as the total size of the data files

  Correct Answer: C

• Question 18:

  You deleted billions of records from several tables in the SAP HANA database. However, the file system

  for the data volumes did not gain any free space.

  What is the reason?

  Please choose the correct answer.

  Choose one:

  A. You did not execute the ALTER SYSTEM RECLAIM LOG

  B. You did not execute a full backup and restore to reduce the size of the data volumes.

  C. SAP HANA did not trigger a delta merge yet.

  D. SAP HANA keeps the space for later reuse.

  Correct Answer: D

• Question 19:

  Which of the following actions are required in the SAP HANA studio to use the Enhanced Change and Transport System (CTS+)?

  There are 2 correct answers to this question.

  A. Create a delivery unit that contains all of the runtime objects.

  B. Create the HTTP connection named CTSDEPLOY.

  C. Configure the connection to the CTS in the preferences.

  D. Use an authorized user to attach SAP HANA content to transport requests.

  Correct Answer: CD

• Question 20:

  Your SAP HANA usage scenario does not require SAP HANA XS.

  What do you have to consider before you remove the SAP HANA XS service from the configuration?

  There are 3 correct answers to this question.

  All applications using the SAP HANA instance must be stopped.

  A. User adm is required to remove the SAP HANA XS service.

  B. A data backup must be taken after the SAP HANA XS service has been removed.

  C. The SAP HANA XS service must be removed from all hosts of the SAP HANA instance.

  D. The user privileges for accessing SAP HANA XS must be revoked.

  Correct Answer: ACD