Professional Cloud Developer exam

You have two tables in an ANSI-SQL compliant database with identical columns that you need to quickly combine into a single table, removing duplicate rows from the result set. What should you do?A . Use the JOIN operator in SQL to combine the tables.B . Use nested WITH statements to...

You want to use the Stackdriver Logging Agent to send an application's log file to Stackdriver from a Compute Engine virtual machine instance. After installing the Stackdriver Logging Agent, what should you do first?A . Enable the Error Reporting API on the project.B . Grant the instance full access to...

You are creating an App Engine application that writes a file to any user's Google Drive. How should the application authenticate to the Google Drive API?A . With an OAuth Client ID that uses the https://www.googleapis.com/auth/drive.file scope to obtain an access token for each user.B . With an OAuth Client...

You are running an application on App Engine that you inherited. You want to find out whether the application is using insecure binaries or is vulnerable to XSS attacks. Which service should you use?A . Cloud AmorB . Stackdriver DebuggerC . Cloud Security ScannerD . Stackdriver Error ReportingView AnswerAnswer: C...

You are developing an HTTP API hosted on a Compute Engine virtual machine instance that needs to be invoked by multiple clients within the same Virtual Private Cloud (VPC). You want clients to be able to get the IP address of the service. What should you do?A . Reserve a...

You are working on a social media application. You plan to add a feature that allows users to upload images. These images will be 2 MB C 1 GB in size. You want to minimize their infrastructure operations overhead for this feature. What should you do?A . Change the application...

Your teammate has asked you to review the code below. Its purpose is to efficiently add a large number of small rows to a BigQuery table. Which improvement should you suggest your teammate make?A . Include multiple rows with each request.B . Perform the inserts in parallel by creating multiple...

You are creating a Google Kubernetes Engine (GKE) cluster and run this command: The command fails with the error: You want to resolve the issue. What should you do? A. Request additional GKE quota is the GCP Console. B. Request additional Compute Engine quota in the GCP Console. C. Open...

You are deploying your application to a Compute Engine virtual machine instance with the Stackdriver Monitoring Agent installed. Your application is a unix process on the instance. You want to be alerted if the unix process has not run for at least 5 minutes. You are not able to change...

You are planning to migrate a MySQL database to the managed Cloud SQL database for Google Cloud. You have Compute Engine virtual machine instances that will connect with this Cloud SQL instance. You do not want to whitelist IPs for the Compute Engine instances to be able to access Cloud...