Database operators example in Kubernetes - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

What is the primary role of a Database Operator in Kubernetes?

In Kubernetes, a Database Operator helps manage database lifecycle. What is its main job?

A Automatically manage database deployment, backups, scaling, and updates

B Only monitor database performance without making changes

C Replace the Kubernetes scheduler for database pods

D Serve as a database client to query data

💡 Hint

Think about automation tasks related to databases in Kubernetes.

Database Operators automate tasks like deployment, backup, scaling, and updates, making database management easier in Kubernetes.

💻 Command Output

intermediate

Output of checking PostgreSQL Operator pods status

You run the command kubectl get pods -n postgres-operator after installing a PostgreSQL Operator. What output indicates the operator is running correctly?

Kubernetes

kubectl get pods -n postgres-operator

A Error from server (NotFound): namespaces "postgres-operator" not found

B postgres-operator-abc123 1/1 Running 0 2m

C No resources found in postgres-operator namespace.

D postgres-operator-abc123 0/1 CrashLoopBackOff 3 2m

💡 Hint

Look for pods with all containers ready and status Running.

A pod with 1/1 containers ready and status Running means the operator pod is healthy and active.

❓ Configuration

advanced

Correct Custom Resource for a MySQL Cluster using an Operator

Which YAML snippet correctly defines a MySQL cluster custom resource for a MySQL Operator?

A

apiVersion: mysql.oracle.com/v1alpha1
kind: MySQLCluster
metadata:
  name: my-mysql
spec:
  replicas: 3
  version: "8.0"

B

apiVersion: mysql.oracle.com/v1alpha1
kind: Cluster
metadata:
  name: my-mysql
spec:
  replicas: 3
  version: "8.0"

C

apiVersion: mysql.oracle.com/v1alpha1
kind: MySQL
metadata:
  name: my-mysql
spec:
  nodes: 3
  version: "8.0"

D

apiVersion: mysql.oracle.com/v1alpha1
kind: Cluster
metadata:
  name: my-mysql
spec:
  nodes: 3
  version: "8.0"

💡 Hint

Check the kind field for the correct resource type the operator expects.

The MySQL Operator expects a custom resource of kind 'MySQLCluster' with spec fields like replicas and version.

❓ Troubleshoot

advanced

Troubleshooting a Failed Backup Job in a Database Operator

A backup job created by your database operator fails with the error 'permission denied'. What is the most likely cause?

A The database cluster has no replicas

B The database operator pod is not running

C The service account used by the backup job lacks permissions to access the storage location

D The Kubernetes API server is down

💡 Hint

Consider what permissions are needed for backup jobs to write data.

Backup jobs need proper permissions to write to storage. A 'permission denied' error usually means the service account lacks these permissions.

🔀 Workflow

expert

Order the steps to deploy a database using an Operator in Kubernetes

Put the following steps in the correct order to deploy a database using an Operator.

A 3,1,2,4

B 2,1,3,4

C 1,3,2,4

D 1,2,3,4

💡 Hint

Think about installing the operator first before creating and applying resources.

You must install the operator first, then create and apply the custom resource, and finally check the pods.