SAP Certified Technology Associate - SAP HANA (Edition 2015)

QUESTION NO: 1
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?

A. Create a filter on an attribute B. Assign the analytic privilege to the users C. Select an attribute and define restricted values for it D. Create an analytic privilege E. Assign a package privilege to the users

Correct Answer: B,C,D

QUESTION NO: 2
Which of the following privileges are mandatory for the initial user to configure SAP LT to populate the SAP HANA
database?
There are 2 correct answers to this question.

A. EXECUTE of REPOSITORY_REST(SYS) B. CREATE ANY in _SYS_BIC schema C. ROLE_ADMIN D. SELECT on SYS_REPL.RS_REPLICATION_COMPONENTS with grant option

Correct Answer: C,D

QUESTION NO: 3
Which component of SAP HANA Database is used when you query an SAP HANA information model to populate a
pivot table in Microsoft Excel?

A. The SQL Interface B. The Transaction Manager C. The Log Volumes D. The Calculation Engine

Correct Answer: D

QUESTION NO: 4
Which of the following are allowed to be written to the disk space for the data volumes in an SAP HANA system?

A. Data exports B. Log files C. Runtime dump files D. Backup data files

Correct Answer: A,C

QUESTION NO: 5
Which of the following template roles allows a user who has been assigned this role to grant the privileges of this role
to other users?

A. MONITORING B. CONTENT_ADMIN C. PUBLIC D. MODELING

Correct Answer: B

QUESTION NO: 6
What is the recommended approach by SAP when loading tables into SAP HANA from SAP ERP via Data Services?

A. Use the data staging server B. Use the Replication Server C. Use the ABAP application tier D. Use open hub

Correct Answer: C

QUESTION NO: 7
Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)?

A. Decluster table classes into a transparent format. B. Ensure that replicated changes are kept within the logging tables. C. Include only relevant tables for DB recording. D. Record relevant changes in logging tables.

Correct Answer: A,C

QUESTION NO: 8
The log volume is full and the SAP HANA database does not accept any new requests.
How can you solve this problem and bring the SAP HANA database online?

A. Move the log files to another volume and create a symbolic link to the new folder. B. Set the log_mode parameter to overwrite in global.ini. C. Delete older log files from the log volume before the last successful database backup. D. Run "Delete older backups" in the Backup Catalog.

Correct Answer: A

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

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

Correct Answer: D

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

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

Correct Answer: D

QUESTION NO: 11
You have to size an SAP HANA system for SAP NetWeaver BW. The SAP NetWeaver BW system is currently running on
a non-SAP RDBMS.
Which of the following factors influences the size of the SAP HANA system?

A. The number of tables in the row store B. The number of indexes C. The partitioning of tables D. The size of aggregates

Correct Answer: A

QUESTION NO: 12
Which of the following configuration files contains the backup locations of log and data files?

A. localclient.ini B. attributes.ini C. global.ini D. indexserver.ini

Correct Answer: C

SAP Certified Technology Associate - SAP HANA (Edition 2015) - C-HANATEC151 Exam Questions