Professional Cloud Developer Practice Test practice questions, page 13 of 15, with answer review and explanations.
Question 61
Your application performs well when tested locally, but it runs significantly slower after you deploy it to a Compute Engine instance. You need to diagnose the problem. What should you do? What should you do?
File a ticket with Cloud Support indicating that the application performs faster locally.
Use Cloud Debugger snapshots to look at a point-in-time execution of the application.
Use Cloud Profiler to determine which functions within the application take the longest amount of time.
Add logging commands to the application and use Cloud Logging to check where the latency problem occurs.
Question 62
You have an application running in App Engine. Your application is instrumented with Stackdriver Trace. The /product-details request reports details about four known unique products at /sku-details as shown below. You want to reduce the time it takes for the request to complete. What should you do?
Increase the size of the instance class.
Change the Persistent Disk type to SSD.
Change /product-details to perform the requests in parallel.
Store the /sku-details information in a database, and replace the webservice call with a database query.
Question 63
Your company has a data warehouse that keeps your application information in BigQuery. The BigQuery data warehouse keeps 2 PBs of user data. Recently, your company expanded your user base to include EU users and needs to comply with these requirements: ✑ Your company must be able to delete all user account information upon user request. ✑ All EU user data must be stored in a single region specifically for EU users. Which two actions should you take? (Choose two.)
Use BigQuery federated queries to query data from Cloud Storage.
Create a dataset in the EU region that will keep information about EU users only.
Create a Cloud Storage bucket in the EU region to store information for EU users only.
Re-upload your data using to a Cloud Dataflow pipeline by filtering your user records out.
Use DML statements in BigQuery to update/delete user records based on their requests.
Question 64
Your App Engine standard configuration is as follows: service: production instance_class: B1 You want to limit the application to 5 instances. Which code snippet should you include in your configuration?
Your analytics system executes queries against a BigQuery dataset. The SQL query is executed in batch and passes the contents of a SQL file to the BigQuery CLI. Then it redirects the BigQuery CLI output to another process. However, you are getting a permission error from the BigQuery CLI when the queries are executed. You want to resolve the issue. What should you do?
Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
Grant the service account BigQuery Data Editor and BigQuery Data Viewer roles.
Create a view in BigQuery from the SQL query and SELECT* from the view in the CLI.
Create a new dataset in BigQuery, and copy the source table to the new dataset Query the new dataset and table from the CLI.