205 questions total · 3pages · All types, answers revealed
Page 3 of 3
In Dataflow, what is the impact of using a high number of workers for a small dataset?
You pay for idle workers and incur management overhead.
Why this answer
Over-provisioning leads to excessive cost and overhead without performance gain.
You need to run a Workflows execution based on a schedule. Which Google Cloud service is designed to manage this triggering?
Cloud Scheduler is the standard service for recurring triggers.
Why this answer
Cloud Scheduler is the fully managed service for scheduling jobs, including triggers for Workflows.
When creating a Looker visualization, which chart type is best for showing the relationship between two numerical variables?
Scatter plots display data points representing two variables.
Why this answer
A scatter plot is the standard chart for observing the correlation or relationship between two numeric axes.
Which service should you use to search for and discover datasets across your entire Google Cloud organization?
Data Catalog allows centralized search and metadata discovery.
Why this answer
Data Catalog is the primary discovery tool for finding and understanding data assets in Google Cloud.
What happens if you delete a Dataplex Lake?
The lake is just a logical view; the storage remains intact.
Why this answer
Deleting a Lake removes the logical grouping but does not delete the underlying data assets (like BigQuery datasets or GCS buckets).
You are creating a Looker report with a 'measure' that calculates the total revenue. You notice it is summing correctly but the format is wrong. Where do you change the format?
This is the standard way to apply currency or numeric formats.
Why this answer
The 'value_format_name' or 'value_format' parameter in the LookML view definition is where you control display formatting.
When reviewing a Looker dashboard, which icon do you click to reload the data?
This triggers a re-query of the underlying data.
Why this answer
Looker dashboards have a refresh icon (circular arrow) that reloads the data based on current cache settings.
Your team needs to audit all modifications made to DAG files in the GCS bucket used by Cloud Composer. What is the most efficient way to achieve this?
Audit logs track all mutations to objects in GCS.
Why this answer
Enable Cloud Audit Logs (Data Access logs) on the GCS bucket to track all API calls including object modifications.
You are querying a dataset in BigQuery that uses partitioning. Your query doesn't use the partitioning column. What is the consequence?
This is the default and cost-inefficient behavior.
Why this answer
Without the partition filter, BigQuery performs a full table scan, increasing both cost and execution time.
You need to verify the integrity of a large file uploaded to GCS. What is the standard way to do this?
MD5 hash check is the standard method for verifying file integrity.
Why this answer
Comparing the MD5 hash provided by GCS against the local file's hash ensures integrity.
When configuring a Workflows execution, you want to ensure the workflow can be triggered by an HTTP POST request. Which feature allows this?
The Workflows API endpoint accepts POST requests to trigger executions.
Why this answer
Workflows can be triggered via HTTP POST requests to the workflow execution API endpoint.
In LookML, which parameter is used to define how a table should join to another?
This helps Looker understand how to aggregate joined data.
Why this answer
The 'relationship' parameter is essential for Looker to join tables correctly without errors.
You are building a streaming pipeline using Dataflow to process sensor data arriving via Pub/Sub. You need to handle out-of-order data by allowing events to arrive late. Which Dataflow concept must you configure?
Watermarks track when the system expects all data for a specific time window has arrived.
Why this answer
Watermarks and triggers are used in Dataflow to handle windowing and late data arrival in streaming pipelines.
Which TWO of the following statements about Dataplex discovery are true? (Choose two)
It automatically detects schemas.
Why this answer
Discovery is automatic for registered assets and generates metadata including schema.
Which TWO factors should you consider when choosing a GCS storage class?
Determines lifecycle needs.
Why this answer
Access frequency and data retention requirements drive the choice of storage class.
You have a Looker dashboard that loads slowly. What is the first thing you should check in the 'Looker System Activity' or 'Query History'?
Understanding execution time and the generated SQL is the first step in troubleshooting.
Why this answer
Checking the query history helps identify if the underlying database is slow or if the Looker model is generating inefficient SQL.
Which TWO of the following are GCP ingestion tools?
Primary landing zone for data.
Why this answer
Cloud Storage and Pub/Sub are both primary ingestion entry points.
You need to export query results from BigQuery to a Google Sheet. What is the easiest way to do this?
This provides a direct, simple integration.
Why this answer
BigQuery has a built-in 'Save Results' option that allows exporting directly to Google Sheets.
You have a query that processes 500GB of data. You want to reduce the cost of this query. What is the most effective approach?
Limiting the data scanned is the primary cost-saving technique in BigQuery.
Why this answer
Filtering by partition columns drastically reduces the amount of data scanned, directly lowering the cost.
You have noticed that your data quality tasks are failing. Which THREE of the following are potential causes for failure? (Choose three)
Invalid YAML structure will cause the task to fail.
Why this answer
Common failures include permission issues, invalid rule configurations, or missing execution environments.
You need to store sensitive data in GCS. Which feature ensures data is encrypted at rest?
GCS provides default encryption at rest for all stored objects.
Why this answer
All data in GCS is encrypted at rest by default using Google-managed keys.
You need to ensure that PII (Personally Identifiable Information) in BigQuery is automatically detected and tagged across your organization. Which Dataplex feature should you enable on your Lake?
Data discovery scans the underlying storage to detect and label data.
Why this answer
Dataplex discovery scans data assets and can automatically apply labels and tags based on system-defined taxonomies.
You need to perform data cleansing on a large dataset in Dataprep. Which execution engine should you choose for scalability?
Dataflow provides the distributed processing needed for large-scale Dataprep jobs.
Why this answer
Dataprep uses Dataflow as its execution engine to scale to large datasets.
You are writing a Python script in Vertex AI Workbench. You want to query BigQuery and load the result into a pandas DataFrame. Which library should you use?
This is the official client library for BigQuery integration with Python.
Why this answer
The `google-cloud-bigquery` library contains the `to_dataframe()` method which is specifically designed for this.
Which TWO are methods to secure GCS data?
Controls access.
Why this answer
IAM roles and Cloud KMS encryption are standard security methods.
A data analyst is working in a Vertex AI Workbench notebook. They want to connect to a private BigQuery dataset. How should they authenticate?
Google Cloud handles authentication via service account scopes for managed notebooks.
Why this answer
Vertex AI Workbench notebooks automatically handle authentication using the instance's service account.
When using Cloud Scheduler to trigger a Workflows execution, what is the best practice for authenticating the scheduler to the Workflows API?
OIDC provides secure authentication for Google Cloud API calls.
Why this answer
Using an OIDC token with a service account that has the 'Workflows Invoker' role is the secure, recommended method.
You are using Vertex AI Workbench. You want to install a new Python library, `seaborn`, for visualization. What is the correct way to install it in the notebook instance?
The '!' prefix allows running shell commands like pip install.
Why this answer
Using the pip magic command in a cell is the standard way to install libraries in a Jupyter environment.
Which service should you use to ingest streaming data from mobile devices?
Pub/Sub handles high-scale streaming ingestion.
Why this answer
Pub/Sub is the globally available, scalable message queue perfect for mobile ingestion.
You are building a Looker model and want to create a measure that calculates the count of distinct customers. Which type of measure should you use?
This is the native LookML way to perform distinct counts.
Why this answer
The `count_distinct` type is specifically designed for calculating unique occurrences in LookML.
What is the primary function of the 'Dataplex Discovery' process?
Discovery crawls the data to generate metadata and profile information.
Why this answer
Discovery automatically scans and catalogs data assets in your storage to make them discoverable.
You have a dashboard in Looker Studio and you want to allow users to dynamically change the date range without editing the report. What should you add?
This component enables interactive filtering of the report's time dimension.
Why this answer
A 'Date range control' allows end users to filter the entire report by a specific timeframe.
Which THREE of the following are valid BigQuery table types?
Standard storage.
Why this answer
BigQuery supports native, partitioned, and external tables.
You need to change the color palette of your Looker dashboard charts. Where should you make this change?
Theme/palette settings are defined at the dashboard level.
Why this answer
Dashboard color settings are managed within the dashboard theme settings or the individual chart edit menu.
You have data scattered across multiple projects and need to provide a unified data governance view. What is the recommended hierarchy?
Dataplex Lakes can aggregate assets across projects.
Why this answer
You create one Lake, and within that Lake, you add assets from different projects (within the same organization).
You need to ensure that deleted files in GCS can be restored for 30 days. What should you configure?
Object Versioning allows you to retrieve deleted files.
Why this answer
Object Versioning keeps versions of objects, and Lifecycle policies can delete older ones, but Object Versioning alone is the core feature here.
Which TWO of the following are true about the relationship between Data Catalog and Dataplex? (Choose two)
Data Catalog is the underlying metadata service.
Why this answer
Dataplex integrates Data Catalog capabilities; they are tightly coupled.
Which TWO of the following strategies help reduce Cloud Composer costs?
Stops ongoing costs.
Why this answer
Stopping unused environments and using environment auto-scaling are effective cost-saving measures.
You are running a Dataflow job and notice that it is consuming too much memory and crashing. How do you optimize this?
Choosing an appropriate machine type (e.g., n1-highmem) provides more memory for the workers.
Why this answer
Setting the worker machine type to one with more RAM or adjusting the pipeline to use fewer expensive transforms is the standard optimization path.
You are using Dataplex to manage data across multiple projects. You need to organize your BigQuery datasets and Cloud Storage buckets into a single logical entity for governance. Which Dataplex resource should you create?
A Lake is the top-level container for organizing data assets.
Why this answer
A Lake in Dataplex is a logical grouping of data assets that provides a boundary for governance and security.
You are implementing a security strategy for your data lake. Which THREE of the following are supported ways to control access to data within a Dataplex Lake? (Choose three)
Dataplex roles control access to the governance layer.
Why this answer
Access is controlled via IAM at the resource level, policy tags for fine-grained control, and Dataplex roles for metadata access.
You need to ingest log data into BigQuery from GCS files that arrive sporadically. Which service is best to trigger this?
Functions support GCS triggers to handle files as they arrive.
Why this answer
Cloud Functions, triggered by GCS object creation events, can automatically load files into BigQuery.
You are writing a complex BigQuery query and need to define a temporary table to use later in the same query. What is the most efficient syntax?
CTEs are standard, readable, and well-optimized by BigQuery.
Why this answer
Common Table Expressions (CTEs) defined with the WITH clause are the cleanest, most readable way to handle temporary logic.
You need to perform a complex windowing operation on streaming data in Dataflow. Which windowing strategy is best for session-based activity?
Session windows are designed to group activity by gaps in time.
Why this answer
Session windows group events that happen close together in time, which is ideal for sessionizing user activity.
A team is migrating to Dataplex. Which TWO of the following are prerequisites for adding a BigQuery dataset as an asset to a Lake? (Choose two)
You must have read access to link the dataset.
Why this answer
The user needs proper IAM permissions on the project and the dataset to register it as an asset.
You are using Dataflow with autoscaling. What metric determines whether the worker pool scales up or down?
Autoscaling reacts to the volume of pending work.
Why this answer
Dataflow autoscaling is based on the backlog of work and CPU usage of current workers.
You need to organize your data governance strategy. Which TWO of the following are valid ways to use Dataplex Zones to improve your data organization? (Choose two)
Zones act as security boundaries.
Why this answer
Zones are used to group assets by purpose (e.g., raw vs curated) and to enforce security policies.
You need to ingest IoT data into BigQuery. You need to handle messages arriving in millions per second. Which service acts as the buffer?
Pub/Sub is designed for massive scale ingestion.
Why this answer
Pub/Sub is the only Google Cloud service capable of ingesting millions of messages per second as a globally scalable buffer.
A user complains they cannot see a Dataplex Lake in the console. You verify they have the 'Viewer' role on the project. What is missing?
Specific product-level viewer roles are required for resource visibility.
Why this answer
The user needs a specific Dataplex role (like Dataplex Viewer) to see the Dataplex resources in the UI.
Which THREE of the following are Dataflow windowing types?
Standard window type.
Why this answer
Fixed, Sliding, and Session are the standard windowing types in Beam/Dataflow.
You need to run a task in Cloud Composer only if the previous task failed. Which Trigger Rule should you use?
This trigger rule executes if any parent task failed.
Why this answer
The 'one_failed' trigger rule allows a task to execute if at least one parent task has failed.
Which TWO of the following are true about Dataplex assets? (Choose two)
Assets share the zone's region.
Why this answer
Assets point to existing storage and are managed within zones.
Which THREE steps are involved in an effective Dataflow pipeline development?
Running in production.
Why this answer
Development, Testing, and Deployment are the standard pipeline steps.
You need to ingest data from an external API that requires an OAuth token. Which tool is best for executing this periodically?
Cloud Functions allows custom code to handle OAuth and API interactions.
Why this answer
Cloud Functions triggered by Cloud Scheduler can handle API requests with custom authentication logic.
You are using Dataprep to prepare data. How can you share your work with a team?
Sharing the flow provides access to the recipes and datasets.
Why this answer
Dataprep allows you to share 'Flows' with other project members.
Page 3 of 3
Practice GCP-ADP by domain
Target a specific domain to shore up weak areas.