MENU
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?
Suggested Answer: D
Get Premium Professional Cloud Database Engineer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
38 comments · newest first
YA
Yasuko
11 months ago
Built-in auth (D) is outdated, stick with A!
KR
Krissy
11 months ago
Wait, can you really do password-less with IAM? Sounds too good to be true.
KR
Kristin
11 months ago
IAM authentication (A) is super convenient!
LI
Lillian
11 months ago
I disagree, Managed AD (B) might be better for enterprise setups.
AH
Ahmed
12 months ago
A is the way to go for password-less access!
JU
Justine
12 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.
WI
Willow
1 year ago
Cloud SQL federated queries sound familiar, but I can't recall if they support password-less authentication.
AF
Afton
1 year ago
I remember practicing with a question about using Managed Active Directory for authentication, but I don't think that's password-less.
SH
Sharan
1 year ago
I think IAM authentication might be the right choice since it allows for password-less access, but I'm not entirely sure.
LE
Leatha
1 year 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.
GE
Gertude
1 year 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.
AR
Arlene
1 year 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.
GL
Glory
1 year ago
This seems like a straightforward question. I think the answer is IAM authentication since it allows password-less access to the database.
GI
Gianna
1 year 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.
SH
Shanda
1 year 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.
WA
Walker
1 year ago
IAM authentication? Sounds like something from a spy movie. I'm more of a 'keep it simple' kind of guy.
EL
Elli
1 year ago
But built-in authentication is simpler and more straightforward.
BE
Bettye
1 year ago
IAM authentication is secure and easy to manage.
CA
Carmelina
1 year ago
D) Use PostgreSQL database's built-in authentication.
HE
Heidy
1 year ago
IAM authentication is secure and easy to manage.
VI
Virgie
1 year ago
A) Use Identity and Access Management (IAM) authentication.
SH
Sharen
1 year ago
D) Use PostgreSQL database's built-in authentication.
HO
Horace
1 year ago
A) Use Identity and Access Management (IAM) authentication.
XO
Xochitl
1 year ago
Ah, the good old PostgreSQL authentication. Classic and reliable, just the way I like it!
JA
Jame
1 year ago
D) Use PostgreSQL database's built-in authentication.
AL
Alesia
1 year ago
B) Use Managed Active Directory authentication.
GO
Goldie
1 year ago
A) Use Identity and Access Management (IAM) authentication.
RO
Rodolfo
1 year ago
D) Use PostgreSQL database's built-in authentication.
IL
Iluminada
1 year ago
B) Use Managed Active Directory authentication.
VI
Vinnie
1 year ago
A) Use Identity and Access Management (IAM) authentication.
SH
Sheridan
2 years ago
Federated queries? Hmm, that sounds like overkill for my use case. I'll pass.
CO
Cora
2 years ago
Managed Active Directory? Nah, too much overhead for a simple PostgreSQL database.
ST
Stevie
2 years ago
IAM authentication is the way to go! Seamless integration with my cloud-based applications.
JA
Jaime
1 year ago
IAM authentication is secure and easy to manage.
TE
Terina
1 year ago
A) Use Identity and Access Management (IAM) authentication.
CA
Carolann
2 years ago
I'm not sure, but I think Managed Active Directory authentication could also work.
LO
Louann
2 years ago
I agree with Dalene, IAM authentication provides secure access control.
DA
Dalene
2 years ago
I think we should use IAM authentication for password-less access.