Google Cloud Storage and Database Assessment Latest Answers

Google Cloud Storage (GCP) and Database Assessment Latest Answers 2021 are available below, note that answers are marked in bold.

Q.1 – What is Cloud Bigtable NOT good for?

• (A) It’s not good for very large amounts of data.
• (B) It’s not good for flat data and databases with lots of read-write actions.
• (C) It’s not good for highly structured databases or transactional databases.
• (D) It’s not good for analytical data.

Q.2 – Which Cloud Storage class is meant for organizations with the lowest frequency access?

• (A) Nearline
• (B) Regional
• (C) Coldline
• (D) Multi-Regional

Q.3 – Which of the following describes Cloud Firestore’s business value?

• (A) Cloud Firestore provides daily results for queries to show the changing data.
• (B) Cloud Firestore takes care of scalability and operations for running document-oriented databases.
• (C) Cloud Firestore provides multi-document ACID transactions for SQL databases.
• (D) Cloud Firestore helps you schedule downtime for upgrades, resizing, or configuration changes.

Q.4 – Cloud Storage ____________ object (or BLOB) data. Organizations can store an unlimited number of objects, up to 5 ___________ in size each.

• (A) stores and serves, terabytes
• (B) ingests and transfers, gigabytes
• (C) transforms and organizes, zettabytes
• (D) processes and analyzes, petabytes

Q.5 – Cloud Firestore is:

• (A) An enterprise-grade database service built for the cloud specifically to combine the benefits of relational database structure with relational horizontal scale.
• (B) A tool for developing and executing a wide range of data processing patterns on very large datasets.
• (C) A flexible, scalable NoSQL cloud database to store and sync data for client- and server-side development.
• (D) An industry-leading local SDD that integrates with the other products in the Google Cloud Platform suite.

Q.6 – How does Cloud SQL address the challenge of compatibility?

• (A) If an organization’s app works with MySQL or PostgreSQL, it will work with Cloud SQL.
• (B) Cloud SQL builds on performance innovations in Compute Engine and persistent disk.
• (C) You don’t need to reserve Cloud SQL instances ahead of time to get savings, and you pay by the minute, not by the hour.
• (D) It’s easy to control with less infrastructure for you to manage and operate.

Q.7 – “High availability and durability via replications is just there; you don’t need to think about it or manage it. No scheduled downtime for upgrades, resizing or configuration changes.” Which of the following concerns is addressed by this Cloud Firestore value proposition?

• (A) Infrastructure costs
• (B) Reliability
• (C) Scalability
• (D) Performance

Q.8 – With Cloud Bigtable, organizations can accelerate time to market for their data-intensive applications, enable seamless, ________________, reduce operational overhead, and improve business operations.

• (A) cost configurability
• (B) availability of SDKs and consoles
• (C) elastic scaling with zero downtime
• (D) future proofing

Q.9 – Using your understanding of GCP options/products meant to address storage and database areas, which statement best aligns with where Cloud Bigtable fits within GCP?

• (A) Cloud Bigtable is a fully-managed database service that makes it easy to set up, maintain, manage, and administer relational MySQL and PostgreSQL databases in the cloud.
• (B) Cloud Bigtable helps organizations capture data and rapidly pass massive numbers of messages securely between other Google Cloud Platform big data tools and other software applications.
• (C) Cloud Bigtable is good for relational database service management at a scale that requires high availability and HTAP.
• (D) Cloud Bigtable is aligned to the non-relational database requirements and is good for heavy read and write events and analytical data.

Q.10 – What is Cloud SQL?

• (A) Compute SQL offers industry-leading local SSD performance and integrates with the other products in the Google Cloud Platform suite.
• (B) Cloud SQL is a fully managed database service that makes it easy to set up, maintain, manage, and administer relational MySQL and PostgreSQL databases in the cloud.
• (C) Cloud SQL helps organizations capture data and rapidly pass massive amounts of messages securely between other Google Cloud Platform big data tools and other software applications.
• (D) Cloud SQL ingests event streams from anywhere, at any scale, for simple, reliable, real-time stream analytics.

Q.11 – Why is Cloud Bigtable great for IoT and user analytics?

• (A) Because Cloud Bigtable lowers warehousing costs and augments existing warehouses.
• (B) Because Cloud Bigtable scales up to handle massive computing loads quickly and efficiently.
• (C) Because Cloud Bigtable is a fully managed database service that makes it easy to set up, maintain, manage, and administer relational MySQL and PostgreSQL databases in the cloud.
• (D) Because Cloud Bigtable is a high-performance NoSQL database service for large analytical and operational workloads.

Q.12 – “Cloud Datastore enables you to hand off the responsibility of running a highly scalable document-oriented database to Google. From 10 users to 100s of millions of users, you will no longer need to spend time optimizing, configuring the database, updating it, or monitoring system health.” Which of the following concerns is addressed by this Cloud Datastore value proposition?

• (A) Infrastructure costs
• (B) Scalability
• (C) Reliability
• (D) Performance

Q.13 – Cloud Firestore is good for:

• (A) Organizations that need to store binary data such as images, media serving, and backups.
• (B) Training and testing data that are used in machine learning to validate data sets.
• (C) Organizations that are using relational databases at scale and need to store user metadata.
• (D) Developing mobile and web applications and reducing operational burden with an enterprise-grade database.

Q.14 – What business challenges does Cloud Bigtable address? Select the 2 correct answers.

• (A) Time to market for data-intensive applications
• (B) Access from storage to compute servers within the region
• (C) Scaling without downtime
• (D) Fully managed relational database

Q.15 – With Cloud Firestore, you no longer need to determine the number of nodes or add servers or storage because:

• (A) It’s a fully managed database service.
• (B) It’s a database service that uses SQL.
• (C) It’s a database service that allows complete control.
• (D) It’s a fully managed compute service.

Q.16 – How does Cloud Storage help organizations get content to their users faster?

• (A) Standard connectors and standard tools that allow for seamless integrations with existing SQL workflows.
• (B) Fully managed relational database services that use edge caching to provide performance.
• (C) Regional buckets that enable faster access from storage to compute servers within the region.
• (D) Application patches and updates that optimize data processing when it comes to leveraging user data.

Q.17 – How does Cloud Storage deliver simplicity?

• (A) By providing intelligence from data.
• (B) Includes tape libraries and backup capabilities.
• (C) Single API and millisecond data access latency across storage classes.
• (D) Most reliable service, according to Gartner.

Q.18 – Cloud Storage is good for:

• (A) Training data that’s used in machine learning.
• (B) Tertiary data such as website traffic, clicks, and returning page visitors.
• (C) Binary data such as images, media serving, and backups.
• (D) Testing data that’s used to validate data sets.

Q.19 – Which statement best aligns with the role Cloud Spanner plays in GCP?

• (A) Cloud Spanner is good for binary data such as images, media serving, and backups.
• (B) Cloud Spanner is good for relational database management systems at scale that require high availability and HTAP.
• (C) Cloud Spanner is good for configuring replications and applying updates.
• (D) Cloud Spanner is good for object database management at scale that requires the capacity to process millions of objects in near real time.

Q.20 – Considering where it fits in the GCP, Cloud Datastore is good for:

• (A) Relational database management at scale that requires high availability and HTAP.
• (B) Flat data and databases with lots of read-write actions.
• (C) Highly structured databases or transactional databases.
• (D) Organizations with non-relational data that want to reduce their operations burden with an enterprise-grade database.

Q.21 – Related to ease of use, organizations can focus on their app, not their infrastructure, because Cloud Spanner:

• (A) Distributes organizations’ load-balanced resources in single or multiple regions around the globe, close to their users, to help them meet high-availability requirements.
• (B) Eliminates complex database tasks so there is no need to engineer a complex replication or backup infrastructure.
• (C) Provides a layer of logic that organizations can write code in order to access other services.
• (D) Reduces network latency, offloads some work from the origin server, and reduces serving costs.

Q.22 – Which of these statements about Cloud Datastore is FALSE?

• (A) Cloud Datastore is aligned to non-relational database requirements and is good for heavy read and write, events, and analytical data.
• (B) Cloud Datastore is a proven production system, serving organizations for 10 years.
• (C) Cloud Datastore is a fully managed NoSQL document database that scales from zero to global scale without configuration or downtime.
• (D) Cloud Datastore is ideal for rapid and flexible web and mobile development.

Q.23 – Connecting to Cloud SQL databases looks the same as connecting to a MySQL or PostgreSQL database by using:

• (A) Non-traditional transforms and standard tools like Hadoop.
• (B) Standard connectors and standard tools like MySQL workbench.
• (C) Standard containers and standard tools like BigQuery.
• (D) Non-traditional connectors and standard tools like PostgreSQL BETA

Q.24 – What are some common challenges that can be addressed by data transfer options?

• (A) Offline transfers
• (B) Topline transfers
• (C) Manual transfers
• (D) Hardline transfers

Q.25 – Which statement best defines where data transfers fit within the GCP?

• (A) Data transfer options reduce risk by providing a better understanding of what is happening to allow for greater visibility.
• (B) Data transfer options run clusters ephemerally; in other words, only when needed.
• (C) Data transfer options lead to many other GCP products and solutions that fit an organization’s needs.
• (D) Data transfer options lower warehousing costs and augment existing warehouses.

Q.26 – Organizations considering Cloud Spanner often find ACID transactions valuable. What are ACID transactions?

• (A) Automatic, Constant Infrastructure, Decentralized
• (B) Autonomous, Centralized, Independent, Dependent
• (C) Analog, Chronological, Intelligent, Database
• (D) Atomic, Consistent, Isolated, Durable

Q.27 – What is an example of a time-consuming task required to set up and run a database that organizations can hand off to Google when they choose to use Cloud SQL?

• (A) Migrating data between data centers.
• (B) Managing contractors.
• (C) Developing apps.
• (D) Applying patches and updates.

Q.28 – How does BigQuery Data Transfer Service work?

• (A) Analyzes data to capture insights to be used for more informed decision making.
• (B) Scales up to handle massive computing loads quickly and efficiently.
• (C) Allows organizations to easily use MapReduce, Pig, Hive, and Spark to process data before storing it, for example, in Cloud Storage or BigQuery.
• (D) Automates loading data into BigQuery from YouTube, AdWords, and DoubleClick.

Q.29 – Cloud Spanner is:

• (A) A tool for developing and executing a wide range of data processing patterns on very large datasets.
• (B) A fully managed database service that makes it easy to set up, maintain, manage, and administer relational MySQL and PostgreSQL databases in the cloud.
• (C) An enterprise-grade, globally distributed, and strongly consistent managed database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.
• (D) A managed environment for deploying containerized apps.

Q.30 – “High availability and durability via replications is just there: you don’t need to think about it or manage it. No scheduled downtime for upgrades, resizing or configuration changes.” Which of the following concerns is addressed by this Cloud Datastore value proposition?

• (A) Performance
• (B) Infrastructure costs
• (C) Reliability
• (D) Scalability

Q.31 – What type of database is Cloud SQL?

• (A) Relational database
• (B) Non-relational database
• (C) Object database
• (D) Warehouse database

Q.32 – With Cloud Spanner, if one region goes offline, data can still be served from another region. How does Cloud Spanner make this possible?

• (A) Cloud Spanner uses synchronous replication within and across regions to achieve greater availability.
• (B) Cloud Spanner stores and serves an unlimited number of objects and up to 5 terabytes of object data for each.
• (C) Cloud Spanner captures up to a petabyte of data on one Transfer Appliance without impacting the outbound network.
• (D) Cloud Spanner automates loading data into BigQuery from YouTube, AdWords, and DoubleClick.

Q.33 – What is a common use case for moving data to GCP? Select the 2 correct answers.

• (A) Data center migration
• (B) Decommission tape libraries and infrastructure
• (C) Virtual Private Cloud
• (D) Preferred locations

Q.34 – What is a data transfer option offered by Google to help move data?

• (A) Cloud SQL Transfer Service
• (B) Hardline Transfer
• (C) Cloud Engine Transfer Service
• (D) BigQuery Data Transfer Service

Q.35 – What aspect of Cloud Datastore allows organizations to worry less about making changes to their underlying data structure as their application evolves?

• (A) The warehouse database with a proven production system.
• (B) The schemaless document-oriented database with ACID transactions.
• (C) The object-oriented database with containerized applications.
• (D) The relational database with configuration and downtime.

Tags:

google cloud database

google cloud database pricing

google database system

google cloud sql

assessment: gcp big data and machine learning

free cloud database

google database free

google exam answers