Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A team is developing a mobile-enabled web application on Google Cloud that must manage two distinct data types:
Which combination of Google Cloud storage services should the team select to store the user profile data and media assets, respectively?
Cloud SQL is a managed relational database service for transactional OLTP workloads, and BigQuery is an enterprise, serverless data warehouse optimized for large-scale analytical queries (OLAP) using SQL.
The requirement called for storing structured relational transactional records (in Cloud SQL) and running complex business intelligence reporting across historical datasets (in BigQuery).
Cloud Bigtable is a sparsely populated, wide-column NoSQL database designed for petabyte-scale operational analytics and high-throughput sequential data. Cloud SQL is a fully managed relational database service that runs MySQL, PostgreSQL, or SQL Server engines.
The workload involved storing massive streaming IoT telemetry records requiring millisecond writes (Bigtable) alongside structured financial transactional records (Cloud SQL).
Cloud Firestore is a fully managed, serverless NoSQL document database designed for automatic scaling, high performance, and flexible document data models. Cloud Storage is Google Cloud's highly scalable, secure, and durable object storage service built to store and serve unstructured files and binary data.
Separating semi-structured application metadata into a document store (Firestore) and unstructured binary blobs into an object store (Cloud Storage) follows cloud architecture best practices. Storing binary assets directly inside database rows or documents degrades database indexing performance and inflates costs, whereas pairing Firestore with Cloud Storage achieves optimal performance, scalability, and cost efficiency.
This option reverses the roles of the two storage solutions by attempting to store fine-grained, semi-structured document entities in Cloud Storage and large unstructured binary assets (photos and videos) inside Cloud Firestore.
The application needed to store static profile export archives (such as batch JSON backups) in object storage and small text snippets or user status tokens in a NoSQL database.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated