Google Cloud Professional Data Engineer — Question 2

Your infrastructure includes a set of YouTube channels. You have been tasked with creating a process for sending the YouTube channel data to Google Cloud for analysis. You want to design a solution that allows your world-wide marketing teams to perform ANSI SQL and other types of analysis on up-to-date YouTube channels log data. How should you set up the log data transfer into Google Cloud?

Answer options

• A. Use Storage Transfer Service to transfer the offsite backup files to a Cloud Storage Multi-Regional storage bucket as a final destination.
• B. Use Storage Transfer Service to transfer the offsite backup files to a Cloud Storage Regional bucket as a final destination.
• C. Use BigQuery Data Transfer Service to transfer the offsite backup files to a Cloud Storage Multi-Regional storage bucket as a final destination.
• D. Use BigQuery Data Transfer Service to transfer the offsite backup files to a Cloud Storage Regional storage bucket as a final destination.

Correct answer: C

Explanation

The correct answer is C because using BigQuery Data Transfer Service is specifically designed for transferring data to BigQuery, which supports ANSI SQL queries. Options A and B involve the Storage Transfer Service, which is not optimized for direct integration with BigQuery. Option D uses the correct service but a Regional bucket, which may not provide the required performance and availability for global analysis.