Google Cloud SQL - Cloud SQL Proxy for authentication MCQ

Google Cloud SQL – 20 – Cloud SQL Proxy for authentication MCQ

1 / 25

1. What is the primary purpose of Google Cloud SQL Proxy?

Act as a firewall for Cloud SQL instances

Manage database instances

Monitor database performance

Securely connect applications to Cloud SQL

2 / 25

2. How does Google Cloud SQL Proxy enhance security?

By acting as an intermediary for secure connections

By providing firewall capabilities

By encrypting database files

By restricting database access

3 / 25

3. What is the benefit of using Google Cloud SQL Proxy for authentication?

Increased performance of database operations

Direct access to database files

Simplified authentication without credentials

Access to proxy logs

4 / 25

4. Which authentication methods can you use with Google Cloud SQL Proxy?

Google Cloud credentials and service account keys

IAM roles and SSL/TLS certificates

API keys and HMAC credentials

IP whitelisting and OAuth tokens

5 / 25

5. How can you start Google Cloud SQL Proxy with the necessary configuration?

./cloud_sql_proxy -instances=[INSTANCE_CONNECTION_NAME]=tcp:5432 -credential_file=[PATH_TO_CREDENTIALS]

gcloud sql proxy start [CONFIG_OPTIONS]

run_sql_proxy –instance=[INSTANCE_CONNECTION_NAME] –credentials=[PATH_TO_CREDENTIALS]

start_proxy –instance=[INSTANCE_CONNECTION_NAME] –credentials=[PATH_TO_CREDENTIALS]

6 / 25

6. What is the purpose of specifying -instances in the Google Cloud SQL Proxy command?

To specify the connection name of the Cloud SQL instance

To specify the database name

To specify the proxy's IP address

To specify the proxy's local port

7 / 25

7. Which part of the command is used to define the Cloud SQL instance’s connection name in the proxy command?

–tcp

–instance

–credentials

-instances

8 / 25

8. What should be provided for the credential_file parameter in the proxy command?

Path to Google Cloud credentials

Path to SQL scripts

Path to database backup files

Path to SSL/TLS certificates

9 / 25

9. What type of connections does Google Cloud SQL Proxy manage between applications and the Cloud SQL instance?

Encrypted connections

Physical connections

Static connections

Dynamic connections

10 / 25

10. How does Google Cloud SQL Proxy handle connection pooling?

It creates a new connection for each query

It enforces SSL/TLS encryption for each connection

It dynamically manages and reuses database connections

It restricts the number of queries per connection

11 / 25

11. What is the benefit of using Google Cloud SQL Proxy in a cross-platform environment?

It enforces IP-based restrictions

It enables database mirroring

It supports various programming languages and platforms

It restricts connections to a single platform

12 / 25

12. How can Google Cloud SQL Proxy help in reducing the attack surface for a Cloud SQL instance?

By acting as a firewall and limiting access

By disabling SSL/TLS encryption

By increasing the instance's public IP addresses

By allowing unrestricted access to the database

13 / 25

13. What does the parameter -dir do in the Google Cloud SQL Proxy command?

Specifies the proxy's IP address

Specifies the directory for proxy logs

Specifies the database directory

Specifies the proxy's local port

14 / 25

14. What is the primary function of the -credential_file parameter in the proxy command?

Specifies the path to SSL/TLS certificates

Specifies the path to Google Cloud credentials

Specifies the path to the proxy executable

Specifies the proxy's IP address

15 / 25

15. Which parameter is used to specify the local port for the proxy in the command?

–local_port

–proxy_port

–instances

–local_address

16 / 25

16. How can you terminate a running Google Cloud SQL Proxy instance?

Use the command stop_proxy

Use the command terminate_proxy

Press Ctrl + D in the terminal

Press Ctrl + C in the terminal

17 / 25

17. What is the purpose of specifying the -json parameter in the proxy command?

To enable JSON-based authentication

To output logs in JSON format

To enable verbose logging

To specify JSON input for the proxy

18 / 25

18. How does Google Cloud SQL Proxy simplify application configuration for database connections?

By managing authentication and connection details

By enforcing SSL/TLS encryption

By restricting connection options

By limiting the number of database connections

19 / 25

19. How does Google Cloud SQL Proxy enhance security when connecting to Cloud SQL from local environments?

By encrypting all database files

By avoiding the need to expose the database to the internet

By enforcing strict IP address restrictions

By using a hardware firewall

20 / 25

20. What is the primary benefit of specifying the –pid_file parameter in the proxy command?

To specify the proxy's process ID

To enable process tracing

To specify the proxy's local port

To specify the database PID

21 / 25

21. What happens if you omit the -credential_file parameter in the proxy command?

The proxy prompts for credentials

The proxy uses SSL/TLS for authentication

The proxy uses default credentials

The proxy terminates

22 / 25

22. Which of the following does Google Cloud SQL Proxy not handle?

Database queries

Connection pooling

Authentication

SSL/TLS encryption

23 / 25

23. What is the primary role of the -ip_address_types parameter in the proxy command?

To specify the proxy's IP address

To specify the local IP address

To enforce IP address restrictions

To define the types of IP addresses to use

24 / 25

24. In a cross-platform environment, how does Google Cloud SQL Proxy facilitate database connections?

By enforcing SSL/TLS encryption

By restricting connections to specific platforms

By supporting various programming languages and platforms

By using only service account keys

25 / 25

25. What is the recommended way to authenticate applications using Google Cloud SQL Proxy?

Use OAuth tokens and IAM roles

Use Google Cloud credentials or service account keys

Use API keys and HMAC credentials

Use SSL/TLS certificates and IP whitelisting

Your score is

Google Cloud SQL – Cloud SQL Proxy for authentication MCQ