MENU
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?
Suggested Answer: A
Get Premium PostgreSQL-Essentials Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
JU
Julio
2 months ago
I agree with Tom. C makes the most sense for this scenario.
SH
Shaunna
2 months ago
I feel like C is the best choice. It specifies data-only and inserts.
WI
Winifred
2 months ago
I think the answer is A. It covers everything needed.
KA
Katheryn
2 months ago
B) doesn't seem right, you need -a for data-only.
FL
Flo
2 months ago
Wait, why use INSERT instead of COPY? Seems odd.
DA
Darci
2 months ago
Totally agree with A! Fast and efficient.
BE
Ben
3 months ago
I think C) --data-only --inserts makes more sense.
AL
Altha
3 months ago
A) -a --inserts --disable-triggers is the way to go!
KA
Kattie
3 months 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.
DE
Della
3 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.
LE
Leila
3 months ago
I remember practicing a similar question where we had to disable triggers, so I think --disable-triggers is definitely needed.
AR
Aretha
4 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.