Free SAP Certified Technology Associate – SAP HANA 2.0 SPS05 Exam C_HANATEC_17 Exam Practice Test

The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.

• The role name
  
• The privileges assigned to the role
  
• The users assigned to the role
  
• The users assigned by default to this role
  

USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards. What happens if you drop USER B from the HANA database?

• The privilege remains assigned to both USER A and USER C.
  
• The privilege is revoked from USER A, but not USER C.
  
• The privilege is revoked from both USER A and USER C.
  
• The privilege is revoked from USER C, but not USER A.
  

What cryptographic libraries are supported in SAP HANA by default?There are 2 correct answers to this question.

• LibgCrypt
  
• OpenSSL
  
• Common Cryptolib
  
• WolfCrypt
  

Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with the read-enabled mode? Note: There are 2 correct answers.

• The same number of active hosts and standby hosts must be installed
  
• Both must have the same SAP HANA version
  
• An explicit read-only connection between both systems must be available
  
• The CPU architecture must be identical
  

Why do we still need a persistent layer? There are 2 correct answers to this question.

• To store data that has been unloaded from memory
  
• To enable full database recovery if we have a power failure
  
• To hold the delta store for newly arrived records
  
• To store data that is frequently used
  

The SAP HANA database is NOT reachable, and the root cause is unclear. Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.

• Troubleshoot unresponsive system
  
• Overall database status
  
• Manage full system information dumps
  
• Open blocked transactions
  

Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.

• Admission control
  
• Capture and replay
  
• Thread throttling
  
• Workload classes
  

Which connections do you need to enable explicitly for a Restricted user?There are 2 correct answers to this question.

• ODBC
  
• JDBC
  
• OLEDB
  
• ADO.NET
  

What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping Note: There are 2 correct answers.

• Takeover time is shorter
  
• CPU load is reduced
  
• Network traffic is reduced
  
• Memory consumption is lower
  

What is the correct sequence of the following four steps in the restart of the SAP HANA database system? Please choose the correct answer.

• Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded.
  
• Aborted transactions are rolled back.
  
• Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded.
  
• Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back.
  
• Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded.