Google Associate Cloud Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
Your company has a 5 TB AVRO file in Cloud Storage containing five years of user activity data from your E-commerce website. The data analysis team, proficient in SQL, needs access to this data to predict FMCG product demands. What is the most cost-effective and quickest method to meet their needs?
Explanation:
Option A is incorrect because loading a 5 TB file into Cloud Datastore is slow and expensive, and Cloud Datastore is a NoSQL database, which may complicate data transformation. Option B is incorrect because loading the data into BigQuery incurs unnecessary storage and processing costs, and dropping the table would require reloading data for future requests. Option C is correct because BigQuery supports querying external tables in AVRO format directly from Cloud Storage, offering a cost-effective and efficient solution without additional storage costs. Option D is incorrect due to the unnecessary complexity and overhead of managing a Hadoop cluster for this task.