Exam Professional Data Engineer topic 1 question 69 discussion

Correct Answer: A Destination is GCS and having multi-regional so A is the best option available. Even since BigQuery Data Transfer Service initially supports Google application sources like Google Ads, Campaign Manager, Google Ad Manager and YouTube but it does not support destination anything other than bq data set

None of the answers make any sense. BigQuery Transfer Service is for moving data from various sources (S3, Youtube etc) into BigQuery, not Google Cloud Storage. Further, how are we supposed to use SQL to query data if it is stored in Cloud Storage?

First thing log data is usually semi-strucutred or unstrucutred data, then GCS is more suitable in this situation. Besides, you can use external table or BigLake to run BQ query directly running on GCS.

This is A, because it's "offsite backup files". You can transfer direct from Youtube to BigQuery: https://cloud.google.com/bigquery/docs/youtube-channel-transfer, but this isn't that. It's direct from some backup files to Cloud Storage, all answers mandate that fact, and all that remains is "should this be Storage Transfer, or BigQuery" - clearly this is storage transfer, and all the youtube/ANSI sql stuff is just distraction.

E. Use BigQuery Data Transfer Service to transfer the offsite backup files to BigQuery as a final destination.

Using BQ data transfer we can only load data into the Bigquery storage, which means a table inside the bq dataset. What is Storage Transfer Service? Storage Transfer Service automates the transfer of data to, from, and between object and file storage systems, including Google Cloud Storage, Amazon S3, Azure Storage, on-premises data, and more. It can be used to transfer large amounts of data quickly and reliably, without the need to write any code. As per the above lines from the Google's documentation on Storage transfer service, we can go with option A. For additional info, have a look at the below link. https://cloud.google.com/storage-transfer/docs/overview?_gl=1*jaku2h*_ga*MjA5Mzc4OTM0LjE2ODQ3MzA5NzQ.*_ga_WH2QY8WWF5*MTcxNTA1OTM0OC4xODMuMS4xNzE1MDU5NTY3LjAuMC4w&_ga=2.6452401.-209378934.1684730974&_gac=1.162721358.1713078448.CjwKCAjw_e2wBhAEEiwAyFFFo4Da6-2MNQqNJuzAGSyJmCXdaPpXXiqaI0lkZYHlcln0IBbtWSJjLBoCp_4QAvD_BwE

Correct answer: A Solution should cater a worldwide solution which makes B and D invalid. You don't use BigQuery Data transfer to move data to a bucket. So C is also invalid.

BigQuery Data Transfer Service can only transfer to BigQuery not in Cloud Storage. So Ans A is correct.

No sense to use BQ data transfer serice to store the data to a storage bucket ... It is obviously A

To transfer YouTube channel data to Google Cloud for analysis, you can use the BigQuery Data Transfer Service to transfer the offsite backup files to a Cloud Storage Multi-Regional storage bucket as a final destination 1. This service allows you to automatically schedule and manage recurring load jobs for YouTube Channel reports 1. The BigQuery Data Transfer Service for YouTube Channel reports supports the following reporting options: Channel Reports (automatically loaded into BigQuery) 1. When you transfer data from a YouTube Channel into BigQuery, the data is loaded into BigQuery tables that are partitioned by date 1.

The correct answer is C. https://cloud.google.com/bigquery/docs/dts-introduction

not c The BigQuery Data Transfer Service automates data movement into [[[[ BigQuery ]]]] on a scheduled, managed basis. Your analytics team can lay the foundation for a BigQuery data warehouse without writing a single line of code. ... After you configure a data transfer, the BigQuery Data Transfer Service automatically loads data into [[[[[ BigQuery ]]]]] on a regular basis.

Correct answer is A. At first, it's between A and C because of the term multi-regional. However, since you cannot use the BigQuery Data Transfer Service to transfer data out of BigQuery, A is the correct answer. Source: https://cloud.google.com/bigquery/docs/dts-introduction

What VishalB said is correct.

GPT: Option A: Using Storage Transfer Service to transfer offsite backup files to a Cloud Storage Multi-Regional storage bucket is not the best option for this use case since this service is designed to transfer data from on-premises or other cloud providers to Google Cloud, not for data transfer from YouTube channels. Option B: Using Storage Transfer Service to transfer offsite backup files to a Cloud Storage Regional bucket as a final destination is also not the best option since this service is designed for data transfer from on-premises or other cloud providers to Google Cloud, not for data transfer from YouTube channels.

Option C suggests using BigQuery Data Transfer Service to transfer data to a Cloud Storage Multi-Regional storage bucket. While this is a valid approach to transfer data to a storage bucket, using a multi-regional bucket is not necessary for this use case and can incur additional cost.

Answer is A As Bigquery data transfer service cannot support loading data from offsite locations. https://cloud.google.com/bigquery/docs/dts-introduction