Test 1 Questions - C_HANATEC_12

1. What connection type does the SAP Hana direct Extractor connection (DXC) used to transfer data to SAP Hana?
Please choose the correct answer.
Choose one:
o HTTP connection
o BICS connection
o secondary database connection
o ODBO connection



2. What situation can Trigger Delta merge?
Please choose the correct answer.
Choose one:
o The memory consumption of The Delta storage exceeds a limit
o An SQL statement reads data from the Delta storage
o A predefined time of day is reached
o The number of records in the main storage exceeds a limit

3. Which technologies use trigger-based replication?
There are 2 correct answers to this question.
Choose 2:
 Standard SQL database replication
 Near Zero Downtime
 Test Data Migration Server (TDMS)
 TREX engine
 ABAP extractors

4. In the SAP HANA studio, to which of the following does the loading status "partially" refer?
Please choose the correct answer.
Choose one:
o To a row store table of which only some rows are loaded
o To a column store table that is loaded in delta storage
o To a row store table that is loaded in delta storage
o To a column store table of which only some columns are loaded

5. When you try to stop SAP HANA using the sapcontrol command, you receive the error message. "Command not found".
What is the reason for the error?
Please choose the correct answer.
Choose one:
o The host agent is not installed.
o The SAP HANA database is not installed.
o SAP SUM is not installed.
o The SAP HANA client is not installed.

6. To start SAP HANA System after the installation has finished successfully, which of the following command is correct by using sapcontrol program.
Please choose the correct answer.
Choose one:
o /usr/hana/hostctrl/exe/sapcontrol -nr -function Start
o /usr/sap/hostctrl/exe/hanacontrol -nr -function Start
o /usr/sap/hostctrl/exe/sapcontrol -nr -function Start
o /usr/sap/hostctrl/ini/sapcontrol -nr -function Start


7. Which of the following steps allow you to create a test system (system A) based on a productive SAP HANA standalone system (system B)?
There are 2 correct answers to this question.
Choose 2:
o Copy a snapshot from system B to system A.
o Export the data from system B to a file share and import the data to system A.
o Copy the data and log volume files from system B to system A.
o Restore a complete database backup from system B to system A.

8. What happens when an SAP Hana system is restarted?
There are 2 correct answers to this question
Choose 2:
 All row tables are loaded into the memory except the row table that are configured to be loaded on demand
Tables and table attributes that are marked for preload are loaded into the memory synchronously
 All row tables and row table attributes are loaded into the memory
 Column tables and column table attributes that were loaded before the restart reloaded into the memory asynchronously

9. Which of the following can you use to update SAP HANA (SPS06)?
Please choose the correct answer.
Choose one:
o SAP HANA update wizard
o SAP HANA on-site configuration tool
o Software update manager (SUM) for SAP HANA
o SAP HANA lifecycle manager

10. Which component is installed on each node when you install an SAP HANA scale-out systems?
Please choose the correct answer.
Choose one:
o SAP host agent
o SAP statistics service
o SAP Hana client
o SAP SMD agent

11. 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?
Please choose the correct answer.
Choose one:
o Package privileges
o SQL privileges
o System privileges
o Analytic privileges

12. Which of the following SAP HANA tools is used to collect diagnostic information?
Please choose the correct answer.
Choose one:
o landscapeHostConfiguration.py
o fullSystemInfoDump.py
o Hdbnsutil
o Hdbsql

.