SAP C_HANATEC_17 Online Practice Questions and Exam Preparation

SAP C_HANATEC_17 Online Questions & Answers

• Question 241:

  In which circumstances do you create a column store table? There are 3 correct answers to this question.

  A. When the calculations are based on a small number of columns
  B. When aggregations or fast search is required
  C. When accessing complete records
  D. When the table has a large number of columns
  A. When the calculations are based on a small number of columns
  B. When aggregations or fast search is required
  D. When the table has a large number of columns

• Question 242:

  Your SAP HANA system CANNOT be reached by SQL. You need to check all connections, transactions, and blocked transactions to understand the root cause. Which system service do you use to collect the information? Please choose the

  correct answer.

  Response:

  A. daemon
  B. sapstartsrv
  C. preprocessor
  D. nameserver
  B. sapstartsrv

• Question 243:

  you need to integrate an existing SAP HANA 2.0 SPS02 database system into SAP HANA cockpit monitor infrastructure where do you create the technical user created for the resource registration Please choose the correct answer Response:

  A. in the first tenant
  B. in the SYSTEMDB and the first tenant
  C. in the SYSTEMDB and the all tenant
  D. in the SYSTEMDB
  C. in the SYSTEMDB and the all tenant

• Question 244:

  Which software components do you download to prepare the database migration option? There are 2 correct answers to this question. Response:

  A. SPAM/SAINT
  B. SAP Host Agent
  C. SAPUI5
  D. SAP GUI
  A. SPAM/SAINT
  B. SAP Host Agent

• Question 245:

  What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question.

  A. Kernel settings
  B. Network configuration
  C. Memory configuration
  D. Missing OS patches
  A. Kernel settings
  C. Memory configuration

• Question 246:

  You need to reset the database migration option (DMO) procedure due to a hardware failure. What are the prerequisites if you want to use the DMO reset procedure? There are 2 correct answers to this question Response:

  A. The source database needs to be available.
  B. The SUM folder needs to exist.
  C. The before-downtime backup needs to be available.
  D. The cleanup procedure needs to be performed.
  A. The source database needs to be available.
  B. The SUM folder needs to exist.

• Question 247:

  In the Aggregate Health Monitor application, you are viewing the overall status of all tenants assigned to your SAP HANA cockpit user.

  Which user retrieves this database status information? Please choose the correct answer.

  Response:

  A. A named user with monitor permissions
  B. The system user
  C. The cockpit_admin user
  D. A technical user with limited permissions
  D. A technical user with limited permissions

• Question 248:

  To maintain good read performance in a constantly changing database, which two components are used?

  There are 2 correct answers to this question.

  Response:

  A. Column store
  B. Memory store
  C. Delta storage
  D. Main storage
  C. Delta storage
  D. Main storage

• Question 249:

  Why would you implement the SAP HANA Data Warehousing Foundation? Please choose the correct answer. Response:

  A. To add OLAP data warehousing capabilities to SAP HANA
  B. To implement a SQL-driven approach to data warehousing
  C. To improve the loading and reporting performance of SAP Business Warehouse
  D. To enable reporting on SAP HANA data using the full suite of SAP BusinessObjects
  B. To implement a SQL-driven approach to data warehousing

• Question 250:

  SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems? Please choose the correct answer.

  A. A restart of the primary system
  B. A restart of the secondary system
  C. An upgrade of the secondary system
  D. An upgrade of the primary system
  D. An upgrade of the primary system