You are a developer at a social media company. The company runs their social media website on-premises and uses MySQL as a backend to store user profiles and user posts. Your company plans to migrate to Google Cloud, and your learn will migrate user profile information to Firestore.
You are tasked with designing the Firestore collections. What should you do?

• A.Create one root collection for user profiles, and create one subcollection for each user's posts.
• B.Create one root collection for user profiles, and store each user's post as a nested list in the user profile document.
• C.Create one root collection for user profiles, and create one root collection for user posts.
• D.Create one root collection for user posts, and create one subcollection for each user's profile.

Comment: *

Name: *

Email: *

Verification: *

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 combine the tables.
• C.Use the UNION operator in SQL to combine the tables.
• D.Use the UNION ALL operator in SQL to combine the tables.

Comment: *

Name: *

Email: *

Verification: *

Which service should HipLocal use for their public APIs?

• A.Cloud Functions
• B.Cloud Armor
• C.Shielded Virtual Machines
• D.Cloud Endpoints

Comment: *

Name: *

Email: *

Verification: *

You are developing a new application. You want the application to be triggered only when a given file is updated in your Cloud Storage bucket. Your trigger might change, so your process must support different types of triggers. You want the configuration to be simple so that multiple team members can update the triggers in the future. What should you do?

• A.Configure Cloud Storage events to be sent to Pub/Sub, and use Pub/Sub events to trigger a Cloud Build job that executes your application.
• B.Create an Eventarc trigger that monitors your Cloud Storage bucket for a specific filename, and set the target as Cloud Run.
• C.Configure a Cloud Function that executes your application and is triggered when an object is updated in Cloud Storage.
• D.Configure a Firebase function that executes your application and is triggered when an object is updated in Cloud Storage.

Comment: *

Name: *

Email: *

Verification: *

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 all Cloud APIs.
• C.Configure the application log file as a custom source.
• D.Create a Stackdriver Logs Export Sink with a filter that matches the application's log entries.

Comment: *

Name: *

Email: *

Verification: *