# Professional-Data-Engineer — Question 427

**Type:** multiple_choice
**Topics:** topic_1

## Question

You need to copy millions of sensitive patient records from a relational database to BigQuery. The total size of the database is 10 TB. You need to design a solution that is secure and time-efficient. What should you do?

## Correct Answer

_See scenario._

## Explanation

You are transferring sensitive patient information, so C & D are ruled out. Choice comes down to A & B. Here it gets tricky. How to choose Transfer Appliance: (https://cloud.google.com/transfer-appliance/docs/2.0/overview)
Without knowing the bandwidth, it is not possible to determine whether the upload can be completed within 7 days, as recommended by Google. So the safest and most performant way is to use Transfer Appliance.
Therefore my choice is B.

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/google/Professional-Data-Engineer/427  
Practice (tracked): https://hiexam.net/study/Professional-Data-Engineer/practice