Google Cloud Professional Cloud Developer — Question 281

You are developing an application component to capture user behavior data and stream the data to BigQuery. You plan to use the BigQuery Storage Write API. You need to ensure that the data that arrives in BigQuery does not have any duplicates. You want to use the simplest operational method to achieve this. What should you do?

Answer options

• A. Create a write stream in the default type.
• B. Create a write stream in the committed type.
• C. Configure a Kafka cluster. Use a primary universally unique identifier (UUID) for duplicate messages.
• D. Configure a Pub/Sub topic. Use Cloud Functions to subscribe to the topic and remove any duplicates.

Correct answer: B

Explanation

The correct answer is B because creating a write stream in the committed type ensures that data is written in a way that prevents duplicates. Options A, C, and D either do not specifically address the prevention of duplicates in the simplest manner or introduce unnecessary complexity with additional components.