Exam Professional Data Engineer topic 1 question 222 discussion

Actual exam question from Google's Professional Data Engineer

Question #: 222
Topic #: 1

[All Professional Data Engineer Questions]

You have a variety of files in Cloud Storage that your data science team wants to use in their models. Currently, users do not have a method to explore, cleanse, and validate the data in Cloud Storage. You are looking for a low code solution that can be used by your data science team to quickly cleanse and explore data within Cloud Storage. What should you do?

A. Provide the data science team access to Dataflow to create a pipeline to prepare and validate the raw data and load data into BigQuery for data exploration.
B. Create an external table in BigQuery and use SQL to transform the data as necessary. Provide the data science team access to the external tables to explore the raw data.
C. Load the data into BigQuery and use SQL to transform the data as necessary. Provide the data science team access to staging tables to explore the raw data.
D. Provide the data science team access to Dataprep to prepare, validate, and explore the data within Cloud Storage.

Show Suggested Answer

Suggested Answer: D 🗳️

by e70ea9e at Dec. 30, 2023, 9:48 a.m.

Comments

Submit Cancel

raaad

Highly Voted 1 year, 1 month ago

Selected Answer: D

- Dataprep is a serverless, no-code data preparation tool that allows users to visually explore, cleanse, and prepare data for analysis. - It's designed for business analysts, data scientists, and others who want to work with data without writing code. - Dataprep can directly access and transform data in Cloud Storage, making it a suitable choice for a team that prefers a low-code, user-friendly solution.

upvoted 13 times

...

JyoGCP

Most Recent 12 months ago

Selected Answer: D

Dataprep

upvoted 1 times

...

JimmyBK

1 year ago

Selected Answer: D

Goes without say

upvoted 1 times

...

Matt_108

1 year, 1 month ago

Selected Answer: D

Option D - Low code and efficient way to explore and prep data

upvoted 1 times

...

Alex3551

1 year, 1 month ago

why you message wrong answers correct is C

upvoted 1 times

Matt_108

1 year, 1 month ago

The "Reveal Answer" button contains 90% of the time an incorrect answer. You should always check the community and the discussion during studying :)

upvoted 2 times

...

e70ea9e

1 year, 1 month ago

Selected Answer: D

Low-Code Interface: Offers a visual, drag-and-drop interface that empowers users with varying technical skills to cleanse and explore data without extensive coding, aligning with the low-code requirement. Data Cleaning and Validation: Provides built-in tools for data profiling, cleaning, transformation, and validation, ensuring data quality and accuracy before model training. Direct Cloud Storage Access: Connects directly to Cloud Storage, allowing users to work with data in place without additional data movement or storage costs, optimizing efficiency.

upvoted 4 times

...