Question 1

A data scientist has prepared a query in BigQuery and expects to process a large amount of data. Before executing the query, he wants to know how much data will be processed. What should a data scientist do?

Options :

A : He should use Google Cloud Pricing Calculator to estimate the number of bytes read by the query.

B : When he runs a query in the bq command-line tool, he should use --dry_run flag to estimate the number of bytes read by the query.

C : The number of bytes cannot be estimated without executing the query.

D : When he runs a query in the bq command-line tool, he should use --cost flag to estimate the number of bytes read by the query.

Answer: B

Question 2

As a cloud architect, you need to establish connection between your on-premises network and Google Cloud. Your company will need 5 Gbps of bandwidth in total between the on-premises data center and Google Cloud. The traffic may be split between multiple connections. How many VPN endpoints will you need?

Options :

A : 4

B : 1

C : 3

D : 2

Answer: D

Question 3

For data files, a production database virtual machine on Google Compute Engine has an ext4-formatted persistent disk. The database is on the verge of running out of storage space. How can you solve the problem in the shortest amount of time?

Options :

A : Increase the persistent disk size in the Cloud Platform Console and use the resize2fs command in Linux.

B : Shut down the virtual machine, then use the Cloud Platform Console to increase the persistent disk size before restarting it.

C : Increase the persistent disk size in the Cloud Platform Console and test the new space with the fdisk command in Linux.

D : In the Cloud Platform Console, create a new persistent disk attached to the virtual machine, format and mount it, and configure the database service to move the files to the new disk

E : In the Cloud Platform Console, create a snapshot of the persistent disk restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service

Answer: A

Question 4

How would you design a solution for running a large-scale, multi-cloud, and secure disaster recovery plan for a global enterprise, considering the requirement for real-time data replication, low recovery time objective (RTO), and the ability to handle multiple TBs of data from multiple locations?

Options :

A : Use Cloud Functions for data replication, with Cloud Interconnect for network connectivity and Cloud Bigtable for database management.

B : Use Cloud Storage Transfer Service for data replication, with Cloud Dedicated Interconnect for network connectivity and Cloud Spanner for database management.

C : Use Cloud Storage Transfer Service for data replication, with Cloud Dedicated Interconnect for network connectivity and Cloud Filestore for database management.

D : Use Cloud Storage Transfer Service for data replication, with Cloud VPN for network connectivity and Cloud Storage for database management.

Answer: B

Question 5

Introductory Info Company Overview -

Dress4Win is a web-based company that helps their users organize and manage their personal wardrobe using a website and mobile application. The company also cultivates an active social network that connects their users with designers and retailers. They monetize their services through advertising, e-commerce, referrals, and a premium app model.

Company Background -

Dress4Win's application has grown from a few servers in the founder's garage to several hundred servers and appliances in a collocated data center. However, the capacity of their infrastructure is now insufficient for the application's rapid growth. Because of this growth and the company's desire to innovate faster,

Dress4Win is committing to a full migration to a public cloud.

Solution Concept -

For the first phase of their migration to the cloud, Dress4Win is considering moving their development and test environments. They are also considering building a disaster recovery site, because their current infrastructure is at a single location. They are not sure which components of their architecture they can migrate as is and which components they need to change before migrating them.

Existing Technical Environment -

The Dress4Win application is served out of a single data center location.

Databases:

- MySQL - user data, inventory, static data

- Redis - metadata, social graph, caching

Application servers:

- Tomcat - Java micro-services

- Nginx - static content

- Apache Beam - Batch processing

Storage appliances:

- iSCSI for VM hosts

- Fiber channel SAN - MySQL databases

- NAS - image storage, logs, backups

Apache Hadoop/Spark servers:

- Data analysis

- Real-time trending calculations

MQ servers:

- Messaging

- Social notifications

- Events

Miscellaneous servers:

- Jenkins, monitoring, bastion hosts, security scanners

Business Requirements -

Build a reliable and reproducible environment with scaled parity of production.

Improve security by defining and adhering to a set of security and Identity and Access Management (IAM) best practices for cloud.

Improve business agility and speed of innovation through rapid provisioning of new resources.

Analyze and optimize architecture for performance in the cloud.

Migrate fully to the cloud if all other requirements are met.

Technical Requirements -

Evaluate and choose an automation framework for provisioning resources in cloud.

Support failover of the production environment to cloud during an emergency.

Identify production services that can migrate to cloud to save capacity.

Use managed services whenever possible.

Encrypt data on the wire and at rest.

Support multiple VPN connections between the production data center and cloud environment.

CEO Statement -

Our investors are concerned about our ability to scale and contain costs with our current infrastructure. They are also concerned that a new competitor could use a public cloud platform to offset their up-front investment and freeing them to focus on developing better features.

CTO Statement -

We have invested heavily in the current infrastructure, but much of the equipment is approaching the end of its useful life. We are consistently waiting weeks for new gear to be racked before we can start new projects. Our traffic patterns are highest in the mornings and weekend evenings; during other times, 80% of our capacity is sitting idle.

CFO Statement -

Our capital expenditure is now exceeding our quarterly projections. Migrating to the cloud will likely cause an initial increase in spending, but we expect to fully transition before our next hardware refresh cycle. Our total cost of ownership (TCO) analysis over the next 5 years puts a cloud strategy between 30 to 50% lower than our current model. Question As part of their new application experience, Dress4Wm allows customers to upload images of themselves.

The customer has exclusive control over who may view these images.

Customers should be able to upload images with minimal latency and also be shown their images quickly on the main application page when they log in.

Which configuration should Dress4Win use?

Options :

A : Store image files in a Google Cloud Storage bucket. Use Google Cloud Datastore to maintain metadata that maps each customer-s ID and their image files.

B : Store image files in a Google Cloud Storage bucket. Add custom metadata to the uploaded images in Cloud Storage that contains the customer-s unique ID.

C : Use a distributed file system to store customers' images. As storage needs increase, add more persistent disks and/or nodes. Assign each customer a unique ID, which sets each file-s owner attribute, ensuring privacy of images.

D : Use a distributed file system to store customers' images. As storage needs increase, add more persistent disks and/or nodes. Use a Google Cloud SQL database to maintain metadata that maps each customer-s ID to their image files.

Answer: A