Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

EnterpriseDB PostgreSQL-Essentials Exam - Topic 9 Question 16 Discussion

You want to take a data-only dump of the edbstore database, disable all triggers for faster restore, and use the INSERT command instead of COPY. Which pg_dump command options should you use?
A) -a --inserts --disable-triggers
B) -d --inserts --disable-triggers
C) --data-only --inserts
D) -a --copy --disable-triggers

EnterpriseDB PostgreSQL-Essentials Exam - Topic 9 Question 16 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam
Question #: 16
Topic #: 9
[All PostgreSQL-Essentials Questions]

You want to take a data-only dump of the edbstore database, disable all triggers for faster restore, and use the INSERT command instead of COPY. Which pg_dump command options should you use?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Owen at Jun 21, 2026, 02:33 PM

Limited Time Offer

25%

Off

Get Premium PostgreSQL-Essentials Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Julio
3 days ago
I agree with Tom. C makes the most sense for this scenario.
upvoted 0 times
...
Shaunna
8 days ago
I feel like C is the best choice. It specifies data-only and inserts.
upvoted 0 times
...
Winifred
14 days ago
I think the answer is A. It covers everything needed.
upvoted 0 times
...
Katheryn
19 days ago
B) doesn't seem right, you need -a for data-only.
upvoted 0 times
...
Flo
24 days ago
Wait, why use INSERT instead of COPY? Seems odd.
upvoted 0 times
...
Darci
29 days ago
Totally agree with A! Fast and efficient.
upvoted 0 times
...
Ben
1 month ago
I think C) --data-only --inserts makes more sense.
upvoted 0 times
...
Altha
1 month ago
A) -a --inserts --disable-triggers is the way to go!
upvoted 0 times
...
Kattie
1 month ago
I’m leaning towards option A because it has both --inserts and --disable-triggers, but I’m not completely confident about the data-only part.
upvoted 0 times
...
Della
2 months ago
I feel like the INSERT command is important here, so it must be --inserts, but I can't recall if it goes with -a or something else.
upvoted 0 times
...
Leila
2 months ago
I remember practicing a similar question where we had to disable triggers, so I think --disable-triggers is definitely needed.
upvoted 0 times
...
Aretha
2 months ago
I think the command should include the data-only option, but I’m not sure if it’s --data-only or just -a.
upvoted 0 times
...

Save Cancel