Practice Test 2 | Google Cloud Certified Professional Cloud Architect | Dumps | Mock Test
Once a month Terram Earth’s vehicles are serviced and the data is downloaded from the maintenance port. The data analysts would want to query the large amount of data collected from these vehicles and analyze the overall condition of the vehicles. Terram Earth’s management is looking at a solution that is cost-effective and would scale for future requirements. Please select the right choice based on the requirement.
A. Load the data from Cloud Storage to Bigquery and Run queries based on date using an appropriate filter on DATE for the data stored in Bigquery based on the date partitioned table.
B. Store the data in Bigtable and run queries on it.
C. Load the data from Cloud Storage to Bigquery and run queries on Bigquery.
D. Run queries against the data stored in Cloud Spanner.
Correct Answer: A
Option A is correct. Running queries based on month-for-date partitioned tables is an efficient and cost-optimized solution.
Option B is incorrect. While Bigtable can provide low latency for a high volume of reads and writes but it isn’t a requirement here.
Option C is incorrect. One of the requirements is the solution to be cost-effective, and loading the data from Cloud Storage to Bigquery and running queries on Bigquery is a cost-optimized but not a viable and performance-optimized solution.
Option D is incorrect. Cloud Spanner is a transactional database, the requirement suggests a data warehouse service.
Reference :
Comments are closed, but trackbacks and pingbacks are open.