Google Cloud SQL - Managing databases in Cloud SQL MCQ

Google Cloud SQL – 5 – Managing databases in Cloud SQL MCQ

1 / 26

1. What is the primary purpose of creating a database in Google Cloud SQL?

To establish a connection to the internet

To store and manage data

To manage server logs

To optimize query performance

2 / 26

2. Which SQL command is used to create a new database in Google Cloud SQL?

CREATE USER

CREATE INSTANCE

CREATE DATABASE

CREATE TABLE

3 / 26

3. How can you grant permissions to a user to access a database in Cloud SQL?

GRANT ACCESS

GRANT PRIVILEGES

GRANT DATABASE

GRANT USERNAME

4 / 26

4. What SQL command is used to revoke a specific privilege from a user in Cloud SQL?

REVOKE PERMISSIONS

REVOKE USER

REVOKE ACCESS

REVOKE PRIVILEGES

5 / 26

5. Which command creates an on-demand backup of a Google Cloud SQL database?

gcloud sql instances patch [INSTANCE_NAME]

gcloud sql backups create [BACKUP_NAME]

gcloud sql restore [BACKUP_NAME]

gcloud sql create-backup [DATABASE_NAME]

6 / 26

6. How can you restore a database from a backup in Google Cloud SQL?

gcloud sql instances patch [INSTANCE_NAME]

gcloud sql backups restore [BACKUP_NAME]

gcloud sql restore [BACKUP_NAME]

gcloud sql instances create [REPLICA_NAME]

7 / 26

7. What does “scaling” refer to in the context of Google Cloud SQL?

Creating a new database

Managing IAM roles and permissions

Increasing the size of your instance

Adjusting the font size of the Cloud Console

8 / 26

8. Which command is used to resize a Google Cloud SQL instance?

gcloud sql restore [BACKUP_NAME]

gcloud sql backups create [BACKUP_NAME]

gcloud sql instances create [REPLICA_NAME]

gcloud sql instances patch [INSTANCE_NAME]

9 / 26

9. What is the purpose of creating read replicas in Google Cloud SQL?

To restrict database access

To disable SSL/TLS encryption

To simplify backup and restore processes

To improve write performance

10 / 26

10. What are the benefits of using Cloud Monitoring in Google Cloud SQL?

Custom monitoring dashboards

Creating new databases

Managing user access

Performing backups and restores

11 / 26

11. What is the primary role of the maintenance window in Cloud SQL?

Creating read replicas

Minimizing disruptions during maintenance

Controlling the font size of the Cloud Console

Managing user authentication

12 / 26

12. How can you improve query performance in Google Cloud SQL?

Using proper indexing and caching

Granting access to all users

Creating custom monitoring dashboards

Adjusting the maintenance window

13 / 26

13. What tool allows you to connect to your Cloud SQL instance securely within a VPC network?

Cloud SQL Proxy

Serverless VPC Access

Cloud Console

IAM roles and permissions

14 / 26

14. What is the primary advantage of using IAM roles for access control in Cloud SQL?

Fine-grained access control

Improved machine type

Automatic database backups

Query optimization

15 / 26

15. What is the purpose of SSL/TLS encryption in Cloud SQL connections?

Data at rest encryption

Data in transit encryption

DNS resolution

Managing server logs

16 / 26

16. What should you do to effectively manage database queries in Google Cloud SQL?

Disable SSL/TLS encryption

Perform backups frequently

Use query profiling and optimization tools

Share credentials in plaintext

17 / 26

17. What is the significance of the Cloud SQL Proxy tool in connecting to Cloud SQL instances?

Monitoring database performance

Simplifying and securing connections

Configuring IAM roles and permissions

Creating backups

18 / 26

18. How does Private IP enhance security when connecting to a Cloud SQL instance?

It assigns a public IP address

It enables automatic failover

It increases machine type

It restricts access to a VPC network

19 / 26

19. What is the primary role of Cloud Identity and Access Management (IAM) in Cloud SQL?

Controlling access to databases

Configuring backups

Monitoring query performance

Managing DNS resolution

20 / 26

20. How can you optimize performance in Google Cloud SQL by controlling query access?

Using a larger font size

Managing database backups

Enabling public IP access

Using firewall rules and IP whitelisting

21 / 26

21. What is the primary benefit of using Serverless VPC Access to connect to Cloud SQL?

Secure and private connections

Automatic backups

DNS resolution

Minimizing query performance

22 / 26

22. What does Cloud Monitoring help you achieve in Google Cloud SQL?

Creating custom monitoring dashboards

Managing query performance

Controlling access to databases

Configuring backups

23 / 26

23. How can you restrict access to your Cloud SQL instance within your VPC network?

Configuring a Private IP

Using the Cloud SQL Proxy

Using a public IP address

Increasing the machine type

24 / 26

24. What is the primary advantage of using Cloud SQL for database management in the cloud?

Adjusting DNS resolution

Data security and scalability

Scheduling maintenance windows

Managing user profiles

25 / 26

25. What is the primary purpose of optimizing database queries in Google Cloud SQL?

Improving query performance

Creating new databases

Controlling font colors

Enhancing data protection

26 / 26

26. What tool can you use to create custom monitoring dashboards in Google Cloud SQL?

Cloud Pub/Sub

Cloud Spanner

Cloud Monitoring

Cloud Storage

Your score is

Google Cloud SQL – Managing databases in Cloud SQL MCQ