Google Professional Cloud Database Engineer Question 93
Select 4Google Cloud PlatformYou are migrating your on-premises MySQL database to Cloud SQL for MySQL on Google Cloud. The application connected to the database uses stored procedures and triggers extensively. During the assessment phase, what steps should you take to correctly identify application and database dependencies?
- A
Review the stored procedures and triggers for compatibility with Cloud SQL
- B
Analyze application logs to identify all SQL queries being executed
- C
Use the Database Migration Service (DMS) to automatically rewrite incompatible stored procedures
- D
Check for any dependencies on operating system-level features or local file storage
- E
Verify network latency and bandwidth between application and Cloud SQL instance
Show answer and explanation
Correct answers: A, B, D, E
Explanation
To ensure a smooth migration, it is critical to assess all dependencies between the application and the database. This includes reviewing stored procedures and triggers for compatibility, analyzing SQL queries to identify usage patterns, checking for OS-level or file storage dependencies that Cloud SQL does not support, and verifying network performance between the application and the database. These steps help identify potential issues and ensure the application functions correctly after migration.
- A. Correct.
Correct. Cloud SQL supports many MySQL features, but not all versions or configurations. Reviewing stored procedures and triggers ensures you identify potential compatibility issues before migration.
- B. Correct.
Correct. Application logs can provide insights into the exact SQL queries being executed and help identify dependencies between the application and database.
- C. Incorrect.
Incorrect. The Database Migration Service (DMS) does not automatically rewrite stored procedures or resolve compatibility issues with triggers. This must be done manually.
- D. Correct.
Correct. Some applications rely on OS-level features or local file storage, which Cloud SQL does not support. Identifying such dependencies is crucial for a successful migration.
- E. Correct.
Correct. Network latency and bandwidth can impact the application's performance when moving to a managed database like Cloud SQL. Assessing these factors helps prevent performance degradation.