PostgreSQL Exam PGCES-02 Topic 6 Question 67 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 67
Topic #: 6

[All PGCES-02 Questions]

Select two statements that the command below DOES NOT do.

Note: $ is the command prompt. $ pg_dump -b -F c b > d

ABacks up the 'b' database to the 'c' file, and stores error messages to the 'd' file.

BBacks up the 'b' database to the 'd' file.

CBacks up large objects.

DBacks up the 'c' database to the 'd' file as the 'c' user.

ECreates a backup, which is restorable with the pg_restore command.

Show Suggested Answer

Suggested Answer: A

by Janna at Jul 17, 2024, 04:19 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Andree

1 months ago

I'm just impressed that someone came up with a question that involves both pg_dump and pg_restore. That's a deep cut for a certification exam!

upvoted 0 times

...

Ressie

1 months ago

Whoa, wait a minute. The command is creating a compressed backup, not just dumping the database to a file. Option C must be right, it's backing up the large objects too.

upvoted 0 times

Garry

22 days ago

Option E) Creates a backup, which is restorable with the pg_restore command.

upvoted 0 times

...

Lelia

25 days ago

Option C) Backs up large objects.

upvoted 0 times

...

Silvana

2 months ago

Hold up, does this command really create a backup that's restorable with pg_restore? That sounds a bit too good to be true. I'll have to double-check the documentation on that one.

upvoted 0 times

...

Micah

2 months ago

I'm pretty sure the command is backing up the 'b' database to the 'c' file, not to the 'd' file. Option B is definitely wrong.

upvoted 0 times

Marla

1 days ago

User: I'm pretty sure the command is backing up the 'b' database to the 'c' file, not to the 'd' file. Option B is definitely wrong.

upvoted 0 times

...

Geraldo

7 days ago

E) Creates a backup, which is restorable with the pg_restore command.

upvoted 0 times

...

Lucina

9 days ago

A) Backs up the 'b' database to the 'c' file, and stores error messages to the 'd' file.

upvoted 0 times

...

Glen

21 days ago

User: I'm pretty sure the command is backing up the 'b' database to the 'c' file, not to the 'd' file. Option B is definitely wrong.

upvoted 0 times

...

Nilsa

1 months ago

E) Creates a backup, which is restorable with the pg_restore command.

upvoted 0 times

...

Andra

2 months ago

A) Backs up the 'b' database to the 'c' file, and stores error messages to the 'd' file.

upvoted 0 times

...

Krissy

2 months ago

The correct answers are B and D. The command line you provided doesn't back up to the 'd' file, and it doesn't back up the 'c' database as the 'c' user.

upvoted 0 times