Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
An enterprise runs an operational and analytics data platform on Google Cloud with the following access profiles and requirements:
Which multi-service tiered storage strategy optimizes storage and retrieval costs while maintaining the required query latency?
This option attempts to tier data by applying Bigtable tiered storage without application query modifications, offloading 90-day-old BigQuery data into Cloud Storage Coldline external tables, and placing raw object archives in Archive storage.
Analytical tables were never queried interactively, Bigtable operational queries were non-latency-sensitive batch exports, and Cloud Storage payloads were kept strictly for multi-year compliance without regular access.
This architecture optimizes cost across disparate Google Cloud storage systems (Cloud Bigtable, BigQuery, and Cloud Storage) by mapping specific data lifecycle policies and storage classes to the distinct access frequency, query latency, and retention requirements of each workload.
This solution strikes the exact balance between storage-class rates, retrieval fees, and query latency across all three specialized GCP services.
This strategy uses Bigtable garbage collection to drop aged operational data, sets a table expiration policy of 90 days in BigQuery, and avoids object tiering in Cloud Storage.
Operational data past 30 days and analytics past 90 days had zero retention value and could be safely discarded, while Cloud Storage objects required daily high-throughput access.
This configuration proposes converting the entire Bigtable cluster storage layer to HDD, using periodic BigQuery DML rewrite jobs to manage partitioning, and moving Cloud Storage files into Coldline storage.
Bigtable workloads consisted exclusively of large batch scans where latency was irrelevant, and Cloud Storage archives were read at most once per year.
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