Trang chủ Professional Data Engineer 316 / 343
Quay lại bộ đề
Question #316 Topic 1
You have a data analyst team member who needs to analyze data by using BigQuery. The data analyst wants to create a data pipeline that would load 200 CSV files with an average size of 15MB from a Cloud Storage bucket into BigQuery daily. The data needs to be ingested and transformed before being accessed in BigQuery for analysis. You need to recommend a fully managed, no-code solution for the data analyst. What should you do?
A
Create a Cloud Run function and schedule it to run daily using Cloud Scheduler to load the data into BigQuery.
B
Use the BigQuery Data Transfer Service to load files from Cloud Storage to BigQuery, create a BigQuery job which transforms the data using BigQuery SQL and schedule it to run daily.
C
Build a custom Apache Beam pipeline and run it on Dataflow to load the file from Cloud Storage to BigQuery and schedule it to run daily using Cloud Composer.
D
Create a pipeline by using BigQuery pipelines and schedule it to load the data into BigQuery daily.