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

What does the following command do? Choose the most appropriate statement from the selection below.Note: $ is the command prompt.$ pg_dump postgres > pgsql
A) Writes a backup of the database postgres to the file pgsql.
B) Writes a backup of the entire database cluster using user postgres to the file pgsql.
C) Backs up the database postgres and writes an error message to the file pgsql.
D) Writes a backup of the entire database cluster to the file postgres and writes an error message to the file pgsql.
E) Outputs all of the content of the database postgres to the screen using the user pgsql.

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
Lura
7 hours ago
Totally agree with A!
upvoted 0 times
...
Veronika
5 days ago
A) Writes a backup of the database postgres to the file pgsql.
upvoted 0 times
...
Oliva
11 days ago
Nah, it's definitely not C, no error message involved.
upvoted 0 times
...
Flo
16 days ago
I thought it backed up the whole cluster, isn't that B?
upvoted 0 times
...
Cathern
2 months ago
Wait, does it really just back up one database?
upvoted 0 times
...
Mila
2 months ago
Totally agree, it's definitely option A!
upvoted 0 times
...
Bethanie
2 months ago
A is correct, it backs up the postgres database.
upvoted 0 times
...
Aliza
3 months ago
A is spot on, no doubt about it!
upvoted 0 times
...
Sean
3 months ago
B is incorrect, it's definitely just the postgres database.
upvoted 0 times
...
Eleonora
3 months ago
Wait, is it really just the postgres database? I thought it was the whole cluster.
upvoted 0 times
...
Wilburn
3 months ago
Totally agree with A!
upvoted 0 times
...
Yolande
3 months ago
A) Writes a backup of the database postgres to the file pgsql.
upvoted 0 times
...
Luis
3 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
4 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
4 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
4 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