Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Cloud Digital Leader practice bank has an additional 3,070 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
An e-commerce company plans to migrate its on-premises PostgreSQL database to Cloud SQL for PostgreSQL. Because the database supports a 24/7 online storefront, the company has the following migration requirements:
Which Google Cloud service or tool should the company use?
Google Cloud Migration Center is a unified discovery, assessment, and planning platform that helps organizations evaluate their existing on-premises or cloud environments before beginning a migration. It collects inventory data across servers, applications, and databases to provide technical fit analysis, target sizing recommendations, and Total Cost of Ownership (TCO) reports.
The company was in the initial discovery and assessment phase and wanted to build an inventory of its on-premises servers and databases, evaluate technical compatibility with Google Cloud, and generate a Total Cost of Ownership (TCO) report.
A successful cloud migration journey typically pairs Google Cloud Migration Center with Database Migration Service. Organizations first use Migration Center to discover assets and right-size their target Cloud SQL instances, and then use Database Migration Service to execute the low-downtime continuous data transfer.
Transfer Appliance is a high-capacity, rackable physical hardware storage device provided by Google Cloud. Organizations request the appliance, connect it to their local network in their data center, copy large volumes of data onto it, and securely ship it back to a Google upload facility, where the data is uploaded directly into Cloud Storage.
INSERT, UPDATE, and DELETE transactions over a network.The scenario asked for a solution to move hundreds of terabytes of static archival files or offline data from an on-premises facility with limited internet bandwidth into Cloud Storage without saturating the corporate network.
Students sometimes confuse Transfer Appliance with online migration services because both minimize disruption to day-to-day business operations. However, Transfer Appliance minimizes network bandwidth disruption during bulk offline transfers, whereas Database Migration Service minimizes application downtime during live database cutovers.
Storage Transfer Service is a managed data movement tool designed to transfer object and file data into Cloud Storage. It automates the copying of files from external cloud storage providers (such as Amazon S3 or Azure Blob Storage), on-premises file systems, or other Cloud Storage buckets over the network.
INSERT, UPDATE, or DELETE statements, nor can it promote a Cloud SQL replica to a standalone primary database.The company needed to automate the transfer of unstructured files and objects from an on-premises file server or an external cloud provider's object storage bucket into Cloud Storage.
While an administrator could export a static database dump file and move that file to Cloud Storage using Storage Transfer Service, doing so represents a one-time dump-and-load approach. That method would require stopping database writes to prevent data loss, failing the 24/7 minimal-downtime requirement that Database Migration Service solves natively.
Database Migration Service (DMS) is a fully managed, serverless Google Cloud service designed to help organizations migrate relational databases from on-premises environments or other cloud providers into Cloud SQL and AlloyDB for PostgreSQL. It supports both homogeneous migrations (such as PostgreSQL to Cloud SQL for PostgreSQL) and heterogeneous migrations (such as Oracle or SQL Server to Cloud SQL for PostgreSQL).
INSERT, UPDATE, and DELETE operations—until the target database is in sync and ready to be promoted to the primary instance.
Unlike manual backup-and-restore methods that require halting application writes for extended periods, Database Migration Service encapsulates complex replication logic into a unified, serverless workflow. Switching applications over only after the source and destination databases are synchronized ensures near-zero operational disruption.
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