Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

HANA 1 > HANA Backup and Recovery/HA > Flashcards

HANA Backup and Recovery/HA Flashcards

1
Q

The data storage of your productive SAP HANA instance crashed and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old. To which point in time can you recover to minimize the data losee

A

The last committed transaction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which of the below component in HANA system architecture ensures database is restored to most recent state and ensures that all the transactions are completed

A

Persistence layer (The database persistence layer is responsible for durability and atomicity of transactions. It ensures that the database can be restored to the most recent committed state after a restart and that transactions are either completely executed or completely undone.)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the types of data backups supported for the SAP HANA database

A

Full online backup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which can trigger data backups

A
  1. DBACockpit
  2. HDBsql
  3. SAP HANA Cockpit
  4. SAP HANA studio
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which of the following statements describe characteristics of the save point

A

The save point write a complete database image to persistent storage and one purpose of performing savepoint is to speed up restart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A customer needs help with determining what recovery files are needed to initiate a point in time recovery to the previous day at 12pm. What can you use to find the files that are required to recover to this point in time

A

Hdbbackupdiag

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Set the savepoint interval to a lower value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which type of log mode is recommended for production systems

A

Normal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Required system privilege’s for backup related tasks or view

A

BACKUP_ADMIN

CATALOG_READ

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which host has no backup data or log files in a scale out system

A

Stand-By

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Out of all the services offered and used by SAP HANA, which two have their own persistence

A

DATA

LOG

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

In the DBACOCKPIT for HANA what can you not see

A

The triggers for the Backup to happen

The current status of the Background job being used to complete the backup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which index server doesnt have own persistence

A

Standby

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Log backups contain the information stored in the log segments in the log area and should be backed up to an external location automatically in a production environment. What are log backups required for

A
  1. To roll forward committed transactions to ensure no data loss since the last successful backup.
  2. To free up space in the file system that contains the log volumes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

When you make changes to a table the logs are written to log buffers in memory. These need to be persisted to disk in the log volume. Which of the following are true in relation to this process

A

Log buffers are written to log segments when a commit entry is written and when a log buffer is full

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A customer needs help with determining what recovery files are needed to initiate a point in time recovery to the previous day at 12pm. What can you use to find the files that are required to recover to this particular point in time

A

HDBbackupdiag

17
Q

While discussing a customers high availability solution they inform you about their defined KPI values for RPO and RTO. In respect of both these KPIs what do you understand of them

A

RTO refers to the amount of time for a system to recover from an outage
RPO refers to the maximum amount of time in which data loss can occur during an outage

18
Q

Node 3 crashes in a scale out system with a configuration of 1 master node, 3 slave nodes and 1 standby node. A failure is triggered and the standby node takes over from node 3. What were the sequence of events that lead to the discovery of the crashed host and the automatic host failover

A

Both the name server and the daemon of the crashed host failed to reply to pings from the master name server

19
Q

A HANA database is configured with system replication between a primary and secondary system. The secondary system has become unavailable and as a result the primary system has become blocked unti the secondary system is once again available. What replication mode be configured

A

Synchronous full sync

20
Q

A customer implements system replication between primary and secondary systems. They wish to preload the column store tables on the secondary and ask about the pros and cons of this option. Select 1 pro and con

A

Pro- Shorter performance ramp up in case of takeover

Con - Higher memory consumption reduces the likelihood of running non-production systems on the secondary

21
Q

What recommended procedure to backup the content of customer specific configuration files

A

Backup the files manually by copying them to an external directory

HANA 1 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions