SAP C_HANATEC142 Online Practice Questions and Exam Preparation

SAP C_HANATEC142 Online Questions & Answers

• Question 151:

  Which of the following URLs do you define for Software Update Manager? Please choose the correct answer.

  A. https://:8443/studio_repository/
  B. https://:8444/studio_repository/
  C. http://:8443/studio_repository/
  D. http://:8444/studio_repository/
  A. https://:8443/studio_repository/

• Question 152:

  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
  C. The same size as the memory required for static data

• Question 153:

  Which of the following are advantages of using the SAP CO-PA accelerator? There are 2 correct answers to this question.

  A. Transforms data during the load step
  B. Eliminates the need for customization
  C. Provides business configuration
  D. Reduces reporting time
  B. Eliminates the need for customization
  D. Reduces reporting time

• Question 154:

  Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit? There are 3 correct answers to this question.

  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.
  C. Monitor an SQLDBC trace.
  D. Display the statuses of database resources.
  E. View the tables in the _SYS_STATISTICS schema.

• Question 155:

  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
  A. net.ipv4.tcp_slow_start_after_idle and kernel.shmmni

• Question 156:

  You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this?

  There are 3 correct answers to this question.

  Choose:

  A. Assign values to be restricted. Choose at least one information model to assign restrictions.
  B. Assign restricted values to the attribute view.
  C. Choose an attribute and define restricted values for it.
  D. Assign the analytic privilege to a user or role.
  E. Assign values to be restricted to a content table.
  A. Assign values to be restricted. Choose at least one information model to assign restrictions.
  C. Choose an attribute and define restricted values for it.
  D. Assign the analytic privilege to a user or role.

• Question 157:

  You want to make sure that all data accesses to a specific view will be logged in the audit trail. As part of an update of the database schema, the view is dropped and recreated under the same name.

  What is the consequence for auditing?

  Please choose the correct answer.

  Choose one:

  A. Auditing needs to be set up again for the recreated view.
  B. The audit log-object references must be reinitialized.
  C. The audit policy needs to be reactivated.
  D. Auditing continues to work for the view.
  D. Auditing continues to work for the view.

• Question 158:

  Which of the following memory indicators can you reset to measure the impact of a new workload on memory usage? Please choose the correct answer.

  A. Virtual memory
  B. Used memory
  C. Peak used memory
  D. Resident memory
  C. Peak used memory

• Question 159:

  Which tools can you use to monitor the query time from SAP HANA? Please choose the correct answer.

  A. Performance tab of the System Monitor
  B. SQL Trace
  C. Central Management Console
  D. Event Viewer
  B. SQL Trace

• Question 160:

  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
  C. SAP HANA Studio Administration Console->Performance LOAD