Question-32: You are employed by a consulting business that offers data solutions to the vast majority of corporations on the Fortune 500 list. The wage scale for resources employed in your organisation, where the majority (80%) of the data analytics engineers came from Indian IIT institutions, is pretty high. You have been charged with developing a marketing analytics and reporting application using online analytical processing (OLAP). A relational database that is capable of working with tens or hundreds of terabytes of data is required for this. Which tool does Google suggest for using with these kinds of applications?
A. Cloud Spanner, because it is globally distributed
B. Cloud SQL, because it is a fully managed relational database
C. Cloud Firestore, because it offers real-time synchronization across devices
D. BigQuery, because it is designed for large-scale processing of tabular data
Correct Answer
Get All 340 Questions and Answer for Google Professional Cloud Architect
: 4 Explanation: RDBMS are things like Cloud SQL and BigQuery. Bigtable and Cloud Datastore both use NoSQL, whereas OLAP is equivalent to BQ. A relational database that is capable of working with tens or hundreds of terabytes of data is required for this. Relational and querying of join tables are both supported by BigQuery. Google Cloud Spanner is used for OLTP whereas BigQuery is used for OLAP. The relational database BigQuery uses Cloud SQL is not an online analytical processing system, and it cannot store or analyse hundreds of terabytes of data. Only up to 64 terabytes may be stored.