You need to restore only the schema from a custom format backup file. Which pg_restore option should you use?
Suggested Answer: D
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
LA
Lanie
1 month ago
What about D? Both B and C could be right.
LA
Lashandra
1 month ago
I agree, B makes sense for schema restoration.
AR
Arleen
1 month ago
I think it's B, --schema-only.
ST
Stephanie
2 months ago
I thought it was A) --data-only at first.
LA
Lauran
2 months ago
I agree with Richelle, B is the way to go!
DE
Deeanna
2 months ago
Wait, is it really just B? Sounds too simple.
NO
Novella
2 months ago
I think D) Both B and C makes sense too!
RI
Richelle
2 months ago
Definitely B) --schema-only.
SH
Sheron
2 months ago
I’m leaning towards D because it seems like both B and C could be correct for restoring the schema.
VA
Valentin
3 months ago
I feel like I might confuse the data-only and schema-only options. Wasn't there a question that had similar choices?
EL
Eleonore
3 months ago
I remember practicing a question about pg_restore options, and I think both B and C refer to schema-only restoration.
SO
Son
3 months ago
I think the option for restoring just the schema is --schema-only, but I'm not completely sure.