SAP Certified Technology Associate - SAP HANA (Edition 2015) - C_HANATEC151 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which of the following can be done by the SAP HANA lifecycle manager?

A. Copy an SAP HANA system B. Add an additional SAP HANA system C. Uninstall an SAP HANA system D. Rename an SAP HANA system E. Change the SAP HANA license type

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 2

You develop a disaster recovery plan. What do you have to ensure in case of a disk failure?

A. Committed transactions can be recovered B. Save points can be backed up C. Non-committed transactions can be recovered D. Configuration files can be restored automatically E. Log volumes can be backed up

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 3

Which of the following can you use to analyze an expensive SQL statement?
There are 2 correct answers to this question.

A. Open the Plan Explanation. B. Open the SQL Plan Cache. C. Open the hdbcons tool. D. Open the Plan Visualizer.

Discussion 0

Correct Answer: A,D Vote an answer

Question 4

Which of the following URLs do you define for Software Update Manager?

A. https://<host>:8443/studio_repository/ B. https://<host>:8444/studio_repository/ C. http://:8444/studio_repository/ D. http://:8443/studio_repository/

Discussion 0

Correct Answer: A Vote an answer

Question 5

A user is locked due to too many failed logon attempts.
Which SQL command can solve this problem?

A. ALTER USER <user_name> ACCOUNT UNLOCK B. ALTER USER <user_name> DROP CONNECT ATTEMPTS C. ALTER USER <username> FORCE PASSWORD CHANGE AFTER ATTEMPTS D. ALTER USER <username> RESET CONNECT ATTEMPTS

Discussion 0

Correct Answer: D Vote an answer

Question 6

You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have
been executed in parallel and for how long each of them has been active.
Where can you accomplish this?

A. In SAP HANA studio: Administration Console -> Performance -> Job Progress B. In SAP NetWeaver: DBA Cockpit (DBACOCKPIT) -> SQL Plan Cache -> EXPLAIN (graphically) C. In SAP HANA studio: Display the Timeline view via Window -> Show View -> Other ... -> Plan Visualizer -> Timeline D. In HDB admin -> Performance trace -> Show Column Plans

Discussion 0

Correct Answer: C Vote an answer

Question 7

Which of the following Kerberos implementations is supported for single sign-on in SAP HANA?

A. MIT's Kerberos Network Authentication Protocol B. "Advanced Encryption Standard (AES) Encryption for Kerberos 5" on HP-UX C. Windows Active Directory Domain Kerberos implementation D. Red Hat Linux version 4 and later Kerberos implementation

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

Which of the following tools can you use to create and manage SAP HANA database users?

A. hdbsql B. SAP Netweaver Identity Management C. Microsoft Active Directory D. SAP Solution Manager

Discussion 0

Correct Answer: A,B Vote an answer

Question 9

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

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

Discussion 0

Correct Answer: A Vote an answer

Question 10

Which of the following situations can trigger a delta merge?

A. The number of records in the main storage exceeds a limit. B. A pre-defined time of day has arrived. C. The memory consumption of the delta storage exceeds a limit. D. An SQL statement must read merged data.

Discussion 0

Correct Answer: C Vote an answer

Question 11

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.

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 Definition C. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Content D. Content node SALES schema node Tables folder double-click on the table CUST_DATA

Discussion 0

Correct Answer: B,D Vote an answer

Question 12

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

A. Allow modeling only on the SAP HANA development system and export/import the models to the productive
system. B. Remove ALTER SYSTEM in the system privileges for the modeling users. C. Use randomized data for the development of data models. D. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.

Discussion 0

Correct Answer: A,C Vote an answer

Question 13

In the SAP HANA studio, where can you check the throughput performance of SAP HANA backups?

A. Administration Console Diagnosis files Backup.log B. Administration Console Performance Job Progress C. Backup Editor Backup Catalog Backup Details D. System Information Database Information

Discussion 0

Correct Answer: C Vote an answer

Question 14

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

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

Discussion 0

Correct Answer: B Vote an answer

Question 15

Which of the following are pre-delivered template roles?

A. MODELING B. SAP_INTERNAL_HANA_SUPPORT C. HANA_ADMIN D. MONITORING

Discussion 0

Correct Answer: A,D Vote an answer