Discuss EnterpriseDB PostgreSQL-Essentials Exam Topic 6 Question 1

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

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

30 comments · newest first

Marta 6 months ago

I agree with D. Flexibility is good in options.

Peter 6 months ago

I feel confused. Why not just use -s?

Gwen 6 months ago

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

Chaya 7 months ago

I prefer C. --schema edbuser sounds precise.

Amina 7 months ago

Definitely B or C, but not sure about D.

Della 7 months ago

I thought it was just -n, not both.

Elden 8 months ago

Wait, is -s even a valid option?

Leonida 8 months ago

I agree, D makes the most sense!

Deonna 8 months ago

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

Paz 8 months ago

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

Vicky 8 months ago

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

Dorothy 8 months ago

Option C looks good to me.

Ressie 9 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.

Lindsay 9 months ago

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

Laurel 9 months ago

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

Marsha 9 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.

Emerson 9 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.

Carin 9 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.

Nobuko 10 months ago

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

Daniel 10 months ago

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

Kimberely 10 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.

Richelle 10 months ago

B is the standard option for schema.

Trinidad 10 months ago

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

Theron 11 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.

Honey 11 months ago

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

Nichelle 5 months ago

↳ replying to Honey

Whatever works, but I’d stick with D for flexibility.

Haley 5 months ago

↳ replying to Honey

I like C too. Clear and direct.

Cathern 6 months ago

↳ replying to Honey

Option B is simpler, though. Just the flag you need.

Beata 6 months ago

↳ replying to Honey

I agree with Maurine. Why limit yourself?

Maurine 6 months ago

↳ replying to Honey

I think option D is the best choice. Both B and C work.

EnterpriseDB PostgreSQL-Essentials Exam - Topic 6 Question 1 Discussion