Practice Test 3 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
Data analysts in your company are looking for a tool that can be used to check the data tables uploaded by showing review of the data rows and some of the useful stats on columns such as missing cells, expected data type and possible pattern. The tool should provide a user-friendly and easy-to-use UI for data analysts. Which of the following products would you recommend for this scenario?
A. Dataflow
B. BigQuery
C. Dataproc
D. Cloud Dataprep
Correct Answer: D
Cloud Dataprep is an intelligent data service for visually exploring, cleaning, and preparing structured and unstructured data for analysis, reporting, and machine learning.
Because Cloud Dataprep is serverless and works at any scale, there is no infrastructure to deploy or manage. Your next ideal data transformation is suggested and predicted with each UI input, so you don’t have to write code.
With the automatic schema, datatype, possible joins, and anomaly detection, you can skip time-consuming data profiling and focus on data analysis.
Option A is incorrect: Using Dataflow means building a workflow pipeline which can be complicated and time-consuming for this scenario.
Option B is incorrect: BigQuery does not provide stats required in the scenario by default. You need to run and schedule queries to return such stats.
Option C is incorrect: Dataproc is a complicated service for data profiling comparing to Dataprep.
Source(s):
Cloud Dataprep:
Comments are closed, but trackbacks and pingbacks are open.