PostgreSQL PGCES-02 Exam - Topic 11 Question 64 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 64
Topic #: 11

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 Levi at Jun 18, 2024, 06:53 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Hildred

6 months ago

Option B is just wrong, it mixes up user and database.

upvoted 0 times

...

Juliana

6 months ago

Definitely not E, those settings need a change!

upvoted 0 times

...

Colene

6 months ago

Wait, why would we want to skip password verification?

upvoted 0 times

...

Clay

7 months ago

Nah, I believe option C makes more sense.

upvoted 0 times

...

Teresita

7 months ago

I think option A is the right choice.

upvoted 0 times

...

Bok

7 months ago

I’m leaning towards option C, but I’m not completely confident about whether it should be in the last row or if it matters at all.

upvoted 0 times

...

Ozell

7 months ago

I practiced a similar question where we had to modify pg_hba.conf, and I feel like the user should be 'foo' and the database 'bar' in the entry.

upvoted 0 times

...

Samira

7 months ago

I remember something about the 'trust' method allowing connections without a password, but I can't recall the exact syntax for the user and database.

upvoted 0 times

...

Lorriane

8 months ago

I think we need to add a line that specifies the user and database correctly, but I'm not sure if it should be the first or last row.

upvoted 0 times

...

Chauncey

8 months ago

I've seen questions like this before. I think the answer is pretty straightforward, but I'll review the options carefully just to be sure.

upvoted 0 times

...

Sarah

8 months ago

I'm a bit confused by the wording of the question. I'll need to re-read it a few times to make sure I'm understanding it correctly.

upvoted 0 times

...

Lisha

8 months ago

Okay, let me break this down step-by-step. The key is understanding how the pg_hba.conf file works and what the different options mean.

upvoted 0 times

...

Onita

8 months ago

Hmm, I think I know the answer, but I want to double-check the details in the question to make sure I'm not missing anything.

upvoted 0 times

...

Chantell

8 months ago

This looks like a tricky one. I'll need to carefully read through the question and the options to figure out the right approach.

upvoted 0 times

...

Adell

8 months ago

This seems pretty straightforward. The key issue here is that the confidentiality of the message can be affected since a malicious intermediary is intercepting the communication.

upvoted 0 times

...

Susy

8 months ago

I'm a little confused by this question. Does it mean Alibaba Cloud can register clusters running on other clouds, or just on-premise? I'll have to review the details.

upvoted 0 times

...

Eric

8 months ago

I think option C is the way to go. Increasing the logging level on the specific packages involved in the issue view process should give us the detailed information we need to identify the root cause of the slowness.

upvoted 0 times

...