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?

BigQuery Data Transfer Service automates data loading into BigQuery from various sources, including Google Cloud Storage.BigQuery is specifically designed for performing ANSI SQL and other types of analysis on large datasets. Cloud Storage can be used as a staging area, especially a multi-region bucket if the teams are worldwide

BigQuery Data Transfer Service (C) is the best choice because it natively integrates with YouTube, automates data transfers, and enables seamless analysis in BigQuery.

C is the correct answer as the requirement is to transfer data to Google Cloud, which means Big Query and not GCS.

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.