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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

by Delmy at Sep 19, 2024, 10:05 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Yasuko
7 months ago
Built-in auth (D) is outdated, stick with A!
upvoted 0 times
...
Krissy
8 months ago
Wait, can you really do password-less with IAM? Sounds too good to be true.
upvoted 0 times
...
Kristin
8 months ago
IAM authentication (A) is super convenient!
upvoted 0 times
...
Lillian
8 months ago
I disagree, Managed AD (B) might be better for enterprise setups.
upvoted 0 times
...
Ahmed
8 months ago
A is the way to go for password-less access!
upvoted 0 times
...
Justine
9 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
9 months ago
Cloud SQL federated queries sound familiar, but I can't recall if they support password-less authentication.
upvoted 0 times
...
Afton
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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