SAP SAP Certifications C_HANATEC142 Questions & Answers

• Question 161:

  What do you have to consider when you design a backup plan? There are 2 correct answers to this question.

  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 162:

  In an analytic view, you want to restrict the access for users according to their geographical reporting

  region.

  What do you have to do to achieve this?

  There are 3 correct answers to this question.

  Choose:

  A. Create an analytic privilege

  B. Select an attribute and define restricted values for it

  C. Assign a package privilege to the users

  D. Create a filter on an attribute

  E. Assign the analytic privilege to the users

  Correct Answer: ABE

• Question 163:

  Which of the following privileges do you need to activate views? Please choose the correct answer.

  A. SELECT option on the _SYS_BIC schema

  B. SELECT option on the _SYS_BI schema

  C. SELECT option on the _SYS_REPO schema

  D. SELECT option on the _SYS schema

  Correct Answer: C

• Question 164:

  Which of the following must you configure to enable monitoring of SAP HANA in DBA Cockpit? Please choose the correct answer.

  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 165:

  Which of the following authentication methods does SAP HANA support for http(s) access?

  There are 2 correct answers to this question.

  Choose:

  A. X.509 client certificates

  B. Header-based authentication

  C. LDAP authentication

  D. SAP logon tickets

  Correct Answer: AD

• Question 166:

  Which view displays the current SAP HANA Support Package level?

  Please choose the correct answer. Choose one:

  A. M_DATABASE

  B. M_HOST_INFORMATION

  C. M_VERSION_MEMORY

  D. M_LANDSCAPE_HOST_CONFIGURATION

  Correct Answer: A

• Question 167:

  When you install SAP HANA, which of the following disk size requirements apply? There are 2 correct answers to this question.

  A. The log volume is at least four times the amount of memory (RAM) of the system.

  B. The log volume equals the amount of memory (RAM) of the system.

  C. The data volume equals the amount of memory (RAM) of the system.

  D. The data volume is at least four times the amount of memory (RAM) of the system.

  Correct Answer: BD

• Question 168:

  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.

  Choose:

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

  B. Content node SALES schema node Tables folder double-click on the table CUST_DATA

  C. Content node SALES schema node Tables folder simple on the table CUST_DATA Open Definition

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

  Correct Answer: BD

• Question 169:

  How can you find out which SAP HANA parameters have been changed in your system? There are 2 correct answers to this question.

  A. By running the SQL query select * from "PUBLIC"."M_CONFIGURATION" where options != 'DEFAULT'

  B. By checking the indexserver trace file covering the last system startup.

  C. By checking the configuration tab of the Administration Console in SAP HANA studio

  D. By running the SQL query select * from "PUBLIC"."M_INIFILE_CONTENTS" where layer_name != 'DEFAULT'

  Correct Answer: CD

• Question 170:

  Which of the following tools can you use to create and manage SAP HANA database users? There are 2 correct answers to this question.

  A. SAP Solution Manager

  B. Microsoft Active Directory

  C. SAP Netweaver Identity Management

  D. hdbsql

  Correct Answer: CD