Filters
Question type
Study Flashcards

Google Cloud Bigtable indexes a single value in each row. This value is called the _______.


A) primary key
B) unique key
C) row key
D) master key

E) B) and D)
F) C) and D)

Correct Answer

verifed

verified

To give a user read permission for only the first three columns of a table, which access control method would you use?


A) Primitive role
B) Predefined role
C) Authorized view
D) It's not possible to give access to only the first three columns of a table.

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

Your software uses a simple JSON format for all messages. These messages are published to Google Cloud Pub/Sub, then processed with Google Cloud Dataflow to create a real-time dashboard for the CFO. During testing, you notice that some messages are missing in the dashboard. You check the logs, and all messages are being published to Cloud Pub/Sub successfully. What should you do next?


A) Check the dashboard application to see if it is not displaying correctly.
B) Run a fixed dataset through the Cloud Dataflow pipeline and analyze the output.
C) Use Google Stackdriver Monitoring on Cloud Pub/Sub to find the missing messages.
D) Switch Cloud Dataflow to pull messages from Cloud Pub/Sub instead of Cloud Pub/Sub pushing messages to Cloud Dataflow.

E) C) and D)
F) B) and C)

Correct Answer

verifed

verified

You are a retailer that wants to integrate your online sales capabilities with different in-home assistants, such as Google Home. You need to interpret customer voice commands and issue an order to the backend systems. Which solutions should you choose?


A) Cloud Speech-to-Text API
B) Cloud Natural Language API
C) Dialogflow Enterprise Edition
D) Cloud AutoML Natural Language

E) A) and B)
F) A) and D)

Correct Answer

verifed

verified

You want to automate execution of a multi-step data pipeline running on Google Cloud. The pipeline includes Cloud Dataproc and Cloud Dataflow jobs that have multiple dependencies on each other. You want to use managed services where possible, and the pipeline will run every day. Which tool should you use?


A) cron
B) Cloud Composer
C) Cloud Scheduler
D) Workflow Templates on Cloud Dataproc

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

You want to build a managed Hadoop system as your data lake. The data transformation process is composed of a series of Hadoop jobs executed in sequence. To accomplish the design of separating storage from compute, you decided to use the Cloud Storage connector to store all input data, output data, and intermediary data. However, you noticed that one Hadoop job runs very slowly with Cloud Dataproc, when compared with the on-premises bare-metal Hadoop environment (8-core nodes with 100-GB RAM) . Analysis shows that this particular Hadoop job is disk I/O intensive. You want to resolve the issue. What should you do?


A) Allocate sufficient memory to the Hadoop cluster, so that the intermediary data of that particular Hadoop job can be held in memory
B) Allocate sufficient persistent disk space to the Hadoop cluster, and store the intermediate data of that particular Hadoop job on native HDFS
C) Allocate more CPU cores of the virtual machine instances of the Hadoop cluster so that the networking bandwidth for each instance can scale up
D) Allocate additional network interface card (NIC) , and configure link aggregation in the operating system to use the combined throughput when working with Cloud Storage

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

You use BigQuery as your centralized analytics platform. New data is loaded every day, and an ETL pipeline modifies the original data and prepares it for the final users. This ETL pipeline is regularly modified and can generate errors, but sometimes the errors are detected only after 2 weeks. You need to provide a method to recover from these errors, and your backups should be optimized for storage costs. How should you organize your data in BigQuery and store your backups?


A) Organize your data in a single table, export, and compress and store the BigQuery data in Cloud Storage.
B) Organize your data in separate tables for each month, and export, compress, and store the data in Cloud Storage.
C) Organize your data in separate tables for each month, and duplicate your data on a separate dataset in BigQuery.
D) Organize your data in separate tables for each month, and use snapshot decorators to restore the table to a time prior to the corruption.

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

You are migrating your data warehouse to BigQuery. You have migrated all of your data into tables in a dataset. Multiple users from your organization will be using the data. They should only see certain tables based on their team membership. How should you set user permissions?


A) Assign the users/groups data viewer access at the table level for each table
B) Create SQL views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the SQL views
C) Create authorized views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the authorized views
D) Create authorized views for each team in datasets created for each team. Assign the authorized views data viewer access to the dataset in which the data resides. Assign the users/groups data viewer access to the datasets in which the authorized views reside

E) A) and D)
F) B) and C)

Correct Answer

verifed

verified

You work for an advertising company, and you've developed a Spark ML model to predict click-through rates at advertisement blocks. You've been developing everything at your on-premises data center, and now your company is migrating to Google Cloud. Your data center will be migrated to BigQuery. You periodically retrain your Spark ML models, so you need to migrate existing training pipelines to Google Cloud. What should you do?


A) Use Cloud ML Engine for training existing Spark ML models
B) Rewrite your models on TensorFlow, and start using Cloud ML Engine
C) Use Cloud Dataproc for training existing Spark ML models, but start reading data directly from BigQuery
D) Spin up a Spark cluster on Compute Engine, and train Spark ML models on the data exported from BigQuery

E) A) and D)
F) B) and C)

Correct Answer

verifed

verified

When you store data in Cloud Bigtable, what is the recommended minimum amount of stored data?


A) 500 TB
B) 1 GB
C) 1 TB
D) 500 GB

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

Your company's on-premises Apache Hadoop servers are approaching end-of-life, and IT has decided to migrate the cluster to Google Cloud Dataproc. A like-for-like migration of the cluster would require 50 TB of Google Persistent Disk per node. The CIO is concerned about the cost of using that much block storage. You want to minimize the storage cost of the migration. What should you do?


A) Put the data into Google Cloud Storage.
B) Use preemptible virtual machines (VMs) for the Cloud Dataproc cluster.
C) Tune the Cloud Dataproc cluster so that there is just enough disk for all data.
D) Migrate some of the cold data into Google Cloud Storage, and keep only the hot data in Persistent Disk.

E) All of the above
F) None of the above

Correct Answer

verifed

verified

Your company is in the process of migrating its on-premises data warehousing solutions to BigQuery. The existing data warehouse uses trigger-based change data capture (CDC) to apply updates from multiple transactional database sources on a daily basis. With BigQuery, your company hopes to improve its handling of CDC so that changes to the source systems are available to query in BigQuery in near-real time using log-based CDC streams, while also optimizing for the performance of applying changes to the data warehouse. Which two steps should they take to ensure that changes are available in the BigQuery reporting table with minimal latency while reducing compute overhead? (Choose two.)


A) Perform a DML INSERT, UPDATE, or DELETE to replicate each individual CDC record in real time directly on the reporting table.
B) Insert each new CDC record and corresponding operation type to a staging table in real time.
C) Periodically DELETE outdated records from the reporting table.
D) Periodically use a DML MERGE to perform several DML INSERT, UPDATE, and DELETE operations at the same time on the reporting table.
E) Insert each new CDC record and corresponding operation type in real time to the reporting table, and use a materialized view to expose only the newest version of each unique record.

F) All of the above
G) B) and E)

Correct Answer

verifed

verified

You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQuery for a data pipeline on Google Cloud. You want to minimize service costs. You also want to monitor and accommodate input data volume that will vary in size with minimal manual intervention. What should you do?


A) Use Cloud Dataproc to run your transformations. Monitor CPU utilization for the cluster. Resize the number of worker nodes in your cluster via the command line.
B) Use Cloud Dataproc to run your transformations. Use the diagnose command to generate an operational output archive. Locate the bottleneck and adjust cluster resources. Use Cloud Dataproc to run your transformations. Use the diagnose command to generate an operational output archive. Locate the bottleneck and adjust cluster resources.
C) Use Cloud Dataflow to run your transformations. Monitor the job system lag with Stackdriver. Use the default autoscaling setting for worker instances.
D) Use Cloud Dataflow to run your transformations. Monitor the total execution time for a sampling of jobs. Configure the job to use non-default Compute Engine machine types when needed.

E) All of the above
F) B) and C)

Correct Answer

verifed

verified

You designed a database for patient records as a pilot project to cover a few hundred patients in three clinics. Your design used a single database table to represent all patients and their visits, and you used self-joins to generate reports. The server resource utilization was at 50%. Since then, the scope of the project has expanded. The database must now store 100 times more patient records. You can no longer run the reports, because they either take too long or they encounter errors with insufficient compute resources. How should you adjust the database design?


A) Add capacity (memory and disk space) to the database server by the order of 200.
B) Shard the tables into smaller ones based on date ranges, and only generate reports with prespecified date ranges.
C) Normalize the master patient-record table into the patient table and the visits table, and create other necessary tables to avoid self-join.
D) Partition the table into smaller tables, with one for each clinic. Run queries against the smaller table pairs, and use unions for consolidated reports.

E) None of the above
F) All of the above

Correct Answer

verifed

verified

You want to archive data in Cloud Storage. Because some data is very sensitive, you want to use the "Trust No One" (TNO) approach to encrypt your data to prevent the cloud provider staff from decrypting your data. What should you do?


A) Use gcloud kms keys create to create a symmetric key. Then use gcloud kms encrypt to encrypt each archival file with the key and unique additional authenticated data (AAD) . Use gsutil cp to upload each encrypted file to the Cloud Storage bucket, and keep the AAD outside of Google Cloud. Use gcloud kms keys create to create a symmetric key. Then use gcloud kms encrypt to encrypt each archival file with the key and unique additional authenticated data (AAD) . Use gsutil cp to upload each encrypted file to the Cloud Storage bucket, and keep the AAD outside of Google Cloud.
B) Use gcloud kms keys create to create a symmetric key. Then use gcloud kms encrypt to encrypt each archival file with the key. Use gsutil cp to upload each encrypted file to the Cloud Storage bucket. Manually destroy the key previously used for encryption, and rotate the key once. Use gcloud kms keys create to create a symmetric key. Then use to encrypt each archival file with the key. Use gsutil cp to upload each encrypted file to the Cloud Storage bucket. Manually destroy the key previously used for encryption, and rotate the key once.
C) Specify customer-supplied encryption key (CSEK) in the . boto configuration file. Use gsutil cp to upload each archival file to the Cloud Storage bucket. Save the CSEK in Cloud Memorystore as permanent storage of the secret. Specify customer-supplied encryption key (CSEK) in the . boto configuration file. Use gsutil cp to upload each archival file to the Cloud Storage bucket. Save the CSEK in Cloud Memorystore as permanent storage of the secret.
D) Specify customer-supplied encryption key (CSEK) in the . boto configuration file. Use gsutil cp to upload each archival file to the Cloud Storage bucket. Save the CSEK in a different project that only the security team can access. to upload each archival file to the Cloud Storage bucket. Save the CSEK in a different project that only the security team can access.

E) B) and D)
F) None of the above

Correct Answer

verifed

verified

You are updating the code for a subscriber to a Pub/Sub feed. You are concerned that upon deployment the subscriber may erroneously acknowledge messages, leading to message loss. Your subscriber is not set up to retain acknowledged messages. What should you do to ensure that you can recover from errors after deployment?


A) Set up the Pub/Sub emulator on your local machine. Validate the behavior of your new subscriber logic before deploying it to production.
B) Create a Pub/Sub snapshot before deploying new subscriber code. Use a Seek operation to re-deliver messages that became available after the snapshot was created.
C) Use Cloud Build for your deployment. If an error occurs after deployment, use a Seek operation to locate a timestamp logged by Cloud Build at the start of the deployment.
D) Enable dead-lettering on the Pub/Sub topic to capture messages that aren't successfully acknowledged. If an error occurs after deployment, re-deliver any messages captured by the dead-letter queue.

E) C) and D)
F) All of the above

Correct Answer

verifed

verified

Cloud Bigtable is Google's ______ Big Data database service.


A) Relational
B) mySQL
C) NoSQL
D) SQL Server

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

An online retailer has built their current application on Google App Engine. A new initiative at the company mandates that they extend their application to allow their customers to transact directly via the application. They need to manage their shopping transactions and analyze combined data from multiple datasets using a business intelligence (BI) tool. They want to use only a single database for this purpose. Which Google Cloud database should they choose?


A) BigQuery
B) Cloud SQL
C) Cloud BigTable
D) Cloud Datastore

E) C) and D)
F) A) and C)

Correct Answer

verifed

verified

Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?


A) Create a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes Create a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes
B) Create a Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project slots/allocated_for_project
C) Create a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs , and create a Stackdriver Monitoring dashboard based on the custom metric Create a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs , and create a Stackdriver Monitoring dashboard based on the custom metric
D) Create an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs , and create a Stackdriver Monitoring dashboard based on the custom metric Create an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

You work for a manufacturing company that sources up to 750 different components, each from a different supplier. You've collected a labeled dataset that has on average 1000 examples for each unique component. Your team wants to implement an app to help warehouse workers recognize incoming components based on a photo of the component. You want to implement the first working version of this app (as Proof-Of-Concept) within a few working days. What should you do?


A) Use Cloud Vision AutoML with the existing dataset.
B) Use Cloud Vision AutoML, but reduce your dataset twice.
C) Use Cloud Vision API by providing custom labels as recognition hints.
D) Train your own image recognition model leveraging transfer learning techniques.

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

Showing 181 - 200 of 256

Related Exams

Exam 1

Google AdWords: Display Advertising

122 Questions

Exam 2

Google AdWords Fundamentals

153 Questions

Exam 3

Associate Android Developer

86 Questions

Exam 4

Associate Cloud Engineer

134 Questions

Exam 5

Cloud Digital Leader

91 Questions

Exam 6

Google Analytics Individual Qualification (IQ)

121 Questions

Exam 7

Google Analytics Individual Qualification

78 Questions

Exam 8

GSuite

202 Questions

Exam 9

Looker Business Analyst

388 Questions

Exam 10

LookML Developer

41 Questions

Exam 11

Mobile Web Specialist

13 Questions

Exam 12

Professional Cloud Architect on Google Cloud Platform

118 Questions

Exam 13

Professional Cloud Developer

85 Questions

Exam 14

Professional Cloud DevOps Engineer

28 Questions

Exam 15

Professional Cloud Network Engineer

57 Questions

Exam 16

Professional Cloud Security Engineer

80 Questions

Exam 17

Professional Collaboration Engineer

71 Questions

Exam 19

Professional Machine Learning Engineer

35 Questions

Show Answer