SAP SAP Certifications C_HANATEC_12 Questions & Answers

• Question 71:

  Which of the following files should be considered in your SAP HANA backup strategy? (Choose three.)

  A. Dump files

  B. Export and import files

  C. Data and log files

  D. Kernel files

  E. Configuration files

  Correct Answer: CDE

• Question 72:

  You want to update a productive SAP HANA system to the next support package stack (SPS). What are the prerequisites? (Choose two.)

  A. You performed a backup of the system.

  B. You applied the new license key for the new SPS

  C. You planned a business downtime for the system.

  D. You prepared the data and log area in the file system

  E. You know the adm password.

  Correct Answer: BD

• Question 73:

  Which of the following situations can trigger a delta merge?

  A. The memory consumption of the delta storage exceeds a limit

  B. The number of records in the main storage exceeds a limit

  C. An SQL statement must read merged data

  D. A pre-defined time of day has arrived

  Correct Answer: A

• Question 74:

  A company is planning to upgrade from an SAP HANA platform license to an SAP HANA enterprise license.

  Which additional component will be provided?

  A. Database for SAP NetWeaver BW

  B. XS application development

  C. SAP Sybase ASE

  D. Data replication

  Correct Answer: D

• Question 75:

  Which of the following are required to monitor SAP HANA in SAP Solution Manager? (Choose two.)

  A. Host agent running on SAP HANA

  B. Host agent running on SAP Solution Manager

  C. SMD agent running on SAP Solution Manger

  D. SMD agent running on SAP HANA

  Correct Answer: AD

• Question 76:

  Which user must have SELECT privilege with the grant option on the data schema?

  A. _SYS_BIC

  B. _SYS_REPO

  C. SYSTEM

  D. ADM

  Correct Answer: B

• Question 77:

  You have to create an SAP HANA architecture that meets the following requirements:

  -

  Data provisioning is performed in batch mode,

  -

  Data transformation is performed during the load step,

  -

  Reporting is run using analytic data models.

  Which of the following scenarios would you implement?

  A.

  An agile data mart

  B.

  SAP HANA as application platform

  C.

  An operational data mart

  D.

  An SAP HANA accelerator

  Correct Answer: A

• Question 78:

  Which of the following prerequisites must be met before you can install the SAP HANA studio on a Linux operating system? (Choose two.)

  A. You are logged on as the root user.

  B. The installation directory has at least 10 GB of free space.

  C. The Java runtime is accessible via the PATH or JAVA_HOME variable.

  D. You are logged on as the adm user.

  Correct Answer: AC

• Question 79:

  How can you delete old data and log backups from both the backup catalog and physically from the server?

  A. Run ''DELETE from m_backup_catalog_files where backup_id = '' in the SQL editor

  B. Delete all files under $(DIR_GLOBAL)/hdb/log

  C. Delete all files under $(DIR_INSTANCE)/backup/data and $(DIR_INSTANCE)/backup/log

  D. Go to Backup Editor -> Backup Catalog -> Delete Older Backups -> Catalog and backup location

  Correct Answer: D

• Question 80:

  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

  Correct Answer: A