Google Cloud SQL - Creating a Google Cloud SQL instance MCQ

Google Cloud SQL – 2 – Creating a Google Cloud SQL instance MCQ

1 / 26

1. What is the first step to create a Google Cloud SQL instance?

Create a virtual machine

Install a database management system

Enable Google Cloud Platform (GCP) billing

2 / 26

2. What is the primary purpose of creating a Cloud SQL instance?

To design a user interface

To enable high availability

To configure network settings

To simplify database administration

3 / 26

3. Which database engines are supported by Google Cloud SQL?

MongoDB, Cassandra, Redis

SQLite, MariaDB, Couchbase

Oracle, DB2, Sybase

MySQL, PostgreSQL, SQL Server

4 / 26

4. What is the significance of choosing a specific region for your instance?

It sets up email notifications

It defines the timezone for your instance

It impacts the database performance

It determines the billing frequency

5 / 26

5. How can you enable high availability for your Cloud SQL instance?

By using only read replicas

By selecting "High availability" during setup

By configuring advanced encryption options

By choosing a large machine type

6 / 26

6. What is the purpose of setting a root password during instance creation?

To log into the GCP Console

To control access to your database

To connect to the database using SSH

To enable public access to the instance

7 / 26

7. What type of storage can you configure for a Cloud SQL instance?

None of the above

SSD or RAM disk storage

Magnetic, SSD, or Cloud Filestore storage

Floppy disk or optical drive storage

8 / 26

8. What role does Google Identity and Access Management (IAM) play?

It enables fine-grained access control

It manages the instance's network settings

It provides data encryption

It configures machine types and regions

9 / 26

9. What is the purpose of setting up automated backups for your Cloud SQL instance?

To improve query performance

To synchronize data with other instances

To protect data and enable point-in-time recovery

To reduce storage costs

10 / 26

10. How can you configure a Private IP for your Cloud SQL instance?

By specifying the subnet in IAM

By creating a custom network

By installing a VPN

By using a public IP address

11 / 26

11. What configuration can you set during the maintenance preferences step?

Maintenance frequency

Preferred database engine

Database backup schedule

Operating system version

12 / 26

12. What does enabling read replicas in Cloud SQL provide?

Improved write performance

Enhanced security

Reduced data redundancy

Simplified backup and restore processes

13 / 26

13. Which of the following statements about billing for Cloud SQL is true?

It's always free

It's based solely on the number of instances

It's determined by the number of queries executed

It's dependent on instance performance

14 / 26

14. What details are provided after a successful Cloud SQL instance creation?

MAC address and SSL certificate

Social security number and mother's maiden name

GPS coordinates and mailing address

IP address, port, username, and password

15 / 26

15. What tool can you use to monitor the performance of your Cloud SQL database?

Cloud Spanner

Cloud Storage

Cloud Monitoring

Cloud Pub/Sub

16 / 26

16. Which type of encryption is used for data in transit in Cloud SQL?

AES-256

MD5

SSL/TLS

SHA-1

17 / 26

17. Which of the following is not a supported way to connect to a Cloud SQL instance?

Using Morse code

Using Cloud SQL Proxy

Using Private IP

Using Public IP

18 / 26

18. What feature allows you to isolate your Cloud SQL instance?

IP whitelisting

IAM roles

Firewall rules

VPC peering

19 / 26

19. What does Cloud SQL Proxy simplify in terms of authentication?

It blocks all incoming connections

It adds more users to the database

It simplifies database administration tasks

It improves database security

20 / 26

20. What is the primary role of Cloud SQL in content management systems (CMS)?

Managing user authentication and login

Providing customer support

Storing and retrieving website content

Hosting images and videos

21 / 26

21. What kind of applications can benefit from using Google Cloud SQL as a backend?

Mobile apps

3D modeling software

Cryptocurrency mining software

Game engines

22 / 26

22. Which option allows you to create databases within a Cloud SQL instance?

Google Cloud Pub/Sub

Google Cloud Console

Google Cloud Firestore

Google Cloud Spanner

23 / 26

23. In Cloud SQL, what details do you need to connect your application to an instance?

Social security number and mother's maiden name

GPS coordinates and email address

MAC address and SSL certificate

IP address, username, password

24 / 26

24. What kind of replication does Cloud SQL support for read scalability?

Vertical scaling

Diagonal scaling

No scaling

Horizontal scaling

25 / 26

25. What is the primary purpose of Cloud SQL in the gaming industry?

Controlling traffic lights

Launching rockets

Managing user profiles

Brewing coffee

26 / 26

26. What can businesses use Cloud SQL for in terms of analytics?

Augmented reality

Image recognition

Data warehousing

Natural language processing

Your score is

Google Cloud SQL – Creating a Google Cloud SQL instance MCQ