You are tasked with building an online analytical processing (OLAP) marketing analytics and reporting tool.
This requires a relational database that can operate on hundreds of terabytes of data. What is the Google-
recommended tool for such applications?

• A.Cloud Spanner, because it is globally distributed
• B.Cloud SQL, because it is a fully managed relational database
• C.Cloud Firestore, because it offers real-time synchronization across devices
• D.BigQuery, because it is designed for large-scale processing of tabular data

Comment: *

Name: *

Email: *

Verification: *

Your company captures all web traffic data in Google Analytics 260 and stores it in BigQuery. Each country has its own dataset. Each dataset has multiple tables. You want analysts from each country to be able to see and query only the data for their respective countries.
How should you configure the access rights?

• A.Create a group per country. Add analysts to their respective country-groups. Create a single group
  'all_analysts', and add all country-groups as members. Grant the 'all-analysis' group the IAM role of BigQuery jobUser. Share the appropriate dataset with view access with each respective analyst countrygroup.
• B.Create a group per country. Add analysts to their respective country-groups. Create a single group
  'all_analysts', and add all country-groups as members. Grant the 'all-analysis' group the IAM role of BigQuery dataViewer. Share the appropriate dataset with view access with each respective analyst country-group.
• C.Create a group per country. Add analysts to their respective country-groups. Create a single group
  'all_analysts', and add all country-groups as members. Grant the 'all-analysis' group the IAM role of BigQuery jobUser. Share the appropriate tables with view access with each respective analyst countrygroup.
• D.Create a group per country. Add analysts to their respective country-groups. Create a single group
  'all_analysts', and add all country-groups as members. Grant the 'all-analysis' group the IAM role of BigQuery dataViewer. Share the appropriate table with view access with each respective analyst countrygroup.

Comment: *

Name: *

Email: *

Verification: *

Your company wants you to build a highly reliable web application with a few public APIs as the backend. You don't expect a lot of user traffic, but traffic could spike occasionally. You want to leverage Cloud Load Balancing, and the solution must be cost-effective for users. What should you do?

• A.Store static content such as HTML and images in Cloud CDN. Host the APIs on App Engine and store the user data in Cloud SQL.
• B.Store static content such as HTML and images in a Cloud Storage bucket. Host the APIs on a zonal Google Kubernetes Engine cluster with worker nodes in multiple zones, and save the user data in Cloud Spanner.
• C.Store static content such as HTML and images in Cloud CDN. Use Cloud Run to host the APIs and save the user data in Cloud SQL.
• D.Store static content such as HTML and images in a Cloud Storage bucket. Use Cloud Functions to host the APIs and save the user data in Firestore.

Comment: *

Name: *

Email: *

Verification: *

Your organization requires that metrics from all applications be retained for 5 years for future analysis in possible legal proceedings.
Which approach should you use?

• A.Grant the security team access to the logs in each Project
• B.Configure Stackdriver Monitoring for all Projects, and export to BigQuery
• C.Configure Stackdriver Monitoring for all Projects with the default retention policies
• D.Configure Stackdriver Monitoring for all Projects, and export to Google Cloud Storage

Comment: *

Name: *

Email: *

Verification: *

Your company wants to start using Google Cloud resources but wants to retain their on-premises Active Directory domain controller for identity management. What should you do?

• A.Use the Admin Directory API to authenticate against the Active Directory domain controller.
• B.Use Google Cloud Directory Sync to synchronize Active Directory usernames with cloud identities and configure SAML SSO.
• C.Use Cloud Identity-Aware Proxy configured to use the on-premises Active Directory domain controller as an identity provider.
• D.Use Compute Engine to create an Active Directory (AD) domain controller that is a replica of the onpremises AD domain controller using Google Cloud Directory Sync.

Comment: *

Name: *

Email: *

Verification: *