SAP SAP Certifications C_HANATEC142 Questions & Answers

• Question 81:

  Where do you check log and trace files in SAP HANA studio?

  Please choose the correct answer.

  Choose one:

  A. Administration Editor System Information tab

  B. Administration Editor Diagnosis Files tab

  C. Administration Editor Performance tab

  D. Diagnosis Files tab Modeler Diagnosis Files tab

  Correct Answer: B

• Question 82:

  Application users report that a query sometimes runs much slower than usual. You suspect that high system load is causing the slower query execution.

  Which of the following can you use to review overall system resource utilization at the time of query execution?

  Please choose the correct answer.

  Choose one:

  A. DBA Cockpit (DBACOCKPIT) Performance Expensive Statements

  B. DBA Cockpit (DBACOCKPIT) Current Status Alerts

  C. SAP HANA Studio Administration Console->Performance LOAD

  D. SAP HANA Studio System Monitor Sessions

  Correct Answer: C

• Question 83:

  Which of the following can be monitored in SAP Solution Manager system monitoring?

  There are 3 correct answers to this question.

  Choose:

  A. Expensive SQL statements

  B. Alert status of SAP HANA internal alerting

  C. Host level monitoring

  D. User-specific traces

  E. Availability of SAP HANA services

  Correct Answer: BCE

• Question 84:

  You created an information model in the SAP HANA studio and activated it successfully. When you

  execute the data preview you get an error message indicating missing privileges.

  Which of the following could solve the problem?

  Please choose the correct answer.

  A. GRANT SELECT ON SCHEMA TO _SYS_BIC

  B. GRANT CREATE ANY ON SCHEMA TO _SYS_REPO

  C. GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANT OPTION

  D. GRANT SELECT ON SCHEMA TO _SYS_BI WITH GRANT OPTION

  Correct Answer: C

• Question 85:

  Which new connection type is available as of SAP BusinessObjects Data Services 4.0? Please choose the correct answer.

  A. BAPI function calls

  B. Read table via ABAP data flows

  C. IDOCs

  D. Operational data provider

  Correct Answer: D

• Question 86:

  In the SAP HANA studio, where can you check the throughput performance of SAP HANA backups? Please choose the correct answer.

  A. Administration Console Diagnosis files Backup.log

  B. Backup Editor Backup Catalog Backup Details

  C. System Information Database Information

  D. Administration Console Performance Job Progress

  Correct Answer: B

• Question 87:

  Which of the following would you use to upgrade an SAP HANA system and keep the downtime to a minimum?

  Please choose the correct answer.

  A. High availability

  B. Storage replication

  C. Partitioning

  D. System replication

  Correct Answer: D

• Question 88:

  Which parameters do you change to configure the trace file rotation? There are 2 correct answers to this question.

  A. maxfilesize

  B. tracefile

  C. maxfiles

  D. trace

  Correct Answer: AC

• Question 89:

  Which of the following situations result in a system lockdown?

  There are 2 correct answers to this question.

  Choose:

  A. The license keys installed in the database have been deleted.

  B. The license type was changed from platform to enterprise.

  C. The system ID and/or hardware key of the database have been changed after a system copy or renaming.

  D. The installed license key is an unenforced license key and the current memory consumption exceeds the licensed amount plus the tolerance.

  Correct Answer: AC

• Question 90:

  The statistics server was stopped during an upgrade by the system administrator.

  Which of the following parameters in statisticsserver.ini do you modify to restart the statistics server?

  Please choose the correct answer.

  A. statsconnect in the trace section

  B. editing in the statisticsserver_general section

  C. active in the statisticsserver_general section

  D. statsserv in the trace section

  Correct Answer: C