Storing the data Questions
Practice questions for Storing the data topic in Google Cloud Professional Data Engineer. 38 questions covering this domain.
Cloud Storage lifecycle management rules apply at what scope?
What is stored in BigQuery when you create an external table?
How is Cloud Bigtable organized according to its overview?
Which statement accurately describes Cloud SQL high availability for MySQL?
A dataset requires cross-region redundancy in two specific regions and may later need turbo replication. Which Cloud Storage location type is the best...
A workload needs low-latency access to a massive sparse table where unused columns should consume no storage space. Which service is the best fit?
Which statement accurately describes BigQuery storage?
If multiple Cloud Storage lifecycle rules match an object and one rule deletes the object while another changes its storage class, which action takes ...
A system requires globally distributed relational transactions with serializable isolation and external consistency. Which statement about Spanner bes...
Which statement about Cloud Bigtable consistency is correct?
A BigQuery table grows to many terabytes, and most queries filter on a date column called event_date. Which design most directly reduces bytes scanned...
Which Spanner schema feature physically co-locates child rows with their parent row to make joins on the parent key efficient?
A BigQuery user accidentally deletes important rows from a table. Within the time-travel window, which approach restores the data without requiring an...
Which Cloud Storage class is intended for data that is accessed less than once per year and offers the lowest at-rest storage cost in exchange for hig...
A Bigtable schema designer wants to avoid hotspots when storing time-ordered events for many devices. Which row-key design is recommended?
A Cloud Storage bucket holds critical configuration files, and the team wants to be able to recover previous versions if an object is overwritten or d...
A BigQuery table is already partitioned by date, but queries also frequently filter on customer_id and product_id. Which feature should be applied nex...
A regulated workload requires that the encryption keys protecting BigQuery and Cloud Storage data remain under the customer's control, with the abilit...
A Spanner workload frequently filters rows by a column that is not the primary key. Which Spanner feature most directly accelerates these lookups?
An application connects to a Cloud SQL for PostgreSQL instance over an encrypted connection without whitelisting IP addresses in the Cloud SQL authori...
Sign in to see all 38 questions
Create a free account to browse all questions — completely free during our launch phase.