Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A data analyst needs to prepare a raw customer dataset stored in Cloud Storage before loading it into BigQuery for reporting. The dataset contains several data quality issues, including leading and trailing whitespace, inconsistent date formats, and missing values.
The analyst needs a visual, code-free interface within Google Cloud to inspect sample rows, identify anomalies, interactively apply data cleaning directives, and convert the resulting recipe into an automated pipeline.
Which component of Cloud Data Fusion should the analyst use?
The Pipeline Hub in Cloud Data Fusion is a repository and template catalog that provides pre-configured pipeline templates, plugins, drivers, and reusable design patterns for common integration tasks.
The scenario asked: "Which Cloud Data Fusion feature provides a catalog of pre-built pipeline templates and downloadable plugins to quickly start common integration projects?"
Namespace Administration in Cloud Data Fusion is a governance and administrative capability used to isolate data, pipelines, configurations, and user permissions into distinct logical partitions (namespaces).
The scenario asked: "Which Cloud Data Fusion administrative feature should you configure to logically separate development and production pipelines within the same instance?"
Metadata Search in Cloud Data Fusion is a discovery and governance feature that indexes datasets, pipelines, schemas, and processing history across an entire Cloud Data Fusion instance.
The scenario asked: "Which feature of Cloud Data Fusion allows data governance teams to search for data assets and trace field-level lineage across existing pipelines?"
Wrangler is the interactive visual data preparation and data cleansing interface built directly into Cloud Data Fusion. It is designed to allow data analysts and data engineers to visually inspect, clean, and transform structured and semi-structured datasets without needing to write custom code or programming scripts.
Wrangler is the purpose-built visual tool in Google Cloud for interactive data cleansing and rapid recipe creation. It removes the need to write complex SQL, Python, or Java scripts for common data sanitization tasks, making data preparation accessible to both technical and non-technical team members.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated