SAP C_HANATEC_12 Online Practice Questions and Exam Preparation

SAP C_HANATEC_12 Online Questions & Answers

• Question 81:

  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. Where can you accomplish this?

  A. In SAP HANA studio: Administration Console -> Performance -> Job Progress
  B. In HDB admin -> Performance trace -> Show Column Plans
  C. In SAP NetWeaver: DBA Cockpit (DBACOCKPIT) -> SQL Plan Cache -> EXPLAIN (graphically)
  C. In SAP NetWeaver: DBA Cockpit (DBACOCKPIT) -> SQL Plan Cache -> EXPLAIN (graphically)

• Question 82:

  SAP Support needs to access a customer's SAP HANA studio remotely. Which entry must the client maintain in SAP Service Marketplace?

  A. Name server
  B. Master index server
  C. Preprocessor server
  D. Statistics server
  B. Master index server

• Question 83:

  The SAP LT trigger-based approach uses a log table to record all relevant changes.

  Where is this log table stored?

  A. In SAP Solution Manager
  B. In SAP HANA
  C. In the source system
  D. In SAP LT
  C. In the source system

• Question 84:

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

  A. Reducing the number of fields in the master data
  B. Reducing the size of the transactional data records
  C. Reducing the number of column tables in the database
  D. Reducing the size of the row-based tables
  D. Reducing the size of the row-based tables

• Question 85:

  An administrator should be enabled to cancel long running commands and end sessions. Which privilege must the user be granted?

  A. SESSION ADMIN
  B. RESOURCE ADMIN
  C. USER ADMIN
  D. MONITOR ADMIN
  A. SESSION ADMIN

• Question 86:

  Which of the following must be shared by SAP HANA nodes in a high availability scenario?

  A. Virtual host name
  B. Network
  C. Shared memory
  D. Storage
  D. Storage

• Question 87:

  When you try to create a delivery unit from the SAP HANA studio you receive the following error message. 'Cannot create Delivery Unit as content vendor is not defined for this system'. How do you troubleshoot this issue?

  A. Grant REPO.MAINTAIN_DELIVERY_UNITS privilege
  B. Grant REPO.MAINTAIN_NATIVE_PACKAGES privilege
  C. Maintain the content_vendor parameter
  D. Maintain the vendor ID
  C. Maintain the content_vendor parameter

• Question 88:

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

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

• Question 89:

  A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this requirement?

  A. Analytic privileges
  B. System privileges
  C. Package privileges
  D. SQL privileges
  A. Analytic privileges

• Question 90:

  Which of the following can you use to update SAP HANA?

  A. SAP HANA on-site configuration tool
  B. Software update manager (SUM) for SAP HANA
  C. SAP HANA lifecycle manager
  D. SAP HANA update wizard
  C. SAP HANA lifecycle manager