Exam: Cloud Digital Leader 0 Likes

An organization wants a cost-effective relational database (Digital Leader)

Updated on 05/24/2024

An organization wants a cost-effective relational database.

Which Google Cloud service should the organization use?

A) Cloud Storage
B) BigQuery
C) Cloud SQL
D) Dataflow


Solution

Correct answer: C) Cloud SQL.
Here's why:

A) Cloud Storage is a scalable object storage service suitable for storing large amounts of unstructured data, such as files and backups. However, it is not a relational database service and is not optimized for structured query operations typically associated with relational databases.

B) BigQuery is a fully managed data warehouse service designed for analyzing large datasets using SQL queries. While it is powerful for analytics, it is not a relational database service optimized for transactional workloads and may not be the most cost-effective option for that use case.

C) Cloud SQL is a fully managed relational database service that supports popular database engines such as MySQL, PostgreSQL, and SQL Server. It is designed for transactional workloads, offers high availability, automatic backups, and scalability, making it a cost-effective choice for organizations requiring a relational database solution without the overhead of managing infrastructure.

D) Dataflow is a fully managed stream and batch processing service for ingesting, transforming, and processing data in real-time. While it is useful for data processing tasks, it is not a relational database service and does not provide the features required for storing and querying relational data.

Category: Innovating with data and Google Cloud

There are no comments yet.

Authentication required

You must log in to post a comment.
Log in to like this solution

Log in

Support us!
Subscribe Now

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All" you consent to our use of cookies. Privacy Policy.