PostgreSQL Exam PGCES-02 Topic 10 Question 76 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 76
Topic #: 10

A pg_hba.conf file is set up as follows. local all all md5 host all all 127.0.0.1/32 md5 host all all 172.16.1.0/24 md5 When user foo connects to database bar from host IP address 172.16.1.2, I would like password verification to not be performed. Select one appropriate line for the new pg_hba.conf file.

AAdd 'host foo bar 172.16.1.2/32 trust' to the first row.

BAdd 'host bar foo 172.16.1.2/32 trust' to the first row.

CAdd 'host foo bar 172.16.1.2/32 trust' to the last row.

DAdd 'host bar foo 172.16.1.2/32 trust' to the last row.

EThe settings are fine as is.

Show Suggested Answer

Suggested Answer: B

by Edward at Oct 19, 2024, 03:08 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Chaya

7 days ago

Option B, all the way! Gotta keep those passwords secure, even if it's a bit of a hassle. Can't be too careful these days, am I right?

upvoted 0 times

...

Raylene

8 days ago

Hmm, I'm not too sure about this one. Maybe option E is the safest bet - the settings seem fine as they are. Why mess with a working configuration, right?

upvoted 0 times

...

Izetta

12 days ago

I'd go with option D. It's clearer to add the 'trust' line for the 'bar' user on the 'foo' database from the specific IP address.

upvoted 0 times

Carry

3 days ago

I think option D is the best choice.

upvoted 0 times

...

Rikki

15 days ago

Option C looks good to me. Adding the 'trust' authentication method for the user 'foo' on the database 'bar' from the specific IP address '172.16.1.2' seems like the right approach.

upvoted 0 times

Jacki

6 days ago

User 1: Option C looks good to me.

upvoted 0 times

...

Ilene

28 days ago

I agree with Merilyn, because adding 'host foo bar 172.16.1.2/32 trust' to the last row would allow password verification to not be performed for user foo connecting from host IP address 172.16.1.2.

upvoted 0 times

...

Merilyn

1 months ago

I think the answer is C.

upvoted 0 times

...