Google Google Certifications CLOUD-DIGITAL-LEADER Questions & Answers

• Question 241:

  A small scale retailer has been collecting its point of sale transaction in a PostgreSQL Da-tabase. They have raised funding for a strategic expansion goal in the next year that will see them grow significantly in Asia, Europe, North America, Which Database option should they choose in Google Cloud?

  A. BigQuary

  B. Spanner

  C. Cloud SQL

  D. Bigtable

  Correct Answer: B

  Spanner is a global scale Database that Support SQL querying, Similar to PostgreSQL, Which will be regional. So that will be a fairly smooth move, Since they have the time and the funding, they can plan for this migration.

• Question 242:

  Which of the following statements is/are true about Cloud Spanner offered by Google Cloud Plat-form.

  A. It can scale horizontally to support additional capacity.

  B. It comes with Zero Downtime, No Maintenance windows, and is proven for large and small workloads.

  C. You don't need to shard or replicate data.

  D. All of the above.

  Correct Answer: D

  Cloud Spanner:

  Fully managed relational database with unlimited scale, strong consistency, and up to 99.999% availability.

  -Get all the benefits of relational semantics and SQL with unlimited scale -Start at any size and scale with no limits as your needs grow -Enjoy high availability with zero scheduled downtime and online schema changes -Deliver high-performance transactions with strong consistency across regions and continents -Focus on innovation, eliminating manual tasks with capabilities like automatic sharding.

• Question 243:

  You are running a data warehouse on BigQuery. A partner company is offering a recommendation engine based on the data in your data warehouse. The partner company is also running their applica-tion on Google Cloud. They manage the resources in their own project, but they need access to the BigQuery dataset in your project. You want to provide the partner company with access to the da-taset. What should you do?

  A. Ask the partner to create a Service Account in their project, and have them give the Service Account access to BigQuery in their project.

  B. Create a Service Account in your own project, and grant this Service Account ac-cess to BigQuery in your project.

  C. Create a Service Account in your own project, and ask the partner to grant this Service Account access to BigQuery in their project.

  D. Ask the partner to create a Service Account in their project, and grant their Service Account access to the BigQuery dataset in your project.

  Correct Answer: D

  -if the need is to authenticate the application to access your dataset, it's the application's serice account that will be provided during the authentication, so the service account is to be created at their side to run the application

• Question 244:

  A customer has a tens of applications that are dependent on Oracle databases in their on-premise data centers. The customer wants to migrate to Google Cloud. Their long term goal is to move to other cloud native database technologies. What options do they have to initially move their data?

  A. Migrate to a Bare Metal server.

  B. Migrate to Cloud SQL.

  C. Since there is no hosted Oracle solution, leave the Oracle data on-premise while doing analytics on Google Cloud.

  D. Containerize Oracle and run it using Cloud Run.

  Correct Answer: B

  The Bare Metal solution is the recommended approach. You can deploy Oracle capabilities like clustered databases, replication, and all performance features at licensing costs that are similar to on-premise systems

  https://cloud.google.com/architecture/migrating-bare-metal-workloads

• Question 245:

  A customer of yours has an SLA with their client that a particular service will respond within 4 sec-onds. The end client has reported that it feels slower. Your engineers do a trial at the client site and notice that there seems to be a delay for many of the requests. It's your team's responsibility to iden-tify the issue quickly within the strict timeline for fixes according to the contract, and then fix it. What should you do?

  A. Recommend a move to serverless technologies which will scale automatically on demand.

  B. Add logging statements at multiple points in the application, build it, and deploy it. Now new requests will give us information on latency in the logs.

  C. Check if the browsers used by the client are different from yours. If they are, that's most likely the issue. Ensure that everybody uses the latest version of the browser that you are also using.

  D. Use Cloud Trace to collect latency data and track how requests propagate and why there is a delay.

  Correct Answer: D

  Cloud Trace is a built-in tool in the Operations suite to identify issues like latency.

  -> Such fixes are unlikely to change core issues like the service itself being architected or written sub-optimally. Though changes like browser, networking, etc. are helpful, it would be the wrong approach to first recommend that the customer

  upgrade all their hardware and software.

  -> Rewriting code and logging information is going to be time consuming. In general though, logging should always be included in code and it can give good insights. But tracing is way more specific and comprehensive for this requirement.->

  In certain cases, we might identify scaling as the issue. But we should first identify the core problem. So, start with tracing. We can also achieve scale in server-ful technologies.

  Reference link-https://cloud.google.com/trace

• Question 246:

  In terms of Cloud SQL for MySQL Features offered by Google Cloud Platform which of the statements is/are correct?

  A. Do not support Private IP (private service access).

  B. Customer data is encrypted on Google's internal networks and in database tables, temporary files, and backups.

  C. Do not Provide automated and on-demand backups and point-in-time recovery.

  D. None of the above

  Correct Answer: B

  Cloud SQL for MySQL:

  Features

  -Fully managed MySQL Community Edition databases in the cloud.

  -Cloud SQL instances support MySQL 8.0, 5.7 (default), and 5.6, and provide up to 624 GB of RAM and 64 TB of data storage, with the option to automatically increase the storage size, as needed.

  -Create and manage instances in the Google Cloud Console.

  -Instances are available in the Americas, EU, Asia, and Australia.

  -Customer data is encrypted on Google's internal networks and in database tables, temporary files, and backups.

  -Support for secure external connections with the Cloud SQL Auth proxy or with the SSL/TLS protocol.

  -Support for private IP (private services access).

  -Data replication between multiple zones with automatic failover.

  -Import and export databases using mysqldump, or import and export CSV files.

  -Support for MySQL wire protocol and standard MySQL connectors.

  -Automated and on-demand backups and point-in-time recovery.

  -Instance cloning.

  -Integration with Google Cloud's operations suite logging and monitoring.

• Question 247:

  What characteristics should an organization adopt to be a DevOps organization?

  A. Teamwork over individual work

  B. Obsession with Automation over preoccupation with manual work

  C. Product based teams over component teams.

  D. All of the Above

  Correct Answer: D

• Question 248:

  Which of the following statements is/are true about Google Cloud BigTable?

  A. It is not compatible with Hadoop.

  B. It Scales from Giga Byte to Peta Byte with No Downtime.

  C. It can not be used in Real-time Ad analytics and tracking thousands of IoT Devices Data.

  D. It is an enterprise-level Database that offers relational and non-relational features

  Correct Answer: B

  Cloud Bigtable

  A fully managed, scalable NoSQL database service for large analytical and operational workloads with up to 99.999% availability.

  -Consistent sub-10ms latency--handle millions of requests per second

  -Ideal for use cases such as personalization, ad tech, fintech, digital media, and IoT

  -Seamlessly scale to match your storage needs; no downtime during reconfiguration

  -Designed with a storage engine for machine learning applications leading to better predictions

  -Easily connect to Google Cloud services such as BigQuery or the Apache ecosystem

• Question 249:

  An e-commerce company's business has been booming. To keep up with the growth the IT team also grew. Many new people are being added and new resources are being set up. The CIO is in conver-sation with you over coffee one day and expresses her growing concern that they might be moving too fast. Their security checks and policies have not kept pace. She worries that somebody would make a misconfiguration or compliance violation thus exposing the company to data and privacy loss. What can you advise her?

  A. Use Cloud Identity-Aware Proxy to allow only specific users to access the data.

  B. Use Security Command Center to have a centralized view of assets and get noti-fied on misconfigurations and vulnerabilities.

  C. Use Cloud Data Loss Prevention to prevent the loss of any data.

  D. Use Cloud Armor to block any DDoS attacks that could be a threat.

  Correct Answer: B

  Security Command Center is the right tool for this use case. It can check resources for security issues and notify you when issues are found.

  https://cloud.google.com/security-command-center

• Question 250:

  A large travel services company has been running all their workloads on Google Cloud in the previous year. They looked at their past usage of cloud resources and see that there is a consistent use of 10,000 virtual machines throughout the year. Based on the projections for the following year they have a strong indication that they will use at least this much or more capacity within Google Cloud. What is one way in which they can take advantage of this knowledge?

  A. They can use these numbers to negotiate a better contract with another public cloud number.

  B. They can cut costs by cutting down on the number of VMs used.

  C. They can get into a committed use contract with Google Cloud to get a significant discount on the usage of VMs.

  D. They can ask for a sustained use discount.

  Correct Answer: C

  Compute Engine lets you purchase committed use contracts in return for deeply discounted prices for VM usage. These discounts are referred to as committed use discounts. Committed use discounts are ideal for workloads with predictable resource needs. When you purchase a committed use contract, you purchase Compute Engine resources--such as vCPUs, memory, GPUs, local SSDs, and sole-tenant nodes--at a discounted price in return for committing to paying for those resources for 1 year or 3 years. The discount is up to 57% for most resources like machine types or GPUs. The discount is up to 70% for memory-optimized machine types.