Exam (elaborations)
GCP - Architect Certification 003 Exam Questions & Answers
- Course
- Institution
GCP - Architect Certification 003 Exam Questions & Answers
[Show more]
Seller
Follow
Victorious23
Reviews received
Content preview
GCP - Architect Certification 003Exam Questions & Answers
Your company plans to migrate a multi-petabyte data set to the cloud. The
data set must be available 24hrs a day. Your business analysts have
experience only with using an SQL interface. How should you store the data
to optimize it for ease of analysis?
[ ] Load data into Google BigQuery.
[ ] Insert data into Google Cloud SQL.
[ ] Put flat files into Google Cloud Storage.
[ ] Stream data into Google Cloud Datastore. - -Correct Answer A
Feedback
A (Correct answer) - BigQuery is the only of these Google products that
supports an SQL interface and a high enough SLA (99.9%) to make it readily
available.
-Your company plans to migrate a multi-petabyte data set to the cloud. The
data set must be available 24hrs a day. Your business analysts have
experience only with using an SQL interface. How should you store the data
to optimize it for ease of analysis?
[ ] Load data into Google BigQuery.
[ ] Insert data into Google Cloud SQL.
[ ] Put flat files into Google Cloud Storage.
[ ] Stream data into Google Cloud Datastore. - -Correct Answer A
Feedback
A (Correct answer) - BigQuery is the only of these Google products that
supports an SQL interface and a high enough SLA (99.9%) to make it readily
available.
-The database administration team has asked you to help them improve the
performance of their new database server running on Google Compute
Engine. The database is for importing and normalizing their performance
statistics and is built with MySQL running on Debian Linux. They have an n1-
standard-8 virtual machine with 80 GB of SSD persistent disk. What should
they change to get better performance from this system?
[ ] Create a new virtual machine running PostgreSQL.
[ ] Migrate their performance metrics warehouse to BigQuery.
, [ ] Increase the virtual machine's memory to 64 GB.
[ ] Modify all of their batch jobs to use bulk inserts into the database.
[ ] Dynamically resize the SSD persistent disk to 500 GB. - -Correct Answer
E
All of other answers are either not applicable or not specified by the question
scenarios.
The following console screenshot show the effect to IO performance by
changing memory or disk - it's self-explained (please enlarge to see the
details). Answer E is a clear straightforward winner over answer C as well as
others.
https://cloud.google.com/compute/docs/disks/add-persistent-disk
Adding or Resizing Persistent Disks
-For this question, refer to the TerramEarth case study
You analyzed TerramEarth's business requirement to reduce downtime and
found that they can achieve a majority of time saving by reducing
customers' wait time for parts. You decided to focus on reduction of the 3
weeks aggregate reporting time. Which modifications to the company's
processes should you recommend?
[ ] Migrate from CSV to binary format, migrate from FTP to SFTP transport,
and develop machine learning analysis of metrics.
[ ] Migrate from FTP to streaming transport, migrate from CSV to binary
format, and develop machine learning analysis of metrics.
[ ] Increase fleet cellular connectivity to 80%, migrate from FTP to streaming
transport, and develop machine learning analysis of metrics.
[ ] Migrate from FTP to SFTP transport, develop machine learning analysis of
metrics, and increase dealer local inventory by a fixed factor - -Correct
Answer C
Feedback
B - Migrate from FTP to streaming transport, migrate from CSV to binary
format, and develop machine learning analysis of metrics.
If no cellular connection, then it cannot do streaming; CVS to binary does not
necessary reduce the size (compress does).
C (Correct answer) - Increase fleet cellular connectivity to 80%, migrate from
FTP to streaming transport, and develop machine learning analysis of
metrics.
,TerramEarth Existing Technical Environment New Solution: 80% going to
streaming; 20% goes to Batch; No FTP
GCP offers many ways to connect to PubSub and GCS such as IOT Type, rich
client library, as well as gsutil for reliable, parallel, resumable upload data
By increase fleet cellular connectivity to 80%, migrating from FTP to
streaming transport, and the rest of 20% batch users for Cloud storage
upload instead of FTP, majority of bottlenecked areas are covered and
resolved.
A and D can be eliminated for "Migrate from FTP to SFTP transport" since
SFTP doesn't provide speed advantage over FTP nor the better solution with
streaming.
TerramEarth's Case Study - relevant information
Solution Concept
There are 20 million TerramEarth vehicles in operation that collect 120 fields
of data per second. Data is stored locally on the vehicle and can be accessed
for analysis when a vehicle is serviced.
Approximately 200,000 vehicles are connected to a cellular network,
allowing TerramEarth to collect data directly. At a rate of 120 fields of data
per second, with 22 hours of operation per day, TerramEarth collects a total
of about 9 TB/day from these connected vehicles.
Existing Technical Environment
TerramEarth's existing architecture is composed of Linux-based systems that
reside in a data center. These systems gzip CSV files from the field and
upload via FTP, transform and aggreg
-You can SSH into an instance from another instance in the same VPC by its
internal IP address, but not its external IP address. What is one possible
reason why this is so?
[ ] The outgoing instance does not have correct permission granted to its
service account.
[ ] The external IP address is disabled.
[ ] The firewall rule to allow SSH is restricted to the internal VPC.
[ ] The receiving instance has an ephemeral address instead of a reserved
address. - -Correct answer C
The firewall rule to allow SSH is restricted to the internal VPC
, Instances can have both Internal and External IP addresses. When
connecting to another instance by its external address, you're going out of
your internal network to the external Internet and coming back to access the
instance by its external address. If traffic is restricted to the local VPC, it will
reject this attempt as it is coming from an external source.
-You are helping the QA team to roll out a new load-testing tool to test the
scalability of your primary cloud services that run on Google Compute Engine
with Cloud Bigtable. Which three requirements should they include?
Choose 3 answers:
[ ] Ensure all third-party systems your services used are capable of handling
high load.
[ ] Instrument the load-testing tool and the target services with detailed
logging and metrics collection.
[ ] Create a separate Google Cloud project to use for the load-testing
environment.
[ ] Instrument the production services to record every transaction for replay
by the load- testing tool.
[ ] Ensure that the load tests validate the performance of Cloud Bigtable.
[ ] Schedule the load-testing tool to regularly run against the production
environment. - -Correct Answer B, C, and E
Feedback
A - Ensure all third-party systems your services used are capable of handling
high load
This is out of scope - it's beyond your control. You may test them, but you
cannot control them. If you have doubts the third-party dependencies
causing the overall performance issue, you may use integration test to
identify and isolate them. This should not be your focus.
B (Correct answer) - Instrument the load-testing tool and the target services
with detailed logging and metrics collection.
This is normal requirement and practice for load testing to collect testing
results with detailed measurable metric and historical logs otherwise load
testing would be meaningless
C (Correct answer) - Create a separate Google Cloud project to use for the
load-testing environment.
This is a good practice for least privileges and separation of responsibilities.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Victorious23. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $20.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81531 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now