Google Cloud-Digital-Leader - Google Cloud Digital Leader exam

Cloud SQL supports SQL Server, Since the IT team's attention is being focused on other activities, they will have less time for existing admin tasks, It would be best to take a managed/hosted version.

These are the feature of Infrastructure as a Service (IaaS)

It’s economical

Because IaaS resources are used on demand and enterprises only have to pay for the compute, storage, and networking resources that are actually used, IaaS costs are fairly predictable and can be easily contained and budgeted for.

It’s efficient

IaaS resources are regularly available to businesses when they need them. As a result, enterprises reduce delays when expanding infrastructure and, alternatively, don’t waste resources by overbuilding capacity.

It boosts productivity

Because the cloud provider is responsible for setting up and maintaining the underlying physical infrastructure, enterprise IT departments save time and money and can redirect resources to more strategic activities.

It’s reliable

IaaS has no single point of failure. Even if any one component of the hardware resources fails, the service will usually still remain available.

It’s scalable

One of the biggest advantages of IaaS in cloud computing is the capability to scale the resources up and down rapidly according to the needs of the enterprise.

It drives faster time to market

Because IaaS offers virtually infinite flexibility and scalability, enterprises can get their work done more efficiently, ensuring faster development life cycles.

Compute Engine provides machine type recommendations to help you optimize the resource utilization of your virtual machine (VM) instances. These recommendations are generated automatically based on system metrics gathered by the Cloud Monitoring service over the previous 8 days. Use these recommendations to resize your instance’s machine type to use the instance’s resources more efficiently. This feature is also known as rightsizing recommendations

Reference link- https://cloud.google.com/compute/docs/instances/apply-machine-type-recommendations-for-instances

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.

The key reason I included this question is to clarify some terminologies that will be important for your estimates. The data size mentioned is a TB terabyte. Note the "byte". The speed is mentioned in Mbps, which is Megabits per second. Note the "bits". 8 bits make a byte. So, to get the actual number of bits transferred, you need to multiply the TB number by 8.

Total data transferred (in bits) = 100 * 1,000,000,000,000 * 8 bits

Speed = 100Mbps = 100 * 1,000,000. i.e. 100 million bits are transferred per second.

Hence time taken to transfer all the data = Total Data/Speed = 8,000,000 seconds.

Number of seconds in a day = 24*60*60 = 86,400

Total time taken in days = 8,000,000/86,400 = 92.59 days

Reference link- https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer

You can send notification messages using the Notifications composer in the Firebase console. Though this does not provide the same flexibility or scalability as sending messages with the Admin SDK or the HTTP and XMPP protocols, it can be very useful for testing or for highly targeted marketing and user engagement. The Firebase console provides analytics-based A/B testing to help refine and improve marketing messages.

After you have developed logic in your app to receive messages, you can allow non-technical users to send messages per the instructions on the Notifications page in the Firebase Help Center.

Coldline storage is a very low cost highly durable storage service for data archiving, online backup, and disaster recovery. Coldline storage is the best choice for data that you plan to access at most once a year due to its slightly lower availability, 90 day minimum storage duration cost for data access, and higher per operation costs.

Nearline and Coldline are for backup and archival storage and having the highest availability for both with 99.9 percent.

Compute Engine allows you to allocate VMs with different OSs - Windows and Linux, included.

Cloud Spanner:

Fully managed relational database with unlimited scale, strong consistency, and up to 99.999% availability.

- Get all the benefits of relational semantics and SQL with unlimited scale

- Start at any size and scale with no limits as your needs grow

- Enjoy high availability with zero scheduled downtime and online schema changes

- Deliver high-performance transactions with strong consistency across regions and continents

- Focus on innovation, eliminating manual tasks with capabilities like automatic sharding.