SAP SAP Certifications C_HANATEC142 Questions & Answers

• Question 141:

  Which of the following can you use to update SAP HANA (SPS06)? Please choose the correct answer.

  A. SAP HANA lifecycle manager

  B. SAP HANA update wizard

  C. SAP HANA on-site configuration tool

  D. Software update manager (SUM) for SAP HANA

  Correct Answer: A

• Question 142:

  Which technologies use trigger-based replication? There are 2 correct answers to this question.

  A. Test Data Migration Server (TDMS)

  B. ABAP extractors

  C. TREX engine

  D. Near Zero Downtime

  E. Standard SQL database replication

  Correct Answer: AC

• Question 143:

  Which of the following commands installs or updates the repository for SAP HANA studio?

  Please choose the correct answer.

  A. hdbinst -a studio - -copy_repository=

  B. hdbinst -a studio - -copy_repository=

  C. hdbinst -a studio - -repository=

  D. hdbinst -a studio - -repository=

  Correct Answer: A

• Question 144:

  You are using continuous system replication between SAP HANA systems in two separate data centers.

  What are the advantages of this scenario?

  There are 2 correct answers to this question.

  Choose:

  A. Database changes are continuously updated to the secondary site.

  B. Memory and CPU are used on the secondary site for shadow processes.

  C. The take-over happens in less than 3 minutes.

  D. The take-over only requires a roll forward since the last synchronization point.

  Correct Answer: AD

• Question 145:

  What are the recommended ways to perform a database backup? There are 2 correct answers to this question.

  A. Use the./hdbsetup command

  B. Use SAP HANA Studio

  C. Use SQL commands

  D. Use the BRBACKUP command

  Correct Answer: CD

• Question 146:

  Which operating system commands show the SAP HANA processes?

  There are 2 correct answers to this question.

  Choose:

  A. HDB admin

  B. HDB info

  C. HDB version

  D. HDB proc

  Correct Answer: B

• Question 147:

  Which of the following template roles allows a user who has been assigned this role to grant the privileges of this role to other users?

  Please choose the correct answer.

  A. CONTENT_ADMIN

  B. MODELING

  C. PUBLIC

  D. MONITORING

  Correct Answer: A

• Question 148:

  Which of the following requires a dedicated network interface to SAP HANA? Please choose the correct answer.

  A. SAP HANA studio

  B. SAP LT

  C. Backup destination

  D. SAP BusinessObjects Business Intelligence platform

  Correct Answer: B

• Question 149:

  Which Linux kernel parameters need to be adapted during SAP HANA installation depending on the SAP

  HANA system size?

  Please choose the correct answer.

  Choose one:

  A. net.ipv4.tcp_slow_start_after_idle and kernel.shmmni

  B. fs.file-max and net.core.wmem_max

  C. kernel.shmall and fs.file-max

  D. net.core_rmem_max and kernel.sysrq

  Correct Answer: A

• Question 150:

  You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been active. How can you accomplish this?

  Please choose the correct answer.

  A. Use the Visualize Plan functionality in the SAP HANA studio.

  B. Use Job Progress in the SAP HANA studio.

  C. Use Performance Trace in HDB admin.

  D. Use EXPLAIN (graphically) in the DBA Cockpit.

  Correct Answer: A