Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A company wants to ingest data regularly from several external Software-as-a-Service (SaaS) applications, such as Salesforce and Google Ads, directly into BigQuery for reporting. The analytics team wants a fully managed, scheduled solution that requires no custom code or complex pipeline development.
Which Google Cloud service should the team select to meet these requirements?
BigQuery Data Transfer Service (DTS) is a fully managed data ingestion service designed to automate the scheduled movement of data into BigQuery from diverse sources, including third-party SaaS platforms, cloud storage, and external databases, without writing code.
bq command-line tool, or the API without writing extraction scripts.
BigQuery Data Transfer Service is specifically built for straightforward, code-free, scheduled transfers from SaaS and cloud sources into BigQuery. It avoids the operational overhead of provisioning cluster-based visual tools or coding custom ETL pipelines when data only needs to be transferred directly into the data warehouse.
Storage Transfer Service is a scalable Google Cloud service designed to automate and manage large-scale data transfers between cloud storage repositories (such as Amazon S3, Microsoft Azure Blob Storage), on-premises POSIX file systems, and Cloud Storage buckets.
The company needed to transfer large volumes of raw files or backup archives from an Amazon S3 bucket or on-premises file server into Google Cloud Storage.
While Storage Transfer Service is essential for bulk object migration to Cloud Storage, BigQuery Data Transfer Service is the specialized tool for automated SaaS application ingestion into BigQuery.
Cloud Data Fusion is a fully managed, visual data integration platform based on open-source CDAP. It enables users to build, deploy, and manage complex Extract, Transform, and Load (ETL) and ELT data pipelines using a graphical drag-and-drop user interface.
The scenario required building visual, drag-and-drop ETL pipelines to clean, restructure, and join data from multiple disparate sources before loading it into target systems.
Cloud Data Fusion is the premier tool when non-programmers need visual pipeline creation with deep transformation capabilities, whereas BigQuery Data Transfer Service focuses strictly on direct, automated data movement.
Database Migration Service (DMS) is a fully managed service designed to facilitate lift-and-shift migrations of relational databases (such as MySQL, PostgreSQL, Oracle, and SQL Server) from on-premises, compute instances, or other clouds into Google Cloud databases like Cloud SQL and AlloyDB.
The team needed to perform a lift-and-shift migration of an on-premises MySQL or PostgreSQL database into Cloud SQL with minimal application downtime.
Always distinguish between database migration tools (DMS), which move transactional databases to Cloud SQL, and analytic ingestion tools (BigQuery Data Transfer Service), which move SaaS and operational data into BigQuery.
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