Google Cloud SQL - Configuring instance settings MCQ

Google Cloud SQL – 3 – Configuring instance settings MCQ

1 / 30

1. What is the primary purpose of configuring instance settings in Google Cloud SQL?

To optimize performance, security, and scalability

To create a new database

To design user interfaces

To customize the database engine

2 / 30

2. Which of the following database engines is supported by Google Cloud SQL?

NoSQL

MySQL

PostgreSQL

MongoDB

3 / 30

3. What is the significance of choosing the machine type during instance configuration?

It sets up private networking

It allocates CPU and memory resources

It defines the database engine version

It determines the maintenance frequency

4 / 30

4. How can you enhance the availability of your Cloud SQL instance?

By disabling backups

By enabling high availability

By selecting a different region

By using public IP addresses

5 / 30

5. What does the root password control during instance setup?

Database performance

Access to your database

Network configurations

The number of database replicas

6 / 30

6. What types of storage can you configure for a Cloud SQL instance?

Mechanical hard drives

Floppy disk or optical drive storage

Magnetic, SSD, or Cloud Filestore storage

RAM disk storage

7 / 30

7. What role does high availability play in Cloud SQL instances?

It optimizes database queries

It allows public IP access

It enables automatic failover

It increases instance performance

8 / 30

8. What does configuring database flags and parameters allow you to do?

Enable high availability

Customize the behavior of your database

Adjust the machine type

Set up a Private IP for the instance

9 / 30

9. What is the primary advantage of using Private IP for a Cloud SQL instance?

Improved database security

Enhanced write performance

Lower subscription costs

Public access from anywhere

10 / 30

10. How can you control who can access your Cloud SQL instance?

By choosing a larger machine type

By using public IP addresses

By disabling the instance

By configuring IAM roles and permissions

11 / 30

11. What is the purpose of setting up automated backups for a Cloud SQL instance?

To limit the number of database replicas

To reduce storage costs

To ensure data availability

To enforce password complexity rules

12 / 30

12. What is the function of read replicas in Cloud SQL?

They provide high availability

They simplify backup and restore processes

They reduce data redundancy

They improve write performance

13 / 30

13. How is database version selection relevant to instance configuration?

It defines the maintenance window

It specifies the number of read replicas

It chooses the database engine version

It determines the machine type and storage capacity

14 / 30

14. What does Google Identity and Access Management (IAM) control in Cloud SQL?

Network settings

Maintenance schedules

Machine type and storage capacity

Access to the database

15 / 30

15. How can you configure a Cloud SQL instance to be accessible only via Private IP?

By specifying a maintenance window

By using a firewall rule

By enabling high availability

By setting up public IP addresses

16 / 30

16. What is the primary purpose of setting up maintenance preferences?

To control maintenance notifications

To schedule automated backups

To minimize disruptions during maintenance

To configure database flags and parameters

17 / 30

17. What role does selecting the geographic region play during instance setup?

It affects instance performance

It determines the root password

It sets up machine type and storage

It controls the maintenance window

18 / 30

18. What is the primary advantage of configuring alerting for your Cloud SQL instance?

It proactively detects and addresses performance issues

It monitors network traffic

It configures automated backups

It improves database security

19 / 30

19. How does Google Cloud SQL handle billing for its services?

It charges a fixed monthly fee

It charges based on the number of instances

It bills based on instance performance

It offers a free trial with no charges

20 / 30

20. What details are provided after successfully creating a Cloud SQL instance?

MAC address and SSL certificate

Social security number and mother's maiden name

GPS coordinates and mailing address

IP address, port, username, and password

21 / 30

21. What tool can you use to monitor the performance of your Cloud SQL instance?

Cloud Monitoring

Cloud Storage

Cloud Pub/Sub

Cloud Spanner

22 / 30

22. How is data in transit secured in Cloud SQL?

With firewall rules and IP whitelisting

Through encryption at rest

Using SSL/TLS encryption

By disabling internet access

23 / 30

23. Which of the following is not a supported method for connecting to a Cloud SQL instance?

Using Morse code

Using Private IP

Using Public IP

Using Cloud SQL Proxy

24 / 30

24. What does IAM provide for securing your Cloud SQL instance?

Backup and recovery settings

Machine type and storage capacity

Network settings

Fine-grained access control

25 / 30

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

Providing customer support

Storing and retrieving website content

Hosting images and videos

Managing user authentication and login

26 / 30

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

Cryptocurrency mining software

Mobile apps

Game engines

3D modeling software

27 / 30

27. How can you create databases within a Cloud SQL instance?

By using Google Cloud Spanner

By using Google Cloud Pub/Sub

By using Google Cloud Console

By using Google Cloud Firestore

28 / 30

28. What type of scaling does Cloud SQL support for read scalability?

Vertical scaling

Horizontal scaling

No scaling

Diagonal scaling

29 / 30

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

Managing user profiles

Controlling traffic lights

Brewing coffee

Launching rockets

30 / 30

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

Augmented reality

Image recognition

Natural language processing

Data warehousing

Your score is

Google Cloud SQL – Configuring instance settings MCQ