DE D1

Which of the following tasks (on the cloud) are data engineers responsible for accomplishing?

• Managing data in a data warehouse

• Setting up physical servers to store data

• Building data pipelines

BigQuery is Google's serverless data warehouse offering on Google Cloud.

• True

• False

Which of the following are storage classes on Google Cloud?

• Ancient

• Coldline

• Archive

• Live

You chose EU region for your BigQuery data. Select all statements that are TRUE.

• Data will be stored in at least 2 different regions

• Data will be stored in at least 2 different zones in 1 region

• 
  On-demand compute pricing will be cheaper than in single region.

• 
  On-demand compute pricing will be more expensive than in single region.

Which CLI tool is more performant(faster) if you want to upload data to Cloud Storage or download data from Cloud Storage.

• gcloud storage

• gsutil

Which service is the most appropriate for migrating petabytes of data to Google Cloud when network bandwidth is a major bottleneck

• Storage Transfer Service

• Transfer Appliance

• gcloud storage cp

• BigQuery Data Transfer Service

Which Google Cloud service allows for building and managing SQL workflows in BigQuery with version control and data quality testing?

• Dataform

• Cloud Scheduler

• Datastream

• Analytics Hub

What’s the most important concept you learned on Day 1 ?