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.
[ ] I...
GCP - Architect Certification 003 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 mus t 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 buil t 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 th eir 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 modifi cations 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 binar y 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 machi ne 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, pa rallel, 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.
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 Tulloch. 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.
