What is an SLO (Service Level Objective) in the context of database monitoring?

A target level of service, such as 99.9% availability

A company runs a Cloud SQL for SQL Server instance. The database engineer needs to rebuild fragmented indexes on a large table. The table is 1 TB and the maintenance window is 30 minutes. The engineer also needs to ensure that the SLO for query performance is not violated during the rebuild. What should the engineer do?

Run 'DBCC DBREINDEX' on the table.

Use the Cloud SQL Console to rebuild indexes automatically.

Drop and recreate the indexes manually.

Run 'ALTER INDEX ... REBUILD' on the table during the maintenance window.

A company uses Cloud SQL for PostgreSQL for a critical application. The database engineer needs to upgrade the instance to a new minor version. The application can tolerate a few minutes of downtime, but the upgrade must be completed during the next maintenance window. What should the engineer do?

Create a new instance with the desired minor version and migrate traffic using a read replica.

Set the maintenance window to a suitable time and allow Cloud SQL to apply the minor version upgrade automatically.

Use the gcloud command to manually upgrade the minor version immediately, ignoring the maintenance window.

Disable automatic maintenance to prevent any version changes.

A Cloud SQL for MySQL instance must be backed up to Cloud Storage for long-term archival. Which maintenance task should be performed?

Export the database to a Cloud Storage bucket

Rebuild all indexes on the instance

A Cloud SQL for PostgreSQL instance is due for a minor version upgrade. What is the recommended way to plan for this upgrade?

Upgrade immediately without any planning

Use the maintenance window to control when the upgrade occurs

Delete the instance and recreate it

Ignore the upgrade because it is automatic

Google CloudProfessional Cloud Database Engineer

Domain 2Objective 5

2.5 Automate Common Database Tasks PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 2)

Part of the Manage a solution that can span multiple database technologies domain, which accounts for ~25% of the PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam.

16questions here

4free pages

4concepts

~25%of the exam

Questions 6–10

6foundation · easy
What is an SLO (Service Level Objective) in the context of database monitoring?
Select an answer first
7expert · hard
A company runs a Cloud SQL for SQL Server instance. The database engineer needs to rebuild fragmented indexes on a large table. The table is 1 TB and the maintenance window is 30 minutes. The engineer also needs to ensure that the SLO for query performance is not violated during the rebuild. What should the engineer do?
Select an answer first
8application · medium
A company uses Cloud SQL for PostgreSQL for a critical application. The database engineer needs to upgrade the instance to a new minor version. The application can tolerate a few minutes of downtime, but the upgrade must be completed during the next maintenance window. What should the engineer do?
Select an answer first
9foundation · easy
A Cloud SQL for MySQL instance must be backed up to Cloud Storage for long-term archival. Which maintenance task should be performed?
Select an answer first
10foundation · easy
A Cloud SQL for PostgreSQL instance is due for a minor version upgrade. What is the recommended way to plan for this upgrade?
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.