This Quiz contains totally 25 Questions each carry 1 point for you.
- What is Cloud SQL?
A cloud-based machine learning service
A cloud-based database service
A cloud-based storage service
A cloud-based networking service
Correct!
Wrong!
2. Which database engines does Cloud SQL support?
MySQL and PostgreSQL only
MySQL, PostgreSQL, and SQL Server
Oracle and SQL Server
MySQL only
Correct!
Wrong!
3. What is the primary benefit of using Cloud SQL?
It provides high-performance computing
It provides scalable and managed database services
It provides machine learning capabilities
It provides cloud-based storage
Correct!
Wrong!
4. What are the two ways to create Cloud SQL instances?
Google Cloud Console and REST API
Google Cloud Console and Python SDK
REST API and Python SDK
Google Cloud Console and gcloud command-line tool
Correct!
Wrong!
5. Which of the following statements about managing Cloud SQL instances is false?
You can stop and start instances
You can delete instances
You can clone instances
You can't upgrade instances
Correct!
Wrong!
6. What does vertical scaling in Cloud SQL refer to?
Increasing the number of instances
Increasing the storage capacity of an instance
Increasing the processing power or memory of an instance
Decreasing the storage capacity of an instance
Correct!
Wrong!
7. What is the maximum storage capacity for a Cloud SQL instance?
10 TB
30 TB
40 TB
100 TB
Correct!
Wrong!
8. How does Cloud SQL ensure database performance?
By automatic scaling
By automatic backups
By automatic updates
All of the above
Correct!
Wrong!
9. Which of the following is not a feature of Cloud SQL's security?
Data encryption
Firewall rules
Automatic backups
Two-factor authentication
Correct!
Wrong!
10. How does Cloud SQL provide monitoring?
Through Google Cloud's operations suite
Through the Google Cloud Console
Through email notifications
All of the above
Correct!
Wrong!
11. What is the recommended approach for handling database connections in Cloud SQL?
Use a new connection for each query
Use a connection pool
Use a single connection for all queries
All of the above
Correct!
Wrong!
12. Which of the following is not a best practice when using Cloud SQL?
Regularly backup your data
Use Cloud SQL with Compute Engine in the same region
Use the root account for routine access
Monitor your instances
Correct!
Wrong!
13. Which of the following is a use case for Cloud SQL?
Big data analysis
Structured query language operations
Machine learning
Unstructured data storage
Correct!
Wrong!
14. How does Cloud SQL ensure data reliability?
Through data encryption
Through automatic backups
Through regular updates
Through firewall rules
Correct!
Wrong!
15. What is the purpose of read replicas in Cloud SQL?
To reduce costs
To provide failover support
To offload read traffic from the primary instance
To provide automatic backups
Correct!
Wrong!
16. Which of the following is not a scaling option in Cloud SQL?
Vertical scaling
Horizontal scaling
Diagonal scaling
Autoscaling
Correct!
Wrong!
17. In terms of security, what does Cloud SQL use to encrypt data in transit?
SSL/TLS
HTTPS
SSH
SFTP
Correct!
Wrong!
18. What is a failover replica in Cloud SQL?
A copy of the primary instance for read operations
A backup of the primary instance
A standby instance in case the primary instance fails
A secondary instance for write operations
Correct!
Wrong!
19. What's the purpose of the 'Cloud SQL Auth proxy'?
It provides secure access to your Cloud SQL instance
It manages database connections
It increases the performance of your database
It creates backups of your database
Correct!
Wrong!
20. What type of storage does Cloud SQL provide?
SSD
HDD
Both SSD and HDD
Neither SSD nor HDD
Correct!
Wrong!
21. Which Cloud SQL feature can you use to automate database administration tasks?
Cloud SQL Auth proxy
Cloud SQL Insights
Automatic storage increase
Cloud SQL Read Replicas
Correct!
Wrong!
22. How can you connect to a Cloud SQL instance?
Google Cloud Console
gcloud command-line tool
Cloud SQL Auth proxy
All of the above
Correct!
Wrong!
23. Which of the following is a best practice for improving the performance of a Cloud SQL instance?
Enable automatic storage increase
Use Cloud SQL Insights to diagnose performance issues
Use the smallest machine type possible
Disable automatic backups
Correct!
Wrong!
24. What is the role of the 'Cloud SQL Insights' tool?
It provides secure access to your Cloud SQL instance
It helps you diagnose and resolve database performance issues
It manages database connections
It creates backups of your database
Correct!
Wrong!
25. Which of the following actions can improve the security of a Cloud SQL instance?
Using the Cloud SQL Auth proxy
Restricting network access with firewall rules
Enabling automatic backups
Both a and b
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
GCP Data Engineering Cloud SQL – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...