Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

PostgreSQL PGCES-02 Exam - Topic 2 Question 96 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 96
Topic #: 2
[All PGCES-02 Questions]

What does the following command do? Choose the most appropriate statement from the selection below.

Note: $ is the command prompt.

$ pg_dump postgres > pgsql

Show Suggested Answer Hide Answer
Suggested Answer: A

by Veronica at Mar 05, 2026, 08:11 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Cathern
15 days ago
Wait, does it really just back up one database?
upvoted 0 times
...
Mila
20 days ago
Totally agree, it's definitely option A!
upvoted 0 times
...
Bethanie
25 days ago
A is correct, it backs up the postgres database.
upvoted 0 times
...
Aliza
1 month ago
A is spot on, no doubt about it!
upvoted 0 times
...
Sean
1 month ago
B is incorrect, it's definitely just the postgres database.
upvoted 0 times
...
Eleonora
1 month ago
Wait, is it really just the postgres database? I thought it was the whole cluster.
upvoted 0 times
...
Wilburn
2 months ago
Totally agree with A!
upvoted 0 times
...
Yolande
2 months ago
A) Writes a backup of the database postgres to the file pgsql.
upvoted 0 times
...
Luis
2 months ago
I feel like I’ve seen a question where pg_dump outputs to a file, but I can't recall if it was just the database or something broader. I need to think this through.
upvoted 0 times
...
Freeman
2 months ago
I’m a bit confused because I thought pg_dump only backed up one database, but the wording in option B makes me second guess that.
upvoted 0 times
...
Lucina
2 months ago
I remember practicing a similar question where pg_dump was used, and it was definitely about backing up a specific database. So I’m leaning towards A.
upvoted 0 times
...
Wilda
2 months ago
I think the command is supposed to back up the database, but I'm not sure if it only does postgres or the entire cluster.
upvoted 0 times
...

Save Cancel