Data Preparation and Ingestion Questions
Practice questions for Data Preparation and Ingestion topic in Google Cloud Associate Data Practitioner. 59 questions covering this domain.
A company needs to move 30 TiB from Amazon S3 to Cloud Storage on a recurring basis by using a fully managed service optimized for large transfers. Wh...
An analyst needs to run ad hoc SQL across terabytes of historical event data with no database servers to manage. Which storage and analytics target is...
A team wants to query Parquet files stored in Cloud Storage without first loading copies of the data into native BigQuery storage. What should they cr...
A company is moving a MySQL database to Cloud SQL for MySQL and wants an initial snapshot followed by ongoing replication until cutover. Which service...
An event pipeline must aggregate across Pub/Sub messages before writing results to BigQuery, and exact deduplication is important. Which design best m...
A data analyst wants files in Cloud Storage that are efficient for columnar analytics and work well for downstream BigQuery analysis. Which file forma...
A scheduled BigQuery transfer failed for several days because the source system was unavailable. Which BigQuery Data Transfer Service capability helps...
A business application requires a managed relational database for transactional records and SQL application queries. Which storage service is the best...
A team wants Pub/Sub messages written to an existing BigQuery table and does not need a separate subscriber client. They also accept at-least-once del...
A team loads raw operational data into BigQuery first and then applies SQL transformations inside BigQuery. Which data manipulation approach are they ...
You need to move files from an on-premises file system into Cloud Storage while controlling routing and bandwidth with self-hosted agents. Which servi...
A team plans to use BigQuery Data Transfer Service for recurring managed ingestion from SaaS sources. Which expectation is incorrect?
Marketing data from Google Ads needs to land in BigQuery on a managed schedule without custom code. Which service is the best fit?
It would take months to upload 300 TB over the network from a remote site. Which Google Cloud product is designed for copying the data onto a device a...
Which statement correctly distinguishes continuous migration from one-time migration in Database Migration Service?
Which Google Cloud service provides scalable, asynchronous messaging used to ingest streaming events into analytics pipelines?
Which Google Cloud service is the managed object storage offering used to land raw files such as CSV, JSON, Avro, and Parquet for downstream analytics...
A team must load very large compressed JSON files into BigQuery efficiently for analytics. Which approach is recommended for the best load performance...
A team must ingest events into BigQuery with the lowest latency and the highest throughput, while strictly maintaining exactly-once semantics. Which a...
A team is loading data from Cloud Storage into BigQuery and needs schema autodetection to infer column types from the source files. Which option enabl...
Sign in to see all 59 questions
Create a free account to browse all questions — completely free during our launch phase.