When evaluating an auditing policy for compliance, what is the primary reason to configure log retention?

To meet regulatory requirements that mandate how long audit logs must be kept.

To improve database performance.

To reduce the cost of storing logs.

What type of information is typically found in database-specific audit logs (e.g., Cloud SQL's mysql_general_log)?

Network traffic packet captures.

SQL queries executed against the database.

A team is designing a new microservices architecture on Google Cloud. Each microservice will connect to a shared Cloud SQL for MySQL instance. The team expects variable traffic and wants to minimize the risk of connection exhaustion while keeping operational complexity low. What should they do?

Set the database's max_connections to a very high value to accommodate all microservices.

Use a single shared database user for all microservices to reduce the number of connections.

Deploy a separate Cloud SQL instance for each microservice.

Configure each microservice to use a connection pool with a maximum size that is a fraction of the database's max_connections.

Google CloudProfessional Cloud Database Engineer

Domain 1Objective 3

1.3 Determine How Applications Will Connect to the Database PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 3)

Part of the Design innovative, scalable, and highly available cloud database solutions domain, which accounts for ~32% of the PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam.

27questions here

6free pages

9concepts

~32%of the exam

9 Concepts in This Objective

VPC networking and private connectivity
Database authentication and authorization
Encryption key management
Data encryption in transit and at rest
Firewall rules and private IP
Session pooler services
Connection pooling benefits and trade-offs
Audit logging configuration
Audit policy assessment

Questions 11–15

11foundation · easy
Which Google Cloud service provides audit logs for actions performed on managed database resources?
Select an answer first
12foundation · easy
When evaluating an auditing policy for compliance, what is the primary reason to configure log retention?
Select an answer first
13foundation · easy
What type of information is typically found in database-specific audit logs (e.g., Cloud SQL's mysql_general_log)?
Select an answer first
14application · medium
A team is designing a new microservices architecture on Google Cloud. Each microservice will connect to a shared Cloud SQL for MySQL instance. The team expects variable traffic and wants to minimize the risk of connection exhaustion while keeping operational complexity low. What should they do?
Select an answer first
15foundation · easy
Which protocol is used to encrypt data in transit between an application and a managed database like Cloud SQL?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-CLOUD-DATABASE-ENGINEER” is a trademark of its owner, used for identification only.

1.3 Determine How Applications Will Connect to the Database PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 3)

Questions 11–15

Which Google Cloud service provides audit logs for actions performed on managed database resources?

When evaluating an auditing policy for compliance, what is the primary reason to configure log retention?

What type of information is typically found in database-specific audit logs (e.g., Cloud SQL's mysql_general_log)?

A team is designing a new microservices architecture on Google Cloud. Each microservice will connect to a shared Cloud SQL for MySQL instance. The team expects variable traffic and wants to minimize the risk of connection exhaustion while keeping operational complexity low. What should they do?

Which protocol is used to encrypt data in transit between an application and a managed database like Cloud SQL?

Keep studying — Design innovative, scalable, and highly available cloud database solutions