SAP SAP Certifications C_HANATEC141 Questions & Answers

• Question 31:

  Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit? (Choose three)

  A. Execute system recovery.

  B. Implement backup scheduling.

  C. Monitor an SQLDBC trace.

  D. Display the statuses of database resources.

  E. View the tables in the _SYS_STATISTICS schema.

  Correct Answer: CDE

• Question 32:

  In the navigator tree of the SAP HANA studio, how can you find out which indexes are defined for table CUST_DATA from the SALES schema? (Choose two)

  A. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition

  B. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Content

  C. Catalog node SALES schema node Tables folder double-click on the table CUST_DATA

  D. Catalog node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition

  Correct Answer: CD

• Question 33:

  Which of the following can decrease the startup time of an SAP HANA system after a reboot?

  A. Reducing the number of column tables in the database

  B. Reducing the size of the transactional data records

  C. Reducing the number of fields in the master data

  D. Reducing the size of the row-based tables

  Correct Answer: D

• Question 34:

  You have created a file named backup.sql with the following information to run a backup:

  /c -n -i -u -p BACKUP DATA USING FILE ('backupDirectory/data/COMPLETE_BK')

  Which of the following commands executes the backup?

  A. hdbsql -I backup.sql

  B. hdbsql c backup.sql

  C. hdbsql -S backup.sql

  D. hdbsql -o backup.sql

  Correct Answer: A

• Question 35:

  When is the administration editor in SAP HANA studio opened automatically in diagnosis mode? (Choose two)

  A. When the index server service is restarted

  B. When an SQL connection is not available

  C. When the sapstartsrv service is not running

  D. When the system is restarting

  Correct Answer: BD

• Question 36:

  Which of the following memory indicators can you reset to measure the impact of a new workload on memory usage?

  A. Virtual memory

  B. Used memory

  C. Peak used memory

  D. Resident memory

  Correct Answer: C

• Question 37:

  Which of the following are allowed to be written to the disk space for the data volumes in an SAP HANA system? (Choose two)

  A. Data exports

  B. Backup data files

  C. Log files

  D. Runtime dump files

  Correct Answer: AD

• Question 38:

  Which of the following are advantages of using the SAP CO-PA accelerator? (Choose two)

  A. Transforms data during the load step

  B. Eliminates the need for customization

  C. Provides business configuration

  D. Reduces reporting time

  Correct Answer: CD

• Question 39:

  You are replicating data in real-time from a source system to SAP HANA using System Landscape Transformation (SLT). The source system had to be restored using a point-in-time recovery to an earlier point in time. The systems are now out of sync.

  How can you synchronize the systems again?

  A. Select "Suspend" and "Resume" in the Data Provisioning dialog

  B. Run the hdbnsutil program on the command line

  C. Restart the master job using transaction LTR in the SLT system

  D. Select "Stop Replication" and "Replicate" in the Data Provisioning dialog

  Correct Answer: D

• Question 40:

  You have to create an SAP HANA architecture that meets the following requirements:

  Data provisioning is performed in batch mode

  Data transformation is performed during the load step, Reporting is run using analytic data models.

  Which of the following scenarios would you implement?

  A. An operational data mart

  B. SAP HANA as application platform

  C. An SAP HANA accelerator

  D. An agile data mart

  Correct Answer: D