Google Cloud SQL - Introduction to Google Cloud SQL MCQ

Google Cloud SQL – 1 – Introduction to Google Cloud SQL MCQ

1 / 26

1. What is Google Cloud SQL primarily designed for?

Web development

Game development

Artificial Intelligence

None of the above

2 / 26

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

SQLite, MariaDB, Couchbase

MongoDB, Cassandra, Redis

Oracle, DB2, Sybase

MySQL, PostgreSQL, SQL Server

3 / 26

3. What does Cloud SQL offer to simplify database administration?

Container orchestration

Video streaming services

Automated patch management

Data visualization tools

4 / 26

4. How does Cloud SQL ensure high availability?

By using only read replicas

Through manual failover configurations

By enabling automatic failover

By setting up regular backups

5 / 26

5. What is a benefit of using read replicas in Cloud SQL?

Reduced data redundancy

Simplified backup and restore processes

Enhanced security

Improved write performance

6 / 26

6. What type of encryption does Cloud SQL provide for data at rest?

SHA-256

RSA-2048

AES-128

AES-256

7 / 26

7. Which security feature allows you to isolate your Cloud SQL instance?

Firewall rules

VPC peering

IP whitelisting

IAM roles

8 / 26

8. What is the purpose of automated daily backups in Cloud SQL?

To synchronize data across multiple instances

To protect data and enable point-in-time recovery

To create new databases

To enhance query performance

9 / 26

9. Which use case is suitable for Cloud SQL?

Storing customer data for an e-commerce website

Creating a virtual reality game

Building a weather forecasting application

Managing a fleet of autonomous drones

10 / 26

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

Data warehousing

Augmented reality

Natural language processing

Image recognition

11 / 26

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

Mobile apps

Game engines

3D modeling software

Cryptocurrency mining software

12 / 26

12. What are the initial steps to get started with Google Cloud SQL?

Create a GCP project and enable billing

Build a web application

Install a database management system

Hire a database administrator

13 / 26

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

GCP Project

Google Cloud Storage

Google Cloud Console

Google Cloud Functions

14 / 26

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

IP address, username, password

GPS coordinates, email address, phone number

Social security number, mother's maiden name

MAC address, SSL certificate, private key

15 / 26

15. How can existing databases be migrated into Cloud SQL?

Using telepathy

It's not possible

Using tools provided by Google Cloud

Manually re-entering all data

16 / 26

16. What does Google Cloud SQL simplify for businesses and developers?

Aerospace engineering

Application development

Quantum computing

Grocery shopping

17 / 26

17. What can Cloud SQL be used for in the gaming industry?

Launching rockets

Managing user profiles

Controlling traffic lights

Brewing coffee

18 / 26

18. Which type of businesses can benefit from using Google Cloud SQL?

Neither startups nor enterprises

Both startups and enterprises

Only startups

Only Fortune 500 companies

19 / 26

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

Storing and retrieving website content

Managing user authentication and login

Hosting images and videos

Providing customer support

20 / 26

20. What does Cloud SQL provide for monitoring the performance of a database?

Cloud Monitoring

GPS navigation

Built-in video player

Virtual reality headsets

21 / 26

21. Which encryption technology is used for data in transit in Cloud SQL?

ROT13

MD5

SHA-1

SSL/TLS

22 / 26

22. Which tool can be used to create and manage databases in Google Cloud SQL?

Google Cloud Firestore

Google Cloud Console

Google Cloud Spanner

Google Cloud Pub/Sub

23 / 26

23. What feature in Cloud SQL allows you to protect your data from accidental deletion?

Biometric authentication

Backup and recovery

Data masking and redaction

IAM roles

24 / 26

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

No scaling

Vertical scaling

Diagonal scaling

Horizontal scaling

25 / 26

25. Which option enables you to monitor the performance of your Cloud SQL database?

Cloud Climbing

Cloud Cartography

Cloud Monitoring

Cloud Cooking

26 / 26

26. What is the purpose of using Cloud SQL Proxy for authentication?

To simplify database administration tasks

To improve database security

To add more users to the database

To block all incoming connections

Your score is

Google Cloud SQL – Introduction to Google Cloud SQL MCQ