ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam
Go to Exam

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 Hide Answer
Suggested Answer: D 🗳️
by e70ea9e at Dec. 30, 2023, 9:48 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
raaad
Highly Voted 10 months 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 8 months, 2 weeks ago
Selected Answer: D
Dataprep
upvoted 1 times
...
JimmyBK
9 months, 2 weeks ago
Selected Answer: D
Goes without say
upvoted 1 times
...
Matt_108
9 months, 3 weeks ago
Selected Answer: D
Option D - Low code and efficient way to explore and prep data
upvoted 1 times
...
Alex3551
9 months, 3 weeks ago
why you message wrong answers correct is C
upvoted 1 times
Matt_108
9 months, 3 weeks 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
10 months 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago