Question 18 of 72
Single answerYou are working with a large dataset of customer reviews stored in Cloud Storage. The dataset contains several inconsistencies, such as missing values, incorrect data types, and duplicate entries. You need to clean the data to ensure that it is accurate and consistent before using it for analysis. What should you do?
A.Use the PythonOperator in Cloud Composer to clean the data and load it into BigQuery. Use SQL for analysis.
B.Use BigQuery to batch load the data into BigQuery. Use SQL for cleaning and analysis.
C.Use Storage Transfer Service to move the data to a different Cloud Storage bucket. Use event triggers to invoke Cloud Run functions to load the data into BigQuery. Use SQL for analysis.
D.Use Cloud Run functions to clean the data and load it into BigQuery. Use SQL for analysis.
<p>A.Use the PythonOperator in Cloud Composer to clean the data and load it into BigQuery. Use SQL for analysis.</p>
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.