Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Your company relies on data stored in BigQuery to generate its reports. Recently, you have identified that some fields in the weekly executive reports are not adhering to the required company standards. Common issues include inconsistent telephone number formats and varying country code identifiers. Recognizing that this is a recurring problem, you need to implement an automated, recurring job to normalize the data. You seek a fast and coding-free solution. What should you do?
Your company relies on data stored in BigQuery to generate its reports. Recently, you have identified that some fields in the weekly executive reports are not adhering to the required company standards. Common issues include inconsistent telephone number formats and varying country code identifiers. Recognizing that this is a recurring problem, you need to implement an automated, recurring job to normalize the data. You seek a fast and coding-free solution. What should you do?
Explanation:
The correct answer is A. Cloud Data Fusion and Wrangler provide a no-code solution for data normalization. Data Fusion offers an intuitive visual interface for building ETL pipelines, and Wrangler is a feature within Data Fusion that allows for interactive data preparation. This option meets the requirement of no coding and allows for setting up recurring jobs to normalize the data according to company standards.