Storing data
Practise only this domain. 92 questions with explanations, 20 at a time.
Start storing dataSample questions
- A SaaS startup runs an order-management application that needs a managed PostgreSQL database with automated backups, point-in-time recovery and automatic maintenance. It does not need writes in multiple regions. Which service is the best fit?Easy
- A payments company must keep transaction receipts in a Cloud Storage bucket for 10 years. Regulators require that no one, including project owners, can delete or overwrite a receipt before its retention period ends. Which configuration meets this requirement?Medium
- An IoT platform stores sensor readings in BigQuery. Every dashboard query specifies a reading time window, and many queries also filter by sensor_id. What table design fits this access pattern best?Medium
- An executive dashboard reruns the same aggregation query every few minutes against an unchanging daily table. The dashboard must respond in under a second when people interact with it. Which approach fits best?Easy
- A payments platform needs a relational schema with multi-row ACID transactions, SQL access and strongly consistent reads. It must also keep synchronous replicas on three continents so the service survives a regional outage. Which storage service fits?Medium
- A data governance lead wants to know which BigQuery datasets and tables consume the most logical and physical storage, so that cleanup work can be targeted. Which built-in source provides this view?Easy
- A mobile inventory app must refresh its screen the moment a stock document changes in Cloud Firestore, without the client repeatedly asking the server whether anything changed. What should the developer attach to that document?Easy
- A photo marketplace stores originals and edited versions of each image. Prior file versions must stay recoverable for 90 days and then be removed without manual work. Which design meets this?Easy
- A genomics company keeps raw sequencing outputs that Spark jobs, a BigQuery dashboard, and a Presto cluster must all read. Storage should avoid duplicate copies. Which approach enables shared access?Medium
- A data engineer must show auditors which upstream files and which Dataflow pipeline steps produced a reporting table in BigQuery, so that each table can be traced back to its origins. Which capability should the engineer use?Easy
- A marketing analyst runs a query over a 10 TB events table to find the 100 accounts with the most conversions last month. The table is partitioned by event date, but the query filters only on conversion status. The analyst wants a lower on-demand bill. Which change helps most?Medium
- A hospital moved imaging files into the coldest Cloud Storage class last year. An auditor now needs three of those files within the next half hour for a review. Which statement describes the situation correctly?Medium