VendorsExamsEnterprise
Support
Request an ExamContact UsFAQ

Google Cloud Associate Data Practitioner Free Sample Questions

Description

Covers preparing and ingesting data into Google Cloud storage, analyzing trends with BigQuery and visualizing them in Looker, building data pipelines, and access control and governance.

12 free sample questions135 in the full practice test Other version: ADP(307)

Try simulator

GCP-ADP Sample Questions

  1. Question 1

    Intermediate

    Data Preparation and Ingestion · Data transfer tools

    A retail company collects clickstream data from its e-commerce website. The data is currently stored in on-premises servers as JSON files. You need to migrate this historical data (approximately 50 TB) to Google Cloud for analysis in BigQuery. The company has a limited network bandwidth of 100 Mbps and requires the data to be available in Google Cloud within one week. Which approach should you take?

    Answer and explanation

    Correct answer: C

    At 100 Mbps, uploading 50 TB of data would theoretically take over 46 days (50TB * 8000000 Mb / 100 Mbps / 60 / 60 / 24). This far exceeds the one-week requirement. The Transfer Appliance is a high-capacity storage server that you rent, fill with data on-premises, and ship to an ingestion center, which is the only viable option for this volume and bandwidth constraint.

  2. Question 2

    Intermediate

    Data Preparation and Ingestion · Storage solutions

    You are designing a data ingestion pipeline for a financial services application. The application generates high-throughput transactional data that must be stored with strong consistency and high availability across a global user base. You need to select a storage solution that supports SQL queries and horizontal scalability. Which service should you choose?

    Answer and explanation

    Correct answer: C

    Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at a global scale, schemas, SQL (ANSI 2011 with extensions), and automatic, synchronous replication for high availability. Cloud SQL is regional and scales vertically. BigQuery is for analytics (OLAP), not transactional (OLTP) workloads.

  3. Question 3

    Intermediate

    Data Preparation and Ingestion · Extract and load data

    You are building a data warehouse in BigQuery. You have a requirement to load daily batch files from Cloud Storage into BigQuery. The source data is in CSV format, but the schema of the files might evolve over time (e.g., new columns added). You want to ensure that the loading process handles these schema changes automatically without manual intervention. What should you do?

    Answer and explanation

    Correct answer: A

    While BigQuery supports schema updates for CSVs, Avro is the preferred format for handling schema evolution because the schema is embedded in the file itself. Using ALLOW_FIELD_ADDITION allows the load job to add new columns found in the source data to the destination table schema.

  4. Question 4

    Beginner

    Data Preparation and Ingestion · Prepare and process data

    A marketing team needs to analyze customer sentiment from social media posts. The data is unstructured text stored in Cloud Storage. You need to process this data, extract sentiment scores, and store the structured results in BigQuery for analysis. Which tool provides a visual interface to build this pipeline without writing extensive code?

    Answer and explanation

    Correct answer: C

    Cloud Data Fusion is a fully managed, cloud-native data integration service that provides a visual point-and-click interface (GUI) for building ETL/ELT pipelines. It is ideal for users who want to build pipelines without writing code (code-free). It can leverage plugins to process text and write to BigQuery.

  5. Question 5

    Intermediate

    Data Management · Configure lifecycle management

    You are managing a data lake in Cloud Storage containing sensitive customer information. You need to ensure that the data is stored cost-effectively. The data is accessed frequently during the first 30 days, rarely for the next 60 days, and almost never after 90 days, but must be retained for 3 years for compliance. Which Object Lifecycle Management configuration should you apply?

    Answer and explanation

    Correct answer: B

    This matches the access patterns described: Standard for frequent access ( Nearline -> Coldline is the most logical step-down cost optimization for the described timeline.

  6. Question 6

    Intermediate

    Data Analysis and Presentation · Identify trends and insights

    You are analyzing a large dataset in BigQuery to identify sales trends. You need to calculate the moving average of sales over the last 7 days for each product. Which SQL construct should you use?

    Answer and explanation

    Correct answer: B

    Window functions allow calculations across a set of table rows that are somehow related to the current row. To calculate a moving average, you use the OVER clause to define the window. PARTITION BY separates the calculation by product, ORDER BY ensures chronological order, and ROWS BETWEEN 6 PRECEDING AND CURRENT ROW defines the 7-day window (current day + previous 6 days).

Register free for 6 more questions

Or unlock all 135 GCP-ADP questions with explanations, timed mode and flashcards.

Related practice tests

All Google practice exams