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

Where is SDI used? There are 2 correct answers to this question.

• Data transformation
  
• Data cleansing
  
• Data streaming
  
• For data loading
  

Which database objects can you manipulate if you have the ALL PRIVILEGES activity? There are 2 correct answers to this question.

• Procedures
  
• Sequences
  
• Tables
  
• Views
  

Which characteristics describe an SAP HANA Multiple Database Container (MDC) System?There are 3 correct answers to this question.

• Each tenant database runs its own compile server and the preprocessor server.
  
• Database Isolation increases the isolation between tenant databases on the operating system level.
  
• A Multitenant Database Container system is identified by a single System ID (SID).
  
• The name server owns information about the location of tables and table partitions in databases.
  
• The name server provides index server functionality for the system database.
  

Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to

• Keep all partitions on different hosts.
  
• Keep the number of partitions per table high.
  
• Keep the number of partitioned tables low.
  
• Keep the number of key columns low.
  

In which of the following SAP HANA scenarios is it recommended to encrypt communication between the client software and SAP HANA? There are 2 correct answers to this question.

• SAP HANA as a data mart for reporting and analytics.
  
• SAP HANA as a platform for providing database and application services to native SAP HANA-based applications.
  
• SAP HANA as a classic three-tier architecture as the primary database (for example. SAP NetWeaver Business Warehouse, SAP Business Suite Installation).
  

Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer.

• The SYSTEM user of the tenant database
  
• The user who created the role
  
• The _SYS_REPO technical user
  
• The container-specific technical user
  

Which SUM database migration option utility do you use to check and monitor table splitting?

• R3ta
  
• Log tail Viewer
  
• Table comparison
  
• R3load utilization
  

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
  

Which operating system process takes care of starting the SAP HANA database system services?Please choose the correct answer.

• hdbrsutil
  
• hdbdaemon
  
• apstartsrv
  
• sapstart
  

Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question.

• To generate indexes for the column store
  
• To persist in-memory data
  
• To enable data recovery if the power fails
  
• To allow row store operations