PostgreSQL Exam PGCES-02 Topic 2 Question 66 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 66
Topic #: 2

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 Lavelle at Jul 06, 2024, 08:42 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Mindy

5 months ago

I think adding it to the last row is the best option, it won't interfere with other settings.

upvoted 0 times

...

Evette

5 months ago

I'm not sure, maybe we should add it to the first row instead.

upvoted 0 times

...

Rasheeda

5 months ago

I agree with Alfreda, it makes sense to add it to the last row.

upvoted 0 times

...

Alfreda

5 months ago

I think we should add 'host foo bar 172.16.1.2/32 trust' to the last row.

upvoted 0 times

...

Ollie

5 months ago

I bet the person who wrote this question has a wicked sense of humor. Tricking us with these obscure Postgres configuration options. Nicely done!

upvoted 0 times

...

Junita

5 months ago

Ha! Clearly the answer is E. The settings are fine as is. Why mess with a perfectly good configuration, am I right?

upvoted 0 times

Edgar

5 months ago

No need to change anything, the settings are fine as is.

upvoted 0 times

...

Dorsey

5 months ago

I think we should add 'host foo bar 172.16.1.2/32 trust' to the last row.

upvoted 0 times

...

Lindsay

6 months ago

Hmm, I'm not so sure about that. Wouldn't option D be more appropriate, since the database name comes before the user name in the rule?

upvoted 0 times

...

Kristofer

6 months ago

I think option C is the correct answer. It makes the most sense to add the 'trust' rule for the specific user and database combination to the last row.

upvoted 0 times