PCDE Plan and manage database infrastructure — All Questions With Answers

Refer to the exhibit.

```
gcloud spanner instances create test-instance \
    --config=regional-us-central1 \
    --description="Test Instance" \
    --nodes=2
```

Refer to the exhibit.

```
Failed to create connection to Cloud SQL instance `myproject:us-central1:myinstance`.
Error: SQL Server does not exist or access denied.
```

Refer to the exhibit.
```
$ gcloud spanner instances list
NAME         CONFIG          NODES  STATE
orders-db    regional-us-central1  3   READY
analytics-db regional-us-central1  5   READY
$ gcloud spanner databases list --instance=orders-db
NAME     STATE
orders   READY
$ gcloud spanner databases get-iam-policy orders --instance=orders-db
bindings:
- members:
  - serviceAccount:sa-backup@project.iam.gserviceaccount.com
  role: roles/spanner.databaseReader
- members:
  - serviceAccount:sa-backup@project.iam.gserviceaccount.com
  role: roles/spanner.databaseBackupAdmin
etag: BwXZ...==
```

Refer to the exhibit.

```
gcloud spanner instances create test-instance \
    --config=regional-us-west1 \
    --description="Test Instance" \
    --nodes=2 \
    --processing-units=1000
```

The command output shows an error: "ERROR: (gcloud.spanner.instances.create) INVALID_ARGUMENT: processing_units and nodes cannot be set simultaneously."

Refer to the exhibit.

gcloud sql instances describe my-instance
...
databaseVersion: POSTGRES_13
settings:
  activationPolicy: ALWAYS
  availabilityType: ZONAL
  backupConfiguration:
    enabled: true
    pointInTimeRecoveryEnabled: true
    startTime: '03:00'
    transactionLogRetentionDays: '7'
  dataDiskSizeGb: '100'
  dataDiskType: PD_SSD
  tier: db-custom-4-15360
...

Refer to the exhibit.

{
  "bindings": [
    {
      "role": "roles/storage.objectViewer",
      "members": [
        "serviceAccount:sa-1@project.iam.gserviceaccount.com",
        "user:admin@example.com"
      ]
    },
    {
      "role": "roles/storage.objectAdmin",
      "members": [
        "serviceAccount:sa-2@project.iam.gserviceaccount.com"
      ]
    }
  ],
  "etag": "BwXQ=="
}

Refer to the exhibit.

gcloud bigtable instances describe my-bigtable-instance
--format="json"
{
  "name": "my-bigtable-instance",
  "displayName": "my-bigtable-instance",
  "instanceType": "PRODUCTION",
  "state": "READY"
}

gcloud sql instances describe my-instance --format=json
Output:
{"availabilityType": "ZONAL", "databaseVersion": "MYSQL_8_0", "region": "us-central1"}

gcloud spanner instances describe my-instance --format=json
Output:
{"config": "regional-us-central1", "nodeCount": 1, "displayName": "my-instance"}

gcloud bigtable instances describe my-instance --format=json
Output:
{
  "instanceType": "PRODUCTION",
  "clusters": [
    {
      "id": "cluster-a",
      "zone": "us-central1-a",
      "serveNodes": 3,
      "defaultStorageType": "HDD",
      "location": "us-central1-a"
    }
  ]
}

CREATE TABLE Users (
  UserId INT64 NOT NULL,
  Name STRING(MAX),
) PRIMARY KEY (UserId);

gcloud bigtable instances create my-instance \
    --display-name="My Instance" \
    --cluster=my-cluster \
    --cluster-zone=us-central1-a \
    --cluster-num-nodes=3 \
    --cluster-storage-type=SSD \
    --cluster-autoscaling-min-nodes=1 \
    --cluster-autoscaling-max-nodes=10

service cloud.firestore {
  match /databases/{database}/documents {
    match /{document=**} {
      allow read: if request.auth != null;
      allow write: if request.auth != null && request.auth.uid == resource.data.owner;
    }
  }
}

2024-04-01 12:00:00 UTC [ERROR] [my-instance] : SSL connection required. Client IP: 192.168.1.1. Instance requires SSL for public connections.

CREATE TABLE Customers (
  CustomerId INT64 NOT NULL,
  Name STRING(1024),
) PRIMARY KEY (CustomerId);

CREATE TABLE Orders (
  CustomerId INT64 NOT NULL,
  OrderId INT64 NOT NULL,
  OrderDate DATE,
) PRIMARY KEY (CustomerId, OrderId),
  INTERLEAVE IN PARENT Customers ON DELETE CASCADE;

gcloud sql instances describe my-instance --format='json' | jq '.settings.backupConfiguration'
{
  "binaryLogEnabled": true,
  "enabled": true,
  "startTime": "03:00",
  "transactionLogRetentionDays": 7
}

Refer to the exhibit.

```
gcloud sql instances describe my-instance --format=json
{
  "kind": "sql#instance",
  "name": "my-instance",
  "databaseVersion": "MYSQL_8_0",
  "state": "RUNNABLE",
  "region": "us-central1",
  "settings": {
    "tier": "db-n1-standard-2",
    "activationPolicy": "ALWAYS",
    "backupConfiguration": {
      "enabled": true,
      "binaryLogEnabled": true,
      "pointInTimeRecoveryEnabled": true,
      "startTime": "07:00",
      "retentionSettings": {
        "retentionUnit": "COUNT",
        "retainedBackupsCount": 7
      }
    }
  },
  "ipAddresses": [
    {
      "ipAddress": "34.71.123.45",
      "type": "PRIMARY"
    }
  ]
}
```

Refer to the exhibit.

```json
[
  {
    "name": "projects/my-project/instances/test-instance/backups/backup-1",
    "createTime": "2024-01-15T10:00:00Z",
    "expireTime": "2024-01-22T10:00:00Z",
    "versionTime": "2024-01-15T10:00:00Z",
    "database": "projects/my-project/instances/test-instance/databases/mydb",
    "state": "READY",
    "referenceBackup": null,
    "encryptionInfo": {
      "encryptionType": "GOOGLE_DEFAULT_ENCRYPTION"
    }
  }
]
```

gcloud spanner instances describe test-instance
config: regional-us-central1
displayName: test-instance
nodeCount: 3
state: READY