GCP Professional Cloud Architect Practice Question

Your team plans to migrate a 4-TB MySQL 5.7 database to Cloud Spanner using the open-source Spanner Migration Tool (SMT). Before committing engineering time, they want to estimate how many schema objects can be converted automatically and identify any manual work that will be required. Which initial SMT action best provides this insight without exporting data or provisioning Cloud Spanner resources?

Execute the SMT assessment workflow to generate a schema compatibility report from the live MySQL instance.
Launch a custom Dataflow job that tails MySQL's binary logs and writes the streamed changes into a Cloud Spanner shadow database.
Run the SMT data-migration workflow to export all rows to Avro files and load them into a temporary Spanner test database.
Invoke the SMT direct-apply command to convert the MySQL DDL and create equivalent tables and indexes in a new Spanner instance.

Report Issue

Answer Description

Running SMT in assessment (schema-only) mode connects directly to the source MySQL instance, reads table, index, and constraint metadata, and generates a compatibility report (for example, in HTML and JSON formats) that grades each object's Spanner readiness and highlights any unsupported features. Because it only analyzes metadata and writes files locally, no data is exported and no Cloud Spanner databases are created. The other options either attempt data extraction, create a temporary Spanner database, or apply the converted DDL directly, all of which exceed the stated requirement for a lightweight upfront assessment.

Ask Bash

Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.