Data access logs in GCP - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to enable data access logs for a BigQuery dataset.

GCP

resource "google_bigquery_dataset" "dataset" {
  dataset_id = "my_dataset"
  project    = "my_project"
  location   = "US"

  access_logs_config {
    [1] = true
  }
}

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

Adata_access_logs_enabled

Benable_data_access_logs

Cdata_access_logging

Dlog_data_access

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect attribute names like 'enable_data_access_logs' or 'log_data_access'.

The correct attribute to enable data access logs in the BigQuery dataset resource is data_access_logs_enabled.

2fill in blank

medium

Complete the code to specify the log type for data access logs in Cloud Audit Logs.

GCP

resource "google_logging_project_sink" "data_access_sink" {
  name        = "data-access-logs"
  destination = "storage.googleapis.com/my-bucket"
  filter      = "logName:[1]"
}

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

A"cloudaudit.googleapis.com/activity"

B"cloudaudit.googleapis.com/data_access"

C"cloudaudit.googleapis.com/system_event"

D"cloudaudit.googleapis.com/admin_activity"

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'activity' or 'admin_activity' log names instead of 'data_access'.

The filter for data access logs uses the log name cloudaudit.googleapis.com/data_access.

3fill in blank

hard

Fix the error in the IAM policy binding to allow logging service account to write data access logs.

GCP

resource "google_project_iam_member" "logging_writer" {
  project = "my_project"
  role    = "roles/logging.[1]"
  member  = "serviceAccount:logging@my_project.iam.gserviceaccount.com"
}

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

Alogs.writer

Blogging.logWriter

Clogging.logWriterRole

DlogWriter

Attempts:

3 left

💡 Hint

Common Mistakes

Adding extra prefixes like 'logging.' or suffixes like 'Role' in the role name.

The correct role for allowing logging write access is roles/logging.logWriter, but in the code the role is specified after 'roles/logging.' so only 'logWriter' is needed as the blank.

4fill in blank

hard

Fill both blanks to configure a sink that exports data access logs to a Pub/Sub topic.

GCP

resource "google_logging_project_sink" "data_access_sink" {
  name        = "data-access-logs"
  destination = "pubsub.googleapis.com/[1]"
  filter      = "logName:[2]"
}

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

Aprojects/my-project/topics/my-topic

Bprojects/my-project/subscriptions/my-subscription

C"cloudaudit.googleapis.com/data_access"

D"cloudaudit.googleapis.com/activity"

Attempts:

3 left

💡 Hint

Common Mistakes

Using a subscription path instead of a topic path for destination.

Using the wrong log name in the filter.

The destination for Pub/Sub sinks uses the topic path like 'projects/my-project/topics/my-topic'. The filter for data access logs uses 'cloudaudit.googleapis.com/data_access'.

5fill in blank

hard

Fill all three blanks to create a BigQuery dataset with data access logs enabled and a sink exporting logs to Cloud Storage.

GCP

resource "google_bigquery_dataset" "dataset" {
  dataset_id = [1]
  project    = [2]
  location   = "US"

  access_logs_config {
    data_access_logs_enabled = true
  }
}

resource "google_logging_project_sink" "sink" {
  name        = "bq-data-access-logs"
  destination = "storage.googleapis.com/[3]"
  filter      = "logName:cloudaudit.googleapis.com/data_access"
}

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

A"my_dataset"

B"my_project"

C"my-bucket"

D"dataset_logs"

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting quotes around string values.

Using incorrect bucket names or project IDs.

The BigQuery dataset ID is 'my_dataset', the project is 'my_project', and the sink destination bucket is 'my-bucket'.

Practice

1. What is the main purpose of data access logs in Google Cloud?

easy

A. To reduce storage costs

B. To record who accessed or changed your cloud data

C. To automatically backup your data

D. To increase the speed of data processing

Solution

1. Step 1: Understand what data access logs record

   Data access logs track user actions on cloud data, such as access or changes.

2. Step 2: Identify the main purpose

   The main goal is to monitor and audit who accessed or modified data for security and compliance.

3. Final Answer:

   To record who accessed or changed your cloud data -> Option B

4. Quick Check:

   Data access logs = record access and changes [OK]

Hint: Logs track data access and changes, not performance or cost [OK]

Common Mistakes:

• Confusing logs with backup or performance tools
• Thinking logs reduce costs automatically
• Assuming logs speed up data processing

2. Which of the following is the correct way to enable data access logs for a Google Cloud service?

easy

A. Install a logging agent on your local machine

B. Create a firewall rule to allow logging

C. Use Cloud Storage lifecycle rules

D. Enable audit logs in Cloud IAM & Admin for the service

Solution

1. Step 1: Identify how to enable data access logs

   Data access logs are enabled by configuring audit logs in Cloud IAM & Admin for the specific service.

2. Step 2: Eliminate unrelated options

   Firewall rules, local agents, and storage lifecycle rules do not enable audit logging.

3. Final Answer:

   Enable audit logs in Cloud IAM & Admin for the service -> Option D

4. Quick Check:

   Audit logs enabled via IAM & Admin [OK]

Hint: Audit logs are enabled in IAM & Admin, not by firewall or agents [OK]

Common Mistakes:

• Confusing firewall rules with logging setup
• Thinking local agents enable cloud audit logs
• Using storage lifecycle rules for logging

3. Given this filter for a logging sink:
resource.type="bigquery_resource" AND protoPayload.methodName="tableservice.insert"
What logs will this sink collect?

medium

A. All Cloud Storage bucket creations

B. All BigQuery query executions

C. All BigQuery table creation events

D. All Compute Engine VM starts

Solution

1. Step 1: Analyze the filter components

   The filter targets resource type 'bigquery_resource' and method 'tableservice.insert', which means table creation in BigQuery.

2. Step 2: Match filter to log events

   This filter collects logs about BigQuery tables being created, not queries or other services.

3. Final Answer:

   All BigQuery table creation events -> Option C

4. Quick Check:

   Filter matches BigQuery table inserts [OK]

Hint: Look for resource type and method name to identify event type [OK]

Common Mistakes:

• Confusing table creation with query execution
• Mixing BigQuery with Cloud Storage or Compute Engine
• Ignoring methodName in filter

4. You created a logging sink to export data access logs to BigQuery but see no data arriving. What is a likely cause?

medium

A. Data access logs are disabled in the project

B. BigQuery dataset is in a different region

C. The sink uses a Cloud Storage bucket instead of BigQuery

D. The sink filter excludes data access logs

Solution

1. Step 1: Check if data access logs are enabled

   If data access logs are disabled, no logs will be generated or exported.

2. Step 2: Consider other causes

   While filters and regions matter, the most common cause is logs not enabled at all.

3. Final Answer:

   Data access logs are disabled in the project -> Option A

4. Quick Check:

   Logs must be enabled to export data [OK]

Hint: Verify logs are enabled before checking sinks [OK]

Common Mistakes:

• Assuming filter or region is always the problem
• Confusing sink destination with log generation
• Not enabling data access logs in IAM & Admin

5. You want to audit all data access to Cloud Storage buckets in your project and store logs in BigQuery for analysis. Which steps should you take?

hard

A. Enable data access audit logs for Cloud Storage, create a sink with filter resource.type="gcs_bucket", export to BigQuery dataset

B. Enable system logs only, create a sink exporting all logs to Cloud Storage

C. Install logging agents on VMs, export logs to BigQuery without filters

D. Create a firewall rule to allow logging traffic, enable data access logs

Solution

1. Step 1: Enable data access audit logs for Cloud Storage

   This ensures logs capture who accessed or changed Cloud Storage buckets.

2. Step 2: Create a sink with filter resource.type="gcs_bucket" and export to BigQuery

   This filters logs to only Cloud Storage bucket access and stores them in BigQuery for analysis.

3. Final Answer:

   Enable data access audit logs for Cloud Storage, create a sink with filter resource.type="gcs_bucket", export to BigQuery dataset -> Option A

4. Quick Check:

   Enable logs + filter + export to BigQuery = audit setup [OK]

Hint: Enable logs, filter by resource, export to BigQuery [OK]

Common Mistakes:

• Using system logs instead of data access logs
• Exporting all logs without filtering
• Relying on firewall rules for logging