Free C_HANATEC_17 Sample Questions — SAP Certified Technology Associate - SAP HANA 2.0 SPS05

Free C_HANATEC_17 sample questions for the SAP Certified Technology Associate - SAP HANA 2.0 SPS05 exam. No account required: study at your own pace.

Want an interactive quiz? Take the full C_HANATEC_17 practice test

Looking for more? Click here to get the full PDF with 38+ practice questions for $5 for offline study and deeper preparation.

Question 1

Which schema provides performance data and alert details to review in SAP HANA mini-checks?

  • A. SAP_XS_USAGE
  • B. COCKPIT_MONITOR
  • C. _SYS_SQL_ANALYZER
  • D. _SYS_STATISTICS
Show Answer
Correct Answer:
D. _SYS_STATISTICS
Question 2

How can you ensure that a consistent database status is saved using data snapshots?

  • A. Trigger a savepoint
  • B. Execute the hdbbackupdiag tool
  • C. Create an internal database snapshot
  • D. Create a fallback snapshot
Show Answer
Correct Answer:
C. Create an internal database snapshot
Question 3

Which technology is utilized by the Performance Warehouse option in the transaction DBACOCKPIT?

  • A. SAP Business Intelligence
  • B. SAP Data Warehouse Cloud
  • C. SAP Intelligent Query (SAP IQ)
  • D. SAP Analytics Cloud
Show Answer
Correct Answer:
A. SAP Business Intelligence
Question 4

Which system usage types are automatically assigned to tiles in the SAP HANA cockpit? (Choose three.)

  • A. Quality assurance
  • B. Development
  • C. Production
  • D. Custom
  • E. Test
Show Answer
Correct Answer:
  • B. Development
  • C. Production
  • E. Test
Question 5

Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure? (Choose two.)

  • A. cleanup has already been triggered
  • B. The SUM folder needs to exist
  • C. The DMO procedure hasn’t reached downtime yet
  • D. The source database is up and running
Show Answer
Correct Answer:
  • B. The SUM folder needs to exist
  • C. The DMO procedure hasn’t reached downtime yet
Question 6

Which file system locations do you need to specify when installing the SAP HANA multi-host database system using the default settings? (Choose two.)

  • A. /usr/sap/<SID>
  • B. /hana/shared
  • C. /hana/log/<SID>
  • D. /usr/sap/hostctrl
Show Answer
Correct Answer:
  • B. /hana/shared
  • C. /hana/log/<SID>
Question 7

When performing a standard SAP HANA database system installation, which users will be created or validated during that installation? (Choose two.)

  • A. SYSTEM
  • B. sapadm
  • C. SAP<SID>
  • D. <sid>crypt
Show Answer
Correct Answer:
  • A. SYSTEM
  • B. sapadm
Question 8

Which tool shows you information about the list of tablets to be pre-loaded during an SAP HANA system start?

  • A. HDBAdmin
  • B. hdbcons
  • C. sapcontrol
  • D. RecoverStateChecker.py
Show Answer
Correct Answer:
B. hdbcons
Question 9

What additional action do you need to perform after you create a new tenant in an SAP HANA system replication configuration?

  • A. Start the tenant database
  • B. Copy the tenant database
  • C. Back up the tenant database
  • D. Restart the secondary system
Show Answer
Correct Answer:
C. Back up the tenant database
Question 10

In which situations can you resume the failed recovery of your productive SAP HANA tenant database? (Choose two.)

  • A. An aborted recovery of the configuration files
  • B. An aborted recovery of a delta data backup
  • C. An aborted recovery of a log backup
  • D. An aborted recovery of a complete data backup
Show Answer
Correct Answer:
  • B. An aborted recovery of a delta data backup
  • C. An aborted recovery of a log backup

Aced these? Get the Full Exam

Download the complete C_HANATEC_17 study bundle with 38+ questions in a single printable PDF.

Purchase Full Exam PDF | $5