Why data services matter in GCP - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Cloud Storage bucket named 'my-data-bucket'.

GCP

gsutil mb gs://[1]/

Drag options to blanks, or click blank then click option'

Abucket-data

Bdata-bucket-123

Cstorage-bucket

Dmy-data-bucket

Attempts:

3 left

💡 Hint

Common Mistakes

Using invalid bucket names

Omitting the gs:// prefix

Using spaces in bucket names

The command gsutil mb creates a new Cloud Storage bucket. The bucket name must be unique and is placed after gs://.

2fill in blank

medium

Complete the code to create a BigQuery dataset named 'analytics_data'.

GCP

bq mk [1]

Drag options to blanks, or click blank then click option'

Aanalytics_data

BanalyticsDataset

Cdata_analytics

Dmydataset

Attempts:

3 left

💡 Hint

Common Mistakes

Using camelCase instead of underscores

Using spaces in dataset names

Using invalid characters

The bq mk command creates a new BigQuery dataset. The dataset name should be descriptive and follow naming rules.

3fill in blank

hard

Fix the error in the command to load data from a CSV file into BigQuery table 'sales_data'.

GCP

bq load --source_format=CSV [1].sales_data gs://my-bucket/sales.csv

Drag options to blanks, or click blank then click option'

Asales_dataset

Bmydataset

Csales_data

Ddataset_sales

Attempts:

3 left

💡 Hint

Common Mistakes

Using table name instead of dataset name

Omitting the dataset name

Using incorrect dataset names

The bq load command requires the dataset name before the file path and table name. Here, 'mydataset' is the dataset where the table 'sales_data' will be created or updated.

4fill in blank

hard

Fill both blanks to create a Pub/Sub topic named 'data-updates' and publish a message 'Hello' to it.

GCP

gcloud pubsub topics create [1]
gcloud pubsub topics publish [2] --message="Hello"

Drag options to blanks, or click blank then click option'

Adata-updates

Bupdates-data

Cdata_update

Dupdate-data

Attempts:

3 left

💡 Hint

Common Mistakes

Using different topic names in create and publish commands

Typos in topic names

Using underscores instead of hyphens

Both commands must use the exact same topic name 'data-updates' to create and then publish a message to that topic.

5fill in blank

hard

Fill all three blanks to define a Cloud Function named 'processData' triggered by a Pub/Sub topic 'data-topic' with runtime 'python39'.

GCP

gcloud functions deploy [1] --runtime=[2] --trigger-topic=[3] --entry-point=main

Drag options to blanks, or click blank then click option'

AprocessData

Bpython39

Cdata-topic

DdataProcess

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong runtime versions

Mismatching topic names

Incorrect function names

The Cloud Function name is 'processData', the runtime is 'python39', and the trigger topic is 'data-topic'. These must match exactly for the function to deploy and trigger correctly.

Practice

1. Why are data services important in cloud computing?

easy

A. They simplify data management and improve security.

B. They increase the physical size of data centers.

C. They replace the need for internet connectivity.

D. They reduce the number of users accessing data.

Solution

1. Step 1: Understand the role of data services

   Data services help manage data easily and keep it safe in the cloud.

2. Step 2: Compare options

   Only They simplify data management and improve security. mentions simplifying management and improving security, which matches the role of data services.

3. Final Answer:

   They simplify data management and improve security. -> Option A

4. Quick Check:

   Data services = simplify and secure data [OK]

Hint: Data services make data easy and safe to use [OK]

Common Mistakes:

• Confusing data services with hardware size
• Thinking data services remove internet needs
• Assuming data services limit user access

2. Which of the following is the correct way to create a BigQuery dataset using gcloud CLI?

easy

A. gcloud dataset create bigquery my_dataset

B. gcloud bigquery create dataset my_dataset

C. gcloud bigquery datasets create my_dataset

D. gcloud create bigquery dataset my_dataset

Solution

1. Step 1: Recall gcloud CLI syntax for BigQuery dataset creation

   The correct command starts with 'gcloud bigquery datasets create' followed by the dataset name.

2. Step 2: Match options with correct syntax

   Only gcloud bigquery datasets create my_dataset matches the correct syntax exactly.

3. Final Answer:

   gcloud bigquery datasets create my_dataset -> Option C

4. Quick Check:

   Correct CLI syntax = gcloud bigquery datasets create my_dataset [OK]

Hint: Remember 'gcloud bigquery datasets create' for dataset creation [OK]

Common Mistakes:

• Mixing order of words in CLI command
• Using 'create dataset' instead of 'datasets create'
• Omitting 'bigquery' keyword

3. Given this code snippet using Google Cloud Storage client in Python:

bucket = client.get_bucket('my-bucket')
blob = bucket.blob('file.txt')
blob.upload_from_string('Hello World')

What will happen after running this code?

medium

A. A new file named 'file.txt' with content 'Hello World' is uploaded to 'my-bucket'.

B. The bucket 'my-bucket' is deleted.

C. An error occurs because 'upload_from_string' is not a valid method.

D. The content 'Hello World' is printed to the console.

Solution

1. Step 1: Understand the code actions

   The code gets a bucket, creates a blob (file) object, and uploads a string as file content.

2. Step 2: Identify the effect of 'upload_from_string'

   This method uploads the given string as the content of the blob in the bucket.

3. Final Answer:

   A new file named 'file.txt' with content 'Hello World' is uploaded to 'my-bucket'. -> Option A

4. Quick Check:

   upload_from_string uploads content to bucket [OK]

Hint: upload_from_string uploads text as file content [OK]

Common Mistakes:

• Thinking upload_from_string prints content
• Confusing blob creation with bucket deletion
• Assuming upload_from_string is invalid

4. You try to query a BigQuery table but get an error: Access Denied: User does not have permission. What is the most likely cause?

medium

A. The table does not exist in the dataset.

B. The user lacks the required IAM role to read the table.

C. The query syntax is incorrect.

D. The BigQuery service is down.

Solution

1. Step 1: Analyze the error message

   'Access Denied' and 'User does not have permission' indicate a permissions issue.

2. Step 2: Match error to cause

   Permission errors usually mean the user lacks the right IAM role to access the resource.

3. Final Answer:

   The user lacks the required IAM role to read the table. -> Option B

4. Quick Check:

   Access Denied = missing permissions [OK]

Hint: Access Denied means check user permissions first [OK]

Common Mistakes:

• Assuming table does not exist
• Blaming query syntax for permission errors
• Thinking service outage causes permission errors

5. You want to build an app that needs to store user profiles with flexible fields and run fast queries on user activity logs. Which GCP data services combination best fits this need?

hard

A. Use Bigtable for user profiles and Cloud Spanner for activity logs.

B. Use Cloud SQL for user profiles and Cloud Storage for activity logs.

C. Use Cloud Storage for user profiles and Cloud SQL for activity logs.

D. Use Cloud Firestore for user profiles and BigQuery for activity logs analysis.

Solution

1. Step 1: Identify data needs

   User profiles need flexible fields (NoSQL), and activity logs require fast, large-scale queries.

2. Step 2: Match services to needs

   Cloud Firestore is a NoSQL database good for flexible user profiles. BigQuery is designed for fast analysis of large datasets like logs.

3. Final Answer:

   Use Cloud Firestore for user profiles and BigQuery for activity logs analysis. -> Option D

4. Quick Check:

   Flexible data + fast queries = Firestore + BigQuery [OK]

Hint: NoSQL for flexible data, BigQuery for big data queries [OK]

Common Mistakes:

• Using Cloud SQL for flexible NoSQL data
• Storing logs in Cloud Storage without query ability
• Mixing services that don't fit data types