205 questions total · 3pages · All types, answers revealed
Page 1 of 3
Page 2You have a large table in BigQuery that is updated constantly. You need to perform a query that is consistent. What should you use?
This lets you query data as it existed at a past time.
Why this answer
Table snapshots allow you to query a consistent version of a table from a specific point in time.
Which TWO of the following are true regarding Dataplex security? (Choose two)
Granular IAM is supported.
Why this answer
Dataplex uses IAM for access and integrates with GCP security features.
You need to load CSV files from GCS to BigQuery. The schema changes frequently. Which approach handles schema evolution automatically?
Load jobs with auto-detect enabled adapt to schema changes in CSV files.
Why this answer
BigQuery schema auto-detection combined with ingestion into a landing table supports schema evolution if configured properly.
Which TWO of the following are common Dataflow pipeline patterns?
Common real-time pattern.
Why this answer
Streaming to BigQuery and Batch processing files from GCS are common patterns.
You are using Airflow with a Cloud Composer environment. You want to ensure that a specific task runs on a specific day of the week. How do you configure the schedule?
Cron strings (e.g., '0 0 * * 1') allow for specific days.
Why this answer
The 'schedule_interval' parameter in the DAG definition supports cron syntax, which includes day-of-week specifications.
You need to control access to specific columns in a BigQuery table using Dataplex-integrated policy tags. What must you create before you can apply a policy tag to a column?
You must define the taxonomy and the specific tags within it first.
Why this answer
A Policy Tag Taxonomy must be created in the Data Catalog / Dataplex taxonomy management before tags can be applied to columns.
Which TWO of the following are true about Workflows' serverless nature?
Handles variable loads.
Why this answer
Serverless means no infrastructure management and auto-scaling based on demand.
You need to track lineage for a BigQuery table populated by a Dataflow pipeline. How does Dataplex help?
Lineage is automatically integrated for BigQuery and Dataflow.
Why this answer
Dataplex and Data Catalog integrate with BigQuery and Dataflow to capture lineage automatically when pipelines are correctly instrumented.
You are designing a streaming pipeline in Dataflow. You need to ensure that data is processed in the order it was generated, even if it arrives late. What do you use?
Watermarks track progress and allowed lateness handles data arriving after the watermark.
Why this answer
Watermarks and event time processing in Dataflow allow for handling out-of-order data correctly.
What is the primary function of the Airflow 'Executor' in Cloud Composer?
The executor handles task distribution (e.g., Celery or Kubernetes executor).
Why this answer
The executor is responsible for managing the execution of tasks, determining how to distribute work to the workers.
You want to enforce that all data in a specific Dataplex Zone must be encrypted with a Customer-Managed Encryption Key (CMEK). How do you enforce this?
Dataplex allows specifying CMEK keys during resource creation to enforce encryption.
Why this answer
When creating a Dataplex Lake or Zone, you can configure CMEK settings that apply to the underlying resources.
Which THREE of the following are components of a Workflows definition?
Required entry point.
Why this answer
Workflows consist of steps, main entry points, and can include variable assignments.
What is the primary function of a Looker Explore?
This is the core purpose of the Explore UI.
Why this answer
An Explore is the user-friendly interface that allows analysts to query and visualize data defined in LookML.
What is the primary benefit of using partitioned tables in BigQuery?
Partitioning reduces data scanned during queries.
Why this answer
Partitioning improves query performance and reduces costs by limiting the amount of data scanned.
You need to provide temporary access to a GCS file for a third party. What should you use?
Signed URLs grant temporary access to specific objects.
Why this answer
Signed URLs provide time-limited access to GCS objects without needing an account.
You need to analyze a petabyte-scale dataset in BigQuery. To optimize cost, you must ensure that users only query relevant partitions. How should you enforce this?
This setting directly prevents queries that do not filter by the partitioning column.
Why this answer
Requiring partition filters forces users to include a WHERE clause on the partitioning column, preventing full table scans.
How do you restrict access to a specific GCS bucket to only members of a specific team?
Bucket-level IAM policies restrict access correctly.
Why this answer
IAM policies at the bucket level allow you to define access for specific users or groups.
You are migrating data into a Dataplex Lake. You need to ensure that the data is partitioned by date to improve query performance. Where do you define this partitioning?
Assets represent the physical data; partitioning is defined here.
Why this answer
In Dataplex, partitioning is defined at the asset level when linking the BigQuery table or Cloud Storage files.
You need to ingest data from a legacy database into Google Cloud. The database has strict network egress controls. How should you connect?
VPN establishes a secure, private connection to Google Cloud.
Why this answer
Cloud VPN or Interconnect is required to bridge the on-premises network to Google Cloud securely.
Which of the following describes the purpose of 'BigQuery ML'?
This allows data practitioners to do ML without leaving SQL.
Why this answer
BQML allows users to build and run machine learning models using standard SQL within BigQuery.
You notice your Looker dashboard is showing duplicate data. What is the most likely cause?
This is the classic cause of duplication in Looker.
Why this answer
Fan-outs occur when joining a one-to-many relationship without correctly defining the primary key or using the correct aggregate type.
Which TWO of the following services can trigger Workflows executions?
Time-based triggering.
Why this answer
Cloud Scheduler and Eventarc are common triggers for Workflows.
A user wants to see the top 10 products sold, but also an 'Other' category for the rest. How can you achieve this in a Looker Explore?
This is the standard approach to bucket categories.
Why this answer
A 'Dimension Fill' or using a 'Case' statement in a dimension allows grouping everything else into an 'Other' bucket.
A colleague has shared a Vertex AI Workbench notebook with you. How can you run it?
This allows you to execute the code in your own compute environment.
Why this answer
You can open it in a managed instance and run the cells directly in the browser interface.
A user needs to see the distribution of values in a column in BigQuery. Which visualization approach is most effective for this?
Histograms show frequency distributions of continuous variables.
Why this answer
A histogram is the standard statistical visualization for showing the distribution of numerical data.
In Looker, what is the impact of defining a 'primary_key' in a LookML view?
Primary keys are required for correct join logic and avoiding double-counting.
Why this answer
Defining a primary key is essential for Looker to calculate accurate counts and prevent fan-outs (fan-out avoidance) when joining tables.
You need to restrict data access to specific geographic regions for compliance. Which Dataplex feature supports this?
You define the region during the creation of Lakes and Zones.
Why this answer
Dataplex allows you to restrict the location of data assets when creating a lake or zone.
When optimizing a Looker model, you want to prevent users from accidentally running very expensive queries. Which parameter should you use in LookML?
This ensures a filter is applied to every query generated by the Explore.
Why this answer
The 'sql_always_where' parameter forces a filter on every query, which is an effective guardrail for cost and performance.
You need to share a BigQuery dataset across multiple organizations. What is the recommended approach using Dataplex?
Dataplex provides the logical layer to bridge these assets.
Why this answer
Dataplex allows you to link cross-project and cross-org assets into a single lake, provided the appropriate IAM permissions are set.
Which BigQuery feature allows you to monitor query usage and identify expensive queries?
This is the source of truth for query performance and cost history.
Why this answer
The 'INFORMATION_SCHEMA.JOBS' view contains metadata about all queries executed in the project.
Which service is the primary tool for managing and running Jupyter notebooks in a managed environment within Google Cloud?
This is the current standard for managed notebooks in Google Cloud.
Why this answer
Vertex AI Workbench is the managed service for running Jupyter notebook instances.
A task in your Airflow DAG involves a long-running process that might exceed the default Airflow worker pod timeout. How should you handle this?
This allows individual tasks to exceed default limits safely.
Why this answer
Adjust the 'execution_timeout' parameter for the specific task in the Airflow DAG definition to allow longer processing times.
You are analyzing query performance in BigQuery. You notice that your queries are spilling to disk. What is the most likely cause?
Memory-intensive operations on non-optimized data result in disk spills.
Why this answer
Operations like ORDER BY, JOIN, or GROUP BY on large datasets without efficient distribution or filtering often cause spills to disk when memory limits are exceeded.
You are troubleshooting lineage issues. Which THREE of the following factors could prevent lineage from being captured? (Choose three)
Required permission for writing lineage.
Why this answer
Lineage requires specific services, proper permissions, and correct instrumentation.
Which role is required to manage Dataplex assets within a Zone?
This role allows full management of lakes, zones, and assets.
Why this answer
The Dataplex Data Steward or Dataplex Admin role is required to manage assets, but specifically 'roles/dataplex.admin' or 'roles/dataplex.dataSteward' are used.
You want to perform data quality checks on a BigQuery table that is updated daily. How should you schedule the Dataplex task?
Tasks support scheduling for automation.
Why this answer
Dataplex tasks can be triggered on a schedule using cron syntax, allowing for daily alignment with data updates.
You are using BigQuery and need to load data from an external file that is not in GCS. Which method is recommended?
GCS is the standard landing zone for BigQuery ingestion.
Why this answer
BigQuery can ingest data from local files via the CLI, or by first uploading them to GCS.
Which THREE of the following are key benefits of using Cloud Composer for data orchestration?
It is based on the community Airflow project.
Why this answer
Composer provides managed infrastructure, native integration with GCP services, and the extensive Airflow ecosystem.
Which of the following is NOT a benefit of using Dataplex?
Dataplex does not provide OLTP capabilities; that is for Cloud Spanner/SQL.
Why this answer
Dataplex is for data governance and management, not for high-frequency low-latency transaction processing (OLTP).
You are planning to ingest log data into Google Cloud. Which THREE of the following services support streaming ingestion?
The Storage Write API allows high-throughput streaming ingestion into BigQuery.
Why this answer
Pub/Sub, Dataflow, and BigQuery (via Storage Write API) are primary streaming ingestion tools.
Which THREE features does Dataprep provide?
Essential for understanding data.
Why this answer
Dataprep provides data profiling, transformation, and sampling.
Which TWO of the following tools allow you to interact with Dataplex? (Choose two)
Used for scripting and automation.
Why this answer
Users interact with Dataplex via the Cloud Console and the Google Cloud CLI (gcloud).
A data scientist is using Vertex AI Workbench and needs to share a notebook with a team member who only needs read access. What is the most secure way to do this?
This provides read-only access to the file without granting compute permissions.
Why this answer
Storing the notebook in Cloud Storage and using IAM permissions is the standard way to share notebook artifacts.
In Cloud Composer, what is the default behavior if a DAG execution takes longer than the 'dagrun_timeout' setting?
Timeout triggers a failure state for the DAG run.
Why this answer
If a DAG run exceeds the timeout, Airflow marks the DAG run as 'failed'.
Which tool is used to monitor the performance of your Dataflow pipelines?
Monitoring is the tool for pipeline health and performance metrics.
Why this answer
Cloud Monitoring provides metrics like system lag and CPU utilization for Dataflow.
A Cloud Composer environment is experiencing high latency in the Airflow UI. What is a common cause and mitigation for this?
Complex DAGs increase parsing time, which impacts UI responsiveness.
Why this answer
High DAG count and complex dependency parsing can slow down the UI; using the 'DAG Serialization' feature (enabled by default in newer versions) helps, but optimizing DAG file size and complexity is the best mitigation.
You need to pass a JSON object into a Workflows execution. How should you format the argument in the 'gcloud workflows executions' command?
The --data flag is the correct way to pass inputs.
Why this answer
The '--data' flag accepts a JSON string, which is the standard format for passing parameters to workflows.
When creating a dashboard in Looker Studio, which connector type allows you to connect to an arbitrary SQL query?
This allows for complex logic directly in the data source.
Why this answer
The 'Custom Query' option in the BigQuery connector allows users to enter raw SQL.
Which TWO of the following are valid ways to visualize BigQuery data within the Google Cloud ecosystem?
Looker Studio is the native, no-cost visualization tool.
Why this answer
Looker Studio and Looker are the primary visualization tools for BigQuery data.
Which THREE of the following are common administrative tasks when managing a Dataplex Lake? (Choose three)
Managing the contents of the lake.
Why this answer
Admins handle access, assets, and task scheduling.
Which GCP tool provides a managed way to run Apache Airflow workflows?
Composer is the managed Airflow service.
Why this answer
Cloud Composer is the fully managed service for Apache Airflow.
A team requires access to a specific Dataplex Zone. You want to grant them the ability to view metadata and query the data without granting them full owner permissions. Which role should you assign at the Lake level?
This role is designed to allow read access to metadata and underlying data.
Why this answer
The Dataplex Data Viewer role allows viewing metadata and querying data within the lake assets.
You need to transfer files from an Amazon S3 bucket to GCS. What is the most efficient method?
This service is purpose-built for multi-cloud transfers.
Why this answer
Storage Transfer Service has a built-in connector for S3, making it the most direct method.
Which TWO of the following are best practices for managing Cloud Composer DAG dependencies?
Plugins allow sharing reusable operators.
Why this answer
Best practices include keeping DAGs small and using modular code for shared tasks.
Which THREE are features of Pub/Sub?
Supports push delivery.
Why this answer
Pub/Sub is global, scalable, and supports push/pull subscriptions.
Which THREE features does Looker offer to support data governance?
Ensures one source of truth for business logic.
Why this answer
Governance is supported by central modeling, user permissions, and audit logs.
You are migrating a legacy Airflow environment to Cloud Composer. You need to ensure that local Python packages used by custom operators are installed correctly. What is the recommended approach?
Composer automatically installs packages listed in the requirements.txt file.
Why this answer
Define custom Python dependencies in the 'requirements.txt' file in the environment's bucket for Composer to install.
You need to ensure data compliance for PII. Which THREE of the following tools or features should you use in combination with Dataplex? (Choose three)
Audit logs ensure accountability.
Why this answer
DLP API, Policy Tags, and Audit Logs are standard for compliance.
Which THREE of these are valid ways to monitor or analyze BigQuery performance?
Shows the execution stages of a query.
Why this answer
Performance analysis is done via metadata views, query plans, and monitoring dashboards.
Which THREE items can be added to a Looker Studio report to enhance interactivity?
Allows filtering by categorical values.
Why this answer
Controls allow users to change data views dynamically.
When setting up a new Dataplex Lake, which TWO of the following configurations are required? (Choose two)
Names must be unique within the project.
Why this answer
A name and a region are required for every Lake creation.
Which THREE of the following are necessary for a production-ready Dataflow pipeline?
Ensures reliability.
Why this answer
Monitoring, logging, and error handling are essential.
You need to anonymize PII (Personally Identifiable Information) before loading data into BigQuery. Which tool is best?
Cloud DLP is designed specifically for data masking and anonymization.
Why this answer
Cloud Data Loss Prevention (DLP) API provides automated de-identification and masking.
Which THREE of the following are valid methods for troubleshooting failed tasks in Cloud Composer?
Identifies the point of failure.
Why this answer
Reviewing logs, checking task instance states in the UI, and examining scheduler logs are all standard troubleshooting steps.
Which TWO of the following are recommended practices when designing a Dataflow pipeline for high-throughput streaming ingestion?
Effective parallelism is key to handling high throughput.
Why this answer
Separating your processing logic and using the correct windowing strategy are crucial for performance.
You have a Dataplex Lake containing data from two different regions. How does this affect data access?
Regional access rules still apply to the physical data.
Why this answer
You must ensure that users have the necessary IAM permissions to access the data in both regions; the lake acts as a logical container but does not override regional access restrictions.
You are working in a Vertex AI Workbench notebook and want to list the files in your current working directory. What command should you run?
The '!' prefix allows executing shell commands from a notebook cell.
Why this answer
In a Jupyter-based environment, the `ls` command (prefix with % or ! if in a cell) lists files in the current folder.
A BigQuery table has 10 billion rows. You notice a query performing a cross-join is timing out. What should you do?
JOIN ON is significantly more efficient than a cross-join.
Why this answer
Cross-joins on massive datasets are the leading cause of query failure; they should be avoided in favor of JOIN ON or other set-based operations.
You need to ensure that a Dataplex user cannot view the contents of files in a GCS bucket registered as an asset. What is the minimal configuration?
IAM roles on the underlying storage resource govern data access.
Why this answer
You must remove the Storage Object Viewer role from the user for that specific bucket, even if they have Dataplex viewer roles.
You have a Data Catalog taxonomy that you want to share across multiple projects. How do you achieve this?
Taxonomies can be created in a central project and referenced by others.
Why this answer
You create the taxonomy in a central host project and grant permissions to other projects to use it.
You are orchestrating a pipeline with Workflows that invokes several Cloud Functions. You need to pass the output of one function as an argument to the next. What is the correct syntax?
Workflows allows assigning results to variables for use in subsequent steps.
Why this answer
In Workflows, you capture the output of a call and pass it as an input variable to the next step using the assignment operator.
You are migrating a high-throughput on-premises database to BigQuery. You need to ensure zero downtime. What is your best strategy?
Datastream captures changes continuously, allowing for seamless migration.
Why this answer
Using Datastream to capture Change Data Capture (CDC) events allows for continuous, near-real-time synchronization.
Which THREE of the following Cloud Composer 2 features provide improved performance over Composer 1?
Integrated UI and configuration management.
Why this answer
Composer 2 offers auto-scaling, custom resource allocation, and environment-level configuration management.
When setting up a Dataplex Lake, you chose the 'Multi-region' location type. What is the implication of this choice?
Multi-region provides high availability and geo-redundancy.
Why this answer
Multi-region deployment increases availability and ensures data is replicated across multiple regions within the same geography.
What is the role of the 'Dataplex Data Steward'?
Data stewards handle the 'data' aspects of the platform.
Why this answer
The Data Steward is responsible for defining metadata, managing quality rules, and ensuring data policies are met.
Page 1 of 3
Page 2Practice GCP-ADP by domain
Target a specific domain to shore up weak areas.