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

Google Professional Cloud Database Engineer Exam - Topic 11 Question 45 Discussion

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?
D) Use PostgreSQL database's built-in authentication.
A) Use Identity and Access Management (IAM) authentication.
B) Use Managed Active Directory authentication.
C) Use Cloud SQL federated queries.

Google Professional Cloud Database Engineer Exam - Topic 11 Question 45 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 45
Topic #: 11
[All Professional Cloud Database Engineer Questions]

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

0/2000 characters
Yasuko
9 months ago
Built-in auth (D) is outdated, stick with A!
upvoted 0 times
...
Krissy
9 months ago
Wait, can you really do password-less with IAM? Sounds too good to be true.
upvoted 0 times
...
Kristin
10 months ago
IAM authentication (A) is super convenient!
upvoted 0 times
...
Lillian
10 months ago
I disagree, Managed AD (B) might be better for enterprise setups.
upvoted 0 times
...
Ahmed
10 months ago
A is the way to go for password-less access!
upvoted 0 times
...
Justine
10 months ago
I feel like the built-in PostgreSQL authentication is more traditional, but it probably requires passwords, so it might not be the answer here.
upvoted 0 times
...
Willow
11 months ago
Cloud SQL federated queries sound familiar, but I can't recall if they support password-less authentication.
upvoted 0 times
...
Afton
11 months ago
I remember practicing with a question about using Managed Active Directory for authentication, but I don't think that's password-less.
upvoted 0 times
...
Sharan
11 months ago
I think IAM authentication might be the right choice since it allows for password-less access, but I'm not entirely sure.
upvoted 0 times
...
Leatha
11 months ago
Based on the requirements, IAM authentication seems like the most appropriate solution. It allows for password-less access and should integrate well with the Cloud SQL for PostgreSQL environment.
upvoted 0 times
...
Gertude
11 months ago
I'm a bit confused by the options. I'll need to research the differences between IAM, Managed Active Directory, and the other choices to determine the best approach.
upvoted 0 times
...
Arlene
11 months ago
Hmm, I'm not sure about this one. I'll need to review the details of the different authentication mechanisms to decide which one is the best fit.
upvoted 0 times
...
Glory
11 months ago
This seems like a straightforward question. I think the answer is IAM authentication since it allows password-less access to the database.
upvoted 0 times
...
Gianna
11 months ago
IAM authentication sounds like the way to go here. It's a secure and convenient option for providing password-less access to the database.
upvoted 0 times
...
Shanda
11 months ago
This seems like a tricky situation. I'd want to make sure I understand all the key stakeholders and their requirements before jumping in.
upvoted 0 times
...
Walker
1 year ago
IAM authentication? Sounds like something from a spy movie. I'm more of a 'keep it simple' kind of guy.
upvoted 0 times
Elli
1 year ago
But built-in authentication is simpler and more straightforward.
upvoted 0 times
...
Bettye
1 year ago
IAM authentication is secure and easy to manage.
upvoted 0 times
...
Carmelina
1 year ago
D) Use PostgreSQL database's built-in authentication.
upvoted 0 times
...
Heidy
1 year ago
IAM authentication is secure and easy to manage.
upvoted 0 times
...
Virgie
1 year ago
A) Use Identity and Access Management (IAM) authentication.
upvoted 0 times
...
Sharen
1 year ago
D) Use PostgreSQL database's built-in authentication.
upvoted 0 times
...
Horace
1 year ago
A) Use Identity and Access Management (IAM) authentication.
upvoted 0 times
...
...
Xochitl
1 year ago
Ah, the good old PostgreSQL authentication. Classic and reliable, just the way I like it!
upvoted 0 times
Jame
1 year ago
D) Use PostgreSQL database's built-in authentication.
upvoted 0 times
...
Alesia
1 year ago
B) Use Managed Active Directory authentication.
upvoted 0 times
...
Goldie
1 year ago
A) Use Identity and Access Management (IAM) authentication.
upvoted 0 times
...
Rodolfo
1 year ago
D) Use PostgreSQL database's built-in authentication.
upvoted 0 times
...
Iluminada
1 year ago
B) Use Managed Active Directory authentication.
upvoted 0 times
...
Vinnie
1 year ago
A) Use Identity and Access Management (IAM) authentication.
upvoted 0 times
...
...
Sheridan
1 year ago
Federated queries? Hmm, that sounds like overkill for my use case. I'll pass.
upvoted 0 times
...
Cora
1 year ago
Managed Active Directory? Nah, too much overhead for a simple PostgreSQL database.
upvoted 0 times
...
Stevie
1 year ago
IAM authentication is the way to go! Seamless integration with my cloud-based applications.
upvoted 0 times
Jaime
1 year ago
IAM authentication is secure and easy to manage.
upvoted 0 times
...
Terina
1 year ago
A) Use Identity and Access Management (IAM) authentication.
upvoted 0 times
...
...
Carolann
1 year ago
I'm not sure, but I think Managed Active Directory authentication could also work.
upvoted 0 times
...
Louann
1 year ago
I agree with Dalene, IAM authentication provides secure access control.
upvoted 0 times
...
Dalene
1 year ago
I think we should use IAM authentication for password-less access.
upvoted 0 times
...

Save Cancel