PAS-C01 Operations and Maintenance Practice Question
A company runs an SAP HANA database on an EC2 instance with EBS volumes. The operations team needs to ensure that snapshots of the database volumes are consistent. Which step should be taken before initiating the EBS snapshot?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use hdbsql to execute BACKUP DATA FULL USING FILE ('/backup/snapshot_prep')
Running hdbsql with BACKUP DATA and USING FILE creates a snapshot-consistent backup. Option B is wrong because 'sync' only flushes OS buffers but does not guarantee HANA consistency. Option C is wrong because stopping HANA is excessive. Option D is wrong because EBS snapshots alone do not ensure application consistency.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Use hdbsql to execute BACKUP DATA FULL USING FILE ('/backup/snapshot_prep')
Why this is correct
This command prepares HANA for a snapshot-consistent backup.
- ✗
Run the Linux 'sync' command on the instance
Why it's wrong here
The sync command only flushes file system buffers, not HANA-specific consistency.
- ✗
Stop the HANA database service
Why it's wrong here
Stopping the database is not required and causes downtime.
- ✗
Create the EBS snapshot directly without any preparation
Why it's wrong here
Direct snapshots may be crash-consistent, not application-consistent.
Go deeper
Related to this question
About these practice questions
One of 1,616 original PAS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PAS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PAS-C01 exam.