Hana

10 Questions | By Zhan.lee.m | Updated: Nov 16, 2017 | Attempts: 224

Questions

Settings

Create your own Quiz

Questions and Answers

1.

You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database.From which location does the Recover Database app read the recovery information by default?
- A.
  
  $(DIR_INSTANCE)/../global/hdb/custom/config
- B.
  
  $(DIR_INSTANCE)/backup/log
- C.
  
  $(DIR_INSTANCE)//trace
- D.
  
  $(DIR_INSTANCE)/backup/data
Correct Answer
B. $(DIR_INSTANCE)/backup/log
2.

What can you do to shorten the startup time of an SAP HANA system after a reboot?
- A.
  
  Set the preload column value in the Tables system table to FULL.
- B.
  
  Flag all columnar tables for preload.
- C.
  
  Set the savepoint interval to a lower value.
- D.
  
  Partition the row store across nodes.
Correct Answer
C. Set the savepoint interval to a lower value.
3.

Which of the following traces is active after the SAP HANA installation is completed?
- A.
  
  SQL
- B.
  
  Plan
- C.
  
  Performance
- D.
  
  Database
Correct Answer
D. Database
4.

Which prerequisites must be met to set up high availability for a distributed SAP HANA system?Note: There are 2 correct answers to this question.
- A.
  
  The column tables were assigned to an index server manually.
- B.
  
  The name server is started on all nodes.
- C.
  
  The synchronized backup savepoint is set.
- D.
  
  The shared storage is connected to every host.
Correct Answer(s)
B. The name server is started on all nodes.
D. The shared storage is connected to every host.
5.

Which security settings can you monitor in SAP HANA cockpit 2.0?
- A.
  
  Data Storage Security
- B.
  
  Password Policy
- C.
  
  Manage Database Backups
- D.
  
  Manage Users
Correct Answer(s)
A. Data Storage Security
B. Password Policy
6.

You are monitoring the application server of an SAP S/4 HANA system. You need to investigate on the SAP HANA database, but someone locked your personal SAP HANA user.Which tools can you use to execute an SQL query?Note: There are 2 correct answers to this question.
- A.
  
  SQL Command Editor of the DBA Cockpit on the application server
- B.
  
  SAP HANA studio on the SAP HANA server
- C.
  
  HDBSQL command line tool on the SAP HANA server
- D.
  
  SAP HANA cockpit 2.0 on a central server
Correct Answer(s)
A. SQL Command Editor of the DBA Cockpit on the application server
D. SAP HANA cockpit 2.0 on a central server
7.

Which tasks must you perform to convert a single database to a multitenant database system?Note: There are 2 correct answers to this question.
- A.
  
  Set the password for the system database user.
- B.
  
  Trigger the conversion in the SAP HANA cockpit 2.0.
- C.
  
  Generate the system database before the conversion.
- D.
  
  Create an operating system user for the converted tenant database.
Correct Answer(s)
A. Set the password for the system database user.
B. Trigger the conversion in the SAP HANA cockpit 2.0.
8.

You implement a multi-host SAP HANA system with auto-failover capabilities.What are the requirements for the disk storage?Note: There are 2 correct answers to this question.
- A.
  
  The slave node is set to backup standby.
- B.
  
  The failed worker host gets fenced during failover.
- C.
  
  The standby host has file access.
- D.
  
  The master node is fully clustered.
Correct Answer(s)
B. The failed worker host gets fenced during failover.
C. The standby host has file access.
9.

You need to enable single sign-on for SAP HANA with Microsoft Active Directory.Which authentication method allows you to use the Active Directory groups?
- A.
  
  X.509 client certificates
- B.
  
  Security Assertion Markup Language (SAML)
- C.
  
  SAP Logon and assertion tickets
- D.
  
  Kerberos
Correct Answer
D. Kerberos
10.

Your customer sets up an SAP HANA system as tailored datacenter integration (TDI) deployment.What are the enterprise network requirements?Note: There are 2 correct answers to this question.
- A.
  
  8 GbE storage area
- B.
  
  4 GbE fiber channel
- C.
  
  15 GbE internode
- D.
  
  10 GbE backup
Correct Answer(s)
C. 15 GbE internode
D. 10 GbE backup

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Nov 16, 2017

Quiz Edited by
ProProfs Editorial Team
Nov 02, 2017

Quiz Created by
Zhan.lee.m

You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database.From which location does the Recover Database app read the recovery information by default?

What can you do to shorten the startup time of an SAP HANA system after a reboot?

Which of the following traces is active after the SAP HANA installation is completed?

Which prerequisites must be met to set up high availability for a distributed SAP HANA system?Note: There are 2 correct answers to this question.

Which security settings can you monitor in SAP HANA cockpit 2.0?

You are monitoring the application server of an SAP S/4 HANA system. You need to investigate on the SAP HANA database, but someone locked your personal SAP HANA user.Which tools can you use to execute an SQL query?Note: There are 2 correct answers to this question.

Which tasks must you perform to convert a single database to a multitenant database system?Note: There are 2 correct answers to this question.

You implement a multi-host SAP HANA system with auto-failover capabilities.What are the requirements for the disk storage?Note: There are 2 correct answers to this question.

You need to enable single sign-on for SAP HANA with Microsoft Active Directory.Which authentication method allows you to use the Active Directory groups?

Your customer sets up an SAP HANA system as tailored datacenter integration (TDI) deployment.What are the enterprise network requirements?Note: There are 2 correct answers to this question.