Question 1
A data analyst needs to load a large CSV file from an on-premises server into BigQuery. The file is 500 GB. Which transfer method is most appropriate?
Correct Answer:
Use Storage Transfer Service to move the file to Cloud Storage first, then load into BigQuery
Question 2
Which Google Cloud storage service is best suited for storing semi-structured JSON documents that require flexible schemas and real-time mobile application access?
Correct Answer:
Firestore
Question 3
A pipeline must read streaming events from Pub/Sub and write aggregated results to BigQuery in near real-time. Which service provides a fully managed, serverless option for this use case?
Correct Answer:
Dataflow
Question 4
What does ELT stand for in the context of data pipelines, and how does it differ from ETL?
Correct Answer:
Extract, Load, Transform — data is loaded raw into the destination before transformation
Question 5
A team stores customer data in BigQuery. They want to ensure that personally identifiable information (PII) such as email addresses cannot be read by analysts unless they have explicit permission. Which BigQuery feature enforces this at the column level?
Correct Answer:
Column-level security with policy tags
Question 1
Exam overview

About this Exam

Prepare with the GCP Data Practitioner Practice Questions - Google Cloud Associate Data Practitioner Exam practice quiz. This question bank includes 100 questions covering bigquery, data, cloud, storage, and table. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

GCP Data Practitioner Practice Questions - Google Cloud Associate Data Practitioner Exam

This practice set contains 100 questions from the matching question bank and focuses on bigquery, data, cloud, storage, and table. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions