Domain 3.4: Deploying and implementing data solutions

You have a CSV file named `data.csv` on your local machine. You need to upload this file to a Cloud Storage bucket named `my-data-bucket`. Which command should you use?

You need to load a large JSONL (JSON Lines) file from Cloud Storage into a BigQuery table. Which TWO methods can you use to accomplish this? (Select TWO)

You have a 50 GB CSV file stored locally on your on-premises server. You need to load this data into a BigQuery table named 'sales_data' in the dataset 'company_metrics'. Which command should you use?

You are migrating a MySQL database to Cloud SQL. You have exported your on-premises database to a SQL dump file. What is the recommended sequence of steps to import this data into your new Cloud SQL instance?

You have a 50 GB CSV file stored in a Cloud Storage bucket. You need to load this data into an existing BigQuery table named 'sales_data' in the 'finance' dataset. Which command-line tool and command should you use?

You are initializing a new Cloud SQL for PostgreSQL instance for a production application. The database must be highly available and able to survive a zone failure with zero data loss and minimal downtime. Which TWO configuration choices must you make during initialization? (Select TWO)

You have a 50 GB CSV file stored in a Cloud Storage bucket. You need to load this data into a BigQuery table named 'sales_data' in the 'finance' dataset. Which command-line tool and command should you use?

You are setting up a new Cloud Spanner database for a global application. You need to initialize the instance, create a database, and define the schema. Which TWO statements are true regarding the deployment and initialization of Cloud Spanner? (Select TWO)

You have a large CSV file stored in a Cloud Storage bucket (`gs://my-bucket/sales_data.csv`). You need to load this data into an existing BigQuery table named `sales` in the `analytics` dataset. Which command should you use?

You need to initialize a new Cloud SQL for PostgreSQL instance by importing a `.sql` dump file. Which TWO requirements must be met to successfully perform this import? (Select TWO)

You have a large CSV file containing historical sales data stored in a Cloud Storage bucket (`gs://my-data-bucket/sales.csv`). You need to load this data into an existing BigQuery table named 'sales_history' in the 'analytics' dataset. Which command-line tool and command should you use?

You are migrating an on-premises MySQL database to Cloud SQL. You have exported the on-premises database to a SQL dump file. Which TWO steps are required to import this data into your new Cloud SQL instance? (Select TWO)

You have a 50 GB CSV file stored in a Cloud Storage bucket (`gs://my-data-bucket/sales.csv`). You need to load this data into a BigQuery table named `sales_data` in the `finance` dataset. Which command should you use?

You need to import a large SQL dump file into a Cloud SQL for MySQL instance. The dump file is currently stored in a Cloud Storage bucket. Which TWO prerequisites must be met before you can successfully perform the import? (Select TWO)