EnterpriseDB PostgreSQL-Essentials Exam - Topic 6 Question 1 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam

Question #: 1
Topic #: 6

[All PostgreSQL-Essentials Questions]

You need to take a backup of only the edbuser schema from the edbstore database. Which pg_dump option should you use?

A-s edbuser

B-n edbuser

C--schema edbuser

DBoth B and C

Show Suggested Answer

Suggested Answer: D

by Kenneth at Nov 25, 2025, 11:57 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Elden

9 hours ago

Wait, is -s even a valid option?

upvoted 0 times

...

Leonida

6 days ago

I agree, D makes the most sense!

upvoted 0 times

...

Deonna

11 days ago

Haha, I bet the exam writers are trying to trick us with these options!

upvoted 0 times

...

Paz

16 days ago

B is too simple, C is more specific. I'll go with D.

upvoted 0 times

...

Vicky

21 days ago

I'd go with D. Seems like the most comprehensive choice.

upvoted 0 times

...

Dorothy

26 days ago

Option C looks good to me.

upvoted 0 times

...

Ressie

1 month ago

I'm leaning towards D because it seems like both B and C would work for the schema backup, but I can't recall the exact details.

upvoted 0 times

...

Lindsay

1 month ago

I feel like I might be mixing up the options, but I think -s is for something else, maybe just for structure?

upvoted 0 times

...

Laurel

1 month ago

I remember practicing a similar question, and I think both -n and --schema do the same thing for schema backups.

upvoted 0 times

...

Marsha

2 months ago

I'm leaning towards B, but I'm not 100% sure. I'll need to think this through carefully and review the pg_dump options before making my final decision.

upvoted 0 times

...

Emerson

2 months ago

I'm pretty confident that C is the right answer here. The question is specifically asking about backing up a schema, so the --schema option seems like the way to go.

upvoted 0 times

...

Carin

2 months ago

Option D looks good to me. Using both the -n and --schema flags should give me the flexibility to target just the edbuser schema.

upvoted 0 times

...

Nobuko

2 months ago

I think the answer is D, both B and C.

upvoted 0 times

...

Daniel

2 months ago

I think it's B. -n edbuser is clear.

upvoted 0 times

...

Kimberely

2 months ago

I think the option for backing up a specific schema is related to the -n flag, but I'm not entirely sure if it's just that one.

upvoted 0 times

...

Richelle

3 months ago

B is the standard option for schema.

upvoted 0 times

...

Trinidad

3 months ago

Option D is the way to go. Can't go wrong with that one.

upvoted 0 times

...

Theron

3 months ago

Hmm, I'm a bit confused. I'm not sure if I should use -n or --schema. I'll need to double-check the pg_dump documentation to make sure I get this right.

upvoted 0 times

...

Honey

3 months ago

I think I'd go with option C. That seems like the most straightforward way to just back up the edbuser schema.

upvoted 0 times

...