SAP SAP Certifications C_HANATEC_10 Questions & Answers

• Question 71:

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

  Please choose the correct answer.

  Response:

  A. Administration Editor Performance tab Diagnosis Files tab

  B. Modeler Diagnosis Files tab Administration Editor

  C. System Information tab Administration Editor

  D. Diagnosis Files tab

  Correct Answer: D

• Question 72:

  Which operating system commands show the SAP HANA processes?

  There are 2 correct answers to this question.

  Response:

  A. HDB proc

  B. HDB version

  C. HDB admin

  D. HDB info

  Correct Answer: AD

• Question 73:

  In SAP HANA, what is the recommended memory size you must reserve for dynamic objects?

  Please choose the correct answer. Response:

  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 total size of the data files

  D. The same size as the memory required for static data

  Correct Answer: D

• Question 74:

  What do you have to consider when you design a backup plan?

  There are 2 correct answers to this question.

  Response:

  A. The newest data must be backed up most often.

  B. The column table data needs to be compressed before a backup.

  C. The backup execution must be monitored.

  D. The database backup must be stored at a different location than the database server.

  Correct Answer: CD

• Question 75:

  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?

  There are 2 correct answers to this question.

  Response:

  A. Content node SALES schema node Tables folder simple 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. Content node SALES schema node Tables folder double-click on the table CUST_DATA

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

  Correct Answer: CD

• Question 76:

  SAP Support needs to access a customer's SAP HANA studio remotely. Which entry must the client

  maintain in SAP Service Marketplace?

  Please choose the correct answer.

  Response:

  A. Preprocessor server

  B. Statistics server

  C. Name server

  D. Master index server

  Correct Answer: D

• Question 77:

  Which of the following must you configure to enable monitoring of SAP HANA in DBA Cockpit?

  Please choose the correct answer.

  Response:

  A. The CCMS agent in SAP HANA

  B. A database connection in the table DBCON

  C. The CCMS connection in DBA cockpit

  D. A database connection in DBA Cockpit

  Correct Answer: D

• Question 78:

  You have an SAP HANA productive system with sensitive data. How can you restrict modeling users from

  viewing this data?

  There are 2 correct answers to this question.

  Response:

  A. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.

  B. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.

  C. Use randomized data for the development of data models.

  D. Remove ALTER SYSTEM in the system privileges for the modeling users.

  Correct Answer: BC

• Question 79:

  Which of the following are parts of SAP HANA sizing? There are 3 correct answers to this question. Response:

  A. Disk sizing

  B. Network bandwidth sizing

  C. Memory sizing

  D. CPU sizing

  E. Data and log file sizing

  Correct Answer: ACD

• Question 80:

  Which of the following can you use to analyze an expensive SQL statement?

  There are 2 correct answers to this question.

  Response:

  A. Open the Plan Visualizer.

  B. Open the Plan Explanation.

  C. Open the hdbcons tool.

  D. Open the SQL Plan Cache.

  Correct Answer: AB