Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
You are in the process of transitioning your existing on-premises data warehouse infrastructure to Google BigQuery. One of the critical data sources currently resides in a MySQL database within your on-premises data center, which is configured without public IP addresses to enhance security. Ensuring the secure transfer of data from the MySQL database to BigQuery is a top priority, specifically to avoid any exposure to the public internet during this transfer. What steps will you take to achieve this secure data ingestion into BigQuery?
Explanation:
The correct answer is B. Datastream is a serverless, real-time change data capture and replication service that can be used to replicate data from various relational databases, including MySQL, to BigQuery. By setting up Cloud Interconnect between your on-premises data center and Google Cloud, you create a secure and direct private connection that bypasses the public internet. This method ensures secure data transfer without exposure to the public internet, which meets the requirement perfectly. Using private connectivity as suggested is the recommended approach for secure, large-scale data migrations.