Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Associate Cloud Engineer practice bank has an additional 2,014 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
An e-commerce application connected to a Cloud SQL instance is experiencing slow response times during peak business hours. Database CPU utilization is unusually high, and you suspect that unindexed, resource-intensive queries are degrading overall database performance.
How should you examine the database performance using Google Cloud diagnostic tools and implement recommended index improvements?
This option suggests using an Auto-apply recommendations button within the Query insights dashboard to allow Cloud SQL to alter the database schema and maintain indexes automatically without human intervention.
CREATE INDEX recommendations only. It does not automatically modify database tables, add indexes in the background, or provide a one-click automated schema application button.This answer would be correct if Cloud SQL featured an autonomous database management engine capable of automatic index lifecycle management and self-tuning schema modifications without administrator intervention.
Cloud Profiler is a continuous, low-overhead application profiling tool designed to analyze CPU, heap memory, and thread utilization across application code. It visualizes call stacks as interactive flame graphs, allowing software engineers to optimize code performance in languages such as Go, Java, Python, and Node.js.
This answer would be correct if the performance bottleneck were caused by an inefficient CPU-bound algorithm, memory leak, or expensive loop within the application source code rather than missing database indexes.
Cloud Trace is a distributed tracing system that collects latency data from cloud applications to show how requests propagate through microservice architectures. Cloud Logging is a centralized log aggregation, indexing, and analysis service used for storing and querying system and application log events.
CREATE INDEX recommendations.This answer would be correct if you needed to track a user request across multiple microservices to determine which backend service or API endpoint was introducing the highest overall latency.
Query insights is a specialized diagnostic tool built into Cloud SQL that allows administrators to detect, diagnose, and prevent query performance problems. It tracks database load using normalized queries and breaks down performance by metrics such as execution time, call frequency, and database load. Working alongside Query insights, the index advisor periodically analyzes regular query workloads to recommend new indexes that enhance retrieval speeds and reduce resource consumption.
CREATE INDEX DDL statements. You can copy these commands to the clipboard and run them directly against the primary database instance to implement the optimization.This approach directly leverages Cloud SQL's purpose-built query observability and indexing engine. It eliminates guesswork by identifying the exact queries causing performance bottlenecks and providing pre-computed index definitions tailored to the live database workload.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated