- (Topic 2)
In terms of Cloud SQL for MySQL Features offered by Google Cloud Platform which of the statements is/are correct?

1. A. Do not support Private IP (private service access).
2. B. Customer data is encrypted on Google's internal networks and in database tables, temporary files, and backups.
3. C. Do not Provide automated and on-demand backups and point-in-time recovery.
4. D. None of the above

Correct Answer: B
Cloud SQL for MySQL:
Features
- Fully managed MySQL Community Edition databases in the cloud.
- Cloud SQL instances support MySQL 8.0, 5.7 (default), and 5.6, and provide up to 624 GB of RAM and 64 TB of data storage, with the option to automatically increase the storage size, as needed.
- Create and manage instances in the Google Cloud Console.
- Instances are available in the Americas, EU, Asia, and Australia.
- Customer data is encrypted on Google's internal networks and in database tables, temporary files, and backups.
- Support for secure external connections with the Cloud SQL Auth proxy or with the SSL/TLS protocol.
- Support for private IP (private services access).
- Data replication between multiple zones with automatic failover.
- Import and export databases using mysqldump, or import and export CSV files.
- Support for MySQL wire protocol and standard MySQL connectors.
- Automated and on-demand backups and point-in-time recovery.
- Instance cloning.
- Integration with Google Cloud's operations suite logging and monitoring.

- (Topic 1)
Your organization is developing an application that will manage payments and online bank accounts located around the world. The most critical requirement for your database is that each transaction is handled consistently. Your organization anticipates almost unlimited growth in the amount of data stored.
Which Google Cloud product should your organization choose?

1. A. Cloud SQL
2. B. Cloud Storage
3. C. Firestore
4. D. Cloud Spanner

Correct Answer: D
Features of Cloud Spanner
Reference: https://k21academy.com/google-cloud/cloud-sql-vs-cloud-spanner/

- (Topic 1)
An organization has had a data leak scare because one employee made a sensitive Cloud Storage bucket available to the public. Given the nature of the company's business, it is understood that there is never any reason to give the public direct access to any file. The
security head wants to ensure that such an event never occurs again. How can you ensure this?

1. A. Remove Edit access rights of all Cloud Storage buckets so that no user can make any edits.
2. B. Set an organizational policy constraint to restrict bucket access set to the public.
3. C. Use Cloud Scheduler to run a job at a specified interval to scan bucket
4. D. Any public permissions can be programmatically changed.
5. E. Write Cloud Functions code connected to Cloud Storag
6. F. Any changes will be notified to the function which can be used to reset the public access.

Correct Answer: B
The straightforward way to set it is using Organizational Policy constraint. Any attempts to change the organizational setting will be rejected for any project and resource.

References link:
-> https://cloud.google.com/resource-manager/docs/organization-policy/overview
-> https://cloud.google.com/resource-manager/docs/organization-policy/org-policy- constraints

- (Topic 1)
Your organization needs to process large amounts of data from an online application that operates continuously. You do not want to be required to provision infrastructure or create server clusters. What should your organization choose?

1. A. Compute Engine with BigQuery
2. B. Dataproc
3. C. Google Kubernetes Engine with Cloud Bigtable
4. D. Dataflow

Correct Answer: D
You do not want to be required to provision infrastructure or create server clusters. Because Unified stream and batch data processing that's serverless, fast, and cost-effective.
Reference link- https://cloud.google.com/dataflow

- (Topic 2)
Which of the following is/are core storage options available on the Google Cloud Platform?

1. A. Cloud Storage and Cloud Data Store
2. B. Cloud Spanner
3. C. Cloud SQL and Google Big Table
4. D. All of the above

Correct Answer: D
Google Cloud Platform has other storage options to meet your needs for structured, unstructured, transactional and relational data. Core storage options: Cloud Storage, Cloud SQL, Cloud Spanner, Cloud Data Store and Google Big Table. Depending on your application, you might want to use one or several of these services to get the job done.