GCP Storage and Databases assessment questions – Google Cloud Platform Business Professional Accreditation

Here you’ll find all possible real exam questions for the latest GCP Storage and Databases assessment which is a part of Google Cloud Platform Business Professional Accreditation available in Google Skillshop. You can check all coorect and verified answers here – GCP Storage and Databases assessment answers.

Link to the official certification exam page:  Google Cloud Platform Business Professional Accreditation.

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

 

Access from storage to compute servers within the region
Scaling without downtime
Time to market for data-intensive applications
Fully managed relational database

__________

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

 

Autonomous, Centralized, Independent, Dependent
Automatic, Constant Infrastructure, Decentralized
Analog, Chronological, Intelligent, Database
Atomic, Consistent, Isolated, Durable

__________

Which statement best aligns with the role Cloud Spanner plays in GCP?

 

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

__________

How does Cloud SQL address the challenge of compatibility?

 

Cloud SQL builds on performance innovations in Compute Engine and persistent disk.
It’s easy to control with less infrastructure for you to manage and operate.
If an organization’s app works with MySQL or PostgreSQL, it will work with Cloud SQL.
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.

__________

Cloud Spanner is:

 

A managed environment for deploying containerized apps.
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.
A fully managed database service that makes it easy to set up, maintain, manage, and administer relational MySQL and PostgreSQL databases in the cloud.
A tool for developing and executing a wide range of data processing patterns on very large datasets.

__________

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

 

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

__________

Considering where it fits in the GCP, Cloud Datastore is good for:

 

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

__________

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

 

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

__________

“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?

 

Infrastructure costs
Performance
Scalability
Reliability

__________

What is a data transfer option offered by Google to help move data?

 

Cloud Engine Transfer Service
Cloud SQL Transfer Service
BigQuery Data Transfer Service
Hardline Transfer

__________

What are some common challenges that can be addressed by data transfer options?

 

Manual transfers
Topline transfers
Hardline transfers
Offline transfers

__________

Cloud Firestore is:

 

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

__________

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

 

Non-traditional transforms and standard tools like Hadoop.
Standard connectors and standard tools like MySQL workbench.
Standard containers and standard tools like BigQuery.
Non-traditional connectors and standard tools like PostgreSQL BETA.

__________

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

 

availability of SDKs and consoles
cost configurability
future proofing
elastic scaling with zero downtime

__________

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

 

The object-oriented database with containerized applications.
The schemaless document-oriented database with ACID transactions.
The relational database with configuration and downtime.
The warehouse database with a proven production system.

__________

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?

 

Applying patches and updates.
Migrating data between data centers.
Developing apps.
Managing contractors.

__________

How does Cloud Storage deliver simplicity?

 

By providing intelligence from data.
Includes tape libraries and backup capabilities.
Most reliable service, according to Gartner.
Single API and millisecond data access latency across storage classes.

__________

How does Cloud Storage help organizations get content to their users faster?

 

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

__________

How does BigQuery Data Transfer Service work?

 

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

__________

What is Cloud Bigtable NOT good for?

 

It’s not good for highly structured databases or transactional databases.
It’s not good for very large amounts of data.
It’s not good for flat data and databases with lots of read-write actions.
It’s not good for analytical data.

__________

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

 

processes and analyzes, petabytes
transforms and organizes, zettabytes
stores and serves, terabytes
ingests and transfers, gigabytes

__________

“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?

 

Reliability
Scalability
Performance
Infrastructure costs

__________

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?

 

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.
Cloud Bigtable is aligned to the non-relational database requirements and is good for heavy read and write, events, and analytical data.
Cloud Bigtable is good for relational database service management at scale that requires high availability and HTAP.
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.

__________

“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?

 

Infrastructure costs
Performance
Scalability
Reliability

__________

Which of these statements about Cloud Datastore is FALSE?

 

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

__________

What type of database is Cloud SQL?

 

Non-relational database
Warehouse database
Object database
Relational database

__________

Why is Cloud Bigtable great for IoT and user analytics?

 

Because Cloud Bigtable is a high-performance NoSQL database service for large analytical and operational workloads.
Because Cloud Bigtable lowers warehousing costs and augments existing warehouses.
Because Cloud Bigtable scales up to handle massive computing loads quickly and efficiently.
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.

__________

Which of the following describes Cloud Firestore’s business value?

 

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

__________

Which statement best defines where data transfers fit within the GCP?

 

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

__________

Cloud Storage is good for:

 

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

__________

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

 

It’s a fully managed compute service.
It’s a database service that allows complete control.
It’s a database service that uses SQL.
It’s a fully managed database service.

__________

Which Cloud Storage class is meant for organizations with the lowest frequency access?

 

Nearline
Multi-Regional
Coldline
Regional

__________

Cloud Firestore is good for:

 

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

__________

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

 

Virtual Private Cloud
Data center migration
Preferred locations
Decommission tape libraries and infrastructure

__________

What is Cloud SQL?

 

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.
Compute SQL offers industry-leading local SSD performance and integrates with the other products in the Google Cloud Platform suite.
Cloud SQL ingests event streams from anywhere, at any scale, for simple, reliable, real-time stream analytics.
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.

__________

Google Certifications

You cannot copy content of this page