SAP C_HANATEC_12 Online Practice Questions and Exam Preparation

SAP C_HANATEC_12 Online Questions & Answers

• Question 171:

  In addition to the in-memory database, which of the following technologies are part of SAP HANA? (Choose two.)

  A. Columnar store
  B. Massive parallel processing
  C. Asymmetric multi-processing
  D. Diskless data storage
  A. Columnar store
  B. Massive parallel processing

• Question 172:

  What is the correct hierarchy of the below?

  A. Delivery unit->package->object->product
  B. Product->Delivery unit->package->object
  C. Object->Delivery unit->package->product
  D. Package>product-> Delivery unit-> object
  B. Product->Delivery unit->package->object

• Question 173:

  Which tool do you use for complex data transformation of SAP ERP data?

  A. Sybase Replication Server
  B. SAP BusinessObjects Data Services
  C. SAP Landscape Transformation (SLT)
  D. SAP BusinessObjects Explorer
  B. SAP BusinessObjects Data Services

• Question 174:

  Of the databases that can be used for Data Services 4.0, which of the following is bundled with Information Platform Services (mini-BOE)?

  A. SYBASE Adaptive Server Enterprise
  B. MS SQL Server Express
  C. MySQL
  D. SAP MaxDB
  B. MS SQL Server Express

• Question 175:

  What is the minimum required disk space for the data volumes of an SAP HANA system in relation to its memory (RAM)?

  A. 4 * RAM
  B. 1 * RAM
  C. 3 * RAM
  D. 2 * RAM
  A. 4 * RAM

• Question 176:

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

  A. Storage replication
  B. System replication
  C. Partitioning
  D. High availability
  B. System replication

• Question 177:

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

  A. Implement backup scheduling.
  B. View the tables in the _SYS_STATISTICS schema.
  C. Execute system recovery.
  D. Display the statuses of database resources.
  E. Monitor an SQLDBC trace.
  B. View the tables in the _SYS_STATISTICS schema.
  D. Display the statuses of database resources.
  E. Monitor an SQLDBC trace.

• Question 178:

  In the SAP HANA studio, in which tab can you find information about the performance of queries?

  A. Alerts
  B. Diagnosis Files
  C. System Information
  D. Trace Configuration
  B. Diagnosis Files

• Question 179:

  Which of the following traces provides information about past SQL query runtime performance including the values of parameters?

  A. User-specific trace
  B. Performance trace
  C. Expensive statements SQL trace
  C. Expensive statements SQL trace

• Question 180:

  A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system resources. How can you find out which ABAP module and which SAP NetWeaver user called the query?

  A. Go to the Performance tab of SAP HANA studio- Check the System load diagram
  B. Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system- Sort the list by CPU time- Select the top entry
  C. Open Transaction Process Overview (SM50) in the SAP NetWeaver system-Sort the list by CPU time- Select the top entry- Check the User and Report columns
  D. In SAP HANA studio, check the session overview- Identify the logical CONNECTION ID for the SAP NetWeaver workprocess- Check the columns APPLICATIONSOURCE and APPLICATIONUSER
  D. In SAP HANA studio, check the session overview- Identify the logical CONNECTION ID for the SAP NetWeaver workprocess- Check the columns APPLICATIONSOURCE and APPLICATIONUSER