GCP Professional Data Engineer Practice Question

A healthcare provider must comply with national regulations that prohibit any hyperscaler, including Google Cloud, from ever holding or recovering the encryption keys that protect patient data. The analytics team wants to load sensitive HL7 records into BigQuery and Cloud Storage, using customer-managed encryption keys that reside in an on-premises Hardware Security Module (HSM). The solution must

  • ensure that Google Cloud services can never decrypt data without a successful call to the on-premises HSM,
  • avoid operational work to periodically re-import keys into Google Cloud, and
  • minimize downtime if the primary on-premises HSM becomes unreachable.

Which design best satisfies these requirements?

  • Create a Cloud KMS key that uses Cloud External Key Manager. Define an EkmConnection with multiple on-premises HSM endpoints and set that key as a CMEK for BigQuery datasets and Cloud Storage buckets.

  • Configure Customer-Managed Encryption Keys (CMEK) stored in Cloud KMS HSM and enable automatic Google-managed fallback in case the on-premises HSM is unavailable.

  • Use Customer-Supplied Encryption Keys (CSEK) for each Cloud Storage object and configure periodic re-upload of the key material to avoid expiry.

  • Import the HSM key material into Cloud KMS every 90 days, then reference the imported key as a CMEK for BigQuery and Cloud Storage.

GCP Professional Data Engineer
Designing data processing systems
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot