exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam

Exam Professional Cloud Database Engineer topic 1 question 152 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 152
Topic #: 1
[All Professional Cloud Database Engineer Questions]

Your company uses a custom application to service thousands of users. The application is running on a Compute Engine and a Cloud SQL for PostgreSQL database. The company requires database passwords to be changed every 60 days. You need to ensure that the credentials used by the web application to connect to the database are managed securely. What should you do?

  • A. 1. Store the credentials in an encrypted text file in the application.
    2. Use Cloud Key Management Service (Cloud KMS) to store the key for decrypting the text file.
    3. Modify the application to decrypt the text file and retrieve the credentials on startup.
    4. Update the text file every 60 days.
  • B. 1. Store the credentials to the database in Secret Manager.
    2. Modify the application to retrieve the credentials from Secret Manager on startup.
    3. Configure the rotation interval to 60 days.
  • C. 1. Store the credentials in a text file in a Cloud Storage bucket.
    2. Modify the application to download the text file and retrieve the credentials on startup.
    3. Update the text file every 60 days.
  • D. 1. Configure IAM database authentication for the application to connect to the database.
    2. Create an IAM user and map it to a separate database user for each application user.
    3. Require users to update their passwords every 60 days.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Sai_Vignesh
1 week, 1 day ago
Selected Answer: A
Could be wrong, but I’m backing A. It just clicks.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...