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

Marta

2 months ago

I agree with D. Flexibility is good in options.

upvoted 0 times

...

Peter

2 months ago

I feel confused. Why not just use -s?

upvoted 0 times

...

Gwen

2 months ago

D seems right. Both B and C work for schemas.

upvoted 0 times

...

Chaya

2 months ago

I prefer C. --schema edbuser sounds precise.

upvoted 0 times

...

Amina

2 months ago

Definitely B or C, but not sure about D.

upvoted 0 times

...

Della

2 months ago

I thought it was just -n, not both.

upvoted 0 times

...

Elden

3 months ago

Wait, is -s even a valid option?

upvoted 0 times

...

Leonida

3 months ago

I agree, D makes the most sense!

upvoted 0 times

...

Deonna

3 months ago

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

upvoted 0 times

...

Paz

4 months ago

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

upvoted 0 times

...

Vicky

4 months ago

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

upvoted 0 times

...

Dorothy

4 months ago

Option C looks good to me.

upvoted 0 times

...

Ressie

4 months 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

4 months 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

4 months 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

5 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

5 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

5 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

5 months ago

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

upvoted 0 times

...

Daniel

5 months ago

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

upvoted 0 times

...

Kimberely

5 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

6 months ago

B is the standard option for schema.

upvoted 0 times

...

Trinidad

6 months ago

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

upvoted 0 times

...

Theron

6 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

...