Free Google Associate Cloud Engineer Exam Braindumps (page: 23)

Page 22 of 74

You have a large 5-TB AVRO file stored in a Cloud Storage bucket. Your analysts are proficient only in SQL and need access to the data stored in this file. You want to find a cost-effective way to complete their request as soon as possible.
What should you do?

  1. Load data in Cloud Datastore and run a SQL query against it.
  2. Create a BigQuery table and load data in BigQuery. Run a SQL query on this table and drop this table after you complete your request.
  3. Create external tables in BigQuery that point to Cloud Storage buckets and run a SQL query on these external tables to complete your request.
  4. Create a Hadoop cluster and copy the AVRO file to NDFS by compressing it. Load the file in a hive table and provide access to your analysts so that they can run SQL queries.

Answer(s): C

Explanation:

https://cloud.google.com/bigquery/external-data-sources

An external data source is a data source that you can query directly from BigQuery, even though the data is not stored in BigQuery storage.

BigQuery supports the following external data sources:

Amazon S3
Azure Storage
Cloud Bigtable
Cloud Spanner
Cloud SQL
Cloud Storage
Drive



You need to verify that a Google Cloud Platform service account was created at a particular time.
What should you do?

  1. Filter the Activity log to view the Configuration category. Filter the Resource type to Service Account.
  2. Filter the Activity log to view the Configuration category. Filter the Resource type to Google Project.
  3. Filter the Activity log to view the Data Access category. Filter the Resource type to Service Account.
  4. Filter the Activity log to view the Data Access category. Filter the Resource type to Google Project.

Answer(s): A

Explanation:

https://developers.google.com/cloud-search/docs/guides/audit-logging-manual



You deployed an LDAP server on Compute Engine that is reachable via TLS through port 636 using UDP. You want to make sure it is reachable by clients over that port.
What should you do?

  1. Add the network tag allow-udp-636 to the VM instance running the LDAP server.
  2. Create a route called allow-udp-636 and set the next hop to be the VM instance running the LDAP server.
  3. Add a network tag of your choice to the instance. Create a firewall rule to allow ingress on UDP port 636 for that network tag.
  4. Add a network tag of your choice to the instance running the LDAP server. Create a firewall rule to allow egress on UDP port 636 for that network tag.

Answer(s): C

Explanation:

A tag is simply a character string added to a tags field in a resource, such as Compute Engine virtual machine (VM) instances or instance templates. A tag is not a separate resource, so you cannot create it separately. All resources with that string are considered to have that tag. Tags enable you to make firewall rules and routes applicable to specific VM instances.



You need to set a budget alert for use of Compute Engineer services on one of the three Google Cloud Platform projects that you manage. All three projects are linked to a single billing account.
What should you do?

  1. Verify that you are the project billing administrator. Select the associated billing account and create a budget and alert for the appropriate project.
  2. Verify that you are the project billing administrator. Select the associated billing account and create a budget and a custom alert.
  3. Verify that you are the project administrator. Select the associated billing account and create a budget for the appropriate project.
  4. Verify that you are project administrator. Select the associated billing account and create a budget and a custom alert.

Answer(s): A

Explanation:

https://cloud.google.com/iam/docs/understanding-roles#billing-roles






Post your Comments and Discuss Google Google Associate Cloud Engineer exam with other Community members:

Google Associate Cloud Engineer Discussions & Posts